APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_FI_ANC_INT

Line 27: Removed transaction_dt from igs_fi_anc_int_pkg.update_row

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
30: Call to charges api changed to pass Fee Type Description for invoice description
31: (l_header_rec.p_invoice_desc) instead of null.

Line 383: IGS_FI_IMPCHGS_LINES and update_row of IGS_FI_ANC_INT.

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()

Line 429: l_effective_dt igs_fi_anc_int.Effective_Dt%TYPE;

425: -- New variable defined as part of 2324088
426: l_dff_validate BOOLEAN;
427:
428: -- Variables of type DATE
429: l_effective_dt igs_fi_anc_int.Effective_Dt%TYPE;
430:
431: -- Variables for Charges API Integration
432: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
433: l_line_tbl igs_fi_charges_api_pvt.line_tbl_type;

Line 465: IGS_FI_ANC_INT.*

461: cp_fee_cal_type IGS_FI_ANC_RATES.Fee_Cal_Type%TYPE,
462: cp_fee_ci_sequence_number IGS_FI_ANC_RATES.Fee_Ci_Sequence_Number%TYPE,
463: cp_fee_type IGS_FI_ANC_RATES.Fee_Type%TYPE) IS
464: SELECT rowid,
465: IGS_FI_ANC_INT.*
466: FROM IGS_FI_ANC_INT
467: WHERE ((fee_cal_type = cp_fee_cal_type)
468: OR (cp_fee_cal_type IS NULL))
469: AND ((fee_ci_sequence_number = cp_fee_ci_sequence_number)

Line 466: FROM IGS_FI_ANC_INT

462: cp_fee_ci_sequence_number IGS_FI_ANC_RATES.Fee_Ci_Sequence_Number%TYPE,
463: cp_fee_type IGS_FI_ANC_RATES.Fee_Type%TYPE) IS
464: SELECT rowid,
465: IGS_FI_ANC_INT.*
466: FROM IGS_FI_ANC_INT
467: WHERE ((fee_cal_type = cp_fee_cal_type)
468: OR (cp_fee_cal_type IS NULL))
469: AND ((fee_ci_sequence_number = cp_fee_ci_sequence_number)
470: OR (cp_fee_ci_sequence_number IS NULL))

Line 1105: igs_fi_anc_int_pkg.update_row( x_rowid => ancrec.rowid,

1101:
1102: -- The Record in the Ancillary Interface table to be updated with
1103: -- the status and the error message
1104: -- Call the TBH for updating the record
1105: igs_fi_anc_int_pkg.update_row( x_rowid => ancrec.rowid,
1106: x_ancillary_int_id => ancrec.ancillary_int_id,
1107: x_person_id => ancrec.person_id,
1108: x_person_id_type => ancrec.person_id_type,
1109: x_api_person_id => ancrec.api_person_id,