23: --- GLOBAL Declarations Starts here -----
24: --------------------------------------------------
25:
26: /* Global System Variables */
27: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
28: G_SYSDATE DATE := SYSDATE;
29:
30: /* this procedure looks at the table jty_changed_terrs and retrive the master */
31: /* list that need to be processed by incremental star */
649: END IF;
650:
651: /* Initialize audit columns */
652: l_start_date := SYSDATE;
653: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
650:
651: /* Initialize audit columns */
652: l_start_date := SYSDATE;
653: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
658: l_conc_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
651: /* Initialize audit columns */
652: l_start_date := SYSDATE;
653: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
658: l_conc_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
659: l_pgm_name := 'JTY_STAR';
652: l_start_date := SYSDATE;
653: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
658: l_conc_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
659: l_pgm_name := 'JTY_STAR';
660:
653: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
658: l_conc_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
659: l_pgm_name := 'JTY_STAR';
660:
661: l_param_start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
654: l_resp_id := FND_GLOBAL.RESP_ID;
655: l_user_id := FND_GLOBAL.USER_ID;
656: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
657: l_pgm_appl_id := FND_GLOBAL.PROG_APPL_ID;
658: l_conc_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
659: l_pgm_name := 'JTY_STAR';
660:
661: l_param_start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
662: l_param_end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');