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_INV_INT_PKG dependencies on IGS_FI_INV_INT_ALL

Line 4: old_references igs_fi_inv_int_all%RowType;

1: PACKAGE BODY igs_fi_inv_int_pkg AS
2: /* $Header: IGSSI73B.pls 120.3 2006/06/27 14:08:37 skharida ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_inv_int_all%RowType;
5: new_references igs_fi_inv_int_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_fi_inv_int_all%RowType;

1: PACKAGE BODY igs_fi_inv_int_pkg AS
2: /* $Header: IGSSI73B.pls 120.3 2006/06/27 14:08:37 skharida ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_inv_int_all%RowType;
5: new_references igs_fi_inv_int_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

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

61: Purpose :
62: Know limitations, enhancements or remarks
63: Change History
64: Who When What
65: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
66: pathipat 30-Jun-2003 Bug: 3026125 - Waiver flag inserted as NULL for Ancillary Charges
67: Added NVL clause for waiver_flag value
68: shtatiko 11-MAR2003 Bug# 2734441, Added TRUNC call before assigning the value of
69: x_invoice_creation_date.

Line 82: FROM IGS_FI_INV_INT_ALL

78: ***************************************************************/
79:
80: CURSOR cur_old_ref_values IS
81: SELECT *
82: FROM IGS_FI_INV_INT_ALL
83: WHERE rowid = x_rowid;
84:
85: BEGIN
86:

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

169: Know limitations, enhancements or remarks
170: Change History
171: Who When What
172: (reverse chronological order - newest change first)
173: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
174: vvutukur 17-sep-2002 Enh#2564643.Removed DEFAULT clause from parameters list to avoid gscc
175: warnings in order to comply with 9i standards.
176: ***************************************************************/
177:

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

193: Purpose :
194: Know limitations, enhancements or remarks
195: Change History
196: Who When What
197: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
198: (reverse chronological order - newest change first)
199: ***************************************************************/
200:
201: CURSOR cur_rowid IS

Line 203: FROM igs_fi_inv_int_all

199: ***************************************************************/
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igs_fi_inv_int_all
204: WHERE invoice_id = x_invoice_id
205: FOR UPDATE NOWAIT;
206:
207: lv_rowid cur_rowid%RowType;

Line 310: IGS_FI_APPLICATIONS_PKG.GET_FK_IGS_FI_INV_INT_ALL (

306: PROCEDURE Check_Child_Existance AS
307:
308: BEGIN
309: --modified by sarakshi, all new_references are made old_references
310: IGS_FI_APPLICATIONS_PKG.GET_FK_IGS_FI_INV_INT_ALL (
311: old_references.invoice_id
312: );
313:
314: IGS_FI_OTC_CHARGES_PKG.GET_FK_IGS_FI_INV_INT_ALL (

Line 314: IGS_FI_OTC_CHARGES_PKG.GET_FK_IGS_FI_INV_INT_ALL (

310: IGS_FI_APPLICATIONS_PKG.GET_FK_IGS_FI_INV_INT_ALL (
311: old_references.invoice_id
312: );
313:
314: IGS_FI_OTC_CHARGES_PKG.GET_FK_IGS_FI_INV_INT_ALL (
315: old_references.invoice_id
316: );
317:
318: IGS_FI_BILL_TRNSCTNS_PKG.GET_FK_IGS_FI_INV_INT (

Line 323: IGS_FI_INV_WAV_DET_PKG.GET_FK_IGS_FI_INV_INT_ALL(

319: old_references.invoice_id
320: );
321:
322: --added by sarakshi, bug:2124001
323: IGS_FI_INV_WAV_DET_PKG.GET_FK_IGS_FI_INV_INT_ALL(
324: old_references.invoice_id
325: );
326:
327: -- Added Enh#2144600

Line 342: || Purpose : To carryout the actions before insert/update/delete a record in igs_fi_inv_int_all table.

338: ) AS
339: /*
340: || Created By : vvutukur
341: || Created On : 19-NOV-2003
342: || Purpose : To carryout the actions before insert/update/delete a record in igs_fi_inv_int_all table.
343: || Created as part of bugfix#3249288.
344: || Known limitations, enhancements or remarks :
345: || Change History :
346: || Who When What

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

581: Purpose :
582: Know limitations, enhancements or remarks
583: Change History
584: Who When What
585: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
586: masehgal 10-JAN-2002 Enh # 2170429
587: Obsoletion of SPONSOR_CD
588: (reverse chronological order - newest change first)
589: ***************************************************************/

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

656: Purpose :
657: Know limitations, enhancements or remarks
658: Change History
659: Who When What
660: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
661: smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column
662: REVERSAL_GL_DATE
663: vvutukur 17-Sep-2002 Enh#2564643.Removed references to subaccount_id.Also removed DEFAULT
664: clause from package body to avoid gscc warnings.

Line 672: cursor C is select ROWID from IGS_FI_INV_INT_ALL

668: Enhancement Bug No. 2030448
669: (reverse chronological order - newest change first)
670: ***************************************************************/
671:
672: cursor C is select ROWID from IGS_FI_INV_INT_ALL
673: where INVOICE_ID= X_INVOICE_ID
674: ;
675: X_LAST_UPDATE_DATE DATE ;
676: X_LAST_UPDATED_BY NUMBER ;

Line 771: insert into IGS_FI_INV_INT_ALL (

767: x_tax_year_code => x_tax_year_code,
768: x_waiver_name => x_waiver_name
769: );
770:
771: insert into IGS_FI_INV_INT_ALL (
772: INVOICE_ID
773: ,PERSON_ID
774: ,FEE_TYPE
775: ,FEE_CAT

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

932: || Purpose : Handles the LOCK mechanism for the table.
933: || Known limitations, enhancements or remarks :
934: || Change History :
935: || Who When What
936: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
937: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column REVERSAL_GL_DATE
938: || vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also
939: || removed DEFAULT clause for parametr x_optional_fee_flag to
940: || avoid gscc warning.

Line 988: FROM igs_fi_inv_int_all

984: optional_fee_flag,
985: reversal_gl_date,
986: tax_year_code,
987: waiver_name
988: FROM igs_fi_inv_int_all
989: WHERE rowid = x_rowid
990: FOR UPDATE NOWAIT;
991:
992: tlinfo c1%ROWTYPE;

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

1106: Purpose :
1107: Know limitations, enhancements or remarks
1108: Change History
1109: Who When What
1110: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1111: smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column REVERSAL_GL_DATE
1112: vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also removed
1113: DEFAULT clause from procedure parameters to avoid gscc warnings.
1114: masehgal 10-JAN-2002 Enh # 2170429

Line 1208: update IGS_FI_INV_INT_ALL set

1204: x_tax_year_code => x_tax_year_code,
1205: x_waiver_name => x_waiver_name
1206: );
1207:
1208: update IGS_FI_INV_INT_ALL set
1209: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1210: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
1211: FEE_CAT = NEW_REFERENCES.FEE_CAT,
1212: FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,

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

1314: Purpose :
1315: Know limitations, enhancements or remarks
1316: Change History
1317: Who When What
1318: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1319: smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column REVERSAL_GL_DATE
1320: vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also removed
1321: DEFAULT clause from procedure parameters to avoid gscc warnings.
1322: masehgal 10-JAN-2002 Enh # 2170429

Line 1329: cursor c1 is select ROWID from IGS_FI_INV_INT_ALL

1325: Enhancement Bug No. 2030448
1326: (reverse chronological order - newest change first)
1327: ***************************************************************/
1328:
1329: cursor c1 is select ROWID from IGS_FI_INV_INT_ALL
1330: where INVOICE_ID= X_INVOICE_ID
1331: ;
1332: begin
1333: open c1;

Line 1449: delete from IGS_FI_INV_INT_ALL

1445: Before_DML (
1446: p_action => 'DELETE',
1447: x_rowid => X_ROWID
1448: );
1449: delete from IGS_FI_INV_INT_ALL
1450: where ROWID = X_ROWID;
1451: if (sql%notfound) then
1452: raise no_data_found;
1453: end if;