225: l_b_upgrade_done BOOLEAN := FALSE;
226: l_org_id VARCHAR2(15);
227: l_n_cntr NUMBER;
228:
229: l_v_lkp_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE');
230: l_v_lkp_fee_cal_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAL_TYPE');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
226: l_org_id VARCHAR2(15);
227: l_n_cntr NUMBER;
228:
229: l_v_lkp_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE');
230: l_v_lkp_fee_cal_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAL_TYPE');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
227: l_n_cntr NUMBER;
228:
229: l_v_lkp_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE');
230: l_v_lkp_fee_cal_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAL_TYPE');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
228:
229: l_v_lkp_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE');
230: l_v_lkp_fee_cal_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAL_TYPE');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
230: l_v_lkp_fee_cal_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAL_TYPE');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');
232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
233:
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');
235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');
236:
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');
243: l_v_lkp_success igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'SUCCESS');
237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');
243: l_v_lkp_success igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'SUCCESS');
244:
245: ret_invoice_tab ret_invoice_tab_type;
238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');
243: l_v_lkp_success igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'SUCCESS');
244:
245: ret_invoice_tab ret_invoice_tab_type;
246:
239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');
240:
241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');
242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');
243: l_v_lkp_success igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'SUCCESS');
244:
245: ret_invoice_tab ret_invoice_tab_type;
246:
247: BEGIN