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_PKG

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