27: X_LAST_UPDATE_LOGIN := -1;
28: end if;
29: else
30: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
31: app_exception.raise_exception;
32: end if;
33: insert into IGW_PROP_SCIENCE_CODES (
34: PROPOSAL_ID,
35: SCIENCE_CODE,
73: open c1;
74: fetch c1 into tlinfo;
75: if (c1%notfound) then
76: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
77: app_exception.raise_exception;
78: close c1;
79: return;
80: end if;
81: close c1;
86: ) then
87: null;
88: else
89: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
90: app_exception.raise_exception;
91: end if;
92: return;
93: end LOCK_ROW;
94:
116: X_LAST_UPDATE_LOGIN := -1;
117: end if;
118: else
119: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
120: app_exception.raise_exception;
121: end if;
122: update IGW_PROP_SCIENCE_CODES set
123: PROPOSAL_ID = X_PROPOSAL_ID,
124: SCIENCE_CODE = X_SCIENCE_CODE,