DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APPL dependencies on IGS_FI_CREDITS_ALL

Line 351: p_credit_number igs_fi_credits_all.credit_number%TYPE,

347: retcode OUT NOCOPY NUMBER,
348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,
354: p_credit_date_high VARCHAR2,
355: p_d_gl_date VARCHAR2

Line 352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,

348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,
354: p_credit_date_high VARCHAR2,
355: p_d_gl_date VARCHAR2
356: ) IS

Line 447: p_credit_number igs_fi_credits_all.credit_number%TYPE,

443: END mass_application;
444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,
450: p_credit_date_high VARCHAR2,
451: p_d_gl_date DATE

Line 448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,

444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,
450: p_credit_date_high VARCHAR2,
451: p_d_gl_date DATE
452: ) IS

Line 680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;

676: l_charges_not_fp cur_charges_not_fp%ROWTYPE;
677: l_charges_normal cur_charges_normal%ROWTYPE;
678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH
684: l_rec_installed VARCHAR2(1); -- variable captures the value returned from the

Line 682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;

678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH
684: l_rec_installed VARCHAR2(1); -- variable captures the value returned from the
685: -- function which checks AR is installed or not
686: l_credit_date_low DATE; -- VARCHAR2 datatypes will be made DATE types