45: X_ATTRIBUTE14 in VARCHAR2,
46: X_ATTRIBUTE15 in VARCHAR2,
47: X_MODE in VARCHAR2 default 'R'
48: ) is
49: cursor C is select ROWID from PSP_EFFORT_REPORT_TEMPLATES
50: where TEMPLATE_ID = X_TEMPLATE_ID;
51: X_LAST_UPDATE_DATE DATE;
52: X_LAST_UPDATED_BY NUMBER;
53: X_LAST_UPDATE_LOGIN NUMBER;
68: else
69: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
70: app_exception.raise_exception;
71: end if;
72: insert into PSP_EFFORT_REPORT_TEMPLATES (
73: TEMPLATE_ID,
74: TEMPLATE_NAME,
75: EFFORT_REPORT_PERIOD_NAME,
76: BEGIN_DATE,
263: ATTRIBUTE12,
264: ATTRIBUTE13,
265: ATTRIBUTE14,
266: ATTRIBUTE15
267: from PSP_EFFORT_REPORT_TEMPLATES
268: where TEMPLATE_ID = X_TEMPLATE_ID
269: for update of TEMPLATE_ID nowait;
270: tlinfo c1%rowtype;
271:
469: else
470: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
471: app_exception.raise_exception;
472: end if;
473: update PSP_EFFORT_REPORT_TEMPLATES set
474: TEMPLATE_NAME = X_TEMPLATE_NAME,
475: EFFORT_REPORT_PERIOD_NAME = X_EFFORT_REPORT_PERIOD_NAME,
476: BEGIN_DATE = X_BEGIN_DATE,
477: END_DATE = X_END_DATE,
568: X_ATTRIBUTE14 in VARCHAR2,
569: X_ATTRIBUTE15 in VARCHAR2,
570: X_MODE in VARCHAR2 default 'R'
571: ) is
572: cursor c1 is select rowid from PSP_EFFORT_REPORT_TEMPLATES
573: where TEMPLATE_ID = X_TEMPLATE_ID
574: ;
575: dummy c1%rowtype;
576: begin
675: procedure DELETE_ROW (
676: X_TEMPLATE_ID in NUMBER
677: ) is
678: begin
679: delete from PSP_EFFORT_REPORT_TEMPLATES
680: where TEMPLATE_ID = X_TEMPLATE_ID;
681: if (sql%notfound) then
682: ---raise no_data_found;
683: null;