[Home] [Help]
8: || Change History :
9: || Who When What
10: || (reverse chronological order - newest change first)
11: || skharida 26-Jun-2006 Bug# 5208136 -Modified update_refund_rec, removed the obsoleted columns
12: || from igs_fi_refunds_pkg.update_row.
13: || abshriva 12-MAY-2006 Bug 5217319 Amount precision change in create_ap_int_rec
14: || agairola 20-Feb-2006 Bug 5046245: Commenting out of the Vendor API
15: || shtatiko 30-APR-2003 Enh# 2831569, Modified validate_parameters
16: *****************************************************************/
58: PRAGMA exception_init(e_resource_busy,-0054);
59:
60: CURSOR c_refunds IS
61: SELECT rfnd.rowid, rfnd.*
62: FROM igs_fi_refunds rfnd;
63:
64: TYPE r_party_rel_rec IS RECORD (p_n_party_id hz_parties.party_id%TYPE,
65: p_n_vendor_id igs_fi_party_vendrs.vendor_id%TYPE,
66: p_n_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE);
121: || Purpose : Updates the Refund transaction status
122: || Known limitations, enhancements or remarks :
123: || Change History :
124: || Who When What
125: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
126: || (reverse chronological order - newest change first)
127: *****************************************************************/
128: BEGIN
129: igs_fi_refunds_pkg.update_row(x_rowid => p_r_rfnd_rec.rowid,
125: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
126: || (reverse chronological order - newest change first)
127: *****************************************************************/
128: BEGIN
129: igs_fi_refunds_pkg.update_row(x_rowid => p_r_rfnd_rec.rowid,
130: x_refund_id => p_r_rfnd_rec.refund_id,
131: x_voucher_date => p_r_rfnd_rec.voucher_date,
132: x_person_id => p_r_rfnd_rec.person_id,
133: x_pay_person_id => p_r_rfnd_rec.pay_person_id,
1323: -- Cursor to get all the refund transactions that have been
1324: -- created due to reversal of a refund transaction and have TODO status
1325: CURSOR c_rfnd(cp_n_party_id hz_parties.party_id%TYPE) IS
1326: SELECT rfnd.rowid, rfnd.*
1327: FROM igs_fi_refunds rfnd
1328: WHERE rfnd.person_id = cp_n_party_id
1329: AND rfnd.transfer_status = g_v_todo
1330: AND rfnd.source_refund_id IS NOT NULL
1331: ORDER BY rfnd.pay_person_id
1331: ORDER BY rfnd.pay_person_id
1332: FOR UPDATE NOWAIT;
1333:
1334: -- Get the refund voucher details for the Refund Id
1335: CURSOR c_rfnd_org(cp_n_refund_id igs_fi_refunds.refund_id%TYPE) IS
1336: SELECT rfnd.rowid, rfnd.*
1337: FROM igs_fi_refunds rfnd
1338: WHERE rfnd.refund_id = cp_n_refund_id
1339: FOR UPDATE NOWAIT;
1333:
1334: -- Get the refund voucher details for the Refund Id
1335: CURSOR c_rfnd_org(cp_n_refund_id igs_fi_refunds.refund_id%TYPE) IS
1336: SELECT rfnd.rowid, rfnd.*
1337: FROM igs_fi_refunds rfnd
1338: WHERE rfnd.refund_id = cp_n_refund_id
1339: FOR UPDATE NOWAIT;
1340:
1341: -- Get all the refund transactions that have not been reversed and have
1341: -- Get all the refund transactions that have not been reversed and have
1342: -- status of TODO
1343: CURSOR c_rfnd1(cp_n_party_id hz_parties.party_id%TYPE) IS
1344: SELECT rfnd.rowid, rfnd.*
1345: FROM igs_fi_refunds rfnd
1346: WHERE rfnd.person_id = cp_n_party_id
1347: AND rfnd.transfer_status = g_v_todo
1348: AND rfnd.source_refund_id IS NULL
1349: ORDER BY rfnd.pay_person_id
1509: || (reverse chronological order - newest change first)
1510: ******************************************************************/
1511: CURSOR c_rfnd_per IS
1512: SELECT DISTINCT person_id
1513: FROM igs_fi_refunds
1514: WHERE transfer_status = g_v_todo;
1515:
1516: TYPE c_per_grp_cur IS REF CURSOR;
1517: