APPS.IGS_GE_S_LOG_ENTRY_PKG dependencies on IGS_GE_S_LOG_ENTRY

Line 1: package body IGS_GE_S_LOG_ENTRY_PKG as

1: package body IGS_GE_S_LOG_ENTRY_PKG as
2: /* $Header: IGSMI11B.pls 120.1 2005/10/17 04:40:46 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 10: old_references IGS_GE_S_LOG_ENTRY%RowType;

6: --sarakshi 14-Oct-2005 Bug#4657596, changed the check_constraint such that UPPER is not checked for KEY
7: -- kumma 13-JUN-2002 Removed Procedure GET_FK_IGS_ESSAGE, 2410165
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_GE_S_LOG_ENTRY%RowType;
11: new_references IGS_GE_S_LOG_ENTRY%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_GE_S_LOG_ENTRY%RowType;

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

Line 31: FROM IGS_GE_S_LOG_ENTRY

27: ) as
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_GE_S_LOG_ENTRY
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 122: FROM IGS_GE_S_LOG_ENTRY

118: ) RETURN BOOLEAN as
119:
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM IGS_GE_S_LOG_ENTRY
123: WHERE s_log_type = x_s_log_type
124: AND creation_dt = x_creation_dt
125: AND sequence_number = x_sequence_number
126: FOR UPDATE NOWAIT;

Line 151: FROM IGS_GE_S_LOG_ENTRY

147: ) as
148:
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM IGS_GE_S_LOG_ENTRY
152: WHERE s_log_type = x_s_log_type
153: AND creation_dt = x_creation_dt ;
154:
155: lv_rowid cur_rowid%RowType;

Line 276: cursor C is select ROWID from IGS_GE_S_LOG_ENTRY

272: X_MESSAGE_NAME in VARCHAR2,
273: X_TEXT in VARCHAR2,
274: X_MODE in VARCHAR2 default 'R'
275: ) as
276: cursor C is select ROWID from IGS_GE_S_LOG_ENTRY
277: where S_LOG_TYPE = X_S_LOG_TYPE
278: and CREATION_DT = X_CREATION_DT
279: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
280: X_LAST_UPDATE_DATE DATE;

Line 334: insert into IGS_GE_S_LOG_ENTRY (

330: x_last_updated_by => X_LAST_UPDATED_BY,
331: x_last_update_date => X_LAST_UPDATE_DATE,
332: x_last_update_login => X_LAST_UPDATE_LOGIN
333: );
334: insert into IGS_GE_S_LOG_ENTRY (
335: S_LOG_TYPE,
336: CREATION_DT,
337: SEQUENCE_NUMBER,
338: KEY,

Line 395: from IGS_GE_S_LOG_ENTRY

391: cursor c1 is select
392: KEY,
393: MESSAGE_NAME,
394: TEXT
395: from IGS_GE_S_LOG_ENTRY
396: where ROWID = X_ROWID
397: for update nowait;
398: tlinfo c1%rowtype;
399:

Line 494: update IGS_GE_S_LOG_ENTRY set

490: else
491: X_PROGRAM_UPDATE_DATE := SYSDATE;
492: end if;
493: end if;
494: update IGS_GE_S_LOG_ENTRY set
495: KEY = X_KEY,
496: MESSAGE_Name = NEW_REFERENCES.MESSAGE_NAME,
497: TEXT = NEW_REFERENCES.TEXT,
498: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 526: cursor c1 is select rowid from IGS_GE_S_LOG_ENTRY

522: X_MESSAGE_NAME in VARCHAR2,
523: X_TEXT in VARCHAR2,
524: X_MODE in VARCHAR2 default 'R'
525: ) as
526: cursor c1 is select rowid from IGS_GE_S_LOG_ENTRY
527: where S_LOG_TYPE = X_S_LOG_TYPE
528: and CREATION_DT = X_CREATION_DT
529: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
530: ;

Line 568: delete from IGS_GE_S_LOG_ENTRY

564: Before_DML (
565: p_action => 'DELETE',
566: x_rowid => X_ROWID
567: );
568: delete from IGS_GE_S_LOG_ENTRY
569: where ROWID = X_ROWID;
570: if (sql%notfound) then
571: raise no_data_found;
572: end if;

Line 580: end IGS_GE_S_LOG_ENTRY_PKG;

576: );
577:
578: end DELETE_ROW;
579:
580: end IGS_GE_S_LOG_ENTRY_PKG;