DBA Data[Home] [Help]

APPS.WIP_UNRELEASE dependencies on WIP_CONSTANTS

Line 251: WHEN wip_constants.records_locked THEN

247: close c_lock;-- for bug fix 8977276 (FP 8946106)
248:
249: -- for bug fix 8977276 (FP 8946106)
250: EXCEPTION
251: WHEN wip_constants.records_locked THEN
252: if(c_lock%ISOPEN) then
253: close c_lock;
254: end if;
255: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');

Line 288: x_ent_type =>WIP_CONSTANTS.DISCRETE);

284: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
285: BEGIN
286: UNRELEASE(x_org_id =>P_organization_id,
287: x_wip_id =>P_wip_entity_id,
288: x_ent_type =>WIP_CONSTANTS.DISCRETE);
289:
290:
291: UPDATE WIP_DISCRETE_JOBS
292: SET STATUS_TYPE = WIP_CONSTANTS.UNRELEASED,

Line 292: SET STATUS_TYPE = WIP_CONSTANTS.UNRELEASED,

288: x_ent_type =>WIP_CONSTANTS.DISCRETE);
289:
290:
291: UPDATE WIP_DISCRETE_JOBS
292: SET STATUS_TYPE = WIP_CONSTANTS.UNRELEASED,
293: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
294: LAST_UPDATE_DATE = SYSDATE,
295: LAST_UPDATED_BY = X_user_id,
296: LAST_UPDATE_LOGIN = X_login_id