APPS.IGS_EN_MERGE_ID_ROWS_PKG dependencies on IGS_EN_MERGE_ID_ROWS

Line 1: package body IGS_EN_MERGE_ID_ROWS_PKG AS

1: package body IGS_EN_MERGE_ID_ROWS_PKG AS
2: /* $Header: IGSEI29B.pls 115.4 2002/11/28 23:38:55 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_ROWS%RowType;

Line 5: old_references IGS_EN_MERGE_ID_ROWS%RowType;

1: package body IGS_EN_MERGE_ID_ROWS_PKG AS
2: /* $Header: IGSEI29B.pls 115.4 2002/11/28 23:38:55 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_ROWS%RowType;
6: new_references IGS_EN_MERGE_ID_ROWS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_EN_MERGE_ID_ROWS%RowType;

2: /* $Header: IGSEI29B.pls 115.4 2002/11/28 23:38:55 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_MERGE_ID_ROWS%RowType;
6: new_references IGS_EN_MERGE_ID_ROWS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 30: FROM IGS_EN_MERGE_ID_ROWS

26: ) AS
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_EN_MERGE_ID_ROWS
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 133: IGS_EN_MRG_ID_ACT_CH_PKG.GET_FK_IGS_EN_MERGE_ID_ROWS (

129:
130: PROCEDURE Check_Child_Existance AS
131: BEGIN
132:
133: IGS_EN_MRG_ID_ACT_CH_PKG.GET_FK_IGS_EN_MERGE_ID_ROWS (
134: old_references.smir_id
135: );
136:
137: END Check_Child_Existance;

Line 145: FROM IGS_EN_MERGE_ID_ROWS

141: ) RETURN BOOLEAN AS
142:
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM IGS_EN_MERGE_ID_ROWS
146: WHERE smir_id = x_smir_id
147: FOR UPDATE NOWAIT;
148:
149: lv_rowid cur_rowid%RowType;

Line 171: FROM IGS_EN_MERGE_ID_ROWS

167: ) AS
168:
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM IGS_EN_MERGE_ID_ROWS
172: WHERE current_person_id = x_person_id
173: OR obsolete_person_id = x_person_id ;
174:
175: lv_rowid cur_rowid%RowType;

Line 306: cursor C is select ROWID from IGS_EN_MERGE_ID_ROWS

302: X_CURRENT_ID_ROWID in VARCHAR2,
303: X_CURRENT_UPDATE_ON in DATE,
304: X_MODE in VARCHAR2 default 'R'
305: ) AS
306: cursor C is select ROWID from IGS_EN_MERGE_ID_ROWS
307: where SMIR_ID = X_SMIR_ID;
308: X_LAST_UPDATE_DATE DATE;
309: X_LAST_UPDATED_BY NUMBER;
310: X_LAST_UPDATE_LOGIN NUMBER;

Line 349: insert into IGS_EN_MERGE_ID_ROWS (

345: x_last_update_date => X_LAST_UPDATE_DATE,
346: x_last_updated_by => X_LAST_UPDATED_BY,
347: x_last_update_login => X_LAST_UPDATE_LOGIN
348: );
349: insert into IGS_EN_MERGE_ID_ROWS (
350: SMIR_ID,
351: TABLE_ALIAS,
352: OBSOLETE_PERSON_ID,
353: OBSOLETE_ID_ROW_INFO,

Line 419: from IGS_EN_MERGE_ID_ROWS

415: CURRENT_PERSON_ID,
416: CURRENT_ID_ROW_INFO,
417: CURRENT_ID_ROWID,
418: CURRENT_UPDATE_ON
419: from IGS_EN_MERGE_ID_ROWS
420: where ROWID = X_ROWID
421: for update nowait;
422: tlinfo c1%rowtype;
423:

Line 522: update IGS_EN_MERGE_ID_ROWS set

518: x_last_update_date => X_LAST_UPDATE_DATE,
519: x_last_updated_by => X_LAST_UPDATED_BY,
520: x_last_update_login => X_LAST_UPDATE_LOGIN
521: );
522: update IGS_EN_MERGE_ID_ROWS set
523: TABLE_ALIAS = NEW_REFERENCES.TABLE_ALIAS,
524: OBSOLETE_PERSON_ID = NEW_REFERENCES.OBSOLETE_PERSON_ID,
525: OBSOLETE_ID_ROW_INFO = NEW_REFERENCES.OBSOLETE_ID_ROW_INFO,
526: OBSOLETE_ID_ROWID = NEW_REFERENCES.OBSOLETE_ID_ROWID,

Line 560: cursor c1 is select rowid from IGS_EN_MERGE_ID_ROWS

556: X_CURRENT_ID_ROWID in VARCHAR2,
557: X_CURRENT_UPDATE_ON in DATE,
558: X_MODE in VARCHAR2 default 'R'
559: ) AS
560: cursor c1 is select rowid from IGS_EN_MERGE_ID_ROWS
561: where SMIR_ID = X_SMIR_ID
562: ;
563: begin
564: open c1;

Line 607: delete from IGS_EN_MERGE_ID_ROWS

603: Before_DML (
604: p_action => 'DELETE',
605: x_rowid => X_ROWID
606: );
607: delete from IGS_EN_MERGE_ID_ROWS
608: where ROWID = X_ROWID;
609: if (sql%notfound) then
610: raise no_data_found;
611: end if;

Line 618: end IGS_EN_MERGE_ID_ROWS_PKG;

614: x_rowid => X_ROWID
615: );
616: end DELETE_ROW;
617:
618: end IGS_EN_MERGE_ID_ROWS_PKG;