APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_INVLN_INT

Line 17: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

13: bannamal 05-Jul-2005 Enh# 3392095, Tuition Waivers Build.
14: Modified functions get_crd_cat, get_inv_cat, get_app_cat, validate_parm
15: and procedures transfer_credit, transfer_app for this build.
16: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
17: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
18: vvutukur 11-Dec-2003 Bug#3310756.Modified procedures transfer_credit,igs_ad_appl.
19: shtatiko 18-NOV-2003 Enh# 3256915, modified get_crd_cat and get_app_cat
20: vvutukur 09-Oct-2003 Bug#3160036. Modified procedure transfer_admapp.
21: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build

Line 319: l_n_batch_id igs_fi_invln_int.posting_control_id%TYPE;

315: Change History
316: Who When What
317:
318: ********************************************************************************************** */
319: l_n_batch_id igs_fi_invln_int.posting_control_id%TYPE;
320:
321: CURSOR cur_batch IS
322: SELECT IGS_FI_POSTING_CONTROL_S.NEXTVAL
323: FROM dual;

Line 634: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

630: Known limitations,enhancements,remarks:
631: Change History
632: Who When What
633: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
634: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
635:
636: vchappid 20-Dec-2002 Bug 2720702: In the procedure transfer_charge, for cursor cur_chg,
637: NVL is missing while checking for Error Account. When the Error Account
638: is set to NULL, it has to be treated as a valid transaction

Line 646: CURSOR cur_chg(cp_gl_date_start igs_fi_invln_int.gl_date%TYPE,

642: l_v_inv_cat gl_je_categories.je_category_name%TYPE;
643: l_v_inv_desc gl_interface.reference10%TYPE;
644:
645: -- Cursor for selecting the Charge transactions from the Invoice Lines table
646: CURSOR cur_chg(cp_gl_date_start igs_fi_invln_int.gl_date%TYPE,
647: cp_gl_date_end igs_fi_invln_int.gl_date%TYPE) IS
648: SELECT ln.*,
649: inv.invoice_number,
650: inv.transaction_type,

Line 647: cp_gl_date_end igs_fi_invln_int.gl_date%TYPE) IS

643: l_v_inv_desc gl_interface.reference10%TYPE;
644:
645: -- Cursor for selecting the Charge transactions from the Invoice Lines table
646: CURSOR cur_chg(cp_gl_date_start igs_fi_invln_int.gl_date%TYPE,
647: cp_gl_date_end igs_fi_invln_int.gl_date%TYPE) IS
648: SELECT ln.*,
649: inv.invoice_number,
650: inv.transaction_type,
651: inv.person_id

Line 652: FROM igs_fi_invln_int ln,

648: SELECT ln.*,
649: inv.invoice_number,
650: inv.transaction_type,
651: inv.person_id
652: FROM igs_fi_invln_int ln,
653: igs_fi_inv_int inv
654: WHERE ln.invoice_id = inv.invoice_id
655: AND ln.gl_date IS NOT NULL
656: AND TRUNC(ln.gl_date) >= TRUNC(cp_gl_date_start)

Line 694: p_ref30 => 'IGS_FI_INVLN_INT',

690: p_dr_ccid => chgrec.rec_gl_ccid,
691: p_cr_ccid => chgrec.rev_gl_ccid,
692: p_amount => chgrec.amount,
693: p_ref23 => chgrec.invoice_lines_id,
694: p_ref30 => 'IGS_FI_INVLN_INT',
695: p_desc => l_v_inv_desc);
696: EXCEPTION
697: WHEN OTHERS THEN
698: ROLLBACK TO SP_INV1;

Line 705: igs_fi_invln_int_pkg.update_row(x_rowid => chgrec.row_id,

701: sqlerrm);
702: END;
703:
704: IF NOT l_b_exception_flag THEN
705: igs_fi_invln_int_pkg.update_row(x_rowid => chgrec.row_id,
706: x_invoice_id => chgrec.invoice_id,
707: x_line_number => chgrec.line_number,
708: x_invoice_lines_id => chgrec.invoice_lines_id,
709: x_attribute2 => chgrec.attribute2,