APPS.PSP_ELEMENT_GROUPS_PKG dependencies on PSP_ELEMENT_GROUPS

Line 1: package body PSP_ELEMENT_GROUPS_PKG as

1: package body PSP_ELEMENT_GROUPS_PKG as
2: /* $Header: PSPSUGRB.pls 115.7 2003/09/08 16:11:18 spchakra ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_ELEMENT_GROUP_ID in NUMBER,

Line 30: cursor C is select ROWID from PSP_ELEMENT_GROUPS

26: X_MODE in VARCHAR2 default 'R',
27: X_BUSINESS_GROUP_ID IN NUMBER, -- Introduced for bug fix 3098050
28: X_SET_OF_BOOKS_ID IN NUMBER -- Introduced for bug fix 3098050
29: ) is
30: cursor C is select ROWID from PSP_ELEMENT_GROUPS
31: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID;
32: X_LAST_UPDATE_DATE DATE;
33: X_LAST_UPDATED_BY NUMBER;
34: X_LAST_UPDATE_LOGIN NUMBER;

Line 53: insert into PSP_ELEMENT_GROUPS (

49: else
50: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
51: app_exception.raise_exception;
52: end if;
53: insert into PSP_ELEMENT_GROUPS (
54: ELEMENT_GROUP_ID,
55: ELEMENT_GROUP_NAME,
56: START_DATE_ACTIVE,
57: END_DATE_ACTIVE,

Line 169: from PSP_ELEMENT_GROUPS

165: ATTRIBUTE12,
166: ATTRIBUTE13,
167: ATTRIBUTE14,
168: ATTRIBUTE15
169: from PSP_ELEMENT_GROUPS
170: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
171: -- Introduced BG/SOB check for bug fix 3098050
172: AND business_group_id = x_business_group_id
173: AND set_of_books_id = x_set_of_books_id

Line 300: update PSP_ELEMENT_GROUPS set

296: else
297: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
298: app_exception.raise_exception;
299: end if;
300: update PSP_ELEMENT_GROUPS set
301: ELEMENT_GROUP_NAME = X_ELEMENT_GROUP_NAME,
302: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
303: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
304: COMMENTS = X_COMMENTS,

Line 361: cursor c1 is select rowid from PSP_ELEMENT_GROUPS

357: X_MODE in VARCHAR2 default 'R',
358: X_BUSINESS_GROUP_ID IN NUMBER, -- Introduced for bug fix 3098050
359: X_SET_OF_BOOKS_ID IN NUMBER -- Introduced for bug fix 3098050
360: ) is
361: cursor c1 is select rowid from PSP_ELEMENT_GROUPS
362: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID
363: ;
364: dummy c1%rowtype;
365: begin

Line 430: delete from PSP_ELEMENT_GROUPS

426: procedure DELETE_ROW (
427: X_ELEMENT_GROUP_ID in NUMBER
428: ) is
429: begin
430: delete from PSP_ELEMENT_GROUPS
431: where ELEMENT_GROUP_ID = X_ELEMENT_GROUP_ID;
432: if (sql%notfound) then
433: raise no_data_found;
434: end if;

Line 437: end PSP_ELEMENT_GROUPS_PKG;

433: raise no_data_found;
434: end if;
435: end DELETE_ROW;
436:
437: end PSP_ELEMENT_GROUPS_PKG;