APPS.IGS_EN_MRG_ID_ACT_CH_PKG dependencies on IGS_EN_MRG_ID_ACT_CH

Line 1: package body IGS_EN_MRG_ID_ACT_CH_PKG AS

1: package body IGS_EN_MRG_ID_ACT_CH_PKG AS
2: /* $Header: IGSEI27B.pls 115.3 2002/11/28 23:38:26 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_EN_MRG_ID_ACT_CH%RowType;

2: /* $Header: IGSEI27B.pls 115.3 2002/11/28 23:38:26 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_EN_MRG_ID_ACT_CH%RowType;
7: new_references IGS_EN_MRG_ID_ACT_CH%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_EN_MRG_ID_ACT_CH%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_EN_MRG_ID_ACT_CH%RowType;
7: new_references IGS_EN_MRG_ID_ACT_CH%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_EN_MRG_ID_ACT_CH

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_EN_MRG_ID_ACT_CH
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 139: FROM IGS_EN_MRG_ID_ACT_CH

135: ) RETURN BOOLEAN AS
136:
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM IGS_EN_MRG_ID_ACT_CH
140: WHERE smir_id = x_smir_id
141: AND table_alias = x_table_alias
142: AND action_id = x_action_id
143: FOR UPDATE NOWAIT;

Line 168: FROM IGS_EN_MRG_ID_ACT_CH

164: ) AS
165:
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM IGS_EN_MRG_ID_ACT_CH
169: WHERE table_alias = x_table_alias
170: AND action_id = x_action_id ;
171:
172: lv_rowid cur_rowid%RowType;

Line 195: FROM IGS_EN_MRG_ID_ACT_CH

191: ) AS
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM IGS_EN_MRG_ID_ACT_CH
196: WHERE smir_id = x_smir_id ;
197:
198: lv_rowid cur_rowid%RowType;
199:

Line 314: cursor C is select ROWID from IGS_EN_MRG_ID_ACT_CH

310: X_ACTION_ID in NUMBER,
311: X_PERFORM_ACTION_IND in VARCHAR2,
312: X_MODE in VARCHAR2 default 'R'
313: ) AS
314: cursor C is select ROWID from IGS_EN_MRG_ID_ACT_CH
315: where SMIR_ID = X_SMIR_ID
316: and TABLE_ALIAS = X_TABLE_ALIAS
317: and ACTION_ID = X_ACTION_ID;
318: X_LAST_UPDATE_DATE DATE;

Line 356: insert into IGS_EN_MRG_ID_ACT_CH (

352: x_last_update_login => x_last_update_login
353: );
354:
355:
356: insert into IGS_EN_MRG_ID_ACT_CH (
357: SMIR_ID,
358: TABLE_ALIAS,
359: ACTION_ID,
360: PERFORM_ACTION_IND,

Line 402: from IGS_EN_MRG_ID_ACT_CH

398: X_PERFORM_ACTION_IND in VARCHAR2
399: ) AS
400: cursor c1 is select
401: PERFORM_ACTION_IND
402: from IGS_EN_MRG_ID_ACT_CH
403: where ROWID = X_ROWID
404: for update nowait;
405: tlinfo c1%rowtype;
406:

Line 477: update IGS_EN_MRG_ID_ACT_CH set

473: x_last_update_login => x_last_update_login
474: );
475:
476:
477: update IGS_EN_MRG_ID_ACT_CH set
478: PERFORM_ACTION_IND = NEW_REFERENCES.PERFORM_ACTION_IND,
479: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
480: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
481: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 505: cursor c1 is select rowid from IGS_EN_MRG_ID_ACT_CH

501: X_ACTION_ID in NUMBER,
502: X_PERFORM_ACTION_IND in VARCHAR2,
503: X_MODE in VARCHAR2 default 'R'
504: ) AS
505: cursor c1 is select rowid from IGS_EN_MRG_ID_ACT_CH
506: where SMIR_ID = X_SMIR_ID
507: and TABLE_ALIAS = X_TABLE_ALIAS
508: and ACTION_ID = X_ACTION_ID
509: ;

Line 546: delete from IGS_EN_MRG_ID_ACT_CH

542: x_rowid => X_ROWID
543: );
544:
545:
546: delete from IGS_EN_MRG_ID_ACT_CH
547: where ROWID = X_ROWID;
548: if (sql%notfound) then
549: raise no_data_found;
550: end if;

Line 560: end IGS_EN_MRG_ID_ACT_CH_PKG;

556:
557:
558: end DELETE_ROW;
559:
560: end IGS_EN_MRG_ID_ACT_CH_PKG;