18: --- constants
19: -------------------
20: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
21: g_user_id NUMBER :=
22: FND_GLOBAL.user_id ;
23: g_request_id NUMBER :=
24: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
25: g_program_id NUMBER :=
26: fnd_global.conc_program_id ;
22: FND_GLOBAL.user_id ;
23: g_request_id NUMBER :=
24: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
25: g_program_id NUMBER :=
26: fnd_global.conc_program_id ;
27: g_program_application_id NUMBER :=
28: fnd_global.prog_appl_id ;
29: g_login_id NUMBER :=
30: fnd_global.login_id ;
24: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
25: g_program_id NUMBER :=
26: fnd_global.conc_program_id ;
27: g_program_application_id NUMBER :=
28: fnd_global.prog_appl_id ;
29: g_login_id NUMBER :=
30: fnd_global.login_id ;
31: g_revalidate_error_code VARCHAR2(40) ;
32:
26: fnd_global.conc_program_id ;
27: g_program_application_id NUMBER :=
28: fnd_global.prog_appl_id ;
29: g_login_id NUMBER :=
30: fnd_global.login_id ;
31: g_revalidate_error_code VARCHAR2(40) ;
32:
33: --===================
34: -- PROCEDURES AND FUNCTIONS