APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_APPLICATIONS

Line 131: igs_fi_applications app

127:
128: CURSOR cur_tran_type (cp_n_credit_id IN igs_fi_credits.credit_id%TYPE) IS
129: SELECT inv.transaction_type
130: FROM igs_fi_inv_int_all inv,
131: igs_fi_applications app
132: WHERE inv.invoice_id = app.invoice_id
133: AND app.credit_id = cp_n_credit_id;
134:
135: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

Line 777: CURSOR cur_app(cp_gl_date_start igs_fi_applications.gl_date%TYPE,

773: l_b_exception_flag BOOLEAN;
774: l_b_waiver_flag BOOLEAN;
775:
776: -- Cursor for selecting the unposted application records
777: CURSOR cur_app(cp_gl_date_start igs_fi_applications.gl_date%TYPE,
778: cp_gl_date_end igs_fi_applications.gl_date%TYPE) IS
779: SELECT app.*,app.rowid row_id,
780: inv.invoice_number,
781: crd.credit_number,

Line 778: cp_gl_date_end igs_fi_applications.gl_date%TYPE) IS

774: l_b_waiver_flag BOOLEAN;
775:
776: -- Cursor for selecting the unposted application records
777: CURSOR cur_app(cp_gl_date_start igs_fi_applications.gl_date%TYPE,
778: cp_gl_date_end igs_fi_applications.gl_date%TYPE) IS
779: SELECT app.*,app.rowid row_id,
780: inv.invoice_number,
781: crd.credit_number,
782: inv.person_id

Line 783: FROM igs_fi_applications app,

779: SELECT app.*,app.rowid row_id,
780: inv.invoice_number,
781: crd.credit_number,
782: inv.person_id
783: FROM igs_fi_applications app,
784: igs_fi_credits crd,
785: igs_fi_inv_int inv
786: WHERE crd.credit_id = app.credit_id
787: AND inv.invoice_id = app.invoice_id

Line 834: p_ref30 => 'IGS_FI_APPLICATIONS',

830: p_dr_ccid => apprec.dr_gl_code_ccid,
831: p_cr_ccid => apprec.cr_gl_code_ccid,
832: p_amount => apprec.amount_applied,
833: p_ref23 => apprec.application_id,
834: p_ref30 => 'IGS_FI_APPLICATIONS',
835: p_desc => l_v_app_desc);
836:
837: EXCEPTION
838: WHEN OTHERS THEN

Line 848: igs_fi_applications_pkg.update_row(x_rowid => apprec.row_id,

844:
845: -- If there is no error in creation of the transaction in the GL Interface table,
846: -- then update the application record with the posting control id and the gl posted date
847: IF NOT l_b_exception_flag THEN
848: igs_fi_applications_pkg.update_row(x_rowid => apprec.row_id,
849: x_application_id => apprec.application_id,
850: x_application_type => apprec.application_type,
851: x_invoice_id => apprec.invoice_id,
852: x_credit_id => apprec.credit_id,