APPS.IGS_EN_MERGE_ID_LOG_PKG dependencies on IGS_EN_MERGE_ID_LOG

Line 1: package body IGS_EN_MERGE_ID_LOG_PKG AS

1: package body IGS_EN_MERGE_ID_LOG_PKG AS
2: /* $Header: IGSEI28B.pls 120.1 2005/09/08 15:27:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_LOG%RowType;

Line 5: old_references IGS_EN_MERGE_ID_LOG%RowType;

1: package body IGS_EN_MERGE_ID_LOG_PKG AS
2: /* $Header: IGSEI28B.pls 120.1 2005/09/08 15:27:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_LOG%RowType;
6: new_references IGS_EN_MERGE_ID_LOG%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_EN_MERGE_ID_LOG%RowType;

2: /* $Header: IGSEI28B.pls 120.1 2005/09/08 15:27:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_LOG%RowType;
6: new_references IGS_EN_MERGE_ID_LOG%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_EN_MERGE_ID_LOG

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_EN_MERGE_ID_LOG
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 111: FROM IGS_EN_MERGE_ID_LOG

107: ) RETURN BOOLEAN AS
108:
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_EN_MERGE_ID_LOG
112: WHERE SMIL_ID = x_SMIL_ID
113: FOR UPDATE NOWAIT;
114:
115: lv_rowid cur_rowid%RowType;

Line 159: FROM IGS_EN_MERGE_ID_LOG

155: )AS
156:
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM IGS_EN_MERGE_ID_LOG
160: WHERE table_alias = x_table_alias
161: AND action_id = x_action_id ;
162:
163: lv_rowid cur_rowid%RowType;

Line 288: cursor C is select ROWID from IGS_EN_MERGE_ID_LOG

284: X_ACTION_ID in NUMBER,
285: X_PERFORM_ACTION_IND in VARCHAR2,
286: X_MODE in VARCHAR2 default 'R'
287: ) AS
288: cursor C is select ROWID from IGS_EN_MERGE_ID_LOG
289: where SMIL_ID = X_SMIL_ID;
290: X_LAST_UPDATE_DATE DATE;
291: X_LAST_UPDATED_BY NUMBER;
292: X_LAST_UPDATE_LOGIN NUMBER;

Line 313: SELECT IGS_EN_MERGE_ID_LOG_SMIL_ID_S.Nextval

309: IGS_GE_MSG_STACK.ADD;
310: app_exception.raise_exception;
311: end if;
312:
313: SELECT IGS_EN_MERGE_ID_LOG_SMIL_ID_S.Nextval
314: INTO X_SMIL_ID
315: FROM DUAL;
316:
317: Before_DML(

Line 335: insert into IGS_EN_MERGE_ID_LOG (

331: x_last_updated_by=>X_LAST_UPDATED_BY,
332: x_last_update_login=>X_LAST_UPDATE_LOGIN
333: );
334:
335: insert into IGS_EN_MERGE_ID_LOG (
336: OBSOLETE_PERSON_ID,
337: OBSOLETE_ID_ROW_INFO,
338: CURRENT_PERSON_ID,
339: CURRENT_ID_ROW_INFO,

Line 398: from IGS_EN_MERGE_ID_LOG

394: CURRENT_ID_ROW_INFO,
395: TABLE_ALIAS,
396: ACTION_ID,
397: PERFORM_ACTION_IND
398: from IGS_EN_MERGE_ID_LOG
399: where ROWID = X_ROWID for update nowait;
400: tlinfo c1%rowtype;
401:
402: begin

Line 487: update IGS_EN_MERGE_ID_LOG set

483: x_last_update_date=>X_LAST_UPDATE_DATE,
484: x_last_updated_by=>X_LAST_UPDATED_BY,
485: x_last_update_login=>X_LAST_UPDATE_LOGIN
486: );
487: update IGS_EN_MERGE_ID_LOG set
488: OBSOLETE_PERSON_ID = new_references.OBSOLETE_PERSON_ID,
489: OBSOLETE_ID_ROW_INFO = new_references.OBSOLETE_ID_ROW_INFO,
490: CURRENT_PERSON_ID = new_references.CURRENT_PERSON_ID,
491: CURRENT_ID_ROW_INFO = new_references.CURRENT_ID_ROW_INFO,

Line 523: cursor c1 is select rowid from IGS_EN_MERGE_ID_LOG

519: X_ACTION_ID in NUMBER,
520: X_PERFORM_ACTION_IND in VARCHAR2,
521: X_MODE in VARCHAR2 default 'R'
522: ) AS
523: cursor c1 is select rowid from IGS_EN_MERGE_ID_LOG
524: where SMIL_ID = X_SMIL_ID;
525:
526: begin
527: open c1;

Line 564: delete from IGS_EN_MERGE_ID_LOG

560: Before_DML(
561: p_action => 'DELETE',
562: x_rowid => X_ROWID
563: );
564: delete from IGS_EN_MERGE_ID_LOG
565: where ROWID = X_ROWID;
566: if (sql%notfound) then
567: raise no_data_found;
568: end if;

Line 575: end IGS_EN_MERGE_ID_LOG_PKG;

571: x_rowid => X_ROWID
572: );
573: end DELETE_ROW;
574:
575: end IGS_EN_MERGE_ID_LOG_PKG;