APPS.IGS_GE_S_LOG_PKG dependencies on IGS_GE_S_LOG

Line 1: package body IGS_GE_S_LOG_PKG as

1: package body IGS_GE_S_LOG_PKG as
2: /* $Header: IGSMI10B.pls 115.4 2002/11/29 01:11:35 nsidana ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 9: old_references IGS_GE_S_LOG%RowType;

5: --Who When What
6: -- kumma 13-JUN-2002 Removed procedure GET_FK_IGS_OG_TYPE, 2410165
7: -------------------------------------------------------------------------------------------
8: l_rowid VARCHAR2(25);
9: old_references IGS_GE_S_LOG%RowType;
10: new_references IGS_GE_S_LOG%RowType;
11:
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,

Line 10: new_references IGS_GE_S_LOG%RowType;

6: -- kumma 13-JUN-2002 Removed procedure GET_FK_IGS_OG_TYPE, 2410165
7: -------------------------------------------------------------------------------------------
8: l_rowid VARCHAR2(25);
9: old_references IGS_GE_S_LOG%RowType;
10: new_references IGS_GE_S_LOG%RowType;
11:
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_GE_S_LOG

23: ) as
24:
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_GE_S_LOG
28: WHERE rowid = x_rowid;
29:
30: BEGIN
31:

Line 112: IGS_GE_S_LOG_ENTRY_PKG.GET_FK_IGS_GE_S_LOG (

108:
109: PROCEDURE Check_Child_Existance as
110: BEGIN
111:
112: IGS_GE_S_LOG_ENTRY_PKG.GET_FK_IGS_GE_S_LOG (
113: old_references.s_log_type,
114: old_references.creation_dt
115: );
116:

Line 126: FROM IGS_GE_S_LOG

122: ) RETURN BOOLEAN as
123:
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM IGS_GE_S_LOG
127: WHERE s_log_type = x_s_log_type
128: AND creation_dt = x_creation_dt
129: FOR UPDATE NOWAIT;
130:

Line 239: cursor C is select ROWID from IGS_GE_S_LOG

235: X_CREATION_DT in DATE,
236: X_KEY in VARCHAR2,
237: X_MODE in VARCHAR2 default 'R'
238: ) as
239: cursor C is select ROWID from IGS_GE_S_LOG
240: where S_LOG_TYPE = X_S_LOG_TYPE
241: and CREATION_DT = X_CREATION_DT;
242: X_LAST_UPDATE_DATE DATE;
243: X_LAST_UPDATED_BY NUMBER;

Line 293: insert into IGS_GE_S_LOG (

289: x_last_updated_by => X_LAST_UPDATED_BY,
290: x_last_update_date => X_LAST_UPDATE_DATE,
291: x_last_update_login => X_LAST_UPDATE_LOGIN
292: );
293: insert into IGS_GE_S_LOG (
294: S_LOG_TYPE,
295: CREATION_DT,
296: KEY,
297: CREATION_DATE,

Line 342: from IGS_GE_S_LOG

338: X_KEY in VARCHAR2
339: ) as
340: cursor c1 is select
341: KEY
342: from IGS_GE_S_LOG
343: where ROWID = X_ROWID
344: for update nowait;
345: tlinfo c1%rowtype;
346: begin

Line 431: update IGS_GE_S_LOG set

427: X_PROGRAM_UPDATE_DATE := SYSDATE;
428: end if;
429: end if;
430:
431: update IGS_GE_S_LOG set
432: KEY = NEW_REFERENCES.KEY,
433: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
434: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
435: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 458: cursor c1 is select rowid from IGS_GE_S_LOG

454: X_CREATION_DT in DATE,
455: X_KEY in VARCHAR2,
456: X_MODE in VARCHAR2 default 'R'
457: ) as
458: cursor c1 is select rowid from IGS_GE_S_LOG
459: where S_LOG_TYPE = X_S_LOG_TYPE
460: and CREATION_DT = X_CREATION_DT
461: ;
462:

Line 493: delete from IGS_GE_S_LOG

489: Before_DML (
490: p_action => 'DELETE',
491: x_rowid => X_ROWID
492: );
493: delete from IGS_GE_S_LOG
494: where ROWID = X_ROWID;
495: if (sql%notfound) then
496: raise no_data_found;
497: end if;

Line 505: end IGS_GE_S_LOG_PKG;

501: );
502:
503: end DELETE_ROW;
504:
505: end IGS_GE_S_LOG_PKG;