6: , P_ERROR_MSG OUT VARCHAR2
7: , P_SOURCE_ID IN NUMBER
8: ) IS
9:
10: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
11: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
12: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
13: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
14: L_SYSDATE DATE := SYSDATE;
7: , P_SOURCE_ID IN NUMBER
8: ) IS
9:
10: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
11: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
12: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
13: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
14: L_SYSDATE DATE := SYSDATE;
15:
8: ) IS
9:
10: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
11: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
12: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
13: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
14: L_SYSDATE DATE := SYSDATE;
15:
16: L_NUM_ROWS_READ INTEGER := 0;
9:
10: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
11: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
12: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
13: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
14: L_SYSDATE DATE := SYSDATE;
15:
16: L_NUM_ROWS_READ INTEGER := 0;
17: L_NUM_ROWS_INSERTED INTEGER := 0;