30: X_LAST_UPDATE_LOGIN := -1;
31: end if;
32: else
33: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
34: app_exception.raise_exception;
35: end if;
36: insert into PSP_ER_APPROVALS (
37: EFFORT_REPORT_ID,
38: VERSION_NUM,
85: open c1;
86: fetch c1 into tlinfo;
87: if (c1%notfound) then
88: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
89: app_exception.raise_exception;
90: close c1;
91: return;
92: end if;
93: close c1;
96: ) then
97: null;
98: else
99: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
100: app_exception.raise_exception;
101: end if;
102: return;
103: end LOCK_ROW;
104:
127: X_LAST_UPDATE_LOGIN := -1;
128: end if;
129: else
130: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
131: app_exception.raise_exception;
132: end if;
133: update PSP_ER_APPROVALS set
134: APPROVED_DATE = X_APPROVED_DATE,
135: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,