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.

[Home] [Help]

APPS.IGS_FI_DEPOSITS_PRCSS dependencies on IGS_FI_CREDITS

Line 25: | to igs_fi_credits_pkg.update_row() |

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. |

Line 69: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()

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: -------------------------------------------------------------------

Line 77: FROM igs_fi_credits cre

73: -------------------------------------------------------------------
74:
75: CURSOR cur_fi_credits (cp_credit_id NUMBER ) IS
76: SELECT cre.rowid,cre.*
77: FROM igs_fi_credits cre
78: WHERE credit_id = cp_credit_id
79: AND status = g_cleared;
80:
81: CURSOR cur_fi_cr_types (cp_credit_type_id NUMBER ) IS

Line 117: igs_fi_credits_pkg.update_row ( x_mode => 'R',

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 ,

Line 248: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()

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

Line 264: CURSOR cur_fi_credits (cp_credit_id IN igs_fi_credits.credit_id%TYPE) IS

260: AND lookup_code = cp_reversal_code
261: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE))
262: AND NVL(enabled_flag,'N') = 'Y';
263:
264: CURSOR cur_fi_credits (cp_credit_id IN igs_fi_credits.credit_id%TYPE) IS
265: SELECT *
266: FROM igs_fi_credits
267: WHERE credit_id = cp_credit_id;
268:

Line 266: FROM igs_fi_credits

262: AND NVL(enabled_flag,'N') = 'Y';
263:
264: CURSOR cur_fi_credits (cp_credit_id IN igs_fi_credits.credit_id%TYPE) IS
265: SELECT *
266: FROM igs_fi_credits
267: WHERE credit_id = cp_credit_id;
268:
269: CURSOR c_deposit (cp_party_id IN igs_fi_credits.party_id%TYPE,
270: cp_receipt_number IN igs_fi_credits.credit_number%TYPE) IS

Line 269: CURSOR c_deposit (cp_party_id IN igs_fi_credits.party_id%TYPE,

265: SELECT *
266: FROM igs_fi_credits
267: WHERE credit_id = cp_credit_id;
268:
269: CURSOR c_deposit (cp_party_id IN igs_fi_credits.party_id%TYPE,
270: cp_receipt_number IN igs_fi_credits.credit_number%TYPE) IS
271: SELECT *
272: FROM igs_fi_credits
273: WHERE party_id = cp_party_id

Line 270: cp_receipt_number IN igs_fi_credits.credit_number%TYPE) IS

266: FROM igs_fi_credits
267: WHERE credit_id = cp_credit_id;
268:
269: CURSOR c_deposit (cp_party_id IN igs_fi_credits.party_id%TYPE,
270: cp_receipt_number IN igs_fi_credits.credit_number%TYPE) IS
271: SELECT *
272: FROM igs_fi_credits
273: WHERE party_id = cp_party_id
274: AND credit_number = cp_receipt_number;

Line 272: FROM igs_fi_credits

268:
269: CURSOR c_deposit (cp_party_id IN igs_fi_credits.party_id%TYPE,
270: cp_receipt_number IN igs_fi_credits.credit_number%TYPE) IS
271: SELECT *
272: FROM igs_fi_credits
273: WHERE party_id = cp_party_id
274: AND credit_number = cp_receipt_number;
275:
276: CURSOR cur_fi_cr_types (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE) IS

Line 282: CURSOR cur_insts(cp_n_credit_id igs_fi_credits.credit_id%TYPE,

278: FROM igs_fi_cr_types
279: WHERE credit_type_id = cp_credit_type_id;
280:
281: --Cursor for identifying the Payment Plan installment application records.
282: CURSOR cur_insts(cp_n_credit_id igs_fi_credits.credit_id%TYPE,
283: cp_v_plan_status_cd igs_fi_pp_std_attrs.plan_status_code%TYPE
284: ) IS
285: SELECT app.rowid a_rowid,
286: app.installment_application_id a_inst_app_id,

Line 323: l_v_credit_number igs_fi_credits.credit_number%TYPE;

319: l_v_dummy VARCHAR2(1);
320: l_n_conv_prc_val igs_fi_control_all.conv_process_run_ind%TYPE;
321: l_v_message_name fnd_new_messages.message_name%TYPE;
322: l_v_message_name1 fnd_new_messages.message_name%TYPE := NULL;
323: l_v_credit_number igs_fi_credits.credit_number%TYPE;
324: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
325: l_rowid ROWID := NULL;
326:
327: -- boolean variable for the update balances call

Line 337: l_c_status igs_fi_credits.status%TYPE;

333: l_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
334: l_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
335: l_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%TYPE;
336: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
337: l_c_status igs_fi_credits.status%TYPE;
338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;
339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;
340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;
341: l_d_date DATE;

Line 338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;

334: l_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
335: l_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%TYPE;
336: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
337: l_c_status igs_fi_credits.status%TYPE;
338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;
339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;
340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;
341: l_d_date DATE;
342: l_n_due_amt igs_fi_pp_instlmnts.due_amt%TYPE;

Line 339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;

335: l_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%TYPE;
336: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
337: l_c_status igs_fi_credits.status%TYPE;
338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;
339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;
340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;
341: l_d_date DATE;
342: l_n_due_amt igs_fi_pp_instlmnts.due_amt%TYPE;
343: l_n_inst_appl_id igs_fi_pp_ins_appls.installment_application_id%TYPE;

Line 340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;

336: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
337: l_c_status igs_fi_credits.status%TYPE;
338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;
339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;
340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;
341: l_d_date DATE;
342: l_n_due_amt igs_fi_pp_instlmnts.due_amt%TYPE;
343: l_n_inst_appl_id igs_fi_pp_ins_appls.installment_application_id%TYPE;
344:

Line 474: -- Update into igs_fi_credits, with appropriate status and unapplied_amount

470: l_cr_gl_ccid := NULL;
471: END IF;
472:
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,

Line 477: igs_fi_credits_pkg.update_row( x_mode => 'R',

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.

Line 607: igs_fi_credits_pkg.update_row (

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 ,

Line 780: -- Added param x_source_invoice_id in call to igs_fi_credits_pkg.update_row()

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

Line 790: FROM igs_fi_credits cre

786: -- procedure igs_fi_crdapi_util.validate_dep_crtype,which serves the same purpose of validating the payment credit type.
787: -------------------------------------------------------------------
788: CURSOR cur_fi_credits (cp_credit_id NUMBER ) IS
789: SELECT cre.rowid,cre.*
790: FROM igs_fi_credits cre
791: WHERE credit_id = cp_credit_id
792: AND status = g_cleared;
793:
794:

Line 806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;

802: l_cur_dr_account_info cur_account_info%ROWTYPE;
803: l_cur_cr_account_info cur_account_info%ROWTYPE;
804: l_rowid VARCHAR2(25) := NULL;
805: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;

Line 807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;

803: l_cur_cr_account_info cur_account_info%ROWTYPE;
804: l_rowid VARCHAR2(25) := NULL;
805: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;

Line 872: igs_fi_credits_pkg.update_row ( x_mode => 'R',

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,

Line 961: -- Create a payment record in igs_fi_Credits and an activity correspondingly in igs_fi_cr_activities

957: x_posting_id => NULL
958: );
959:
960:
961: -- Create a payment record in igs_fi_Credits and an activity correspondingly in igs_fi_cr_activities
962: -- Account details obtained
963: l_rowid := NULL;
964: l_n_credit_id := NULL;
965: l_v_credit_number := NULL;

Line 967: igs_fi_credits_pkg.insert_row ( x_mode => 'R',

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,