APPS.IGS_RU_GROUP_SET_PKG dependencies on IGS_RU_GROUP_SET

Line 1: package body IGS_RU_GROUP_SET_PKG as

1: package body IGS_RU_GROUP_SET_PKG as
2: /* $Header: IGSUI06B.pls 115.8 2003/10/14 10:53:40 nsinha ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_RU_GROUP_SET%RowType;

2: /* $Header: IGSUI06B.pls 115.8 2003/10/14 10:53:40 nsinha ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_RU_GROUP_SET%RowType;
7: new_references IGS_RU_GROUP_SET%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_RU_GROUP_SET%RowType;

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

Line 22: FROM IGS_RU_GROUP_SET

18: x_last_update_login IN NUMBER ) as
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_RU_GROUP_SET
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 35: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION INSERT VALIDATE_INSERT : IGSUI06B.PLS');

31: Open cur_old_ref_values;
32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION INSERT VALIDATE_INSERT : IGSUI06B.PLS');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Close cur_old_ref_values;
39: Return;

Line 134: FROM IGS_RU_GROUP_SET

130: ) RETURN BOOLEAN as
131:
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM IGS_RU_GROUP_SET
135: WHERE rug_sequence_number = x_rug_sequence_number
136: AND rud_sequence_number = x_rud_sequence_number
137: FOR UPDATE NOWAIT;
138:

Line 161: FROM IGS_RU_GROUP_SET

157: ) as
158:
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM IGS_RU_GROUP_SET
162: WHERE rud_sequence_number = x_sequence_number ;
163:
164: lv_rowid cur_rowid%RowType;
165:

Line 187: FROM IGS_RU_GROUP_SET

183: ) as
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_RU_GROUP_SET
188: WHERE rug_sequence_number = x_sequence_number ;
189:
190: lv_rowid cur_rowid%RowType;
191:

Line 278: cursor C is select ROWID from IGS_RU_GROUP_SET

274: X_RUD_SEQUENCE_NUMBER in NUMBER,
275: X_RUG_SEQUENCE_NUMBER in NUMBER,
276: X_MODE in VARCHAR2
277: ) as
278: cursor C is select ROWID from IGS_RU_GROUP_SET
279: where RUD_SEQUENCE_NUMBER = X_RUD_SEQUENCE_NUMBER
280: and RUG_SEQUENCE_NUMBER = X_RUG_SEQUENCE_NUMBER;
281: X_LAST_UPDATE_DATE DATE;
282: X_LAST_UPDATED_BY NUMBER;

Line 316: insert into IGS_RU_GROUP_SET (

312: x_last_updated_by=>X_LAST_UPDATED_BY,
313: x_last_update_login=>X_LAST_UPDATE_LOGIN
314: );
315:
316: insert into IGS_RU_GROUP_SET (
317: RUG_SEQUENCE_NUMBER,
318: RUD_SEQUENCE_NUMBER,
319: CREATION_DATE,
320: CREATED_BY,

Line 354: from IGS_RU_GROUP_SET

350: X_RUD_SEQUENCE_NUMBER in NUMBER,
351: X_RUG_SEQUENCE_NUMBER in NUMBER
352: ) as
353: cursor c1 is select ROWID
354: from IGS_RU_GROUP_SET
355: where ROWID = X_ROWID for update nowait;
356: tlinfo c1%rowtype;
357:
358: begin

Line 363: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION LOCK_ROW : IGSUI06B.PLS');

359: open c1;
360: fetch c1 into tlinfo;
361: if (c1%notfound) then
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION LOCK_ROW : IGSUI06B.PLS');
364: IGS_GE_MSG_STACK.ADD;
365: app_exception.raise_exception;
366: close c1;
367: return;

Line 383: delete from IGS_RU_GROUP_SET

379: Before_DML (
380: p_action => 'DELETE',
381: x_rowid => X_ROWID);
382:
383: delete from IGS_RU_GROUP_SET
384: where ROWID = X_ROWID;
385: if (sql%notfound) then
386: raise no_data_found;
387: end if;

Line 395: end IGS_RU_GROUP_SET_PKG;

391: x_rowid => X_ROWID);
392:
393: end DELETE_ROW;
394:
395: end IGS_RU_GROUP_SET_PKG;