APPS.PSP_EFFORT_REPORT_ELEMENTS_PKG dependencies on PSP_EFFORT_REPORT_ELEMENTS

Line 1: package body PSP_EFFORT_REPORT_ELEMENTS_PKG as

1: package body PSP_EFFORT_REPORT_ELEMENTS_PKG as
2: /* $Header: PSPSUEFB.pls 115.11 2003/09/08 16:11:08 spchakra ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_ELEMENT_TYPE_ID in NUMBER,

Line 28: cursor C is select ROWID from PSP_EFFORT_REPORT_ELEMENTS

24: X_MODE in VARCHAR2 default 'R',
25: X_BUSINESS_GROUP_ID IN NUMBER, -- Introduced for bug fix 3098050
26: X_SET_OF_BOOKS_ID IN NUMBER -- Introduced for bug fix 3098050
27: ) is
28: cursor C is select ROWID from PSP_EFFORT_REPORT_ELEMENTS
29: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID;
30: X_LAST_UPDATE_DATE DATE;
31: X_LAST_UPDATED_BY NUMBER;
32: X_LAST_UPDATE_LOGIN NUMBER;

Line 51: insert into PSP_EFFORT_REPORT_ELEMENTS (

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

Line 159: from PSP_EFFORT_REPORT_ELEMENTS

155: ATTRIBUTE13,
156: ATTRIBUTE14,
157: ATTRIBUTE15,
158: BASE_NON_BASE_COMP_FLAG
159: from PSP_EFFORT_REPORT_ELEMENTS
160: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
161: -- Introduced fBG/SOB check for bug fix 3098050
162: AND business_group_id = x_business_group_id
163: AND set_of_books_id = x_set_of_books_id

Line 286: update PSP_EFFORT_REPORT_ELEMENTS set

282: else
283: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
284: app_exception.raise_exception;
285: end if;
286: update PSP_EFFORT_REPORT_ELEMENTS set
287: USE_IN_EFFORT_REPORT = X_USE_IN_EFFORT_REPORT,
288: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
289: ATTRIBUTE1 = X_ATTRIBUTE1,
290: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 343: cursor c1 is select rowid from PSP_EFFORT_REPORT_ELEMENTS

339: X_MODE in VARCHAR2 default 'R',
340: X_BUSINESS_GROUP_ID IN NUMBER, -- Introduced for bug fix 3098050
341: X_SET_OF_BOOKS_ID IN NUMBER -- Introduced for bug fix 3098050
342: ) is
343: cursor c1 is select rowid from PSP_EFFORT_REPORT_ELEMENTS
344: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
345: ;
346: dummy c1%rowtype;
347: begin

Line 408: delete from PSP_EFFORT_REPORT_ELEMENTS

404: procedure DELETE_ROW (
405: X_ELEMENT_TYPE_ID in NUMBER
406: ) is
407: begin
408: delete from PSP_EFFORT_REPORT_ELEMENTS
409: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID;
410: if (sql%notfound) then
411: raise no_data_found;
412: end if;

Line 415: end PSP_EFFORT_REPORT_ELEMENTS_PKG;

411: raise no_data_found;
412: end if;
413: end DELETE_ROW;
414:
415: end PSP_EFFORT_REPORT_ELEMENTS_PKG;