APPS.WIP_WS_EXCEPTIONS dependencies on WIP_EXCEPTIONS

Line 20: WIP_EXCEPTIONS

16:
17: SAVEPOINT WIPVEXC;
18:
19: UPDATE
20: WIP_EXCEPTIONS
21: SET
22: STATUS_TYPE = 2,
23: LAST_UPDATE_DATE = SYSDATE,
24: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 58: WIP_EXCEPTIONS

54:
55: SAVEPOINT WIPVEXC;
56:
57: UPDATE
58: WIP_EXCEPTIONS
59: SET
60: STATUS_TYPE = 2,
61: LAST_UPDATE_DATE = SYSDATE,
62: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 110: WIP_EXCEPTIONS

106:
107: /* CLOSE EXCEPTION ONLY IF DEPTT ID CHANGED */
108: IF (L_ROW_COUNT > 0) THEN
109: UPDATE
110: WIP_EXCEPTIONS
111: SET
112: STATUS_TYPE = 2,
113: LAST_UPDATE_DATE = SYSDATE,
114: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 151: WIP_EXCEPTIONS

147:
148: SAVEPOINT WIPVEXC;
149:
150: UPDATE
151: WIP_EXCEPTIONS
152: SET
153: STATUS_TYPE = 2,
154: LAST_UPDATE_DATE = SYSDATE,
155: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 206: WIP_EXCEPTIONS

202:
203: /* CLOSE EXCEPTION ONLY IF RESOURCE ID CHANGED */
204: IF (L_ROW_COUNT > 0) THEN
205: UPDATE
206: WIP_EXCEPTIONS
207: SET
208: STATUS_TYPE = 2,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 269: WIP_EXCEPTIONS

265:
266: /* CLOSE EXCEPTION ONLY IF RESOURCE ID CHANGED */
267: IF (L_ROW_COUNT > 0) THEN
268: UPDATE
269: WIP_EXCEPTIONS
270: SET
271: STATUS_TYPE = 2,
272: LAST_UPDATE_DATE = SYSDATE,
273: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 313: WIP_EXCEPTIONS

309:
310: SAVEPOINT WIPVEXC;
311:
312: UPDATE
313: WIP_EXCEPTIONS
314: SET
315: STATUS_TYPE = 2,
316: LAST_UPDATE_DATE = SYSDATE,
317: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 389: WIP_EXCEPTIONS

385: /*Remember although, for Equipment type exceptions,
386: * Serial number cannot be null, we still keep a check for it here.
387: */
388: UPDATE
389: WIP_EXCEPTIONS
390: SET
391: STATUS_TYPE = 2,
392: LAST_UPDATE_DATE = SYSDATE,
393: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 452: /* Get inventory_item_id, since we don't have instance_id in wip_exceptions*/

448: * WE CLOSE THE EXCEPTION, OTHERWISE NO ACTION.
449: */
450: IF (L_ROW_COUNT > 0) THEN
451:
452: /* Get inventory_item_id, since we don't have instance_id in wip_exceptions*/
453: SELECT INVENTORY_ITEM_ID
454: INTO L_EQUIP_ITEM_ID
455: FROM BOM_RESOURCE_EQUIPMENTS BRE
456: WHERE INSTANCE_ID = P_INSTANCE_ID;

Line 467: WIP_EXCEPTIONS

463: RESOURCE_SEQ_NUM = P_RESOURCE_SEQ_NUM AND
464: INSTANCE_ID = P_INSTANCE_ID;
465:
466: UPDATE
467: WIP_EXCEPTIONS
468: SET
469: STATUS_TYPE = 2,
470: LAST_UPDATE_DATE = SYSDATE,
471: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 512: WIP_EXCEPTIONS

508:
509: SAVEPOINT WIPVEXC;
510:
511: UPDATE
512: WIP_EXCEPTIONS
513: SET
514: STATUS_TYPE = 2,
515: LAST_UPDATE_DATE = SYSDATE,
516: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 550: WIP_EXCEPTIONS

546:
547: SAVEPOINT WIPVEXC;
548:
549: UPDATE
550: WIP_EXCEPTIONS
551: SET
552: STATUS_TYPE = 2,
553: LAST_UPDATE_DATE = SYSDATE,
554: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 587: WIP_EXCEPTIONS

583:
584: SAVEPOINT WIPVEXC;
585:
586: DELETE FROM
587: WIP_EXCEPTIONS
588: WHERE
589: ORGANIZATION_ID = P_ORGANIZATION_ID AND
590: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
591: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM;

Line 619: WIP_EXCEPTIONS

615:
616: SAVEPOINT WIPVEXC;
617:
618: DELETE FROM
619: WIP_EXCEPTIONS
620: WHERE
621: ORGANIZATION_ID = P_ORGANIZATION_ID AND
622: WIP_ENTITY_ID = P_WIP_ENTITY_ID;
623: