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.

[Home] [Help]

APPS.IGS_FI_FEE_STR_STAT_PKG dependencies on IGS_FI_FEE_STR_STAT

Line 1: package body IGS_FI_FEE_STR_STAT_PKG AS

1: package body IGS_FI_FEE_STR_STAT_PKG AS
2: /* $Header: IGSSI35B.pls 115.4 2002/11/29 03:45:04 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_STR_STAT%RowType;
5: new_references IGS_FI_FEE_STR_STAT%RowType;

Line 4: old_references IGS_FI_FEE_STR_STAT%RowType;

1: package body IGS_FI_FEE_STR_STAT_PKG AS
2: /* $Header: IGSSI35B.pls 115.4 2002/11/29 03:45:04 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_STR_STAT%RowType;
5: new_references IGS_FI_FEE_STR_STAT%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_FEE_STR_STAT%RowType;

1: package body IGS_FI_FEE_STR_STAT_PKG AS
2: /* $Header: IGSSI35B.pls 115.4 2002/11/29 03:45:04 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_STR_STAT%RowType;
5: new_references IGS_FI_FEE_STR_STAT%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_fee_structure_status IN VARCHAR2 DEFAULT NULL,

Line 21: FROM IGS_FI_FEE_STR_STAT

17: x_last_update_login IN NUMBER DEFAULT NULL
18: ) AS
19: CURSOR cur_old_ref_values IS
20: SELECT *
21: FROM IGS_FI_FEE_STR_STAT
22: WHERE rowid = x_rowid;
23: BEGIN
24: l_rowid := x_rowid;
25: -- Code for setting the Old and New Reference Values.

Line 102: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (

98: END IF;
99: END Check_Constraints;
100: PROCEDURE Check_Child_Existance AS
101: BEGIN
102: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
103: old_references.fee_structure_status
104: );
105: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
106: old_references.fee_structure_status

Line 105: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_FEE_STR_STAT (

101: BEGIN
102: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
103: old_references.fee_structure_status
104: );
105: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
106: old_references.fee_structure_status
107: );
108: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
109: old_references.fee_structure_status

Line 108: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (

104: );
105: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
106: old_references.fee_structure_status
107: );
108: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_FI_FEE_STR_STAT (
109: old_references.fee_structure_status
110: );
111: END Check_Child_Existance;
112: FUNCTION Get_PK_For_Validation (

Line 117: FROM IGS_FI_FEE_STR_STAT

113: x_fee_structure_status IN VARCHAR2
114: ) RETURN BOOLEAN AS
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM IGS_FI_FEE_STR_STAT
118: WHERE fee_structure_status = x_fee_structure_status
119: FOR UPDATE NOWAIT;
120: lv_rowid cur_rowid%RowType;
121: BEGIN

Line 196: cursor C is select ROWID from IGS_FI_FEE_STR_STAT

192: X_S_FEE_STRUCTURE_STATUS in VARCHAR2,
193: X_CLOSED_IND in VARCHAR2,
194: X_MODE in VARCHAR2 default 'R'
195: ) AS
196: cursor C is select ROWID from IGS_FI_FEE_STR_STAT
197: where FEE_STRUCTURE_STATUS = X_FEE_STRUCTURE_STATUS;
198: X_LAST_UPDATE_DATE DATE;
199: X_LAST_UPDATED_BY NUMBER;
200: X_LAST_UPDATE_LOGIN NUMBER;

Line 233: insert into IGS_FI_FEE_STR_STAT (

229: x_last_update_date=>X_LAST_UPDATE_DATE,
230: x_last_updated_by=>X_LAST_UPDATED_BY,
231: x_last_update_login=>X_LAST_UPDATE_LOGIN
232: );
233: insert into IGS_FI_FEE_STR_STAT (
234: FEE_STRUCTURE_STATUS,
235: DESCRIPTION,
236: S_FEE_STRUCTURE_STATUS,
237: CLOSED_IND,

Line 273: from IGS_FI_FEE_STR_STAT

269: cursor c1 is select
270: DESCRIPTION,
271: S_FEE_STRUCTURE_STATUS,
272: CLOSED_IND
273: from IGS_FI_FEE_STR_STAT
274: where ROWID = X_ROWID
275: for update nowait;
276: tlinfo c1%rowtype;
277: begin

Line 343: update IGS_FI_FEE_STR_STAT

339: x_last_update_date=>X_LAST_UPDATE_DATE,
340: x_last_updated_by=>X_LAST_UPDATED_BY,
341: x_last_update_login=>X_LAST_UPDATE_LOGIN
342: );
343: update IGS_FI_FEE_STR_STAT
344: set
345: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
346: S_FEE_STRUCTURE_STATUS = NEW_REFERENCES.S_FEE_STRUCTURE_STATUS,
347: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 364: cursor c1 is select rowid from IGS_FI_FEE_STR_STAT

360: X_S_FEE_STRUCTURE_STATUS in VARCHAR2,
361: X_CLOSED_IND in VARCHAR2,
362: X_MODE in VARCHAR2 default 'R'
363: ) AS
364: cursor c1 is select rowid from IGS_FI_FEE_STR_STAT
365: where FEE_STRUCTURE_STATUS = X_FEE_STRUCTURE_STATUS
366: ;
367: begin
368: open c1;

Line 398: delete from IGS_FI_FEE_STR_STAT

394: Before_DML (
395: p_action => 'DELETE',
396: x_rowid => X_ROWID
397: );
398: delete from IGS_FI_FEE_STR_STAT
399: where ROWID = X_ROWID;
400: if (sql%notfound) then
401: raise no_data_found;
402: end if;

Line 404: end IGS_FI_FEE_STR_STAT_PKG;

400: if (sql%notfound) then
401: raise no_data_found;
402: end if;
403: end DELETE_ROW;
404: end IGS_FI_FEE_STR_STAT_PKG;