523: l_start_date_active DATE;
524: l_end_date_active DATE;
525:
526: l_current_date DATE :=sysdate;
527: l_created_by NUMBER :=fnd_global.user_id;
528: l_login NUMBER :=fnd_global.login_id;
529: l_row_id VARCHAR2(100);
530: l_temp NUMBER;
531:
524: l_end_date_active DATE;
525:
526: l_current_date DATE :=sysdate;
527: l_created_by NUMBER :=fnd_global.user_id;
528: l_login NUMBER :=fnd_global.login_id;
529: l_row_id VARCHAR2(100);
530: l_temp NUMBER;
531:
532: l_prob_code_index BINARY_INTEGER;
883: l_start_date_active DATE;
884: l_end_date_active DATE;
885:
886: l_current_date DATE :=sysdate;
887: l_created_by NUMBER :=fnd_global.user_id;
888: l_login NUMBER :=fnd_global.login_id;
889: l_row_id VARCHAR2(100);
890:
891: l_prob_code_index BINARY_INTEGER;
884: l_end_date_active DATE;
885:
886: l_current_date DATE :=sysdate;
887: l_created_by NUMBER :=fnd_global.user_id;
888: l_login NUMBER :=fnd_global.login_id;
889: l_row_id VARCHAR2(100);
890:
891: l_prob_code_index BINARY_INTEGER;
892:
1170: l_start_date_active DATE;
1171: l_end_date_active DATE;
1172:
1173: l_current_date DATE :=sysdate;
1174: l_created_by NUMBER :=fnd_global.user_id;
1175: l_login NUMBER :=fnd_global.login_id;
1176: l_row_id VARCHAR2(100);
1177:
1178: l_res_code_index BINARY_INTEGER;
1171: l_end_date_active DATE;
1172:
1173: l_current_date DATE :=sysdate;
1174: l_created_by NUMBER :=fnd_global.user_id;
1175: l_login NUMBER :=fnd_global.login_id;
1176: l_row_id VARCHAR2(100);
1177:
1178: l_res_code_index BINARY_INTEGER;
1179: