[Home] [Help]
19: -- svuppala 9-JUN-2005 Enh 3442712 - Impact of automatic generation of the Receipt Number.
20: -- changed logic for credit_number in procedure create_cc_credit.
21: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
22: -- Modified update_cc_credit() - added param x_source_invoice_id
23: -- in call to igs_fi_credits_pkg.update_row()
24: --schodava 21-Jan-2004 Bug # 3062706 - Modified procedure finp_calc_fees_todo
25: --vvutukur 04-Dec-2003 Bug#3249288.Modified proceudure finp_set_optional_fee_flag.
26: --pathipat 06-Nov-2003 Enh 3117341 - Audit and Special Fees TD
27: -- Modified finp_calc_fees_todo()
156: vvutukur 15-Nov-2002 Enh#2584986.Modified the call to credits api to pass sysdate to the parameter
157: p_d_gl_date.
158: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie., from parameters
159: list,from where clause of cursor c_credittype_id,from the call to
160: igs_fi_credits_api_pub.create_credit.
161: smadathi 24-Jun-2002 Bug 2404720. The cursor c_credittype_id select is modified to fetch description column along
162: with credit_type_id column. The call to IGS_FI_CREDITS_API_PUB.Create_Credit has been modified
163: to pass this description value to the formal parameter p_description.
164:
158: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie., from parameters
159: list,from where clause of cursor c_credittype_id,from the call to
160: igs_fi_credits_api_pub.create_credit.
161: smadathi 24-Jun-2002 Bug 2404720. The cursor c_credittype_id select is modified to fetch description column along
162: with credit_type_id column. The call to IGS_FI_CREDITS_API_PUB.Create_Credit has been modified
163: to pass this description value to the formal parameter p_description.
164:
165: brajendr 22-FEB-2002 modifed the cursor (c_cc_number)which is used for creating the credit number as per the DLD
166:
166:
167: jbegum 20-FEB-2002 Enh bug # 2228910
168: Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
169:
170: sykrishn 04-FEB-2002 Modifications due to SFCR020- Changes to call to credits API and changes in igs_fi_credits_pkg.update_row
171: to add the new columns
172: Code related to derivation of credit_source removed since it is going to be passed as null to credits API. - SFCR020 - 2191470
173:
174: sarakshi 01-Feb-2002 In the call to the credit's API adding a new parameter p_invoice_id as a part of
196:
197: l_cc_meaning igs_lookup_values.meaning%TYPE;
198: l_credit_type_id c_credittype_id%ROWTYPE;
199: l_credit_card_code c_credit_card_code%ROWTYPE;
200: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
201: l_expiration_date c_expiration_date%ROWTYPE;
202:
203: l_v_currency igs_fi_control_all.currency_cd%TYPE;
204: l_v_curr_desc fnd_currencies_tl.name%TYPE;
207: l_b_return_status BOOLEAN;
208: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
209: l_exception EXCEPTION;
210:
211: l_v_transaction_date igs_fi_credits_all.transaction_date%TYPE := NULL;
212:
213: BEGIN
214: x_credit_id := NULL;
215: x_credit_activity_id :=NULL;
403: Change History
404: Who When What
405: pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
406: pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
407: Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
408: vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new parameters(lockbox_interface_id,batch_name,deposit_date) to the TBH
409: update_row call of credits table.
410: schodava 16-Jun-2003 Enh 2381587 - Credit Card Fund Transfer Build.
411: Modified the Credits TBH update row
408: vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new parameters(lockbox_interface_id,batch_name,deposit_date) to the TBH
409: update_row call of credits table.
410: schodava 16-Jun-2003 Enh 2381587 - Credit Card Fund Transfer Build.
411: Modified the Credits TBH update row
412: vvutukur 16-Dec-2002 Enh#2584741.Modified the tbh call to igs_fi_credits_pkg.update_row to add 3 new
413: parameters check_number,source_transaction_type,source_transaction_ref.
414: vchappid 02-Dec-2002 Enh#2584986, NOCOPY is manually added for x_return_status procedure parameter
415: vvutukur 25-Nov-2002 Enh#2584986.Modified the call to igs_fi_credits_pkg.update_row to pass gl_date.
416: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie.,from the call to
411: Modified the Credits TBH update row
412: vvutukur 16-Dec-2002 Enh#2584741.Modified the tbh call to igs_fi_credits_pkg.update_row to add 3 new
413: parameters check_number,source_transaction_type,source_transaction_ref.
414: vchappid 02-Dec-2002 Enh#2584986, NOCOPY is manually added for x_return_status procedure parameter
415: vvutukur 25-Nov-2002 Enh#2584986.Modified the call to igs_fi_credits_pkg.update_row to pass gl_date.
416: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie.,from the call to
417: IGS_FI_CREDITS_pkg.Update_Row,
418: ***************************************************************/
419: CURSOR c_credit_dtls(cp_credit_id NUMBER) IS
413: parameters check_number,source_transaction_type,source_transaction_ref.
414: vchappid 02-Dec-2002 Enh#2584986, NOCOPY is manually added for x_return_status procedure parameter
415: vvutukur 25-Nov-2002 Enh#2584986.Modified the call to igs_fi_credits_pkg.update_row to pass gl_date.
416: vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie.,from the call to
417: IGS_FI_CREDITS_pkg.Update_Row,
418: ***************************************************************/
419: CURSOR c_credit_dtls(cp_credit_id NUMBER) IS
420: SELECT *
421: FROM igs_fi_credits
417: IGS_FI_CREDITS_pkg.Update_Row,
418: ***************************************************************/
419: CURSOR c_credit_dtls(cp_credit_id NUMBER) IS
420: SELECT *
421: FROM igs_fi_credits
422: WHERE credit_id = cp_credit_id;
423:
424: l_credit_dtls_rec c_credit_dtls%ROWTYPE;
425: BEGIN
423:
424: l_credit_dtls_rec c_credit_dtls%ROWTYPE;
425: BEGIN
426:
427: -- Fetch the values from the igs_fi_credits table for the credit_id
428: -- Credit Source
429: OPEN c_credit_dtls(p_credit_id);
430: FETCH c_credit_dtls INTO l_credit_dtls_rec;
431: CLOSE c_credit_dtls;
429: OPEN c_credit_dtls(p_credit_id);
430: FETCH c_credit_dtls INTO l_credit_dtls_rec;
431: CLOSE c_credit_dtls;
432:
433: igs_fi_credits_pkg.update_row(x_rowid => l_credit_dtls_rec.row_id,
434: x_credit_id => l_credit_dtls_rec.credit_id,
435: x_credit_number => l_credit_dtls_rec.credit_number,
436: x_status => l_credit_dtls_rec.status,
437: x_credit_source => l_credit_dtls_rec.credit_source,