FOR MULTIPLE TRANSACTIONS TO BE CONTROLLED U NEED TO USE

A TRANSACTION FILE. FOR EXAMPLE A STORES PROGRAM IS THERE.

THERE ARE 50 BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99.

SUPPOSE THERE ARE 5 COUNTERS OF ISSUE.

COUNTER 1 OPENED THE ISSUE SCREEN AND TYPED 4. IMMIDIATELY WHEN THE ENTER KEY IS PRESSED 4 IS ENTERED INTO THE TRANSACTION TABLE

WITH USER CODE. A FLAG FIELD IS ALSO NECESSARY. FOR EXAMPLE N STANDS FOR NOT COMMITED INTO THE ISSUE TABLE AND D STANDS FOR

COMMITED TO ISSUE TABLE. SO LONG AS THE FLAG REMAINS N IN THE TRANSACTION TABLE TILL THEN

THE FORMULA IS TOTAL STOCK OF BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99 -(NO OF BOTTLES OF PHYNYLE IN THE TRANSACTION FILE

OF ALL USERS WHERE THE FIELD FLAG IS N). THIS OUTPUT FLASHES ON

ALL SCREENS WHO WANT TO ISSUE BOTTLES OF PHYNYLE OF BRAND X OF BATCH NO 99.

THE MOMENT THE TRANSACTION IS COMMITED TO THE ISSUE TABLE

STEP -1 SUBTRACT ALL THE TRANSACTIONS FROM STOCK THOSE THAT HAVE BEEN ISSUED USING THE TRANSACTION FILE AND STOCK FILE

STEP -2 CHANGE THE FLAG OF THE TRANSACTION RECORDS OF THAT USER

TO D.

STEP -3 DELETE ALL THOSE RECORDS FROM THE TRANSACTION FILE

WHERE THE FLAG D AND THE USER CODE USER CODE OF COUNTER 1.

ALL SHOULD BE DONE USING THE BACKEND PL/SQL PROGRAMMING.

U NEED TO USE

PACKAGES THAT USE STORED PROCEDURES FOR DATA ENTRY AND RETRIVAL

AFTER PROCESSING.

THANKS

V.S.SANDILYA