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.

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_INV_INT

Line 6: --skharida 26-Jun-2006 Bug#5208136 - Modified bill_the_person procedure , removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL

2: /* $Header: IGSFI61B.pls 120.16 2006/06/27 14:15:06 skharida ship $ */
3: ------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --skharida 26-Jun-2006 Bug#5208136 - Modified bill_the_person procedure , removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL
7: --sapanigr 19-Jun-2006 Bug 5134985 - Modified bill_the_person procedure. Date of first bill for student changed from null.
8: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Modified the messages
9: --abshriva 12-May-2006 Bug#5217319:- Amount precision change in bill_the_person,create_payplan_bills
10: --sapanigr 24-Feb-2006 Bug#5018036 - Removed cursor cur_person_number in bill_the_person procedure and replaced it by function call.

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 65: -- IGS_FI_INV_INT_PKG.update_row

61: --sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v and used the
62: -- function igs_fi_gen_007.validate_person to validate person
63: --jbegum 20-Feb-02 As part Enh bug#2228910
64: -- Removed source_transaction_id column from call to
65: -- IGS_FI_INV_INT_PKG.update_row
66: -- Removed the source_transaction_id from Cursor CUR_CHARGE_TRANS_UPD
67: --jbegum 09-Feb-02 As part of Enh bug # 2201081
68: -- Added the local function get_include_in_bill
69: --maseghal 17-Jan-2002 ENH # 2170429

Line 71: -- UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler

67: --jbegum 09-Feb-02 As part of Enh bug # 2201081
68: -- Added the local function get_include_in_bill
69: --maseghal 17-Jan-2002 ENH # 2170429
70: -- Obsoletion of SPONSOR_CD from Cursor CUR_CHARGE_TRANS_UPD and
71: -- UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
72: --smadathi 08-Oct-2001 Balance_flag references Removed from bill_the_person Procedure.
73: -- This is as per enhancement bug no. 2030448
74:
75: -------------------------------------------------------------------

Line 249: --skharida 26-Jun-2006 Bug# 5208136 - Removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL

245: ) IS
246: ------------------------------------------------------------------
247: --Change History:
248: --Who When What
249: --skharida 26-Jun-2006 Bug# 5208136 - Removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL
250: --sapanigr 19-Jun-2006 Bug 5134985 - First bill for a student modified to show start date as earlier of first charge or credit date.
251: -- Earlier this field was being left null.
252: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Added proper messages
253: --

Line 272: --shtatiko 21-AUG-2003 Bug# 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row call

268: -- Removed addition to stack for Bill To address validation failure and Planned Credits validation failure.
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

Line 312: --smadathi 08-Oct-2001 Balance_flag references Removed from igs_fi_inv_int_pkg.update_row call and

308: -- CUR_CHARGE_TRANS , CUR_CHARGE_TRANS_UPD ,CUR_CHARGES_TOTAL,CUR_TRANSACTIONS_FOUND
309: --sarakshi 21-jan-2002 removed fee_cal_type,fee_ci_sequence_number from the where clause of cursor
310: -- cur_charge_trans,cur_charges_total,cur_transactions_found and
311: -- cur_charge_trans_upd, bug:2175865
312: --smadathi 08-Oct-2001 Balance_flag references Removed from igs_fi_inv_int_pkg.update_row call and
313: -- cur_charge_trans_upd cursor and optional_fee_flag added. This is as per enhancement bug no. 2030448
314: -------------------------------------------------------------------
315:
316: -- Bug#2564643 Removed cursor cur_sub_accts

Line 350: FROM igs_fi_inv_int inv

346: inv.fee_type fee_type,
347: inv.invoice_creation_date invoice_creation_date,
348: inv.invoice_desc invoice_desc,
349: NVL (inv.invoice_amount, 0) invoice_amount
350: FROM igs_fi_inv_int inv
351: WHERE inv.person_id = cp_n_person_id
352: AND (cp_d_start_date IS NULL OR (TRUNC(inv.invoice_creation_date) >= TRUNC(cp_d_start_date)))
353: AND TRUNC(inv.invoice_creation_date) <= TRUNC(cp_d_cutoff_dt)
354: AND inv.bill_date IS NULL

Line 365: -- This cursor is meant for updation of the values in igs_fi_inv_int table

361: -- Cursor to find the Charge Transactions made by the Person .
362: -- The Charge transactions are identified on the basis of the Transaction Date.
363: -- The Effective Date is not to be considered for this purpose.
364: -- **
365: -- ** This cursor is meant for updation of the values in igs_fi_inv_int table **
366: -- ** Balance_flag reference is removed from cur_charge_trans_upd
367: --
368:
369: --Change History

Line 433: FROM igs_fi_inv_int inv

429: inv.optional_fee_flag optional_fee_flag,
430: inv.reversal_gl_date reversal_gl_date,
431: inv.tax_year_code tax_year_code,
432: inv.waiver_name
433: FROM igs_fi_inv_int inv
434: WHERE inv.person_id = cp_n_person_id
435: AND (cp_d_start_date IS NULL OR (TRUNC(inv.invoice_creation_date) >= TRUNC(cp_d_start_date)))
436: AND TRUNC(inv.invoice_creation_date) <= TRUNC(cp_d_cutoff_dt)
437: AND inv.bill_date IS NULL;

Line 546: FROM igs_fi_inv_int inv

542: cp_d_start_date IN DATE,
543: cp_d_cutoff_dt IN DATE
544: ) IS
545: SELECT NVL (SUM (inv.invoice_amount), 0) total_charge_amount
546: FROM igs_fi_inv_int inv
547: WHERE inv.person_id = cp_n_person_id
548: AND (cp_d_start_date IS NULL OR (TRUNC(inv.invoice_creation_date) >= TRUNC(cp_d_start_date)))
549: AND TRUNC(inv.invoice_creation_date) <= TRUNC(cp_d_cutoff_dt)
550: AND inv.bill_date IS NULL;

Line 704: FROM igs_fi_inv_int_all

700: l_v_fee_class_meaning igs_lookup_values.meaning%TYPE;
701:
702: CURSOR cur_min_inv_dt IS
703: SELECT MIN(invoice_creation_date)
704: FROM igs_fi_inv_int_all
705: WHERE person_id = p_n_person_id;
706:
707: CURSOR cur_min_crd_dt IS
708: SELECT MIN(effective_date)

Line 1134: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL

1130: LOOP
1131:
1132: --Change History
1133: --Who When What
1134: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row
1136: --jbegum 24-Sep-02 Enh Bug#2564643
1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910

Line 1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row

1131:
1132: --Change History
1133: --Who When What
1134: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row
1136: --jbegum 24-Sep-02 Enh Bug#2564643
1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910
1139: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row

Line 1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row

1133: --Who When What
1134: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row
1136: --jbegum 24-Sep-02 Enh Bug#2564643
1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910
1139: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
1140: --masehgal 17-Jan-2002 ENH # 2170429
1141: -- Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler

Line 1139: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row

1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row
1136: --jbegum 24-Sep-02 Enh Bug#2564643
1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910
1139: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
1140: --masehgal 17-Jan-2002 ENH # 2170429
1141: -- Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
1142: --svuppala 21-Mar-2005 Modified bill_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
1143:

Line 1141: -- Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler

1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910
1139: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row
1140: --masehgal 17-Jan-2002 ENH # 2170429
1141: -- Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
1142: --svuppala 21-Mar-2005 Modified bill_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
1143:
1144: igs_fi_inv_int_pkg.update_row (
1145: x_rowid => rec_cur_charge_trans.row_id,

Line 1144: igs_fi_inv_int_pkg.update_row (

1140: --masehgal 17-Jan-2002 ENH # 2170429
1141: -- Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
1142: --svuppala 21-Mar-2005 Modified bill_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
1143:
1144: igs_fi_inv_int_pkg.update_row (
1145: x_rowid => rec_cur_charge_trans.row_id,
1146: x_invoice_id => rec_cur_charge_trans.invoice_id,
1147: x_person_id => rec_cur_charge_trans.person_id,
1148: x_fee_type => rec_cur_charge_trans.fee_type,