DBA Data[Home] [Help]

APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_APPLICATIONS

Line 2006: l_n_app_id igs_fi_applications.application_id%TYPE;

2002: WHERE invoice_id = cp_invoice_id;
2003:
2004:
2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

Line 2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;

2003:
2004:
2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

Line 2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

2004:
2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

Line 2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;

2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;

Line 2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;
2014: l_v_err_msg VARCHAR2(2000);

Line 2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;
2014: l_v_err_msg VARCHAR2(2000);
2015: l_b_status BOOLEAN := FALSE;

Line 2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;

2429: l_b_ro_rec_match BOOLEAN;
2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2432: l_v_status VARCHAR2(1);
2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;
2434: l_n_app_id igs_fi_applications.application_id%TYPE;
2435: l_n_rec_amnt_prc igs_fi_credits.amount%TYPE;
2436: l_n_rec_cntr NUMBER(38);
2437: l_n_receipt_number NUMBER(38);

Line 2434: l_n_app_id igs_fi_applications.application_id%TYPE;

2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2432: l_v_status VARCHAR2(1);
2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;
2434: l_n_app_id igs_fi_applications.application_id%TYPE;
2435: l_n_rec_amnt_prc igs_fi_credits.amount%TYPE;
2436: l_n_rec_cntr NUMBER(38);
2437: l_n_receipt_number NUMBER(38);
2438: l_n_cntr NUMBER(38);