20: WIP_EXCEPTIONS
21: SET
22: STATUS_TYPE = 2,
23: LAST_UPDATE_DATE = SYSDATE,
24: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
25: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
26: WHERE
27: ORGANIZATION_ID = P_ORGANIZATION_ID AND
28: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
21: SET
22: STATUS_TYPE = 2,
23: LAST_UPDATE_DATE = SYSDATE,
24: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
25: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
26: WHERE
27: ORGANIZATION_ID = P_ORGANIZATION_ID AND
28: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
29: STATUS_TYPE = 1;
58: WIP_EXCEPTIONS
59: SET
60: STATUS_TYPE = 2,
61: LAST_UPDATE_DATE = SYSDATE,
62: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
63: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
64: WHERE
65: ORGANIZATION_ID = P_ORGANIZATION_ID AND
66: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
59: SET
60: STATUS_TYPE = 2,
61: LAST_UPDATE_DATE = SYSDATE,
62: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
63: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
64: WHERE
65: ORGANIZATION_ID = P_ORGANIZATION_ID AND
66: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
67: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
110: WIP_EXCEPTIONS
111: SET
112: STATUS_TYPE = 2,
113: LAST_UPDATE_DATE = SYSDATE,
114: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
115: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
116: WHERE
117: ORGANIZATION_ID = P_ORGANIZATION_ID AND
118: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
111: SET
112: STATUS_TYPE = 2,
113: LAST_UPDATE_DATE = SYSDATE,
114: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
115: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
116: WHERE
117: ORGANIZATION_ID = P_ORGANIZATION_ID AND
118: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
119: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
151: WIP_EXCEPTIONS
152: SET
153: STATUS_TYPE = 2,
154: LAST_UPDATE_DATE = SYSDATE,
155: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
156: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
157: WHERE
158: ORGANIZATION_ID = P_ORGANIZATION_ID AND
159: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
152: SET
153: STATUS_TYPE = 2,
154: LAST_UPDATE_DATE = SYSDATE,
155: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
156: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
157: WHERE
158: ORGANIZATION_ID = P_ORGANIZATION_ID AND
159: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
160: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
206: WIP_EXCEPTIONS
207: SET
208: STATUS_TYPE = 2,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
211: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
212: WHERE
213: ORGANIZATION_ID = P_ORGANIZATION_ID AND
214: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
207: SET
208: STATUS_TYPE = 2,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
211: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
212: WHERE
213: ORGANIZATION_ID = P_ORGANIZATION_ID AND
214: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
215: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
269: WIP_EXCEPTIONS
270: SET
271: STATUS_TYPE = 2,
272: LAST_UPDATE_DATE = SYSDATE,
273: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
274: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
275: WHERE
276: ORGANIZATION_ID = P_ORGANIZATION_ID AND
277: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
270: SET
271: STATUS_TYPE = 2,
272: LAST_UPDATE_DATE = SYSDATE,
273: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
274: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
275: WHERE
276: ORGANIZATION_ID = P_ORGANIZATION_ID AND
277: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
278: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
313: WIP_EXCEPTIONS
314: SET
315: STATUS_TYPE = 2,
316: LAST_UPDATE_DATE = SYSDATE,
317: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
318: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
319: WHERE
320: ORGANIZATION_ID = P_ORGANIZATION_ID AND
321: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
314: SET
315: STATUS_TYPE = 2,
316: LAST_UPDATE_DATE = SYSDATE,
317: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
318: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
319: WHERE
320: ORGANIZATION_ID = P_ORGANIZATION_ID AND
321: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
322: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
389: WIP_EXCEPTIONS
390: SET
391: STATUS_TYPE = 2,
392: LAST_UPDATE_DATE = SYSDATE,
393: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
394: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
395: WHERE
396: ORGANIZATION_ID = P_ORGANIZATION_ID AND
397: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
390: SET
391: STATUS_TYPE = 2,
392: LAST_UPDATE_DATE = SYSDATE,
393: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
394: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
395: WHERE
396: ORGANIZATION_ID = P_ORGANIZATION_ID AND
397: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
398: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
467: WIP_EXCEPTIONS
468: SET
469: STATUS_TYPE = 2,
470: LAST_UPDATE_DATE = SYSDATE,
471: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
472: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
473: WHERE
474: ORGANIZATION_ID = P_ORGANIZATION_ID AND
475: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
468: SET
469: STATUS_TYPE = 2,
470: LAST_UPDATE_DATE = SYSDATE,
471: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
472: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
473: WHERE
474: ORGANIZATION_ID = P_ORGANIZATION_ID AND
475: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
476: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
512: WIP_EXCEPTIONS
513: SET
514: STATUS_TYPE = 2,
515: LAST_UPDATE_DATE = SYSDATE,
516: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
517: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
518: WHERE
519: ORGANIZATION_ID = P_ORGANIZATION_ID AND
520: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
513: SET
514: STATUS_TYPE = 2,
515: LAST_UPDATE_DATE = SYSDATE,
516: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
517: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
518: WHERE
519: ORGANIZATION_ID = P_ORGANIZATION_ID AND
520: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
521: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
550: WIP_EXCEPTIONS
551: SET
552: STATUS_TYPE = 2,
553: LAST_UPDATE_DATE = SYSDATE,
554: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
555: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
556: WHERE
557: EXCEPTION_ID = P_EXCEPTION_ID AND
558: STATUS_TYPE = 1;
551: SET
552: STATUS_TYPE = 2,
553: LAST_UPDATE_DATE = SYSDATE,
554: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
555: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
556: WHERE
557: EXCEPTION_ID = P_EXCEPTION_ID AND
558: STATUS_TYPE = 1;
559: