19:
20: --
21: -- Standard who columns.
22: --
23: who_user_id CONSTANT NUMBER := fnd_global.conc_login_id;
24: who_request_id CONSTANT NUMBER := fnd_global.conc_request_id;
25: who_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
26: who_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
27:
20: --
21: -- Standard who columns.
22: --
23: who_user_id CONSTANT NUMBER := fnd_global.conc_login_id;
24: who_request_id CONSTANT NUMBER := fnd_global.conc_request_id;
25: who_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
26: who_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
27:
28:
21: -- Standard who columns.
22: --
23: who_user_id CONSTANT NUMBER := fnd_global.conc_login_id;
24: who_request_id CONSTANT NUMBER := fnd_global.conc_request_id;
25: who_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
26: who_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
27:
28:
29: CURSOR c_enabled(p_char_id NUMBER) IS
22: --
23: who_user_id CONSTANT NUMBER := fnd_global.conc_login_id;
24: who_request_id CONSTANT NUMBER := fnd_global.conc_request_id;
25: who_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
26: who_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
27:
28:
29: CURSOR c_enabled(p_char_id NUMBER) IS
30: SELECT enabled_flag