APPS.PSP_EFFORT_REPORT_DETAILS_PKG dependencies on PSP_EFFORT_REPORT_DETAILS

Line 1: package body PSP_EFFORT_REPORT_DETAILS_PKG as

1: package body PSP_EFFORT_REPORT_DETAILS_PKG as
2: /* $Header: PSPERDEB.pls 115.7 2002/11/18 12:28:54 lveerubh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_EFFORT_REPORT_ID in NUMBER,

Line 19: cursor C is select ROWID from PSP_EFFORT_REPORT_DETAILS

15: X_AWARD_ID in NUMBER,
16: X_TOTAL_AMOUNT in NUMBER,
17: X_MODE in VARCHAR2 default 'R'
18: ) is
19: cursor C is select ROWID from PSP_EFFORT_REPORT_DETAILS
20: where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
21: and VERSION_NUM = X_VERSION_NUM
22: and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM;
23: X_LAST_UPDATE_DATE DATE;

Line 44: insert into PSP_EFFORT_REPORT_DETAILS (

40: else
41: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
42: app_exception.raise_exception;
43: end if;
44: insert into PSP_EFFORT_REPORT_DETAILS (
45: EFFORT_REPORT_ID,
46: VERSION_NUM,
47: EFFORT_REPORT_LINE_NUM,
48: ASSIGNMENT_ID,

Line 116: from PSP_EFFORT_REPORT_DETAILS

112: EXPENDITURE_TYPE,
113: TASK_ID,
114: AWARD_ID,
115: TOTAL_AMOUNT
116: from PSP_EFFORT_REPORT_DETAILS
117: where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
118: and VERSION_NUM = X_VERSION_NUM
119: and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM
120: for update of EFFORT_REPORT_ID nowait;

Line 200: update PSP_EFFORT_REPORT_DETAILS set

196: else
197: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
198: app_exception.raise_exception;
199: end if;
200: update PSP_EFFORT_REPORT_DETAILS set
201: ASSIGNMENT_ID = X_ASSIGNMENT_ID,
202: ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,
203: GL_CODE_COMBINATION_ID = X_GL_CODE_COMBINATION_ID,
204: PROJECT_ID = X_PROJECT_ID,

Line 238: cursor c1 is select rowid from PSP_EFFORT_REPORT_DETAILS

234: X_AWARD_ID in NUMBER,
235: X_TOTAL_AMOUNT in NUMBER,
236: X_MODE in VARCHAR2 default 'R'
237: ) is
238: cursor c1 is select rowid from PSP_EFFORT_REPORT_DETAILS
239: where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
240: and VERSION_NUM = X_VERSION_NUM
241: and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM
242: ;

Line 289: delete from PSP_EFFORT_REPORT_DETAILS

285: X_VERSION_NUM in NUMBER,
286: X_EFFORT_REPORT_LINE_NUM in NUMBER
287: ) is
288: begin
289: delete from PSP_EFFORT_REPORT_DETAILS
290: where EFFORT_REPORT_ID = X_EFFORT_REPORT_ID
291: and VERSION_NUM = X_VERSION_NUM
292: and EFFORT_REPORT_LINE_NUM = X_EFFORT_REPORT_LINE_NUM;
293: ---if (sql%notfound) then

Line 298: end PSP_EFFORT_REPORT_DETAILS_PKG;

294: ---raise no_data_found;
295: ---end if;
296: end DELETE_ROW;
297:
298: end PSP_EFFORT_REPORT_DETAILS_PKG;