4:
5: --Global Variables
6: G_user_id NUMBER := fnd_profile.value('USER_ID');
7: G_login_id NUMBER := fnd_profile.value('LOGIN_ID');
8: G_request_id NUMBER := fnd_global.conc_request_id;
9: G_program_id NUMBER := fnd_global.conc_program_id;
10: G_application_id NUMBER := fnd_global.prog_appl_id;
11:
12: PROCEDURE INSERT_INTO_CRM(
5: --Global Variables
6: G_user_id NUMBER := fnd_profile.value('USER_ID');
7: G_login_id NUMBER := fnd_profile.value('LOGIN_ID');
8: G_request_id NUMBER := fnd_global.conc_request_id;
9: G_program_id NUMBER := fnd_global.conc_program_id;
10: G_application_id NUMBER := fnd_global.prog_appl_id;
11:
12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
6: G_user_id NUMBER := fnd_profile.value('USER_ID');
7: G_login_id NUMBER := fnd_profile.value('LOGIN_ID');
8: G_request_id NUMBER := fnd_global.conc_request_id;
9: G_program_id NUMBER := fnd_global.conc_program_id;
10: G_application_id NUMBER := fnd_global.prog_appl_id;
11:
12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,