eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_APPLICATIONS

Line 723: FROM igs_fi_applications appl,

719: cp_app_type VARCHAR2,
720: cp_credit_class VARCHAR2,
721: cp_unapp_type VARCHAR2) IS
722: SELECT appl.application_id
723: FROM igs_fi_applications appl,
724: igs_fi_credits fc,
725: igs_fi_cr_types crt
726: WHERE appl.invoice_id = cp_invoice_id
727: AND appl.credit_id = fc.credit_id

Line 732: FROM igs_fi_applications appl2

728: AND fc.credit_type_id = crt.credit_type_id
729: AND crt.credit_class <> cp_credit_class
730: AND appl.application_type = cp_app_type
731: AND NOT EXISTS (SELECT 'x'
732: FROM igs_fi_applications appl2
733: WHERE appl2.application_type = cp_unapp_type
734: AND appl2.link_application_id = appl.application_id
735: AND appl2.amount_applied = - appl.amount_applied)
736: ORDER BY appl.application_id DESC;

Line 753: l_ret_amount igs_fi_applications.amount_applied%TYPE;

749: l_rec_crt cur_crt%ROWTYPE;
750: l_attr_rec igs_fi_credits_api_pub.attribute_rec_type;
751: l_adj_amount igs_fi_inv_int.invoice_amount_due%TYPE;
752: l_inv cur_inv%ROWTYPE;
753: l_ret_amount igs_fi_applications.amount_applied%TYPE;
754: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
755: l_dr_gl_ccid igs_fi_invln_int.rec_gl_ccid%TYPE;
756: l_cr_gl_ccid igs_fi_invln_int.rev_gl_ccid%TYPE;
757: l_dr_account_cd igs_fi_invln_int.rec_account_cd%TYPE;

Line 759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;

755: l_dr_gl_ccid igs_fi_invln_int.rec_gl_ccid%TYPE;
756: l_cr_gl_ccid igs_fi_invln_int.rev_gl_ccid%TYPE;
757: l_dr_account_cd igs_fi_invln_int.rec_account_cd%TYPE;
758: l_cr_account_cd igs_fi_invln_int.rev_account_cd%TYPE;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;
762: l_cr_desc fnd_new_messages.message_text%TYPE;
763: l_appl_rec_exists BOOLEAN;

Line 760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;

756: l_cr_gl_ccid igs_fi_invln_int.rev_gl_ccid%TYPE;
757: l_dr_account_cd igs_fi_invln_int.rec_account_cd%TYPE;
758: l_cr_account_cd igs_fi_invln_int.rev_account_cd%TYPE;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;
762: l_cr_desc fnd_new_messages.message_text%TYPE;
763: l_appl_rec_exists BOOLEAN;
764: l_appl_amt igs_fi_applications.amount_applied%TYPE;

Line 761: l_diff_amt igs_fi_applications.amount_applied%TYPE;

757: l_dr_account_cd igs_fi_invln_int.rec_account_cd%TYPE;
758: l_cr_account_cd igs_fi_invln_int.rev_account_cd%TYPE;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;
762: l_cr_desc fnd_new_messages.message_text%TYPE;
763: l_appl_rec_exists BOOLEAN;
764: l_appl_amt igs_fi_applications.amount_applied%TYPE;
765: l_credit_id igs_fi_credits.credit_id%TYPE;

Line 764: l_appl_amt igs_fi_applications.amount_applied%TYPE;

760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;
762: l_cr_desc fnd_new_messages.message_text%TYPE;
763: l_appl_rec_exists BOOLEAN;
764: l_appl_amt igs_fi_applications.amount_applied%TYPE;
765: l_credit_id igs_fi_credits.credit_id%TYPE;
766: l_v_credit_number igs_fi_credits.credit_number%TYPE;
767: l_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE;
768: l_rec_cntr NUMBER(10);

Line 773: l_application_id igs_fi_applications.application_id%TYPE;

769:
770: l_ret_status VARCHAR2(1);
771: l_msg_count NUMBER(3);
772: l_msg_data VARCHAR2(2000);
773: l_application_id igs_fi_applications.application_id%TYPE;
774: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
775:
776: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
777: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 1115: igs_fi_applications app

1111: OR (inv.invoice_id = cp_invoice_id))
1112: AND NOT EXISTS (SELECT 'x'
1113: FROM igs_fi_credits fc,
1114: igs_fi_cr_types crt,
1115: igs_fi_applications app
1116: WHERE app.invoice_id = inv.invoice_id
1117: AND app.credit_id = fc.credit_id
1118: AND fc.status = g_cleared
1119: AND fc.credit_type_id = crt.credit_type_id

Line 1318: l_application_id igs_fi_applications.application_id%TYPE;

1314: l_line_cnt NUMBER := 1;
1315: l_var NUMBER;
1316: l_acnt_mthd IGS_FI_CONTROL.Accounting_Method%TYPE;
1317: l_rowid VARCHAR2(25);
1318: l_application_id igs_fi_applications.application_id%TYPE;
1319: l_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;
1320: l_invoice_lines_id igs_fi_invln_int.invoice_lines_id%TYPE;
1321: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
1322: l_temp VARCHAR2(1);

Line 1357: igs_fi_applications.*

1353: -- invoice id and the application type as APP
1354: CURSOR cur_app(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE,
1355: cp_app VARCHAR2) IS
1356: SELECT rowid,
1357: igs_fi_applications.*
1358: FROM igs_fi_applications
1359: WHERE invoice_id = cp_invoice_id
1360: AND application_type = cp_app;
1361:

Line 1358: FROM igs_fi_applications

1354: CURSOR cur_app(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE,
1355: cp_app VARCHAR2) IS
1356: SELECT rowid,
1357: igs_fi_applications.*
1358: FROM igs_fi_applications
1359: WHERE invoice_id = cp_invoice_id
1360: AND application_type = cp_app;
1361:
1362: -- Cursor for getting the credit record.

Line 1534: igs_fi_applications app

1530: CURSOR cur_chgadj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1531: SELECT SUM(amount_applied)
1532: FROM igs_fi_credits fc,
1533: igs_fi_cr_types crt,
1534: igs_fi_applications app
1535: WHERE app.invoice_id = cp_invoice_id
1536: AND app.credit_id = fc.credit_id
1537: AND fc.status = g_cleared
1538: AND fc.credit_type_id = crt.credit_type_id

Line 1542: l_n_chgadj_amt igs_fi_applications.amount_applied%TYPE;

1538: AND fc.credit_type_id = crt.credit_type_id
1539: AND crt.credit_class = g_neg_cr_class;
1540:
1541: l_n_elg_amt igs_fi_inv_int_all.invoice_amount%TYPE;
1542: l_n_chgadj_amt igs_fi_applications.amount_applied%TYPE;
1543:
1544: BEGIN
1545:
1546:

Line 2579: igs_fi_applications app

2575: cp_inv_amt igs_fi_inv_int_all.invoice_amount%TYPE) IS
2576: SELECT 'x'
2577: FROM igs_fi_credits_all fc,
2578: igs_fi_cr_types_all crt,
2579: igs_fi_applications app
2580: WHERE app.invoice_id = cp_invoice_id
2581: AND app.credit_id = fc.credit_id
2582: AND fc.status = g_cleared
2583: AND fc.credit_type_id = crt.credit_type_id