APPS.PSP_GROUP_ELEMENT_LIST_PKG dependencies on PSP_GROUP_ELEMENT_LIST

Line 1: package body PSP_GROUP_ELEMENT_LIST_PKG as

1: package body PSP_GROUP_ELEMENT_LIST_PKG as
2: /* $Header: PSPSUGEB.pls 115.6 2002/11/18 08:49:53 lveerubh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_ELEMENT_GROUP_ID in NUMBER,

Line 26: cursor C is select ROWID from PSP_GROUP_ELEMENT_LIST

22: X_ATTRIBUTE14 in VARCHAR2,
23: X_ATTRIBUTE15 in VARCHAR2,
24: X_MODE in VARCHAR2 default 'R'
25: ) is
26: cursor C is select ROWID from PSP_GROUP_ELEMENT_LIST
27: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
28: and ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
29: and START_DATE_ACTIVE = X_START_DATE_ACTIVE;
30: X_LAST_UPDATE_DATE DATE;

Line 51: insert into PSP_GROUP_ELEMENT_LIST (

47: else
48: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
49: app_exception.raise_exception;
50: end if;
51: insert into PSP_GROUP_ELEMENT_LIST (
52: ELEMENT_GROUP_ID,
53: ELEMENT_TYPE_ID,
54: START_DATE_ACTIVE,
55: ATTRIBUTE_CATEGORY,

Line 151: from PSP_GROUP_ELEMENT_LIST

147: ATTRIBUTE12,
148: ATTRIBUTE13,
149: ATTRIBUTE14,
150: ATTRIBUTE15
151: from PSP_GROUP_ELEMENT_LIST
152: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
153: and ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
154: and START_DATE_ACTIVE = X_START_DATE_ACTIVE
155: for update of ELEMENT_GROUP_ID nowait;

Line 269: update PSP_GROUP_ELEMENT_LIST set

265: else
266: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
267: app_exception.raise_exception;
268: end if;
269: update PSP_GROUP_ELEMENT_LIST set
270: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
271: ATTRIBUTE1 = X_ATTRIBUTE1,
272: ATTRIBUTE2 = X_ATTRIBUTE2,
273: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 321: cursor c1 is select rowid from PSP_GROUP_ELEMENT_LIST

317: X_ATTRIBUTE14 in VARCHAR2,
318: X_ATTRIBUTE15 in VARCHAR2,
319: X_MODE in VARCHAR2 default 'R'
320: ) is
321: cursor c1 is select rowid from PSP_GROUP_ELEMENT_LIST
322: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
323: and ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
324: and START_DATE_ACTIVE = X_START_DATE_ACTIVE
325: ;

Line 386: delete from PSP_GROUP_ELEMENT_LIST

382: X_ELEMENT_TYPE_ID in NUMBER,
383: X_START_DATE_ACTIVE in DATE
384: ) is
385: begin
386: delete from PSP_GROUP_ELEMENT_LIST
387: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
388: and ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
389: and START_DATE_ACTIVE = X_START_DATE_ACTIVE;
390: if (sql%notfound) then

Line 395: end PSP_GROUP_ELEMENT_LIST_PKG;

391: raise no_data_found;
392: end if;
393: end DELETE_ROW;
394:
395: end PSP_GROUP_ELEMENT_LIST_PKG;