141: || Who When What
142: || (reverse chronological order - newest change first)
143: */
144:
145: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
146: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
147: SELECT batch_desc, batch_type
148: FROM igf_ap_li_bat_ints
149: WHERE batch_num = cp_batch_num ;
144:
145: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
146: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
147: SELECT batch_desc, batch_type
148: FROM igf_ap_li_bat_ints
149: WHERE batch_num = cp_batch_num ;
150:
151: l_delete_flag_prmpt VARCHAR2(80);
152: l_error VARCHAR2(80);
151: l_delete_flag_prmpt VARCHAR2(80);
152: l_error VARCHAR2(80);
153: l_lkup_type VARCHAR2(60) ;
154: l_lkup_code VARCHAR2(60) ;
155: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
156: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
157: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
158: l_yes_no igf_lookups_view.meaning%TYPE ;
159: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
152: l_error VARCHAR2(80);
153: l_lkup_type VARCHAR2(60) ;
154: l_lkup_code VARCHAR2(60) ;
155: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
156: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
157: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
158: l_yes_no igf_lookups_view.meaning%TYPE ;
159: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
160: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
153: l_lkup_type VARCHAR2(60) ;
154: l_lkup_code VARCHAR2(60) ;
155: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
156: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
157: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
158: l_yes_no igf_lookups_view.meaning%TYPE ;
159: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
160: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
161: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;