APPS.IGS_EN_UNIT_SET_STAT_PKG dependencies on IGS_EN_UNIT_SET_STAT

Line 1: package body IGS_EN_UNIT_SET_STAT_PKG as

1: package body IGS_EN_UNIT_SET_STAT_PKG as
2: /* $Header: IGSEI06B.pls 115.3 2002/11/28 23:32:27 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_STAT%RowType;
5: new_references IGS_EN_UNIT_SET_STAT%RowType;

Line 4: old_references IGS_EN_UNIT_SET_STAT%RowType;

1: package body IGS_EN_UNIT_SET_STAT_PKG as
2: /* $Header: IGSEI06B.pls 115.3 2002/11/28 23:32:27 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_STAT%RowType;
5: new_references IGS_EN_UNIT_SET_STAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_UNIT_SET_STAT%RowType;

1: package body IGS_EN_UNIT_SET_STAT_PKG as
2: /* $Header: IGSEI06B.pls 115.3 2002/11/28 23:32:27 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNIT_SET_STAT%RowType;
5: new_references IGS_EN_UNIT_SET_STAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_EN_UNIT_SET_STAT

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_EN_UNIT_SET_STAT
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 111: IGS_EN_UNIT_SET_PKG.GET_FK_IGS_EN_UNIT_SET_STAT (

107:
108: PROCEDURE Check_Child_Existance AS
109: BEGIN
110:
111: IGS_EN_UNIT_SET_PKG.GET_FK_IGS_EN_UNIT_SET_STAT (
112: old_references.unit_set_status
113: );
114:
115: END Check_Child_Existance;

Line 123: FROM IGS_EN_UNIT_SET_STAT

119: ) RETURN BOOLEAN as
120:
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM IGS_EN_UNIT_SET_STAT
124: WHERE unit_set_status = x_unit_set_status
125: FOR UPDATE NOWAIT;
126:
127: lv_rowid cur_rowid%RowType;

Line 239: cursor C is select ROWID from IGS_EN_UNIT_SET_STAT

235: X_DESCRIPTION in VARCHAR2,
236: X_CLOSED_IND in VARCHAR2,
237: X_MODE in VARCHAR2 default 'R'
238: ) AS
239: cursor C is select ROWID from IGS_EN_UNIT_SET_STAT
240: where UNIT_SET_STATUS = X_UNIT_SET_STATUS;
241: X_LAST_UPDATE_DATE DATE;
242: X_LAST_UPDATED_BY NUMBER;
243: X_LAST_UPDATE_LOGIN NUMBER;

Line 278: insert into IGS_EN_UNIT_SET_STAT (

274: x_last_updated_by => x_last_updated_by ,
275: x_last_update_login => x_last_update_login
276: );
277:
278: insert into IGS_EN_UNIT_SET_STAT (
279: UNIT_SET_STATUS,
280: S_UNIT_SET_STATUS,
281: DESCRIPTION,
282: CLOSED_IND,

Line 326: from IGS_EN_UNIT_SET_STAT

322: cursor c1 is select
323: S_UNIT_SET_STATUS,
324: DESCRIPTION,
325: CLOSED_IND
326: from IGS_EN_UNIT_SET_STAT
327: where ROWID = X_ROWID
328: for update nowait;
329: tlinfo c1%rowtype;
330:

Line 401: update IGS_EN_UNIT_SET_STAT set

397: x_last_updated_by => x_last_updated_by ,
398: x_last_update_login => x_last_update_login
399: );
400:
401: update IGS_EN_UNIT_SET_STAT set
402: S_UNIT_SET_STATUS = NEW_REFERENCES.S_UNIT_SET_STATUS,
403: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
404: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
405: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 428: cursor c1 is select rowid from IGS_EN_UNIT_SET_STAT

424: X_DESCRIPTION in VARCHAR2,
425: X_CLOSED_IND in VARCHAR2,
426: X_MODE in VARCHAR2 default 'R'
427: ) AS
428: cursor c1 is select rowid from IGS_EN_UNIT_SET_STAT
429: where UNIT_SET_STATUS = X_UNIT_SET_STATUS
430: ;
431:
432: begin

Line 467: delete from IGS_EN_UNIT_SET_STAT

463: x_rowid => X_ROWID
464: );
465:
466:
467: delete from IGS_EN_UNIT_SET_STAT
468: where ROWID = X_ROWID;
469: if (sql%notfound) then
470: raise no_data_found;
471: end if;

Line 481: end IGS_EN_UNIT_SET_STAT_PKG;

477:
478:
479: end DELETE_ROW;
480:
481: end IGS_EN_UNIT_SET_STAT_PKG;