681: l_start_date_active DATE;
682: l_end_date_active DATE;
683:
684: l_current_date DATE :=sysdate;
685: l_created_by NUMBER :=fnd_global.user_id;
686: l_login NUMBER :=fnd_global.login_id;
687: l_row_id VARCHAR2(100);
688: l_temp NUMBER;
689:
682: l_end_date_active DATE;
683:
684: l_current_date DATE :=sysdate;
685: l_created_by NUMBER :=fnd_global.user_id;
686: l_login NUMBER :=fnd_global.login_id;
687: l_row_id VARCHAR2(100);
688: l_temp NUMBER;
689:
690: l_res_code_index BINARY_INTEGER;
1040: l_start_date_active DATE;
1041: l_end_date_active DATE;
1042:
1043: l_current_date DATE :=sysdate;
1044: l_created_by NUMBER :=fnd_global.user_id;
1045: l_login NUMBER :=fnd_global.login_id;
1046: l_row_id VARCHAR2(100);
1047:
1048: l_res_code_index BINARY_INTEGER;
1041: l_end_date_active DATE;
1042:
1043: l_current_date DATE :=sysdate;
1044: l_created_by NUMBER :=fnd_global.user_id;
1045: l_login NUMBER :=fnd_global.login_id;
1046: l_row_id VARCHAR2(100);
1047:
1048: l_res_code_index BINARY_INTEGER;
1049:
1344: l_start_date_active DATE;
1345: l_end_date_active DATE;
1346:
1347: l_current_date DATE :=sysdate;
1348: l_created_by NUMBER :=fnd_global.user_id;
1349: l_login NUMBER :=fnd_global.login_id;
1350: l_row_id VARCHAR2(100);
1351:
1352: l_res_code_index BINARY_INTEGER;
1345: l_end_date_active DATE;
1346:
1347: l_current_date DATE :=sysdate;
1348: l_created_by NUMBER :=fnd_global.user_id;
1349: l_login NUMBER :=fnd_global.login_id;
1350: l_row_id VARCHAR2(100);
1351:
1352: l_res_code_index BINARY_INTEGER;
1353: