APPS.IGS_EN_ST_SPSHT_CTL_PKG dependencies on IGS_EN_ST_SPSHT_CTL

Line 1: package body IGS_EN_ST_SPSHT_CTL_PKG as

1: package body IGS_EN_ST_SPSHT_CTL_PKG as
2: /* $Header: IGSEI09B.pls 115.3 2002/11/28 23:33:17 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_ST_SPSHT_CTL%RowType;
5: new_references IGS_EN_ST_SPSHT_CTL%RowType;

Line 4: old_references IGS_EN_ST_SPSHT_CTL%RowType;

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

Line 5: new_references IGS_EN_ST_SPSHT_CTL%RowType;

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

Line 22: FROM IGS_EN_ST_SPSHT_CTL

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

Line 61: -- ON IGS_EN_ST_SPSHT_CTL

57: END Set_Column_Values;
58: -- Trigger description :-
59: -- "OSS_TST".trg_essc_br_u
60: -- BEFORE UPDATE
61: -- ON IGS_EN_ST_SPSHT_CTL
62: -- FOR EACH ROW
63:
64: PROCEDURE BeforeRowUpdate1(
65: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 116: IGS_EN_ST_SNAPSHOT_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (

112:
113: PROCEDURE Check_Child_Existance AS
114: BEGIN
115:
116: IGS_EN_ST_SNAPSHOT_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (
117: old_references.snapshot_dt_time
118: );
119:
120: IGS_ST_GVT_SPSHT_CTL_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (

Line 120: IGS_ST_GVT_SPSHT_CTL_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (

116: IGS_EN_ST_SNAPSHOT_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (
117: old_references.snapshot_dt_time
118: );
119:
120: IGS_ST_GVT_SPSHT_CTL_PKG.GET_FK_IGS_EN_ST_SPSHT_CTL (
121: old_references.snapshot_dt_time
122: );
123:
124: END Check_Child_Existance;

Line 132: FROM IGS_EN_ST_SPSHT_CTL

128: ) RETURN BOOLEAN AS
129:
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM IGS_EN_ST_SPSHT_CTL
133: WHERE snapshot_dt_time = x_snapshot_dt_time
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 243: cursor C is select ROWID from IGS_EN_ST_SPSHT_CTL

239: X_DELETE_SNAPSHOT_IND in VARCHAR2,
240: X_COMMENTS in VARCHAR2,
241: X_MODE in VARCHAR2 default 'R'
242: ) AS
243: cursor C is select ROWID from IGS_EN_ST_SPSHT_CTL
244: where SNAPSHOT_DT_TIME = X_SNAPSHOT_DT_TIME;
245: X_LAST_UPDATE_DATE DATE;
246: X_LAST_UPDATED_BY NUMBER;
247: X_LAST_UPDATE_LOGIN NUMBER;

Line 294: insert into IGS_EN_ST_SPSHT_CTL (

290: x_last_update_date => X_LAST_UPDATE_DATE,
291: x_last_updated_by => X_LAST_UPDATED_BY,
292: x_last_update_login => X_LAST_UPDATE_LOGIN
293: );
294: insert into IGS_EN_ST_SPSHT_CTL (
295: SNAPSHOT_DT_TIME,
296: DELETE_SNAPSHOT_IND,
297: COMMENTS,
298: CREATION_DATE,

Line 344: from IGS_EN_ST_SPSHT_CTL

340: ) AS
341: cursor c1 is select
342: DELETE_SNAPSHOT_IND,
343: COMMENTS
344: from IGS_EN_ST_SPSHT_CTL
345: where ROWID = X_ROWID
346: for update nowait;
347: tlinfo c1%rowtype;
348:

Line 435: update IGS_EN_ST_SPSHT_CTL set

431: else
432: X_PROGRAM_UPDATE_DATE := SYSDATE;
433: end if;
434: end if;
435: update IGS_EN_ST_SPSHT_CTL set
436: DELETE_SNAPSHOT_IND = NEW_REFERENCES.DELETE_SNAPSHOT_IND,
437: COMMENTS = NEW_REFERENCES.COMMENTS,
438: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
439: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 463: cursor c1 is select rowid from IGS_EN_ST_SPSHT_CTL

459: X_DELETE_SNAPSHOT_IND in VARCHAR2,
460: X_COMMENTS in VARCHAR2,
461: X_MODE in VARCHAR2 default 'R'
462: ) AS
463: cursor c1 is select rowid from IGS_EN_ST_SPSHT_CTL
464: where SNAPSHOT_DT_TIME = X_SNAPSHOT_DT_TIME
465: ;
466:
467: begin

Line 497: delete from IGS_EN_ST_SPSHT_CTL

493: Before_DML (
494: p_action => 'DELETE',
495: x_rowid => X_ROWID
496: );
497: delete from IGS_EN_ST_SPSHT_CTL
498: where ROWID = X_ROWID;
499: if (sql%notfound) then
500: raise no_data_found;
501: end if;

Line 508: end IGS_EN_ST_SPSHT_CTL_PKG;

504: x_rowid => X_ROWID
505: );
506: end DELETE_ROW;
507:
508: end IGS_EN_ST_SPSHT_CTL_PKG;