DBA Data[Home] [Help]

APPS.WIP_WS_EXCEPTIONS dependencies on FND_GLOBAL

Line 24: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 25: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;

Line 62: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 63: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 114: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 115: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 155: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 156: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 210: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 211: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 273: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 274: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 317: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 318: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 393: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 394: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 471: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 472: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 516: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 517: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 554: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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;

Line 555: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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: