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_APPLICATIONS

Line 149: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,

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,
153: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,

Line 150: p_appl_type IN igs_fi_applications.application_type%TYPE,

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,
153: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
154: p_status OUT NOCOPY BOOLEAN,

Line 151: p_application_id IN igs_fi_applications.application_id%TYPE,

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,
153: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
154: p_status OUT NOCOPY BOOLEAN,
155: p_d_gl_date IN DATE

Line 152: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_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,
153: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
154: p_status OUT NOCOPY BOOLEAN,
155: p_d_gl_date IN DATE
156: ) AS

Line 183: FROM igs_fi_applications

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
186: AND invoice_id=cp_invoice_id;
187:

Line 190: FROM igs_fi_applications a1,

186: AND invoice_id=cp_invoice_id;
187:
188: CURSOR cur_app_rec IS
189: SELECT 'X'
190: FROM igs_fi_applications a1,
191: igs_fi_applications a2
192: WHERE a1.application_id=p_application_id
193: AND a1.application_id=a2.link_application_id
194: AND a1.amount_applied= - a2.amount_applied;

Line 191: igs_fi_applications a2

187:
188: CURSOR cur_app_rec IS
189: SELECT 'X'
190: FROM igs_fi_applications a1,
191: igs_fi_applications a2
192: WHERE a1.application_id=p_application_id
193: AND a1.application_id=a2.link_application_id
194: AND a1.amount_applied= - a2.amount_applied;
195:

Line 198: FROM igs_fi_applications

194: AND a1.amount_applied= - a2.amount_applied;
195:
196: CURSOR cur_chk_app IS
197: SELECT credit_id,invoice_id
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

Line 567: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,

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,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,

Line 574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,

570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%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,

Line 575: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,

571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%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,

Line 595: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_applications_pkg.insert_row

591: || charges table instead of the optional_payment_ind column of fee type table.
592: || pathipat 07-Jun-2003 Enh 2831584 - SS Enhancements build
593: || Modified call to call_update_charges() - Added check for optional_payment_ind
594: || and waiver flag
595: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_applications_pkg.insert_row
596: || to add new parameters GL Date , GL_POSTED_DATE, POSTING_CONTROL_ID
597: || (reverse chronological order - newest change first) */
598:
599: CURSOR cur_cr_act IS

Line 612: l_amount igs_fi_applications.amount_applied%TYPE;

608: WHERE invoice_id = p_invoice_id;
609: l_cur_invln cur_invln%ROWTYPE;
610:
611: l_rowid VARCHAR2(25):=NULL;
612: l_amount igs_fi_applications.amount_applied%TYPE;
613: l_status BOOLEAN :=TRUE;
614: l_appl_success BOOLEAN :=TRUE;
615: l_crd_upd_success BOOLEAN :=TRUE;
616: l_chg_upd_success BOOLEAN :=TRUE;

Line 666: igs_fi_applications_pkg.insert_row( X_ROWID => l_rowid,

662: --Insert record into application table
663: -- Modified apply_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
664: BEGIN
665: p_application_id:=NULL;
666: igs_fi_applications_pkg.insert_row( X_ROWID => l_rowid,
667: X_APPLICATION_ID => p_application_id,
668: X_APPLICATION_TYPE => g_app,
669: X_INVOICE_ID => p_invoice_id,
670: X_CREDIT_ID => p_credit_id,

Line 740: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,

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

Line 743: p_application_id IN OUT NOCOPY igs_fi_applications.application_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,
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,

Line 759: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_applications_pkg.insert_row

755: || Change History :
756: || Who When What
757: || pathipat 07-Jun-2003 Enh 2831584 - SS Enhancements build
758: || Modified call to call_update_charges()
759: || smadathi 20-NOV-2002 Enh. Bug 2584986. Modified igs_fi_applications_pkg.insert_row
760: || to add new parameters GL Date , GL_POSTED_DATE, POSTING_CONTROL_ID
761: || (reverse chronological order - newest change first) */
762:
763:

Line 766: FROM igs_fi_applications

762:
763:
764: CURSOR cur_unapp IS
765: SELECT *
766: FROM igs_fi_applications
767: WHERE application_id = p_application_id;
768: l_cur_unapp cur_unapp%ROWTYPE;
769:
770: l_unapp_amnt igs_fi_applications.amount_applied%TYPE;

Line 770: l_unapp_amnt igs_fi_applications.amount_applied%TYPE;

766: FROM igs_fi_applications
767: WHERE application_id = p_application_id;
768: l_cur_unapp cur_unapp%ROWTYPE;
769:
770: l_unapp_amnt igs_fi_applications.amount_applied%TYPE;
771:
772: l_rowid VARCHAR2(25);
773: l_application_id igs_fi_applications.application_id%TYPE ;
774: l_amount igs_fi_applications.amount_applied%TYPE;

Line 773: l_application_id igs_fi_applications.application_id%TYPE ;

769:
770: l_unapp_amnt igs_fi_applications.amount_applied%TYPE;
771:
772: l_rowid VARCHAR2(25);
773: l_application_id igs_fi_applications.application_id%TYPE ;
774: l_amount igs_fi_applications.amount_applied%TYPE;
775: l_appl_success BOOLEAN :=TRUE;
776: l_crd_upd_success BOOLEAN :=TRUE;
777: l_chg_upd_success BOOLEAN :=TRUE;

Line 774: l_amount igs_fi_applications.amount_applied%TYPE;

770: l_unapp_amnt igs_fi_applications.amount_applied%TYPE;
771:
772: l_rowid VARCHAR2(25);
773: l_application_id igs_fi_applications.application_id%TYPE ;
774: l_amount igs_fi_applications.amount_applied%TYPE;
775: l_appl_success BOOLEAN :=TRUE;
776: l_crd_upd_success BOOLEAN :=TRUE;
777: l_chg_upd_success BOOLEAN :=TRUE;
778: BEGIN

Line 808: igs_fi_applications_pkg.insert_row( X_ROWID => l_rowid,

804: -- Modified apply_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
805: BEGIN
806: l_rowid:=NULL;
807: l_application_id:=NULL;
808: igs_fi_applications_pkg.insert_row( X_ROWID => l_rowid,
809: X_APPLICATION_ID => l_application_id,
810: X_APPLICATION_TYPE => g_unapp,
811: X_INVOICE_ID => p_invoice_id,
812: X_CREDIT_ID => p_credit_id,

Line 983: FUNCTION get_sum_appl_amnt(p_application_id IN igs_fi_applications.application_id%TYPE)

979: END IF;--End of p_status
980:
981: END get_appl_acc;
982:
983: FUNCTION get_sum_appl_amnt(p_application_id IN igs_fi_applications.application_id%TYPE)
984: RETURN NUMBER AS
985: /*
986: || Created By :Sarakshi
987: || Created On :31-Jan-2002

Line 998: SELECT amount_applied FROM igs_fi_applications

994: || pmarada 14-Mar-2005 Bug 4224386, Instead of sum builtin, repeating in a loop to sum the unapply amount.
995: */
996:
997: CURSOR cur_unapp_amnt IS
998: SELECT amount_applied FROM igs_fi_applications
999: WHERE (application_id = p_application_id AND application_type='APP')
1000: OR link_application_id=p_application_id;
1001:
1002: l_cur_unapp_amnt igs_fi_applications.amount_applied%TYPE;

Line 1002: l_cur_unapp_amnt igs_fi_applications.amount_applied%TYPE;

998: SELECT amount_applied FROM igs_fi_applications
999: WHERE (application_id = p_application_id AND application_type='APP')
1000: OR link_application_id=p_application_id;
1001:
1002: l_cur_unapp_amnt igs_fi_applications.amount_applied%TYPE;
1003:
1004: BEGIN
1005: --To return the sum of amount applied for an application Id and its corresponding unapplication
1006: --records ,if no record is found or parameter passed is null then return null

Line 1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,

1016:
1017: END get_sum_appl_amnt;
1018:
1019:
1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,

Line 1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,

1017: END get_sum_appl_amnt;
1018:
1019:
1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,

Line 1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,

1018:
1019:
1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,

Line 1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,

1019:
1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,

Line 1024: p_appl_type IN igs_fi_applications.application_type%TYPE,

1020: PROCEDURE create_application (p_application_id IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
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,

Line 1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,

1021: p_credit_id IN igs_fi_applications.credit_id%TYPE,
1022: p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
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,

Line 1050: FROM igs_fi_applications

1046: || (reverse chronological order - newest change first) */
1047:
1048: CURSOR cur_app IS
1049: SELECT credit_id,invoice_id
1050: FROM igs_fi_applications
1051: WHERE application_id=p_application_id;
1052:
1053: l_cur_app cur_app%ROWTYPE;
1054: l_cur_credit cur_credit%ROWTYPE;