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_CR_ACTIVITIES

Line 88: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;

84: WHERE credit_type_id = cp_credit_type_id;
85:
86: l_cur_fi_credits cur_fi_credits%ROWTYPE;
87: l_cur_fi_cr_types cur_fi_cr_types%ROWTYPE;
88: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
89: l_rowid ROWID := NULL;
90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;

Line 204: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',

200: l_v_cr_account_cd := l_cur_fi_cr_types.forfeiture_account_cd;
201: l_v_dr_account_cd := l_cur_fi_cr_types.cr_account_cd;
202: END IF;
203:
204: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',
205: x_rowid => l_rowid,
206: x_credit_activity_id => l_n_credit_activity_id,
207: x_credit_id => l_cur_fi_credits.credit_id,
208: x_status => g_forfeited ,

Line 324: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;

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
328: l_b_upd_bal BOOLEAN := FALSE;

Line 333: l_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;

329: -- boolean variable for updating the deposit txn
330: -- and inserting into the Credit Activities table.
331: l_b_upd_dp_ins_cr BOOLEAN := FALSE;
332:
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;

Line 334: l_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;

330: -- and inserting into the Credit Activities table.
331: l_b_upd_dp_ins_cr BOOLEAN := FALSE;
332:
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;

Line 335: l_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%TYPE;

331: l_b_upd_dp_ins_cr BOOLEAN := FALSE;
332:
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;

Line 336: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;

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

Line 547: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',

543: -- Insert into the activities table with gl_date as the gl_date used in the reversal
544: -- and with appropriate status. Transaction date would be the system date.
545: -- Amount field is negated.
546:
547: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',
548: x_rowid => l_rowid,
549: x_credit_activity_id => l_n_credit_activity_id,
550: x_credit_id => l_cur_fi_credits.credit_id,
551: x_status => l_c_status, -- Set to 'REVERSED' for CASE 1,2,3. Set to 'CLEARED' for Case 4.

Line 676: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',

672: );
673:
674: l_rowid := NULL;
675: l_n_credit_activity_id := NULL;
676: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',
677: x_rowid => l_rowid,
678: x_credit_activity_id => l_n_credit_activity_id,
679: x_credit_id => rec_deposit.credit_id,
680: x_status => 'CLEARED',

Line 805: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;

801: l_cur_fi_credits cur_fi_credits%ROWTYPE;
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;

Line 941: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',

937:
938: -- Create a new activities record with status 'Transferred' and with
939: -- NULL accounting information
940:
941: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',
942: x_rowid => l_rowid,
943: x_credit_activity_id => l_n_credit_activity_id,
944: x_credit_id => l_cur_fi_credits.credit_id,
945: 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 1064: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',

1060:
1061: l_rowid := NULL;
1062: l_n_credit_activity_id := NULL;
1063:
1064: igs_fi_cr_activities_pkg.insert_row ( x_mode => 'R',
1065: x_rowid => l_rowid,
1066: x_credit_activity_id => l_n_credit_activity_id,
1067: x_credit_id => l_n_credit_id,
1068: x_status => g_cleared,