APPS.IGS_RU_WORK_SET_MBR_PKG dependencies on IGS_RU_WORK_SET_MBR

Line 1: package body IGS_RU_WORK_SET_MBR_PKG as

1: package body IGS_RU_WORK_SET_MBR_PKG as
2: /* $Header: IGSUI16B.pls 115.6 2002/11/29 04:29:12 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_WORK_SET_MBR%RowType;

Line 5: old_references IGS_RU_WORK_SET_MBR%RowType;

1: package body IGS_RU_WORK_SET_MBR_PKG as
2: /* $Header: IGSUI16B.pls 115.6 2002/11/29 04:29:12 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_WORK_SET_MBR%RowType;
6: new_references IGS_RU_WORK_SET_MBR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RU_WORK_SET_MBR%RowType;

2: /* $Header: IGSUI16B.pls 115.6 2002/11/29 04:29:12 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_WORK_SET_MBR%RowType;
6: new_references IGS_RU_WORK_SET_MBR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 25: FROM IGS_RU_WORK_SET_MBR

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

Line 95: FROM IGS_RU_WORK_SET_MBR

91: )return BOOLEAN as
92:
93: CURSOR cur_rowid IS
94: SELECT rowid
95: FROM IGS_RU_WORK_SET_MBR
96: WHERE rws_sequence_number = x_rws_sequence_number
97: AND unit_cd = x_unit_cd
98: AND version_number = x_version_number
99: AND cal_type = x_cal_type

Line 125: FROM IGS_RU_WORK_SET_MBR

121: ) as
122:
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM IGS_RU_WORK_SET_MBR
126: WHERE rws_sequence_number = x_sequence_number ;
127:
128: lv_rowid cur_rowid%RowType;
129:

Line 226: cursor C is select ROWID from IGS_RU_WORK_SET_MBR

222: X_CAL_TYPE in VARCHAR2,
223: X_CI_SEQUENCE_NUMBER in VARCHAR2,
224: X_MODE in VARCHAR2
225: ) as
226: cursor C is select ROWID from IGS_RU_WORK_SET_MBR
227: where RWS_SEQUENCE_NUMBER = X_RWS_SEQUENCE_NUMBER
228: and UNIT_CD = X_UNIT_CD
229: and VERSION_NUMBER = X_VERSION_NUMBER
230: and CAL_TYPE = X_CAL_TYPE

Line 285: insert into IGS_RU_WORK_SET_MBR (

281: x_last_updated_by=>X_LAST_UPDATED_BY,
282: x_last_update_login=>X_LAST_UPDATE_LOGIN
283: );
284:
285: insert into IGS_RU_WORK_SET_MBR (
286: RWS_SEQUENCE_NUMBER,
287: UNIT_CD,
288: VERSION_NUMBER,
289: CAL_TYPE,

Line 340: from IGS_RU_WORK_SET_MBR

336: X_CAL_TYPE in VARCHAR2,
337: X_CI_SEQUENCE_NUMBER in VARCHAR2
338: ) as
339: cursor c1 is select ROWID
340: from IGS_RU_WORK_SET_MBR
341: where ROWID = X_ROWID for update nowait;
342: tlinfo c1%rowtype;
343:
344: begin

Line 371: delete from IGS_RU_WORK_SET_MBR

367: Before_DML (
368: p_action => 'DELETE',
369: x_rowid => X_ROWID);
370:
371: delete from IGS_RU_WORK_SET_MBR
372: where ROWID = X_ROWID;
373: if (sql%notfound) then
374: raise no_data_found;
375: end if;

Line 383: end IGS_RU_WORK_SET_MBR_PKG;

379: x_rowid => X_ROWID);
380:
381: end DELETE_ROW;
382:
383: end IGS_RU_WORK_SET_MBR_PKG;