31: if X_LAST_UPDATE_LOGIN is NULL then
32: X_LAST_UPDATE_LOGIN := -1;
33: end if;
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,
101: begin
102: open c1;
103: fetch c1 into tlinfo;
104: if (c1%notfound) then
105: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
106: app_exception.raise_exception;
107: close c1;
108: return;
109: end if;
124: AND (tlinfo.EFFORT_REPORT_PERIOD_NUMBER = X_EFFORT_REPORT_PERIOD_NUMBER)
125: ) then
126: null;
127: else
128: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
129: app_exception.raise_exception;
130: end if;
131: return;
132: end LOCK_ROW;
159: if X_LAST_UPDATE_LOGIN is NULL then
160: X_LAST_UPDATE_LOGIN := -1;
161: end if;
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,