APPS.PSP_EFFORT_REPORT_PERIODS_PKG dependencies on PSP_EFFORT_REPORT_PERIODS

Line 1: package body PSP_EFFORT_REPORT_PERIODS_PKG as

1: package body PSP_EFFORT_REPORT_PERIODS_PKG as
2: /* $Header: PSPERPEB.pls 115.4 2002/11/18 12:39:07 lveerubh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_EFFORT_REPORT_PERIOD_NAME in VARCHAR2,

Line 15: cursor C is select ROWID from PSP_EFFORT_REPORT_PERIODS

11: X_EFFORT_REPORT_PERIOD_YEAR in NUMBER,
12: X_EFFORT_REPORT_PERIOD_NUMBER in NUMBER,
13: X_MODE in VARCHAR2 default 'R'
14: ) is
15: cursor C is select ROWID from PSP_EFFORT_REPORT_PERIODS
16: where EFFORT_REPORT_PERIOD_NAME = X_EFFORT_REPORT_PERIOD_NAME;
17: X_LAST_UPDATE_DATE DATE;
18: X_LAST_UPDATED_BY NUMBER;
19: X_LAST_UPDATE_LOGIN NUMBER;

Line 38: insert into PSP_EFFORT_REPORT_PERIODS (

34: else
35: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
36: app_exception.raise_exception;
37: end if;
38: insert into PSP_EFFORT_REPORT_PERIODS (
39: EFFORT_REPORT_PERIOD_NAME,
40: DESCRIPTION,
41: START_DATE_ACTIVE,
42: END_DATE_ACTIVE,

Line 96: from PSP_EFFORT_REPORT_PERIODS

92: EFFORT_REPORT_PERIOD_PREFIX,
93: EFFORT_REPORT_PERIOD_TYPE,
94: EFFORT_REPORT_PERIOD_YEAR,
95: EFFORT_REPORT_PERIOD_NUMBER
96: from PSP_EFFORT_REPORT_PERIODS
97: where EFFORT_REPORT_PERIOD_NAME = X_EFFORT_REPORT_PERIOD_NAME
98: for update of EFFORT_REPORT_PERIOD_NAME nowait;
99: tlinfo c1%rowtype;
100:

Line 166: update PSP_EFFORT_REPORT_PERIODS set

162: else
163: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
164: app_exception.raise_exception;
165: end if;
166: update PSP_EFFORT_REPORT_PERIODS set
167: DESCRIPTION = X_DESCRIPTION,
168: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
169: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
170: EFFORT_REPORT_PERIOD_PREFIX = X_EFFORT_REPORT_PERIOD_PREFIX,

Line 196: cursor c1 is select rowid from PSP_EFFORT_REPORT_PERIODS

192: X_EFFORT_REPORT_PERIOD_YEAR in NUMBER,
193: X_EFFORT_REPORT_PERIOD_NUMBER in NUMBER,
194: X_MODE in VARCHAR2 default 'R'
195: ) is
196: cursor c1 is select rowid from PSP_EFFORT_REPORT_PERIODS
197: where EFFORT_REPORT_PERIOD_NAME = X_EFFORT_REPORT_PERIOD_NAME
198: ;
199: dummy c1%rowtype;
200: begin

Line 235: delete from PSP_EFFORT_REPORT_PERIODS

231: procedure DELETE_ROW (
232: X_EFFORT_REPORT_PERIOD_NAME in VARCHAR2
233: ) is
234: begin
235: delete from PSP_EFFORT_REPORT_PERIODS
236: where EFFORT_REPORT_PERIOD_NAME = X_EFFORT_REPORT_PERIOD_NAME;
237: ---if (sql%notfound) then
238: ---raise no_data_found;
239: ---end if;

Line 243: end PSP_EFFORT_REPORT_PERIODS_PKG;

239: ---end if;
240: commit;
241: end DELETE_ROW;
242:
243: end PSP_EFFORT_REPORT_PERIODS_PKG;