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
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
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
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
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
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