eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_CHANGE_STATUS dependencies on WIP_CONSTANTS

Line 41: P_routing_exists := WIP_CONSTANTS.NO;

37: AND REPETITIVE_SCHEDULE_ID = P_repetitive_schedule_id
38: AND PREVIOUS_OPERATION_SEQ_NUM IS NULL;
39: END IF;
40: IF SQL%NOTFOUND THEN
41: P_routing_exists := WIP_CONSTANTS.NO;
42: ELSE
43: P_routing_exists := WIP_CONSTANTS.YES;
44: END IF;
45: END LOAD_QUEUE;

Line 43: P_routing_exists := WIP_CONSTANTS.YES;

39: END IF;
40: IF SQL%NOTFOUND THEN
41: P_routing_exists := WIP_CONSTANTS.NO;
42: ELSE
43: P_routing_exists := WIP_CONSTANTS.YES;
44: END IF;
45: END LOAD_QUEUE;
46:
47:

Line 143: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,

139: FROM WIP_REPETITIVE_SCHEDULES
140: WHERE WIP_ENTITY_ID = P_wip_entity_id
141: AND ORGANIZATION_ID = P_organization_id
142: AND LINE_ID = P_line_id
143: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,
144: WIP_CONSTANTS.COMP_CHRG,
145: WIP_CONSTANTS.HOLD));
146: END IF;
147:

Line 144: WIP_CONSTANTS.COMP_CHRG,

140: WHERE WIP_ENTITY_ID = P_wip_entity_id
141: AND ORGANIZATION_ID = P_organization_id
142: AND LINE_ID = P_line_id
143: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,
144: WIP_CONSTANTS.COMP_CHRG,
145: WIP_CONSTANTS.HOLD));
146: END IF;
147:
148: /* It is possible that no records can be inserted in discrete

Line 145: WIP_CONSTANTS.HOLD));

141: AND ORGANIZATION_ID = P_organization_id
142: AND LINE_ID = P_line_id
143: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,
144: WIP_CONSTANTS.COMP_CHRG,
145: WIP_CONSTANTS.HOLD));
146: END IF;
147:
148: /* It is possible that no records can be inserted in discrete
149: even if there is an open accounting period. This can happen when

Line 216: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

212: AND wo2.wip_entity_id = P_wip_entity_id
213: AND wo1.repetitive_schedule_id = P_repetitive_schedule_id
214: AND wrs.repetitive_schedule_id = wo2.repetitive_schedule_id
215: AND wrs.line_id = P_line_id
216: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
217: WIP_CONSTANTS.HOLD)
218: AND wo1.operation_seq_num = wo2.operation_seq_num
219: AND wo1.department_id = wo2.department_id
220: AND wo1.count_point_type = wo2.count_point_type

Line 217: WIP_CONSTANTS.HOLD)

213: AND wo1.repetitive_schedule_id = P_repetitive_schedule_id
214: AND wrs.repetitive_schedule_id = wo2.repetitive_schedule_id
215: AND wrs.line_id = P_line_id
216: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
217: WIP_CONSTANTS.HOLD)
218: AND wo1.operation_seq_num = wo2.operation_seq_num
219: AND wo1.department_id = wo2.department_id
220: AND wo1.count_point_type = wo2.count_point_type
221: AND wo1.backflush_flag = wo2.backflush_flag

Line 231: AND S.status_type in (WIP_CONSTANTS.RELEASED,

227: AND S.organization_id = P_organization_id
228: AND O.wip_entity_id = P_wip_entity_id
229: AND S.wip_entity_id = P_wip_entity_id
230: AND S.line_id = P_line_id
231: AND S.status_type in (WIP_CONSTANTS.RELEASED,
232: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
233: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
234: AND count(*) =
235: (SELECT count(*)

Line 232: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

228: AND O.wip_entity_id = P_wip_entity_id
229: AND S.wip_entity_id = P_wip_entity_id
230: AND S.line_id = P_line_id
231: AND S.status_type in (WIP_CONSTANTS.RELEASED,
232: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
233: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
234: AND count(*) =
235: (SELECT count(*)
236: FROM wip_operations O,

Line 243: AND S.status_type in (WIP_CONSTANTS.RELEASED,

239: AND S.organization_id = P_organization_id
240: AND O.wip_entity_id = P_wip_entity_id
241: AND S.wip_entity_id = P_wip_entity_id
242: AND S.line_id = P_line_id
243: AND S.status_type in (WIP_CONSTANTS.RELEASED,
244: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
245: AND O.repetitive_schedule_id = S.repetitive_schedule_id);
246:
247: BEGIN

Line 244: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

240: AND O.wip_entity_id = P_wip_entity_id
241: AND S.wip_entity_id = P_wip_entity_id
242: AND S.line_id = P_line_id
243: AND S.status_type in (WIP_CONSTANTS.RELEASED,
244: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
245: AND O.repetitive_schedule_id = S.repetitive_schedule_id);
246:
247: BEGIN
248: LOCK TABLE WIP_VALID_INTRAOPERATION_STEPS IN EXCLUSIVE MODE;

Line 274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/

270:
271: X_tot_op_qty number; /* For Bug 5859224 */
272:
273: BEGIN
274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,

Line 275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

271: X_tot_op_qty number; /* For Bug 5859224 */
272:
273: BEGIN
274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,
279: WIP_CONSTANTS.HOLD)) THEN

Line 276: WIP_CONSTANTS.HOLD) AND

272:
273: BEGIN
274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,
279: WIP_CONSTANTS.HOLD)) THEN
280:

Line 277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,

273: BEGIN
274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,
279: WIP_CONSTANTS.HOLD)) THEN
280:
281: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,

Line 278: WIP_CONSTANTS.COMP_CHRG,

274: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,
279: WIP_CONSTANTS.HOLD)) THEN
280:
281: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,
282: P_repetitive_schedule_id, P_line_id,

Line 279: WIP_CONSTANTS.HOLD)) THEN

275: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
276: WIP_CONSTANTS.HOLD) AND
277: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
278: WIP_CONSTANTS.COMP_CHRG,
279: WIP_CONSTANTS.HOLD)) THEN
280:
281: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,
282: P_repetitive_schedule_id, P_line_id,
283: P_class_code, P_Release_Date); /* fix for bug 2424987 */

Line 320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,

316: P_repetitive_schedule_id, P_routing_exists);
317: END IF;
318:
319: IF P_repetitive_schedule_id IS NOT NULL THEN
320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,

Line 321: WIP_CONSTANTS.COMP_CHRG,

317: END IF;
318:
319: IF P_repetitive_schedule_id IS NOT NULL THEN
320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,
325: WIP_CONSTANTS.HOLD)) THEN

Line 322: WIP_CONSTANTS.HOLD) AND

318:
319: IF P_repetitive_schedule_id IS NOT NULL THEN
320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,
325: WIP_CONSTANTS.HOLD)) THEN
326: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,

Line 323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,

319: IF P_repetitive_schedule_id IS NOT NULL THEN
320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,
325: WIP_CONSTANTS.HOLD)) THEN
326: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
327: P_repetitive_schedule_id, P_line_id);

Line 324: WIP_CONSTANTS.COMP_CHRG,

320: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,
325: WIP_CONSTANTS.HOLD)) THEN
326: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
327: P_repetitive_schedule_id, P_line_id);
328: END IF;

Line 325: WIP_CONSTANTS.HOLD)) THEN

321: WIP_CONSTANTS.COMP_CHRG,
322: WIP_CONSTANTS.HOLD) AND
323: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
324: WIP_CONSTANTS.COMP_CHRG,
325: WIP_CONSTANTS.HOLD)) THEN
326: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
327: P_repetitive_schedule_id, P_line_id);
328: END IF;
329: END IF;

Line 344: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

340: CLASS_CODE
341: FROM WIP_DISCRETE_JOBS
342: WHERE WIP_ENTITY_ID = P_wip_entity_id
343: AND ORGANIZATION_ID = P_organization_id
344: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
345: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
346: WIP_CONSTANTS.PEND_SCHED);
347:
348: X_status_type NUMBER;

Line 345: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,

341: FROM WIP_DISCRETE_JOBS
342: WHERE WIP_ENTITY_ID = P_wip_entity_id
343: AND ORGANIZATION_ID = P_organization_id
344: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
345: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
346: WIP_CONSTANTS.PEND_SCHED);
347:
348: X_status_type NUMBER;
349: X_class_code VARCHAR2(10) := '';

Line 346: WIP_CONSTANTS.PEND_SCHED);

342: WHERE WIP_ENTITY_ID = P_wip_entity_id
343: AND ORGANIZATION_ID = P_organization_id
344: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
345: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
346: WIP_CONSTANTS.PEND_SCHED);
347:
348: X_status_type NUMBER;
349: X_class_code VARCHAR2(10) := '';
350: X_valid_job BOOLEAN;

Line 366: X_class_code, X_status_type, WIP_CONSTANTS.HOLD,

362: FND_MESSAGE.SET_NAME('WIP', 'WIP_QA_ACTION_NO_HOLD');
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END IF;
365: RELEASE (P_wip_entity_id, P_organization_id, '', '',
366: X_class_code, X_status_type, WIP_CONSTANTS.HOLD,
367: X_routing_exists, SYSDATE); /* fix for bug 2424987 */
368:
369: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
370:

Line 371: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,

367: X_routing_exists, SYSDATE); /* fix for bug 2424987 */
368:
369: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
370:
371: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
372: WIP_CONSTANTS.COMP_CHRG,
373: WIP_CONSTANTS.HOLD,
374: WIP_CONSTANTS.CANCELLED) THEN
375: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;

Line 372: WIP_CONSTANTS.COMP_CHRG,

368:
369: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
370:
371: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
372: WIP_CONSTANTS.COMP_CHRG,
373: WIP_CONSTANTS.HOLD,
374: WIP_CONSTANTS.CANCELLED) THEN
375: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
376:

Line 373: WIP_CONSTANTS.HOLD,

369: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
370:
371: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
372: WIP_CONSTANTS.COMP_CHRG,
373: WIP_CONSTANTS.HOLD,
374: WIP_CONSTANTS.CANCELLED) THEN
375: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
376:
377: end if ;

Line 374: WIP_CONSTANTS.CANCELLED) THEN

370:
371: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
372: WIP_CONSTANTS.COMP_CHRG,
373: WIP_CONSTANTS.HOLD,
374: WIP_CONSTANTS.CANCELLED) THEN
375: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
376:
377: end if ;
378:

Line 380: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

376:
377: end if ;
378:
379: UPDATE WIP_DISCRETE_JOBS
380: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
381: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
382: LAST_UPDATE_DATE = SYSDATE,
383: LAST_UPDATED_BY = X_user_id,
384: LAST_UPDATE_LOGIN = X_login_id

Line 401: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

397: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
398:
399: BEGIN
400: UPDATE WIP_REPETITIVE_SCHEDULES
401: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
402: LAST_UPDATE_DATE = SYSDATE,
403: LAST_UPDATED_BY = X_user_id,
404: LAST_UPDATE_LOGIN = X_login_id
405: WHERE LINE_ID = P_line_id

Line 408: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

404: LAST_UPDATE_LOGIN = X_login_id
405: WHERE LINE_ID = P_line_id
406: AND WIP_ENTITY_ID = P_wip_entity_id
407: AND ORGANIZATION_ID = P_organization_id
408: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
409: WIP_CONSTANTS.HOLD);
410: END PUT_LINE_ON_HOLD;
411:
412: PROCEDURE RELEASE_MES_WRAPPER

Line 409: WIP_CONSTANTS.HOLD);

405: WHERE LINE_ID = P_line_id
406: AND WIP_ENTITY_ID = P_wip_entity_id
407: AND ORGANIZATION_ID = P_organization_id
408: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
409: WIP_CONSTANTS.HOLD);
410: END PUT_LINE_ON_HOLD;
411:
412: PROCEDURE RELEASE_MES_WRAPPER
413: (P_wip_entity_id NUMBER,

Line 443: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,

439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END IF;
441:
442: RELEASE (P_wip_entity_id, P_organization_id, '', '',
443: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,
444: X_routing_exists, SYSDATE);
445:
446:
447: UPDATE WIP_DISCRETE_JOBS

Line 448: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,

444: X_routing_exists, SYSDATE);
445:
446:
447: UPDATE WIP_DISCRETE_JOBS
448: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,
449: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
450: LAST_UPDATE_DATE = SYSDATE,
451: LAST_UPDATED_BY = X_user_id,
452: LAST_UPDATE_LOGIN = X_login_id