111: ) IS
112:
113: --NSO Modification by abedajna end
114:
115: p_user NUMBER := FND_GLOBAL.USER_ID;
116: p_login NUMBER := FND_GLOBAL.LOGIN_ID;
117: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
118: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
119: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
112:
113: --NSO Modification by abedajna end
114:
115: p_user NUMBER := FND_GLOBAL.USER_ID;
116: p_login NUMBER := FND_GLOBAL.LOGIN_ID;
117: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
118: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
119: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
120: p_curdate DATE := SYSDATE;
113: --NSO Modification by abedajna end
114:
115: p_user NUMBER := FND_GLOBAL.USER_ID;
116: p_login NUMBER := FND_GLOBAL.LOGIN_ID;
117: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
118: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
119: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
120: p_curdate DATE := SYSDATE;
121: p_rtg_rev_date DATE; -- ADD: CZH.I_OED-1
114:
115: p_user NUMBER := FND_GLOBAL.USER_ID;
116: p_login NUMBER := FND_GLOBAL.LOGIN_ID;
117: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
118: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
119: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
120: p_curdate DATE := SYSDATE;
121: p_rtg_rev_date DATE; -- ADD: CZH.I_OED-1
122: l_count NUMBER := 0;
115: p_user NUMBER := FND_GLOBAL.USER_ID;
116: p_login NUMBER := FND_GLOBAL.LOGIN_ID;
117: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
118: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
119: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
120: p_curdate DATE := SYSDATE;
121: p_rtg_rev_date DATE; -- ADD: CZH.I_OED-1
122: l_count NUMBER := 0;
123: l_stat_num NUMBER;