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_INVLN_INT

Line 30: --gurprsin 03-Jun-2005 Enh# 3442712 Modified call to igs_fi_prc_acct_pkg.build_accounts and igs_fi_invln_int_pkg.insert_row methods.

26: --pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
27: -- parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
28: -- svuppala 9-JUN-2005 Enh 4213629 - Impact of automatic generation of the Receipt Number
29: -- changed logic for l_v_credit_number in procedure proc_neg_chg.
30: --gurprsin 03-Jun-2005 Enh# 3442712 Modified call to igs_fi_prc_acct_pkg.build_accounts and igs_fi_invln_int_pkg.insert_row methods.
31: -- svuppala 05-APR-2005 Bug# "4240402" Additional fix done as part of Time Zone impact
32: -- Changed the negative charge adjustment logic with ORDER BY application_id
33: -- instead of APPLY_DATE as time part of it is truncated.
34: --pathipat 30-Sep-2004 Bug 3908040 - Modified proc_neg_chg() - Removed check on Manage Accounts = Other before application/unapplication

Line 54: -- in call to igs_fi_invln_int.insert_row().

50: --smadathi 18-Feb-2002 Enh. Bug 2747329.Modified create_charge procedure.
51: --vvutukur 12-Dec-2002 Enh#2584741.Deposits Build. Modified procedure proc_neg_chg.
52: --pathipat 14-Nov-2002 Enh 2584986 -
53: -- 1. Modified create_charge(), added parameter p_d_gl_date
54: -- in call to igs_fi_invln_int.insert_row().
55: -- 2. Modified proc_neg_chg(), added p_gl_date and p_currency_cd as IN parameter. Passed gl_date
56: -- in calls to create_application() and create_credit() in proc_neg_chg
57: -- 3. Removed local procedure get_local_amount() - exchange_rate = 1 always.
58: -- 4. Modified function validate_cur()

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 469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,

465: -- enh bug#2584986, removed proc get_local_amount
466:
467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,

Line 470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,

466:
467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER

Line 471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,

467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER
475: ) AS

Line 472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,

468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER
475: ) AS
476: /**********************************************************************************************************************

Line 473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,

469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER
475: ) AS
476: /**********************************************************************************************************************
477:

Line 513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;

509: The call to the procedure igs_fi_prc_acct_pkg.build_accounts was modified.
510: **********************************************************************************************************************/
511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;

Line 514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;

510: **********************************************************************************************************************/
511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;

Line 515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;

511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;

Line 516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;

512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 517: l_err_string igs_fi_invln_int_all.error_string%TYPE;

513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%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;

Line 755: l_dr_gl_ccid igs_fi_invln_int.rec_gl_ccid%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;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;

Line 756: l_cr_gl_ccid igs_fi_invln_int.rev_gl_ccid%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;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;

Line 757: l_dr_account_cd igs_fi_invln_int.rec_account_cd%TYPE;

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;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;

Line 758: l_cr_account_cd igs_fi_invln_int.rev_account_cd%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;
759: l_unapply_amt igs_fi_applications.amount_applied%TYPE;
760: l_unapp_amt igs_fi_applications.amount_applied%TYPE;
761: l_diff_amt igs_fi_applications.amount_applied%TYPE;
762: l_cr_desc fnd_new_messages.message_text%TYPE;

Line 1046: p_uoo_id IN igs_fi_invln_int.uoo_id%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,
1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)

Line 1047: p_location_cd IN igs_fi_invln_int.location_cd%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,
1050: p_source_txn_id IN igs_fi_inv_int.invoice_id%TYPE)
1051: /***********************************************************************************************

Line 1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,

1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%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,

Line 1088: cp_location_cd igs_fi_invln_int.location_cd%TYPE,

1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%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,

Line 1095: igs_fi_invln_int iln

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
1099: AND inv.fee_type = cp_fee_type

Line 1210: and igs_fi_invln_int are now rounded off to currency precision

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.
1214: abshriva 24-Oct-2005 Bug 4680553 - The Message 'IGS_FI_WAV_TRANS_CREATED' was removed as it was being

Line 1221: gurprsin 02-Jun-2005 Enh# 3442712 Modified TBH call of table IGS_fi_invln_int_all

1217: Removed invocation of validate_atd_mode and validate_atd_type
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

Line 1249: in the call to igs_fi_invln_int_pkg.insert_row()

1245: smadathi 18-Feb-2002 Enh. Bug 2747329.Modified the TBH call to IGS_FI_CONTROL to Add new columns
1246: rfnd_destination, ap_org_id, dflt_supplier_site_name
1247: pathipat 14-Nov-2002 Enh Bug: 2584986 -
1248: 1. Added parameters gl_date, gl_posted_date and posting_control_id
1249: in the call to igs_fi_invln_int_pkg.insert_row()
1250: 2. Added parameter p_gl_date in call to proc_neg_chg() for negative charges
1251: 3. Removed calls to get_local_amount, passed the invoice_amount and currency_cd
1252: directly from p_header_rec, instead of conversion to local currency
1253: vvutukur 20-sep-2002 Enh#2562745.1)Added conv_process_run_ind parameter to call to igs_fi_control_pkg.

Line 1287: before inserting the data into igs_fi_invln_int.

1283: kkillams 01-08-2001 Modification done w.r.t student finance dld bug id :1882122
1284: Build accounting process is calling only if these parameters are
1285: don't have values p_override_dr_rec_ccid, p_override_cr_rev_ccid,
1286: p_override_dr_rec_account_cd and p_override_cr_rev_account_cd
1287: before inserting the data into igs_fi_invln_int.
1288: jbegum 26-Sep-2001 As part of bug #1962286 the following changes were done:
1289: Changed the call to the local function validate_uoo.
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

Line 1290: Changed the call to IGS_FI_INVLN_INT_PKG.Insert_row.

1286: p_override_dr_rec_account_cd and p_override_cr_rev_account_cd
1287: before inserting the data into igs_fi_invln_int.
1288: jbegum 26-Sep-2001 As part of bug #1962286 the following changes were done:
1289: Changed the call to the local function validate_uoo.
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,

Line 1320: l_invoice_lines_id igs_fi_invln_int.invoice_lines_id%TYPE;

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;
1324: l_ret VARCHAR2(1);

Line 1332: l_error_string igs_fi_invln_int.error_string%TYPE;

1328: l_status BOOLEAN;
1329: l_rec_exist BOOLEAN;
1330: --
1331: -- these variable are added w.r.t finance accounting bug no : 1882122
1332: l_error_string igs_fi_invln_int.error_string%TYPE;
1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;

Line 1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;

1331: -- these variable are added w.r.t finance accounting bug no : 1882122
1332: l_error_string igs_fi_invln_int.error_string%TYPE;
1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%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:

Line 1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;

1332: l_error_string igs_fi_invln_int.error_string%TYPE;
1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%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;

Line 1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;

1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%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;

Line 1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;

1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%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;

Line 1342: l_n_amount igs_fi_invln_int_all.amount%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
1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS

Line 1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%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,
1391: inv.invoice_id invoice_id,

Line 1388: cp_location_cd igs_fi_invln_int_all.location_cd%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,
1391: inv.invoice_id invoice_id,
1392: inv.invoice_amount_due invoice_amount_due,

Line 1395: igs_fi_invln_int_all iln

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
1399: AND inv.fee_cal_type = cp_fee_cal_type

Line 1492: cp_uoo_id igs_fi_invln_int.uoo_id%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,
1496: inv.invoice_id invoice_id,

Line 1493: cp_location_cd igs_fi_invln_int.location_cd%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,
1496: inv.invoice_id invoice_id,
1497: inv.invoice_amount_due invoice_amount_due,

Line 1500: igs_fi_invln_int iln

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
1504: AND inv.fee_type = cp_fee_type

Line 2310: -- As part of bug #1962286 the call to the IGS_FI_INVLN_INT_PKG.Insert_Row was modified.

2306: l_error_account := 'N';
2307: l_error_string := NULL;
2308: END IF;
2309:
2310: -- As part of bug #1962286 the call to the IGS_FI_INVLN_INT_PKG.Insert_Row was modified.
2311: -- The six UOO columns were removed and the two new columns location_cd and uoo_id were added in the call
2312:
2313: -- Modified by jbegum as part of Enh bug #2228910
2314: -- Removed the column source_transaction_id in the call to IGS_FI_INVLN_INT_PKG.Insert_Row

Line 2314: -- Removed the column source_transaction_id in the call to IGS_FI_INVLN_INT_PKG.Insert_Row

2310: -- As part of bug #1962286 the call to the IGS_FI_INVLN_INT_PKG.Insert_Row was modified.
2311: -- The six UOO columns were removed and the two new columns location_cd and uoo_id were added in the call
2312:
2313: -- Modified by jbegum as part of Enh bug #2228910
2314: -- Removed the column source_transaction_id in the call to IGS_FI_INVLN_INT_PKG.Insert_Row
2315:
2316: -- Call the Table Handler for creating the Charges Lines record
2317: -- Enh bug 2584986: Added parameters gl_date, gl_posted_date and posting_control_id in call to insert_row
2318:

Line 2320: igs_fi_invln_int_pkg.insert_row(x_rowid => l_rowid,

2316: -- Call the Table Handler for creating the Charges Lines record
2317: -- Enh bug 2584986: Added parameters gl_date, gl_posted_date and posting_control_id in call to insert_row
2318:
2319: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
2320: igs_fi_invln_int_pkg.insert_row(x_rowid => l_rowid,
2321: x_invoice_lines_id => l_invoice_lines_id,
2322: x_invoice_id => l_invoice_id,
2323: x_line_number => l_var,
2324: x_chg_elements => p_line_tbl(l_var).p_chg_elements,