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_CREDITS

Line 4: CURSOR cur_credit(cp_credit_id igs_fi_credits.credit_id%TYPE) IS

1: PACKAGE BODY igs_fi_gen_007 AS
2: /* $Header: IGSFI62B.pls 120.5 2006/06/27 14:13:57 skharida ship $ */
3:
4: CURSOR cur_credit(cp_credit_id igs_fi_credits.credit_id%TYPE) IS
5: SELECT *
6: FROM igs_fi_credits
7: WHERE credit_id = cp_credit_id
8: AND status = 'CLEARED'

Line 6: FROM igs_fi_credits

2: /* $Header: IGSFI62B.pls 120.5 2006/06/27 14:13:57 skharida ship $ */
3:
4: CURSOR cur_credit(cp_credit_id igs_fi_credits.credit_id%TYPE) IS
5: SELECT *
6: FROM igs_fi_credits
7: WHERE credit_id = cp_credit_id
8: AND status = 'CLEARED'
9: AND unapplied_amount >0;
10:

Line 17: CURSOR cur_credit_unapp(cp_credit_id igs_fi_credits.credit_id%TYPE) IS

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
18: SELECT *
19: FROM igs_fi_credits
20: WHERE credit_id = cp_credit_id
21: AND status = 'CLEARED'

Line 19: FROM igs_fi_credits

15: AND inv.invoice_amount_due >0;
16:
17: CURSOR cur_credit_unapp(cp_credit_id igs_fi_credits.credit_id%TYPE) IS
18: SELECT *
19: FROM igs_fi_credits
20: WHERE credit_id = cp_credit_id
21: AND status = 'CLEARED'
22: AND unapplied_amount >=0;
23:

Line 147: PROCEDURE validate_parameters(p_credit_id IN igs_fi_credits.credit_id%TYPE,

143: RAISE;
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,

Line 180: CURSOR cur_chk_crd_inv(cp_credit_id igs_fi_credits.credit_id%TYPE,

176: FROM igs_fi_a_hierarchies
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

Line 202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS

198: FROM igs_fi_applications
199: WHERE application_id=p_application_id
200: AND application_type='APP';
201:
202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
203: SELECT credit_class
204: FROM igs_fi_cr_types crtyp
205: WHERE EXISTS (SELECT '1'
206: FROM igs_fi_credits crd

Line 206: FROM igs_fi_credits crd

202: CURSOR c_igs_fi_cr_types(cp_n_credit_id igs_fi_credits.credit_id%TYPE) IS
203: SELECT credit_class
204: FROM igs_fi_cr_types crtyp
205: WHERE EXISTS (SELECT '1'
206: FROM igs_fi_credits crd
207: WHERE crd.credit_type_id = crtyp.credit_type_id
208: AND crd.credit_id = cp_n_credit_id
209: );
210:

Line 466: PROCEDURE call_update_credits(p_unapplied_amount IN igs_fi_credits_all.unapplied_amount%TYPE,

462: END;
463:
464: END call_update_charges;
465:
466: PROCEDURE call_update_credits(p_unapplied_amount IN igs_fi_credits_all.unapplied_amount%TYPE,
467: p_cur_credit IN cur_credit%ROWTYPE,
468: p_flag OUT NOCOPY BOOLEAN)
469: AS
470: /*|| Created By :Sarakshi

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

472: || Purpose : For updating a credit record once a application/unappliaction has happened.
473: || Known limitations, enhancements or remarks :
474: || Change History :
475: || Who When What
476: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_credits_pkg.update_row
477: || pathipat 21-Apr-2004 Enh 3558549 - Commercial Receivables Enhancements
478: || Added parameter x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
479: || vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new parameters(lockbox_interface_id,batch_name,deposit_date) to the update_row
480: || call of credits table.

Line 478: || Added parameter x_source_invoice_id in call to igs_fi_credits_pkg.update_row()

474: || Change History :
475: || Who When What
476: || gurprsin 16-Aug-2005 Enh 3392095 - Tution Waiver build - Added new column waiver_name in the TBH call igs_fi_credits_pkg.update_row
477: || pathipat 21-Apr-2004 Enh 3558549 - Commercial Receivables Enhancements
478: || Added parameter x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
479: || vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new parameters(lockbox_interface_id,batch_name,deposit_date) to the update_row
480: || call of credits table.
481: || schodava 16-Jun-2003 Enh # 2831587 - Credit Card Fund Transfer Build - Modified call to update row.
482: || pathipat 16-Dec-2002 Enh bug 2584741 - Deposits build - Modified call to update_row

Line 484: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_credits_pkg.update_row

480: || call of credits table.
481: || schodava 16-Jun-2003 Enh # 2831587 - Credit Card Fund Transfer Build - Modified call to update row.
482: || pathipat 16-Dec-2002 Enh bug 2584741 - Deposits build - Modified call to update_row
483: || Added columns check_number, source_transaction_type and source_transaction_ref
484: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_credits_pkg.update_row
485: || to add new parameter GL Date
486: || sykrishn 14feb2002 SFCR020 build 2191470- Added 4 new params to update_row call for credits
487: || (reverse chronological order - newest change first) */
488:

Line 492: igs_fi_credits_pkg.update_row( X_ROWID => p_cur_credit.row_id,

488:
489: BEGIN
490: p_flag:=TRUE;
491: BEGIN
492: igs_fi_credits_pkg.update_row( X_ROWID => p_cur_credit.row_id,
493: X_CREDIT_ID => p_cur_credit.credit_id,
494: X_CREDIT_NUMBER => p_cur_credit.credit_number,
495: X_STATUS => p_cur_credit.status,
496: X_CREDIT_SOURCE => p_cur_credit.credit_source,

Line 565: PROCEDURE application(p_credit_id IN igs_fi_credits.credit_id%TYPE,

561: END;
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,

Line 576: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,

572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%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

Line 738: PROCEDURE unapplication(p_credit_id IN igs_fi_credits.credit_id%TYPE,

734: END IF;
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,

Line 744: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%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,
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

Line 899: igs_fi_credits c,

895:
896: CURSOR cur_class IS
897: SELECT ct.credit_class
898: FROM igs_fi_cr_types ct,
899: igs_fi_credits c,
900: igs_fi_cr_activities ca
901: WHERE ct.credit_type_id=c.credit_type_id
902: AND c.credit_id=ca.credit_id
903: AND ca.credit_activity_id=p_cr_activity_id;

Line 1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,

1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%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