DBA Data[Home] [Help]

APPS.IGS_FI_UPG_RETENTION dependencies on IGS_LOOKUP_VALUES

Line 229: l_v_lkp_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE');

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:

Line 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');

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');

Line 231: l_v_lkp_start_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT');

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');

Line 232: l_v_lkp_end_dt igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT');

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:

Line 234: l_v_lkp_dr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'DR_ACCOUNT');

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');

Line 235: l_v_lkp_cr_account igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CR_ACCOUNT');

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');

Line 237: l_v_lkp_charge_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER');

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');

Line 238: l_v_lkp_credit_number igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_NUMBER');

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');

Line 239: l_v_lkp_application_id igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'APPLICATION_ID');

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');

Line 241: l_v_lkp_status igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS');

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;

Line 242: l_v_lkp_error igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'ERROR');

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:

Line 243: l_v_lkp_success igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('STATUS', 'SUCCESS');

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