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_CREDITS

Line 694: Removed the call to igs_fi_credits_api_pub.create_credit, instead placed a call to private credits api with

690: has value STUDENT_FINANCE.
691: vvutukur 05-Apr-2003 Enh#2831554.Internal Credits API Build. Replaced local function validate_lkp with the generic function call
692: igs_fi_crdapi_util.validate_igs_lkp for validating transaction type and charge method. Added check for validity of credit
693: instrument ADJ,fee calendar instance and existence of load calendar instance for a fee calendar instance.
694: Removed the call to igs_fi_credits_api_pub.create_credit, instead placed a call to private credits api with
695: validation level as none.
696: vvutukur 12-Dec-2002 Enh#2584741.Deposits Build.Removed paramter p_validation_level and added 3 new parameters
697: p_v_check_number,p_v_source_tran_type,p_v_source_tran_ref_number in the call to Credits
698: API.

Line 703: usage in the for loop.ii)igs_fi_credits_api_pub.create_credit.

699: pathipat 14-NOV-2002 EnhBug:2584986 - Added IN parameter, p_d_gl_date
700: Added parameter p_d_gl_date in the call to create_credit()
701: and create_application().
702: vvutukur 17-sep-2002 Enh#2564643.Removed references to subaccount_id from i)cursor cur_crt and from its
703: usage in the for loop.ii)igs_fi_credits_api_pub.create_credit.
704: ***********************************************************************************************/
705:
706: -- Cursor for the selection of the Invoice Details from the
707: -- Charges table based on the Invoice Id being passed

Line 724: igs_fi_credits fc,

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
728: AND fc.credit_type_id = crt.credit_type_id

Line 750: l_attr_rec igs_fi_credits_api_pub.attribute_rec_type;

746: cp_effective_date);
747:
748:
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;

Line 765: l_credit_id igs_fi_credits.credit_id%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);
769:

Line 766: l_v_credit_number igs_fi_credits.credit_number%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);
769:
770: l_ret_status VARCHAR2(1);

Line 1113: FROM igs_fi_credits fc,

1109: AND ((inv.course_cd = cp_course_cd)
1110: OR (inv.course_cd IS NULL and cp_course_cd IS NULL)))
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

Line 1294: Balance_Flag has been removed from IGS_FI_INV_INT_ALL, IGS_FI_CREDITS_ALL tables,

1290: Changed the call to IGS_FI_INVLN_INT_PKG.Insert_row.
1291: vchappid 05-Oct-2001 As a part of Enh Bug#2030448, the call to the calculate balances process is
1292: replaced with a call to the new procedure Update_Balances created as a part
1293: of the SFCR010. Limitation of the Accounting Method to CASH is removed,
1294: Balance_Flag has been removed from IGS_FI_INV_INT_ALL, IGS_FI_CREDITS_ALL tables,
1295: New column optional_fee_flag column is added in IGS_FI_INV_INT_ALL Table.
1296: smadathi 12-oct-2001 As part of enhancement bug#2042716 , the TBH calls to
1297: IGS_FI_PARTY_SUBACTS modified . Payment_plan_flag added.
1298: jbegum 19-Nov-2001 As part of Enhancement bug #2113459 the following changes were done:

Line 1319: l_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;

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);
1323: l_org_id igs_fi_inv_int.org_id%TYPE := igs_ge_gen_003.get_org_id;

Line 1363: CURSOR cur_crd(cp_credit_id igs_fi_credits.Credit_Id%TYPE) IS

1359: WHERE invoice_id = cp_invoice_id
1360: AND application_type = cp_app;
1361:
1362: -- Cursor for getting the credit record.
1363: CURSOR cur_crd(cp_credit_id igs_fi_credits.Credit_Id%TYPE) IS
1364: SELECT rowid,
1365: igs_fi_credits.*
1366: FROM igs_fi_credits
1367: WHERE credit_id = cp_credit_id;

Line 1365: igs_fi_credits.*

1361:
1362: -- Cursor for getting the credit record.
1363: CURSOR cur_crd(cp_credit_id igs_fi_credits.Credit_Id%TYPE) IS
1364: SELECT rowid,
1365: igs_fi_credits.*
1366: FROM igs_fi_credits
1367: WHERE credit_id = cp_credit_id;
1368:
1369: -- Cursor for getting the record from the IGS_FI_CONTROL table

Line 1366: FROM igs_fi_credits

1362: -- Cursor for getting the credit record.
1363: CURSOR cur_crd(cp_credit_id igs_fi_credits.Credit_Id%TYPE) IS
1364: SELECT rowid,
1365: igs_fi_credits.*
1366: FROM igs_fi_credits
1367: WHERE credit_id = cp_credit_id;
1368:
1369: -- Cursor for getting the record from the IGS_FI_CONTROL table
1370: CURSOR cur_ctrl IS

Line 1532: FROM igs_fi_credits fc,

1528:
1529: -- Cursor to fetch sum of all negative adjustment credits for a given invoice_id
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

Line 2577: FROM igs_fi_credits_all fc,

2573: -- Cursor to check if the invoice has been completely adjusted previously
2574: CURSOR cur_chk_adj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
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