[Home] [Help]
21: 3. Modified finp_validate_input_data - added check for status in cur_ftci
22: vvutukur 24-Jul-02 Bug#2425767.Procedure finp_imp_calc_anc_charges modified for removing references to
23: obsoleted columns chg_rate and chg_elements.
24: sykrishn 03-JUL-02 Bug 2442163 - Procedure finp_imp_calc_anc_charges modified to insert sysdate to
25: transaction_dt in the table igs_fi_impchgs_lines table
26: Reference to anc_int table.transaction_dt is removed as it will never be present.
27: Removed transaction_dt from igs_fi_anc_int_pkg.update_row
28: Call to charges api changed to pass sysdate for invoice creation date instead of transaction_dt
29: sykrishn 10-JUL-02 Bug 2454128 - Procedure finp_imp_calc_anc_charges
362:
363: Change History
364:
365: Who When What
366: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_impchgs_lines
367: are now rounded off to currency precision
368: svuppala 04-AUG-2005 Enh 3392095 - Tution Waivers build
369: Impact of Charges API version Number change
370: Modified igs_fi_charges_api_pvt.create_charge - version 2.0 and x_waiver_amount
379: vvutukur 06-Jan-2003 Bug#2737714.Used fnd_message.set_encoded to encode the message after charges api call,if charges api returns an error.
380: Also shown the no. of successfully imported records instead of showing no. of records processsed from interface table.
381: pathipat 20-NOV-2002 Enh#2584986 - GL Interface build
382: 1. Removed override account columns from calls to insert_row of IGS_FI_IMP_CHGS and
383: IGS_FI_IMPCHGS_LINES and update_row of IGS_FI_ANC_INT.
384: Also removed the corresponding validations and local variables.
385: 2. Removed ext_attribute columns from calls to insert_row of IGS_FI_IMPCHGS_LINES
386: 3. Removed cursor cur_currency and its usage. Derived local currency using generic
387: function igs_fi_gen_gl.finp_get_cur()
381: pathipat 20-NOV-2002 Enh#2584986 - GL Interface build
382: 1. Removed override account columns from calls to insert_row of IGS_FI_IMP_CHGS and
383: IGS_FI_IMPCHGS_LINES and update_row of IGS_FI_ANC_INT.
384: Also removed the corresponding validations and local variables.
385: 2. Removed ext_attribute columns from calls to insert_row of IGS_FI_IMPCHGS_LINES
386: 3. Removed cursor cur_currency and its usage. Derived local currency using generic
387: function igs_fi_gen_gl.finp_get_cur()
388: 4. Passed sysdate to p_d_gl_date in call to charges_api. Passed null to override account
389: codes before calling charges_api.
388: 4. Passed sysdate to p_d_gl_date in call to charges_api. Passed null to override account
389: codes before calling charges_api.
390: saraskhi 13-sep-2002 Enh#2564643, removed the reference of subaccount
391: vvutukur 24-Jul-2002 Bug#2425767.Removed references to obsoleted columns chg_rate,chg_elements from
392: call to igs_fi_impchgs_lines.insert_row procedure.
393: sykrishn 10-JUL-02 Bug 2454128 - Procedure finp_imp_calc_anc_charges
394: Call to charges api changed to pass Fee Type Description for invoice description
395: (l_header_rec.p_invoice_desc) instead of null.
396: jbegum 12-Jun-02 Bug#2400189 - Added a local valriable l_rec_cntr to count the number of
394: Call to charges api changed to pass Fee Type Description for invoice description
395: (l_header_rec.p_invoice_desc) instead of null.
396: jbegum 12-Jun-02 Bug#2400189 - Added a local valriable l_rec_cntr to count the number of
397: records processed and log that in the log file
398: agairola 04-Jun-2002 Bug 2395663 - Modified the TBH call for the IGS_FI_IMPCHGS_LINES_PKG
399: SYKRISHN 19-APR-2002 Bug 2324088 - Introduced Desc Flex Field Validations and CCID validations.
400: smadathi 27-Feb-2002 Bug 2238413. Reduced selection list for
401: rec installed flag to 'Y' and 'N'.Removed
402: reference of rec installed flag = 'E'.
413:
414: -- Variables of type NUMBER
415: l_diff_amount igs_fi_inv_int.invoice_amount_due%TYPE;
416: l_import_charges_id igs_fi_imp_chgs.import_charges_id%TYPE;
417: l_impchgs_lines_id igs_fi_impchgs_lines.impchg_lines_id%TYPE;
418: l_ancillary_chg_rate igs_fi_anc_rates.ancillary_chg_rate%TYPE;
419: l_rec_cntr NUMBER(10);
420:
421: -- Variables of type BOOLEAN
830:
831: -- Passed l_v_local_currency derived to the currency_cd field (part of enh bug 2584986)
832: -- Obsoleted columns override account codes and ext_attributes
833: -- Call to igs_fi_gen_gl.get_formatted_amount formats l_ancillary_chg_rate by rounding off to currency precision
834: igs_fi_impchgs_lines_pkg.Insert_Row( x_rowid => l_rowid,
835: x_impchg_lines_id => l_impchgs_lines_id,
836: x_import_charges_id => l_import_charges_id,
837: x_transaction_dt => SYSDATE,
838: x_effective_dt => l_effective_dt,
893:
894: -- Passed l_v_local_currency derived to the currency_cd field (part of enh bug 2584986)
895: -- Obsoleted columns override account codes and ext_attributes
896: -- Call to igs_fi_gen_gl.get_formatted_amount formats l_ancillary_chg_rate by rounding off to currency precision
897: igs_fi_impchgs_lines_pkg.Insert_Row( x_rowid => l_rowid,
898: x_impchg_lines_id => l_impchgs_lines_id,
899: x_import_charges_id => l_import_charges_id,
900: x_transaction_dt => SYSDATE,
901: x_effective_dt => l_effective_dt,