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_INV_INT

Line 8: --skharida 26-Jun-2006 Bug 5208136 - Modified procedure create_charge, removed the obsoleted columns of the IGS_FI_INV_INT_PKG

4: --Known limitations/enhancements and/or remarks:
5: --
6: --Change History:
7: --Who When What
8: --skharida 26-Jun-2006 Bug 5208136 - Modified procedure create_charge, removed the obsoleted columns of the IGS_FI_INV_INT_PKG
9: --akandreg 20-Jun-2006 Bug 5116519 - The Message 'IGS_FI_INVALID_FTCI' is modified .The old token FEE_CAL_TYPE
10: -- is replaced by new token CI_DESC and passed fee CI description to that. Also the cursor
11: -- cur_alt_cd_desc is modified to select another column igs_ca_inst_all.description.
12: --pathipat 12-Jun-2006 Bug 5306868 - Modified create_charge - charge adjustment logic revamped

Line 76: -- IGS_FI_INV_INT_PKG.insert_row and IGS_FI_INVLN_INT_PKG.insert_row

72: --vvutukur 27-02-2002 removed local function validate_person and placed call to igs_fi_gen_007.validate_person
73: -- in create_charge procedure.for bug:2238362
74: --jbegum 20-Feb-02 As part Enh bug#2228910
75: -- Removed source_transaction_id column from calls to
76: -- IGS_FI_INV_INT_PKG.insert_row and IGS_FI_INVLN_INT_PKG.insert_row
77: --vvutukur 18-feb-2002 added ar_int_org_id column in call to igs_fi_control_pkg
78: -- for bug:2222272.
79: --jbegum 14-Feb-2001 As part of Enh bug # 2201081
80: -- Added call to IGS_FI_GEN_005.validate_psa and IGS_FI_PARTY_SA_PKG.insert_row

Line 115: g_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

111:
112: g_c_assessment CONSTANT VARCHAR2(30) := 'ASSESSMENT';
113: g_c_retention CONSTANT VARCHAR2(30) := 'RETENTION';
114:
115: g_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
116: g_curr_cd igs_fi_control.currency_cd%TYPE;
117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

115: g_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
116: g_curr_cd igs_fi_control.currency_cd%TYPE;
117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;

116: g_curr_cd igs_fi_control.currency_cd%TYPE;
117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,

Line 425: FUNCTION validate_source_txn_id(p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE) RETURN BOOLEAN AS

421:
422: RETURN l_bool;
423: END validate_org_unit_cd;
424:
425: FUNCTION validate_source_txn_id(p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE) RETURN BOOLEAN AS
426:
427: /***********************************************************************************************
428:
429: Created By: Amit Gairola

Line 446: CURSOR cur_txn_id(cp_source_txn_id igs_fi_inv_int.invoice_id%TYPE) IS

442: l_temp VARCHAR2(1);
443: l_bool BOOLEAN;
444:
445: -- Cursor for validating if the source transaction id is a valid invoice id
446: CURSOR cur_txn_id(cp_source_txn_id igs_fi_inv_int.invoice_id%TYPE) IS
447: SELECT 'x'
448: FROM igs_fi_inv_int
449: WHERE invoice_id = cp_source_txn_id;
450: BEGIN

Line 448: FROM igs_fi_inv_int

444:
445: -- Cursor for validating if the source transaction id is a valid invoice id
446: CURSOR cur_txn_id(cp_source_txn_id igs_fi_inv_int.invoice_id%TYPE) IS
447: SELECT 'x'
448: FROM igs_fi_inv_int
449: WHERE invoice_id = cp_source_txn_id;
450: BEGIN
451: OPEN cur_txn_id(p_source_txn_id);
452: FETCH cur_txn_id INTO l_temp;

Line 522: l_v_transaction_type igs_fi_inv_int_all.transaction_type%TYPE;

518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
521: l_st_date igs_or_unit.start_dt%TYPE;
522: l_v_transaction_type igs_fi_inv_int_all.transaction_type%TYPE;
523:
524: -- As part of the bug #1962286 the local variables l_unit_cd and l_unit_version_number were added
525:
526: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

Line 531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,

527: l_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
528:
529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course
530:
531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,
532: l_person_id igs_fi_inv_int.person_id%TYPE) IS
533: SELECT version_number
534: FROM igs_en_stdnt_ps_att
535: WHERE course_cd = l_course_cd

Line 532: l_person_id igs_fi_inv_int.person_id%TYPE) IS

528:
529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course
530:
531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,
532: l_person_id igs_fi_inv_int.person_id%TYPE) IS
533: SELECT version_number
534: FROM igs_en_stdnt_ps_att
535: WHERE course_cd = l_course_cd
536: AND person_id = l_person_id;

Line 711: FROM igs_fi_inv_int inv

707: -- Charges table based on the Invoice Id being passed
708: CURSOR cur_inv(cp_invoice_id NUMBER) IS
709: SELECT ROWID,
710: inv.*
711: FROM igs_fi_inv_int inv
712: WHERE invoice_id = cp_invoice_id;
713:
714: -- Cursor for the selection of the Application Id from the Application table
715: -- based on the Credits and the Credit Types

Line 751: l_adj_amount igs_fi_inv_int.invoice_amount_due%TYPE;

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;
755: l_dr_gl_ccid igs_fi_invln_int.rec_gl_ccid%TYPE;

Line 754: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

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;
758: l_cr_account_cd igs_fi_invln_int.rev_account_cd%TYPE;

Line 1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,

1036: p_status := TRUE;
1037: p_err_msg := NULL;
1038: END proc_neg_chg;
1039:
1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,
1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,

Line 1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,

1037: p_err_msg := NULL;
1038: END proc_neg_chg;
1039:
1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,
1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,

Line 1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,

1038: END proc_neg_chg;
1039:
1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,
1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,

Line 1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,

1039:
1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,
1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,

Line 1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,

1040: FUNCTION validate_neg_amt(p_person_id IN igs_fi_inv_int.person_id%TYPE,
1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,
1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,

Line 1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,

1041: p_fee_type IN igs_fi_inv_int.fee_type%TYPE,
1042: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
1043: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,
1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
1049: p_amt IN igs_fi_inv_int.invoice_amount%TYPE,

Line 1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,

1044: p_fee_cat IN igs_fi_inv_int.fee_cat%TYPE,
1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,
1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
1049: p_amt IN igs_fi_inv_int.invoice_amount%TYPE,
1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)
1051: /***********************************************************************************************
1052:

Line 1049: p_amt IN igs_fi_inv_int.invoice_amount%TYPE,

1045: p_course_cd IN igs_fi_inv_int.course_Cd%TYPE,
1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,
1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
1049: p_amt IN igs_fi_inv_int.invoice_amount%TYPE,
1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)
1051: /***********************************************************************************************
1052:
1053: Created By: Amit Gairola

Line 1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)

1046: p_uoo_id IN igs_fi_invln_int.uoo_id%TYPE,
1047: p_location_cd IN igs_fi_invln_int.location_cd%TYPE,
1048: p_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
1049: p_amt IN igs_fi_inv_int.invoice_amount%TYPE,
1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)
1051: /***********************************************************************************************
1052:
1053: Created By: Amit Gairola
1054:

Line 1089: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,

1085: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1086: cp_course_cd igs_ps_ver.course_cd%TYPE,
1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1088: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1089: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1090: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1091: SELECT SUM(invoice_amount) inv_amt,
1092: SUM(invoice_amount_due) inv_due,
1093: iln.error_account

Line 1090: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

1086: cp_course_cd igs_ps_ver.course_cd%TYPE,
1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1088: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1089: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1090: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1091: SELECT SUM(invoice_amount) inv_amt,
1092: SUM(invoice_amount_due) inv_due,
1093: iln.error_account
1094: FROM igs_fi_inv_int inv,

Line 1094: FROM igs_fi_inv_int inv,

1090: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1091: SELECT SUM(invoice_amount) inv_amt,
1092: SUM(invoice_amount_due) inv_due,
1093: iln.error_account
1094: FROM igs_fi_inv_int inv,
1095: igs_fi_invln_int iln
1096: WHERE inv.invoice_id = iln.invoice_id
1097: AND ((cp_invoice_id IS NULL
1098: AND inv.person_id = cp_person_id

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

1195:
1196: Change History
1197:
1198: Who When What
1199: skharida 26-Jun-2006 Bug 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
1200: akandreg 20-Jun-2006 Bug 5116519 - The Message 'IGS_FI_INVALID_FTCI' is modified .The old token FEE_CAL_TYPE
1201: is replaced by new token CI_DESC and passed fee CI description to that. Also the cursor
1202: cur_alt_cd_desc is modified to select another column 'description' from igs_ca_inst_all.
1203: pathipat 12-Jun-2006 Bug 5306868 - Modified cursor cur_chg: Added filter on invoice_amount_due

Line 1209: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_inv_int

1205: Added cursors cur_chgadj, cur_charges, associated code and local variables.
1206: sapanigr 29-May-2006 Bug 5251760 Added cursor cur_chg_inv. Removed UNION in cur_chg. Modified related code appropriately
1207: svuppala 05-May-2006 Bug 3924836; Added l_n_invoice_amount, l_n_amount variables to
1208: format amounts by rounding off to currency precision
1209: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_inv_int
1210: and igs_fi_invln_int are now rounded off to currency precision
1211: sapanigr 24-Feb-2006 Bug 5018036 - Removed cursor 'cur_ret' and cursor variable 'l_ret_rec' as it was not being used anywhere in the code.
1212: sapanigr 09-Feb-2006 Bug 5018036 - Modifed cursor 'cur_ret' to take values from base table 'igs_fi_f_typ_ca_inst_all'.
1213: The view igs_fi_f_typ_ca_inst_lkp_v used earlier lead to high shared memory usage.

Line 1222: i.e. igs_fi_inv_int_pkg.insert_row to include unit_type_id and unti_level

1218: svuppala 07-JUL-2005 Enh 3392095 - Tution Waivers build
1219: Modified HEADER_REC_TYPE -- included waiver_name.
1220: Modified l_api_version
1221: gurprsin 02-Jun-2005 Enh# 3442712 Modified TBH call of table IGS_fi_invln_int_all
1222: i.e. igs_fi_inv_int_pkg.insert_row to include unit_type_id and unti_level
1223: pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
1224: uudayapr 08-Mar-2004 Bug#3478599.Added the code to prevent charge creation with
1225: error account as Y for Transaction Type as
1226: Document when Revenue Account Derivation fails.

Line 1261: reference to subaccount_id from the calls to IGS_FI_INV_INT_PKG.Insert_Row and

1257: is running b)if no active balance rule exist for HOLDS.
1258: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie.,Removed call to the private
1259: function validate_subaccount and its related code.Removed declaration of local
1260: variables l_party_subaccount_id,l_subacc_name.Removed cursor cur_sa.Removed
1261: reference to subaccount_id from the calls to IGS_FI_INV_INT_PKG.Insert_Row and
1262: igs_fi_prc_balances.update_balances.Removed call to igs_fi_gen_005.validate_psa
1263: since the function igs_fi_gen_005.validate_psa is being removed.Removed call to
1264: igs_fi_party_sa_pkg.insert_row as the table igs_fi_party_sa is being obsoleted.
1265: Also added 7 new parameters to the call to igs_fi_control_pkg.update_row.

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 1295: New column optional_fee_flag column is added in IGS_FI_INV_INT_ALL Table.

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:
1299: Added a new cursor cur_ret.

Line 1321: l_invoice_id igs_fi_inv_int.invoice_id%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;
1324: l_ret VARCHAR2(1);
1325: l_adj_amt igs_fi_inv_int.invoice_amount%TYPE;

Line 1323: l_org_id igs_fi_inv_int.org_id%TYPE := igs_ge_gen_003.get_org_id;

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;
1324: l_ret VARCHAR2(1);
1325: l_adj_amt igs_fi_inv_int.invoice_amount%TYPE;
1326: l_amt_neg_chg igs_fi_inv_int.invoice_amount%TYPE;
1327: l_err_msg VARCHAR2(100);

Line 1325: l_adj_amt igs_fi_inv_int.invoice_amount%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;
1324: l_ret VARCHAR2(1);
1325: l_adj_amt igs_fi_inv_int.invoice_amount%TYPE;
1326: l_amt_neg_chg igs_fi_inv_int.invoice_amount%TYPE;
1327: l_err_msg VARCHAR2(100);
1328: l_status BOOLEAN;
1329: l_rec_exist BOOLEAN;

Line 1326: l_amt_neg_chg igs_fi_inv_int.invoice_amount%TYPE;

1322: l_temp VARCHAR2(1);
1323: l_org_id igs_fi_inv_int.org_id%TYPE := igs_ge_gen_003.get_org_id;
1324: l_ret VARCHAR2(1);
1325: l_adj_amt igs_fi_inv_int.invoice_amount%TYPE;
1326: l_amt_neg_chg igs_fi_inv_int.invoice_amount%TYPE;
1327: l_err_msg VARCHAR2(100);
1328: l_status BOOLEAN;
1329: l_rec_exist BOOLEAN;
1330: --

Line 1341: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;

1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:
1340: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1341: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;
1342: l_n_amount igs_fi_invln_int_all.amount%TYPE;
1343:
1344: -- Cursor for getting the record from the Charges table based on the invoice id
1345: -- passed to the cursor

Line 1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS

1342: l_n_amount igs_fi_invln_int_all.amount%TYPE;
1343:
1344: -- Cursor for getting the record from the Charges table based on the invoice id
1345: -- passed to the cursor
1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS
1347: SELECT rowid,
1348: igs_fi_inv_int.*
1349: FROM igs_fi_inv_int
1350: WHERE invoice_id = cp_invoice_id;

Line 1348: igs_fi_inv_int.*

1344: -- Cursor for getting the record from the Charges table based on the invoice id
1345: -- passed to the cursor
1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS
1347: SELECT rowid,
1348: igs_fi_inv_int.*
1349: FROM igs_fi_inv_int
1350: WHERE invoice_id = cp_invoice_id;
1351:
1352: -- Cursor for getting the records from the Applications table based on the

Line 1349: FROM igs_fi_inv_int

1345: -- passed to the cursor
1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS
1347: SELECT rowid,
1348: igs_fi_inv_int.*
1349: FROM igs_fi_inv_int
1350: WHERE invoice_id = cp_invoice_id;
1351:
1352: -- Cursor for getting the records from the Applications table based on the
1353: -- invoice id and the application type as APP

Line 1354: CURSOR cur_app(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE,

1350: WHERE invoice_id = cp_invoice_id;
1351:
1352: -- Cursor for getting the records from the Applications table based on the
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

Line 1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,

1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1384: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1385: cp_course_cd igs_ps_ver.course_cd%TYPE,
1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,
1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%TYPE,
1388: cp_location_cd igs_fi_invln_int_all.location_cd%TYPE,
1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1390: SELECT inv.rowid row_id,

Line 1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

1385: cp_course_cd igs_ps_ver.course_cd%TYPE,
1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,
1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%TYPE,
1388: cp_location_cd igs_fi_invln_int_all.location_cd%TYPE,
1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1390: SELECT inv.rowid row_id,
1391: inv.invoice_id invoice_id,
1392: inv.invoice_amount_due invoice_amount_due,
1393: inv.invoice_amount invoice_amount

Line 1394: FROM igs_fi_inv_int_all inv,

1390: SELECT inv.rowid row_id,
1391: inv.invoice_id invoice_id,
1392: inv.invoice_amount_due invoice_amount_due,
1393: inv.invoice_amount invoice_amount
1394: FROM igs_fi_inv_int_all inv,
1395: igs_fi_invln_int_all iln
1396: WHERE inv.invoice_id = iln.invoice_id
1397: AND inv.person_id = cp_person_id
1398: AND inv.fee_type = cp_fee_type

Line 1415: CURSOR cur_chg_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

1411: OR (course_cd IS NULL and cp_course_cd IS NULL))
1412: ORDER BY invoice_amount_due DESC;
1413:
1414: -- Cursor for selecting all the charges based on the Invoice ID. This is used if the invoice_id has been passed.
1415: CURSOR cur_chg_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1416: SELECT inv.rowid row_id,
1417: inv.invoice_id,
1418: inv.invoice_amount_due,
1419: inv.invoice_amount

Line 1420: FROM igs_fi_inv_int_all inv

1416: SELECT inv.rowid row_id,
1417: inv.invoice_id,
1418: inv.invoice_amount_due,
1419: inv.invoice_amount
1420: FROM igs_fi_inv_int_all inv
1421: WHERE inv.invoice_id = cp_invoice_id
1422: AND inv.invoice_amount_due > 0
1423: ORDER BY invoice_amount_due DESC;
1424:

Line 1426: CURSOR cur_waiver(cp_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,

1422: AND inv.invoice_amount_due > 0
1423: ORDER BY invoice_amount_due DESC;
1424:
1425: --3392095 cursor to check whether waiver programs exists or not
1426: CURSOR cur_waiver(cp_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1427: cp_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1428: cp_waiver_name igs_fi_inv_int.waiver_name%TYPE) IS
1429: SELECT 'X'
1430: FROM igs_fi_waiver_pgms fwp

Line 1427: cp_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,

1423: ORDER BY invoice_amount_due DESC;
1424:
1425: --3392095 cursor to check whether waiver programs exists or not
1426: CURSOR cur_waiver(cp_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1427: cp_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1428: cp_waiver_name igs_fi_inv_int.waiver_name%TYPE) IS
1429: SELECT 'X'
1430: FROM igs_fi_waiver_pgms fwp
1431: WHERE fwp.fee_cal_type = cp_fee_cal_type

Line 1428: cp_waiver_name igs_fi_inv_int.waiver_name%TYPE) IS

1424:
1425: --3392095 cursor to check whether waiver programs exists or not
1426: CURSOR cur_waiver(cp_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1427: cp_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
1428: cp_waiver_name igs_fi_inv_int.waiver_name%TYPE) IS
1429: SELECT 'X'
1430: FROM igs_fi_waiver_pgms fwp
1431: WHERE fwp.fee_cal_type = cp_fee_cal_type
1432: AND fwp.fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 1445: l_sum_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

1441: l_rec_chg_inv cur_chg_inv%ROWTYPE;
1442:
1443: l_ctrl_rec cur_ctrl%ROWTYPE;
1444:
1445: l_sum_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
1446:
1447: l_validate_flag BOOLEAN;
1448: l_valid_person VARCHAR2(1); --bug:2238362
1449:

Line 1465: SELECT igs_fi_inv_int_all_s1.NEXTVAL

1461:
1462: -- Bug #2998266 Added the following cursor
1463: CURSOR c_get_nextval
1464: IS
1465: SELECT igs_fi_inv_int_all_s1.NEXTVAL
1466: FROM DUAL;
1467: l_n_get_nextval NUMBER;
1468:
1469: l_v_igs_fi_auto_calc_waivers VARCHAR2(1);

Line 1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,

1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1489: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1490: cp_course_cd igs_ps_ver.course_cd%TYPE,
1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1492: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1493: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1494: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1495: SELECT inv.rowid row_id,

Line 1494: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

1490: cp_course_cd igs_ps_ver.course_cd%TYPE,
1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1492: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1493: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1494: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1495: SELECT inv.rowid row_id,
1496: inv.invoice_id invoice_id,
1497: inv.invoice_amount_due invoice_amount_due,
1498: inv.invoice_amount invoice_amount

Line 1499: FROM igs_fi_inv_int inv,

1495: SELECT inv.rowid row_id,
1496: inv.invoice_id invoice_id,
1497: inv.invoice_amount_due invoice_amount_due,
1498: inv.invoice_amount invoice_amount
1499: FROM igs_fi_inv_int inv,
1500: igs_fi_invln_int iln
1501: WHERE inv.invoice_id = iln.invoice_id
1502: AND cp_invoice_id IS NULL
1503: AND inv.person_id = cp_person_id

Line 1520: CURSOR cur_charges_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

1516: OR (course_cd IS NULL and cp_course_cd IS NULL))
1517: ORDER BY invoice_id ASC;
1518:
1519: -- Cursor for selecting all the charges based on the Invoice ID. This is used if the invoice_id has been passed.
1520: CURSOR cur_charges_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
1521: SELECT inv.rowid row_id,
1522: inv.invoice_id,
1523: inv.invoice_amount_due,
1524: inv.invoice_amount

Line 1525: FROM igs_fi_inv_int_all inv

1521: SELECT inv.rowid row_id,
1522: inv.invoice_id,
1523: inv.invoice_amount_due,
1524: inv.invoice_amount
1525: FROM igs_fi_inv_int_all inv
1526: WHERE inv.invoice_id = cp_invoice_id
1527: ORDER BY invoice_id ASC;
1528:
1529: -- Cursor to fetch sum of all negative adjustment credits for a given invoice_id

Line 1530: CURSOR cur_chgadj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

1526: WHERE inv.invoice_id = cp_invoice_id
1527: ORDER BY invoice_id ASC;
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

Line 1541: l_n_elg_amt igs_fi_inv_int_all.invoice_amount%TYPE;

1537: AND fc.status = g_cleared
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:

Line 1899: -- IGS_FI_INV_INT table

1895: IF p_header_rec.p_source_transaction_id IS NOT NULL THEN
1896:
1897: -- Call the procedure for validating the Source Transaction Id
1898: -- This source transaction id should be a valid Invoice Id in the
1899: -- IGS_FI_INV_INT table
1900: l_bool := validate_source_txn_id(p_header_rec.p_source_transaction_id);
1901:
1902: -- If the function returns false, then
1903: IF NOT l_bool THEN

Line 2210: -- Removed the column source_transaction_id in the call to IGS_FI_INV_INT_PKG.Insert_Row

2206: -- Call the table handler for the Charges table for creating the charges record
2207: -- from the header record passed as input to the API
2208:
2209: -- Modified by jbegum as part of Enh bug #2228910
2210: -- Removed the column source_transaction_id in the call to IGS_FI_INV_INT_PKG.Insert_Row
2211: -- Added column reversal_gl_date in call to insert_row part of bug 2584986
2212:
2213: -- Call to igs_fi_gen_gl.get_formatted_amount formats amounts by rounding off to currency precision
2214: igs_fi_inv_int_pkg.insert_row(x_rowid => l_rowid,

Line 2214: igs_fi_inv_int_pkg.insert_row(x_rowid => l_rowid,

2210: -- Removed the column source_transaction_id in the call to IGS_FI_INV_INT_PKG.Insert_Row
2211: -- Added column reversal_gl_date in call to insert_row part of bug 2584986
2212:
2213: -- Call to igs_fi_gen_gl.get_formatted_amount formats amounts by rounding off to currency precision
2214: igs_fi_inv_int_pkg.insert_row(x_rowid => l_rowid,
2215: x_invoice_id => l_invoice_id,
2216: x_person_id => p_header_rec.p_person_id,
2217: x_fee_type => p_header_rec.p_fee_type,
2218: x_fee_cat => p_header_rec.p_fee_cat,

Line 2562: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

2558:
2559: END create_charge;
2560:
2561:
2562: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
2563: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN AS
2564: /***********************************************************************************************
2565: Created By: Priya Athipatla
2566: Date Created By: 29-03-2006

Line 2563: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN AS

2559: END create_charge;
2560:
2561:
2562: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
2563: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN AS
2564: /***********************************************************************************************
2565: Created By: Priya Athipatla
2566: Date Created By: 29-03-2006
2567: Purpose: This function validates if the charge has been completely adjusted or not.

Line 2574: CURSOR cur_chk_adj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

2570: Who When What
2571: ********************************************************************************************** */
2572:
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,

Line 2575: cp_inv_amt igs_fi_inv_int_all.invoice_amount%TYPE) IS

2571: ********************************************************************************************** */
2572:
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