1: PACKAGE BODY bix_uwq_summary_pkg AS
2: /*$Header: bixxuwsb.pls 115.21 2003/08/19 21:34:18 djambula ship $ */
3:
4: v_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: v_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();
6: v_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
7: v_user_id NUMBER := FND_GLOBAL.USER_ID();
8: v_insert_count NUMBER := 0;
1: PACKAGE BODY bix_uwq_summary_pkg AS
2: /*$Header: bixxuwsb.pls 115.21 2003/08/19 21:34:18 djambula ship $ */
3:
4: v_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: v_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();
6: v_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
7: v_user_id NUMBER := FND_GLOBAL.USER_ID();
8: v_insert_count NUMBER := 0;
9: v_delete_count NUMBER := 0;
2: /*$Header: bixxuwsb.pls 115.21 2003/08/19 21:34:18 djambula ship $ */
3:
4: v_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: v_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();
6: v_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
7: v_user_id NUMBER := FND_GLOBAL.USER_ID();
8: v_insert_count NUMBER := 0;
9: v_delete_count NUMBER := 0;
10: v_message VARCHAR2(4000); --used for storing log file messages that need to be inserted
3:
4: v_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: v_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();
6: v_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
7: v_user_id NUMBER := FND_GLOBAL.USER_ID();
8: v_insert_count NUMBER := 0;
9: v_delete_count NUMBER := 0;
10: v_message VARCHAR2(4000); --used for storing log file messages that need to be inserted
11: v_status VARCHAR2(10); --used for storing the status that needs to be inserted