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_GEN_007 dependencies on IGS_FI_INV_INT

Line 11: CURSOR cur_invoice(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

7: WHERE credit_id = cp_credit_id
8: AND status = 'CLEARED'
9: AND unapplied_amount >0;
10:
11: CURSOR cur_invoice(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
12: SELECT inv.*
13: FROM igs_fi_inv_int inv
14: WHERE inv.invoice_id = cp_invoice_id
15: AND inv.invoice_amount_due >0;

Line 13: FROM igs_fi_inv_int inv

9: AND unapplied_amount >0;
10:
11: CURSOR cur_invoice(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
12: SELECT inv.*
13: FROM igs_fi_inv_int inv
14: WHERE inv.invoice_id = cp_invoice_id
15: AND inv.invoice_amount_due >0;
16:
17: CURSOR cur_credit_unapp(cp_credit_id igs_fi_credits.credit_id%TYPE) IS

Line 24: CURSOR cur_invoice_unapp(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

20: WHERE credit_id = cp_credit_id
21: AND status = 'CLEARED'
22: AND unapplied_amount >=0;
23:
24: CURSOR cur_invoice_unapp(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
25: SELECT inv.*
26: FROM igs_fi_inv_int inv
27: WHERE inv.invoice_id = cp_invoice_id
28: AND inv.invoice_amount_due >=0;

Line 26: FROM igs_fi_inv_int inv

22: AND unapplied_amount >=0;
23:
24: CURSOR cur_invoice_unapp(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
25: SELECT inv.*
26: FROM igs_fi_inv_int inv
27: WHERE inv.invoice_id = cp_invoice_id
28: AND inv.invoice_amount_due >=0;
29:
30: g_chg_adj CONSTANT VARCHAR2(10) :='CHGADJ';

Line 148: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,

144: END get_segval_desc;
145:
146:
147: PROCEDURE validate_parameters(p_credit_id IN igs_fi_credits.credit_id%TYPE,
148: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
149: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
150: p_appl_type IN igs_fi_applications.application_type%TYPE,
151: p_application_id IN igs_fi_applications.application_id%TYPE,
152: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,

Line 181: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

177: WHERE appl_hierarchy_id = p_appl_hierarchy_id;
178:
179:
180: CURSOR cur_chk_crd_inv(cp_credit_id igs_fi_credits.credit_id%TYPE,
181: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
182: SELECT 'X'
183: FROM igs_fi_applications
184: WHERE application_id=p_application_id
185: AND credit_id=cp_credit_id

Line 382: PROCEDURE call_update_charges(p_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,

378:
379:
380: END validate_parameters;
381:
382: PROCEDURE call_update_charges(p_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
383: p_cur_invoice IN cur_invoice%ROWTYPE,
384: p_v_opt_fee_flag IN igs_fi_inv_int_all.optional_fee_flag%TYPE,
385: p_flag OUT NOCOPY BOOLEAN ) AS
386: /*|| Created By :Sarakshi

Line 384: p_v_opt_fee_flag IN igs_fi_inv_int_all.optional_fee_flag%TYPE,

380: END validate_parameters;
381:
382: PROCEDURE call_update_charges(p_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
383: p_cur_invoice IN cur_invoice%ROWTYPE,
384: p_v_opt_fee_flag IN igs_fi_inv_int_all.optional_fee_flag%TYPE,
385: p_flag OUT NOCOPY BOOLEAN ) AS
386: /*|| Created By :Sarakshi
387: || Created On :24-Jan-2002
388: || Purpose : For updating charges record once a application/unapplication has happened.

Line 392: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL

388: || Purpose : For updating charges record once a application/unapplication has happened.
389: || Known limitations, enhancements or remarks :
390: || Change History :
391: || Who When What
392: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
393: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_inv_int_pkg.update_row
394: || pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
395: || pathipat 07-Jun-2003 Enh 2831584 - SS Enhancements build
396: || Added parameter p_v_opt_fee_flag

Line 393: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_inv_int_pkg.update_row

389: || Known limitations, enhancements or remarks :
390: || Change History :
391: || Who When What
392: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
393: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_inv_int_pkg.update_row
394: || pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
395: || pathipat 07-Jun-2003 Enh 2831584 - SS Enhancements build
396: || Added parameter p_v_opt_fee_flag
397: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row

Line 397: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row

393: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_inv_int_pkg.update_row
394: || pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
395: || pathipat 07-Jun-2003 Enh 2831584 - SS Enhancements build
396: || Added parameter p_v_opt_fee_flag
397: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row
398: || to add new parameter reversal GL Date
399: || jbegum 20 feb 02 Enh bug # 2228910
400: || Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
401: || (reverse chronological order - newest change first) */

Line 400: || Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row

396: || Added parameter p_v_opt_fee_flag
397: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row
398: || to add new parameter reversal GL Date
399: || jbegum 20 feb 02 Enh bug # 2228910
400: || Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
401: || (reverse chronological order - newest change first) */
402:
403: l_v_opt_fee_flag igs_fi_inv_int_all.optional_fee_flag%TYPE := NULL;
404:

Line 403: l_v_opt_fee_flag igs_fi_inv_int_all.optional_fee_flag%TYPE := NULL;

399: || jbegum 20 feb 02 Enh bug # 2228910
400: || Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
401: || (reverse chronological order - newest change first) */
402:
403: l_v_opt_fee_flag igs_fi_inv_int_all.optional_fee_flag%TYPE := NULL;
404:
405: BEGIN
406:
407: p_flag := TRUE;

Line 416: igs_fi_inv_int_pkg.update_row(x_rowid => p_cur_invoice.row_id,

412: l_v_opt_fee_flag := p_v_opt_fee_flag;
413: END IF;
414:
415: BEGIN
416: igs_fi_inv_int_pkg.update_row(x_rowid => p_cur_invoice.row_id,
417: x_invoice_id => p_cur_invoice.invoice_id,
418: x_person_id => p_cur_invoice.person_id,
419: x_fee_type => p_cur_invoice.fee_type,
420: x_fee_cat => p_cur_invoice.fee_cat,

Line 566: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,

562: END call_update_credits;
563:
564:
565: PROCEDURE application(p_credit_id IN igs_fi_credits.credit_id%TYPE,
566: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
567: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
568: p_cur_credit IN cur_credit%ROWTYPE,
569: p_cur_invoice IN cur_invoice%ROWTYPE,
570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,

Line 577: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,
575: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,
576: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
577: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
578: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
579: p_status OUT NOCOPY BOOLEAN,
580: p_d_gl_date IN DATE
581: )

Line 618: l_v_optional_fee_flag igs_fi_inv_int_all.optional_fee_flag%TYPE := NULL;

614: l_appl_success BOOLEAN :=TRUE;
615: l_crd_upd_success BOOLEAN :=TRUE;
616: l_chg_upd_success BOOLEAN :=TRUE;
617:
618: l_v_optional_fee_flag igs_fi_inv_int_all.optional_fee_flag%TYPE := NULL;
619:
620: BEGIN
621: SAVEPOINT S1;
622: p_application_id:=NULL;

Line 739: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,

735:
736: END application;
737:
738: PROCEDURE unapplication(p_credit_id IN igs_fi_credits.credit_id%TYPE,
739: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
740: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
741: p_cur_credit IN cur_credit%ROWTYPE,
742: p_cur_invoice IN cur_invoice%ROWTYPE,
743: p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,

Line 745: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

741: p_cur_credit IN cur_credit%ROWTYPE,
742: p_cur_invoice IN cur_invoice%ROWTYPE,
743: p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
744: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
745: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
746: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
747: p_status OUT NOCOPY BOOLEAN,
748: p_d_gl_date IN DATE
749: ) AS

Line 1032: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
1032: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
1033: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
1034: p_status OUT NOCOPY BOOLEAN,
1035: p_d_gl_date IN DATE
1036: ) AS