[Home] [Help]
21: | pmarada 26-May-2005 Enh#3020586- added tax year code column |
22: | to as per 1098-t reporting build |
23: | pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh |
24: | Added param x_source_invoice_id in calls|
25: | to igs_fi_credits_pkg.update_row() |
26: | schodava 06-Oct-2003 Bug # 3123405. Modified procedure |
27: | transfer_deposit.
28: | vvutukur 22-Sep-2003 Enh#3045007.Payment Plans Build.Modified|
29: | reverse_transaction. |
65: --
66: --Change History:
67: --Who When What
68: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
69: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
70: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build.Modified update_row TBH call to credits table to add 3 new columns
71: -- lockbox_interface_id,batch_name,deposit_date.
72: --schodava 11-Jun-03 Enh # 2831587. Modified the Credits table update_row call
73: -------------------------------------------------------------------
113: CLOSE cur_fi_credits;
114:
115: -- Update the credits table - set status to Forfeited, the reversal data is null,
116: -- unapplied amount is same as the amount.
117: igs_fi_credits_pkg.update_row ( x_mode => 'R',
118: x_rowid => l_cur_fi_credits.rowid,
119: x_credit_id => l_cur_fi_credits.credit_id,
120: x_credit_number => l_cur_fi_credits.credit_number ,
121: x_status => g_forfeited ,
244: --
245: --Change History:
246: --Who When What
247: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
248: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
249: --vvutukur 22-Sep-2003 Enh#3045007.Payment Plans Build. Changes as specified in TD.
250: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build.Modified update_row TBH call to credits table to add 3 new columns
251: -- lockbox_interface_id,batch_name,deposit_date.
252: --schodava 11-Jun-03 Enh # 2831587. Modified the Credits table update_row call
473: -- If all validations are passed (CASE 1,2,3 and 4)
474: -- Update into igs_fi_credits, with appropriate status and unapplied_amount
475: -- gl_date of the record is not updated
476:
477: igs_fi_credits_pkg.update_row( x_mode => 'R',
478: x_rowid => l_cur_fi_credits.row_id,
479: x_credit_id => l_cur_fi_credits.credit_id,
480: x_credit_number => l_cur_fi_credits.credit_number,
481: x_status => l_c_status, -- Set to 'REVERSED' for CASE 1,2,3. Set to 'CLEARED' for Case 4.
603: -- For a reversal of a credit, which is created due to the transfer of a deposit, (CASE 2 only)
604: -- the corresponding deposit record of the credit in context should be updated.
605: IF l_b_upd_dp_ins_cr THEN
606:
607: igs_fi_credits_pkg.update_row (
608: x_mode => 'R',
609: x_rowid => rec_deposit.row_id,
610: x_credit_id => rec_deposit.credit_id,
611: x_credit_number => rec_deposit.credit_number ,
776: --Who When What
777: --svuppala 9-JUN-2005 Enh 3442712 - Impact of automatic generation of the Receipt Number
778: -- Modified logic for credit_number.
779: --pathipat 21-Apr-2004 Enh 3558549 - Comm Receivables Enh
780: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()
781: --schodava 06-Oct-2003 Bug # 3123405. The call to update balances is modified.
782: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build.Modified update_row TBH call to credits table to add 3 new columns
783: -- lockbox_interface_id,batch_name,deposit_date.
784: --schodava 11-Jun-03 Enh # 2831587. Modified the Credits table insert_row, update_row calls
868: RETURN;
869: END IF;
870:
871: -- Update the record in the credits table with a status of 'TRANSFERRED'
872: igs_fi_credits_pkg.update_row ( x_mode => 'R',
873: x_rowid => l_cur_fi_credits.rowid,
874: x_credit_id => l_cur_fi_credits.credit_id,
875: x_credit_number => l_cur_fi_credits.credit_number ,
876: x_status => g_transferred,
963: l_rowid := NULL;
964: l_n_credit_id := NULL;
965: l_v_credit_number := NULL;
966:
967: igs_fi_credits_pkg.insert_row ( x_mode => 'R',
968: x_rowid => l_rowid,
969: x_credit_id => l_n_credit_id,
970: x_credit_number => l_v_credit_number ,
971: x_status => g_cleared,