APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_CR_ACTIVITIES

Line 20: -- IGS_FI_INV_INT_PKG, IGS_FI_CR_ACTIVITIES_PKG, IGS_FI_BILL_PKG.

16: -- In PROCEDURE bill_the_person, added new cursor cur_fee_type and added fee_class_meaning
17: -- incase of Sponsor system fee type.
18: --uudayapr 28-Jun-2005 Bug 2767636 Modified the bill_the_person procedure.
19: --svuppala 11-Mar-2005 Bug 4240402 Timezone impact; truncating the time part in calling place of the table handlers
20: -- IGS_FI_INV_INT_PKG, IGS_FI_CR_ACTIVITIES_PKG, IGS_FI_BILL_PKG.
21: -- Modified the sysdate entries as Trunc(Sysdate).
22: --pathipat 21-Jul-2004 Bug 3778782 - Modified procedure billing_extract() and bill_the_person()
23: --pathipat 06-May-2004 Bug# 3578249 - Modified procedure billing_extract()
24: --vvutukur 23-Jan-2004 Bug#3348787.Modified procedure billing_extract.

Line 273: -- and added gl_date, gl_posted_date and posting_control_id columns to igs_fi_cr_activities_pkg calls

269: --vvutukur 07-dec-2003 Bug#3146325.Removed cursor cur_transactions_found and its usage. Added logic to
270: -- rollback the bill txns if no records found for processing.This is done using
271: -- boolean variable.
272: --shtatiko 21-AUG-2003 Bug# 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row call
273: -- and added gl_date, gl_posted_date and posting_control_id columns to igs_fi_cr_activities_pkg calls
274: --vvutukur 18-ul-2003 Enh#3038511.FICR106 Build. Modified cursor cur_planned_crd to to exclude the
275: -- planned credits for which the Award Year status is not OPEN.
276: --shtatiko 12-DEC-2002 Enh Bug# 2584741, Added c_bill_deposits and modified code so that report will include
277: -- Deposit records in report.

Line 463: FROM igs_fi_cr_activities

459: WHERE person_id = cp_n_person_id
460: AND (cp_d_start_date IS NULL OR (TRUNC(effective_date) >= TRUNC(cp_d_start_date)))
461: AND TRUNC(effective_date) <= TRUNC(cp_d_cutoff_dt)
462: AND credit_activity_id IN (SELECT credit_activity_id
463: FROM igs_fi_cr_activities
464: WHERE bill_date IS NULL)
465: FOR UPDATE OF credit_activity_id NOWAIT;
466:
467: --

Line 571: FROM igs_fi_cr_activities

567: WHERE person_id = cp_n_person_id
568: AND (cp_d_start_date IS NULL OR (TRUNC(effective_date) >= TRUNC(cp_d_start_date)))
569: AND TRUNC(effective_date) <= TRUNC(cp_d_cutoff_dt)
570: AND credit_activity_id IN (SELECT credit_activity_id
571: FROM igs_fi_cr_activities
572: WHERE bill_date IS NULL);
573:
574: --
575: -- Cursor to find the Credit History records for a Person.

Line 582: FROM igs_fi_cr_activities ca

578: cp_n_credit_act_id IN NUMBER
579: ) IS
580: SELECT ca.rowid,
581: ca.*
582: FROM igs_fi_cr_activities ca
583: WHERE credit_activity_id = cp_n_credit_act_id;
584: --
585: l_d_start_date DATE;
586: l_d_min_inv_dt DATE;

Line 653: igs_fi_cr_activities cra,

649: cp_d_cutoff_dt IN DATE) IS
650: SELECT
651: cra.credit_activity_id
652: FROM
653: igs_fi_cr_activities cra,
654: igs_fi_credits cr,
655: igs_fi_cr_types crt
656: WHERE
657: cra.status = 'CLEARED'

Line 1199: igs_fi_cr_activities_pkg.update_row (

1195: LOOP
1196: OPEN cur_credit_hist (rec_cur_credit_trans.credit_activity_id);
1197: FETCH cur_credit_hist INTO rec_cur_credit_hist;
1198: IF (cur_credit_hist%FOUND) THEN
1199: igs_fi_cr_activities_pkg.update_row (
1200: x_rowid => rec_cur_credit_hist.rowid,
1201: x_credit_activity_id => rec_cur_credit_hist.credit_activity_id,
1202: x_credit_id => rec_cur_credit_hist.credit_id,
1203: x_status => rec_cur_credit_hist.status,

Line 1231: igs_fi_cr_activities_pkg.update_row (

1227: -- Modified bill_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
1228: OPEN cur_credit_hist (rec_bill_deposits.credit_activity_id);
1229: FETCH cur_credit_hist INTO rec_cur_credit_hist;
1230: IF (cur_credit_hist%FOUND) THEN
1231: igs_fi_cr_activities_pkg.update_row (
1232: x_rowid => rec_cur_credit_hist.rowid,
1233: x_credit_activity_id => rec_cur_credit_hist.credit_activity_id,
1234: x_credit_id => rec_cur_credit_hist.credit_id,
1235: x_status => rec_cur_credit_hist.status,