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_PRC_LOCKBOX dependencies on IGS_FI_LB_RECT_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 2080: Purpose : Procedure for inserting data in igs_fi_lb_rect_errs

2076: p_n_receipt_error_id OUT NOCOPY PLS_INTEGER) AS
2077: /******************************************************************
2078: Created By : Amit Gairola
2079: Date Created By : 12-Jun-2003
2080: Purpose : Procedure for inserting data in igs_fi_lb_rect_errs
2081: table
2082:
2083: Known limitations,enhancements,remarks:
2084: Change History

Line 2087: in the igs_fi_lb_rect_errs_pkg.insert_row call

2083: Known limitations,enhancements,remarks:
2084: Change History
2085: Who When What
2086: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
2087: in the igs_fi_lb_rect_errs_pkg.insert_row call
2088: ***************************************************************** */
2089: l_v_rowid VARCHAR2(25);
2090: l_n_lockbox_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2091: BEGIN

Line 2090: l_n_lockbox_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;

2086: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
2087: in the igs_fi_lb_rect_errs_pkg.insert_row call
2088: ***************************************************************** */
2089: l_v_rowid VARCHAR2(25);
2090: l_n_lockbox_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2091: BEGIN
2092:
2093: -- Create a record in the IGS_FI_LB_RECT_ERRS table
2094: l_v_rowid := null;

Line 2093: -- Create a record in the IGS_FI_LB_RECT_ERRS table

2089: l_v_rowid VARCHAR2(25);
2090: l_n_lockbox_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2091: BEGIN
2092:
2093: -- Create a record in the IGS_FI_LB_RECT_ERRS table
2094: l_v_rowid := null;
2095: l_n_lockbox_receipt_error_id := null;
2096:
2097: -- Bug 5217319 Added call to format amount by rounding off to currency precision

Line 2098: igs_fi_lb_rect_errs_pkg.insert_row(x_rowid => l_v_rowid,

2094: l_v_rowid := null;
2095: l_n_lockbox_receipt_error_id := null;
2096:
2097: -- Bug 5217319 Added call to format amount by rounding off to currency precision
2098: igs_fi_lb_rect_errs_pkg.insert_row(x_rowid => l_v_rowid,
2099: x_lockbox_receipt_error_id => l_n_lockbox_receipt_error_id,
2100: x_lockbox_interface_id => p_r_receipt_rec.lockbox_interface_id,
2101: x_item_number => p_r_receipt_rec.item_number,
2102: x_lockbox_name => p_r_receipt_rec.lockbox_name,

Line 2207: FROM igs_fi_lb_rect_errs

2203: Who When What
2204: ***************************************************************** */
2205: CURSOR cur_lb_err(cp_rowid rowid) 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

Line 2215: l_n_receipt_error_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;

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
2217:
2218: -- For the rowid passed, identifiy the receipt error_id
2219: OPEN cur_lb_err(p_r_rowid);

Line 2230: -- Delete the records in the main IGS_FI_LB_RECT_ERRS errors

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);
2232: END delete_err_success;
2233:
2234: PROCEDURE invoke_credits_api_pvt(p_r_receipt_rec lb_receipt_rec,

Line 2231: igs_fi_lb_rect_errs_pkg.delete_row(p_r_rowid);

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);
2232: END delete_err_success;
2233:
2234: PROCEDURE invoke_credits_api_pvt(p_r_receipt_rec lb_receipt_rec,
2235: p_n_credit_type_id NUMBER,

Line 2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;

2426: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
2428: l_v_message_text VARCHAR2(2000);
2429: l_b_ro_rec_match BOOLEAN;
2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;
2432: l_v_status VARCHAR2(1);
2433: l_n_act_amnt_applied igs_fi_applications.amount_applied%TYPE;
2434: l_n_app_id igs_fi_applications.application_id%TYPE;

Line 4271: FROM igs_fi_lb_rect_errs lre

4267: Who When What
4268: ***************************************************************** */
4269: CURSOR cur_err_rec( cp_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE ) IS
4270: SELECT ROWID row_id, lre.*
4271: FROM igs_fi_lb_rect_errs lre
4272: WHERE lockbox_name = cp_v_lockbox_name
4273: FOR UPDATE NOWAIT;
4274:
4275: l_err_rec cur_err_rec%ROWTYPE;

Line 4288: -- Populate Receipt Records from igs_fi_lb_rect_errs into PL/SQL Table.

4284: l_n_cntr NUMBER := 0;
4285:
4286: BEGIN
4287:
4288: -- Populate Receipt Records from igs_fi_lb_rect_errs into PL/SQL Table.
4289: FOR l_err_rec IN cur_err_rec( p_v_lockbox_name ) LOOP
4290: l_n_cntr := l_n_cntr + 1;
4291:
4292: p_t_err_rec_tab(l_n_cntr).record_status := g_v_todo;