APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_CR_ACTIVITIES

Line 349: FROM igs_fi_cr_activities crac

345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
347:
348: SELECT crac.rowid row_id, crac.*
349: FROM igs_fi_cr_activities crac
350: WHERE crac.gl_date IS NOT NULL
351: AND TRUNC(crac.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
352: AND crac.posting_id IS NULL
353: AND crac.posting_control_id IS NULL

Line 361: CURSOR cur_credit (cp_credit_id igs_fi_cr_activities.credit_id%TYPE ) IS

357: FOR UPDATE OF gl_posted_date NOWAIT;
358:
359:
360: -- Get the Currency Code from the Credit table with the given credit id.
361: CURSOR cur_credit (cp_credit_id igs_fi_cr_activities.credit_id%TYPE ) IS
362: SELECT currency_cd
363: FROM igs_fi_credits
364: WHERE credit_id = cp_credit_id;
365:

Line 369: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;

365:
366: l_b_exception_flag BOOLEAN := FALSE;
367:
368: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
369: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
371: l_n_amount igs_fi_cr_activities.amount%TYPE;
372:
373: l_v_posting_rowid ROWID;

Line 370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;

366: l_b_exception_flag BOOLEAN := FALSE;
367:
368: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
369: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
371: l_n_amount igs_fi_cr_activities.amount%TYPE;
372:
373: l_v_posting_rowid ROWID;
374: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

Line 371: l_n_amount igs_fi_cr_activities.amount%TYPE;

367:
368: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
369: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
371: l_n_amount igs_fi_cr_activities.amount%TYPE;
372:
373: l_v_posting_rowid ROWID;
374: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
375:

Line 445: igs_fi_cr_activities_pkg.update_row(

441: p_cr_acc_code => l_v_cr_account_cd,
442: p_src_txn_type => g_credit);
443:
444: BEGIN
445: igs_fi_cr_activities_pkg.update_row(
446: x_rowid => cr_act_rec.row_id,
447: x_credit_activity_id => cr_act_rec.credit_activity_id,
448: x_credit_id => cr_act_rec.credit_id,
449: x_status => cr_act_rec.status,

Line 1030: igs_fi_cr_activities cra

1026: --Cursor to fetch the credit number for the passed credit_id
1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1028: SELECT crd.credit_number
1029: FROM igs_fi_credits crd,
1030: igs_fi_cr_activities cra
1031: WHERE cra.credit_activity_id = cp_transaction_id
1032: AND crd.credit_id = cra.credit_id;
1033:
1034: --Cursor to fetch the credit id and invoice id for the passed application id