APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_LB_OVFL_ERRS

Line 13: in the igs_fi_lb_ovfl_errs_pkg.insert_row and igs_fi_lb_rect_errs_pkg.insert_row calls

9: Known limitations,enhancements,remarks:
10: Change History
11: Who When What
12: svuppala 12-May-2006 Bug 5217319 Added call to format amounts by rounding off to currency precision
13: in the igs_fi_lb_ovfl_errs_pkg.insert_row and igs_fi_lb_rect_errs_pkg.insert_row calls
14: pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
15: parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
16: svuppala 9-JUN-2005 Enh 3442712 - Impact of automatic generation of the Receipt Number.
17: changed logic for credit_number in invoke_credits_api_pvt().

Line 2157: Purpose : Procedure for inserting data in igs_fi_lb_ovfl_errs

2153: p_n_receipt_error_id PLS_INTEGER) AS
2154: /******************************************************************
2155: Created By : Amit Gairola
2156: Date Created By : 12-Jun-2003
2157: Purpose : Procedure for inserting data in igs_fi_lb_ovfl_errs
2158: table
2159:
2160: Known limitations,enhancements,remarks:
2161: Change History

Line 2164: in the igs_fi_lb_ovfl_errs_pkg.insert_row call

2160: Known limitations,enhancements,remarks:
2161: Change History
2162: Who When What
2163: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
2164: in the igs_fi_lb_ovfl_errs_pkg.insert_row call
2165: ***************************************************************** */
2166: l_v_rowid VARCHAR2(25);
2167: l_n_rec_oflow_err_id igs_fi_lb_ovfl_errs.receipt_overflow_error_id%TYPE;
2168: BEGIN

Line 2167: l_n_rec_oflow_err_id igs_fi_lb_ovfl_errs.receipt_overflow_error_id%TYPE;

2163: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
2164: in the igs_fi_lb_ovfl_errs_pkg.insert_row call
2165: ***************************************************************** */
2166: l_v_rowid VARCHAR2(25);
2167: l_n_rec_oflow_err_id igs_fi_lb_ovfl_errs.receipt_overflow_error_id%TYPE;
2168: BEGIN
2169: l_v_rowid := null;
2170: l_n_rec_oflow_err_id := null;
2171:

Line 2172: -- Create a record in the IGS_FI_LB_OVFL_ERRS table

2168: BEGIN
2169: l_v_rowid := null;
2170: l_n_rec_oflow_err_id := null;
2171:
2172: -- Create a record in the IGS_FI_LB_OVFL_ERRS table
2173: -- Bug 5217319 Added call to format amount by rounding off to currency precision
2174: igs_fi_lb_ovfl_errs_pkg.insert_row(x_rowid => l_v_rowid,
2175: x_receipt_overflow_error_id => l_n_rec_oflow_err_id,
2176: x_lockbox_receipt_error_id => p_n_receipt_error_id,

Line 2174: igs_fi_lb_ovfl_errs_pkg.insert_row(x_rowid => l_v_rowid,

2170: l_n_rec_oflow_err_id := null;
2171:
2172: -- Create a record in the IGS_FI_LB_OVFL_ERRS table
2173: -- Bug 5217319 Added call to format amount by rounding off to currency precision
2174: igs_fi_lb_ovfl_errs_pkg.insert_row(x_rowid => l_v_rowid,
2175: x_receipt_overflow_error_id => l_n_rec_oflow_err_id,
2176: x_lockbox_receipt_error_id => p_n_receipt_error_id,
2177: x_charge_cd1 => p_r_receipt_rec.charge_cd1,
2178: x_charge_cd2 => p_r_receipt_rec.charge_cd2,

Line 2210: CURSOR cur_lb_oflow(cp_lb_rec_err_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE) IS

2206: SELECT lockbox_receipt_error_id
2207: FROM igs_fi_lb_rect_errs
2208: WHERE rowid = cp_rowid;
2209:
2210: CURSOR cur_lb_oflow(cp_lb_rec_err_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE) IS
2211: SELECT rowid row_id
2212: FROM igs_fi_lb_ovfl_errs
2213: WHERE lockbox_receipt_error_id = cp_lb_rec_err_id;
2214:

Line 2212: FROM igs_fi_lb_ovfl_errs

2208: WHERE rowid = cp_rowid;
2209:
2210: CURSOR cur_lb_oflow(cp_lb_rec_err_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE) IS
2211: SELECT rowid row_id
2212: FROM igs_fi_lb_ovfl_errs
2213: WHERE lockbox_receipt_error_id = cp_lb_rec_err_id;
2214:
2215: l_n_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2216: BEGIN

Line 2227: igs_fi_lb_ovfl_errs_pkg.delete_row(l_oflow_rec.row_id);

2223: -- For the receipt error id, loop across the records in the Overflow table
2224: FOR l_oflow_rec IN cur_lb_oflow(l_n_receipt_error_id) LOOP
2225:
2226: -- delete the records in the Overflow table
2227: igs_fi_lb_ovfl_errs_pkg.delete_row(l_oflow_rec.row_id);
2228: END LOOP;
2229:
2230: -- Delete the records in the main IGS_FI_LB_RECT_ERRS errors
2231: igs_fi_lb_rect_errs_pkg.delete_row(p_r_rowid);

Line 4277: CURSOR cur_err_ro( cp_n_lre_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE ) IS

4273: FOR UPDATE NOWAIT;
4274:
4275: l_err_rec cur_err_rec%ROWTYPE;
4276:
4277: CURSOR cur_err_ro( cp_n_lre_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE ) IS
4278: SELECT ROWID row_id, loe.*
4279: FROM igs_fi_lb_ovfl_errs loe
4280: WHERE lockbox_receipt_error_id = cp_n_lre_id
4281: FOR UPDATE NOWAIT;

Line 4279: FROM igs_fi_lb_ovfl_errs loe

4275: l_err_rec cur_err_rec%ROWTYPE;
4276:
4277: CURSOR cur_err_ro( cp_n_lre_id igs_fi_lb_ovfl_errs.lockbox_receipt_error_id%TYPE ) IS
4278: SELECT ROWID row_id, loe.*
4279: FROM igs_fi_lb_ovfl_errs loe
4280: WHERE lockbox_receipt_error_id = cp_n_lre_id
4281: FOR UPDATE NOWAIT;
4282:
4283: l_err_ro cur_err_ro%ROWTYPE;

Line 4354: -- Populate Receipt Overflow Records found for each Receipt Record from igs_fi_lb_ovfl_errs into PL/SQL Table.

4350: p_t_err_rec_tab(l_n_cntr).source_transaction_type := NULL;
4351: p_t_err_rec_tab(l_n_cntr).eligible_to_apply_yn := NULL;
4352: p_t_err_rec_tab(l_n_cntr).receipt_number := NULL;
4353:
4354: -- Populate Receipt Overflow Records found for each Receipt Record from igs_fi_lb_ovfl_errs into PL/SQL Table.
4355: FOR l_err_ro IN cur_err_ro( l_err_rec.lockbox_receipt_error_id ) LOOP
4356: l_n_cntr := l_n_cntr + 1;
4357:
4358: p_t_err_rec_tab(l_n_cntr).record_status := g_v_todo;