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.XDPCORE_WI dependencies on FND_GLOBAL

Line 968: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

964: /*
965: update XDP_FULFILL_WORKLIST
966: set WF_ITEM_TYPE = l_WFItemType,
967: WF_ITEM_KEY = l_WFItemKey,
968: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
969: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
970: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
971: */
972: elsif l_wiwf = 'WORKFLOW' then

Line 969: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

965: update XDP_FULFILL_WORKLIST
966: set WF_ITEM_TYPE = l_WFItemType,
967: WF_ITEM_KEY = l_WFItemKey,
968: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
969: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
970: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
971: */
972: elsif l_wiwf = 'WORKFLOW' then
973: if (l_UserItemKeyPrefix is null) OR (l_UserItemType is null) OR

Line 1003: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

999: /*
1000: update XDP_FULFILL_WORKLIST
1001: set WF_ITEM_TYPE = l_WFItemType,
1002: WF_ITEM_KEY = l_WFItemKey,
1003: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1004: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1005: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
1006: */
1007:

Line 1004: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1000: update XDP_FULFILL_WORKLIST
1001: set WF_ITEM_TYPE = l_WFItemType,
1002: WF_ITEM_KEY = l_WFItemKey,
1003: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1004: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1005: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
1006: */
1007:
1008: elsif l_wiwf = 'DYNAMIC' then

Line 1055: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1051:
1052: update XDP_FULFILL_WORKLIST
1053: set WF_ITEM_TYPE = l_WFItemType,
1054: WF_ITEM_KEY = l_WFItemKey,
1055: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1056: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1057: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
1058:
1059:

Line 1056: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1052: update XDP_FULFILL_WORKLIST
1053: set WF_ITEM_TYPE = l_WFItemType,
1054: WF_ITEM_KEY = l_WFItemKey,
1055: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1056: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1057: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
1058:
1059:
1060: /* Enqueue all the Wormitems in the Workitem Queue */

Line 1314: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1310: /*
1311: update XDP_FULFILL_WORKLIST
1312: set WF_ITEM_TYPE = l_WFItemType,
1313: WF_ITEM_KEY = l_WFItemKey,
1314: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1316: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1317: */
1318: elsif l_wiwf = 'WORKFLOW' then

Line 1315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1311: update XDP_FULFILL_WORKLIST
1312: set WF_ITEM_TYPE = l_WFItemType,
1313: WF_ITEM_KEY = l_WFItemKey,
1314: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1316: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1317: */
1318: elsif l_wiwf = 'WORKFLOW' then
1319: if (l_UserItemKeyPrefix is null) OR (l_UserItemType is null) OR

Line 1351: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1347: /*
1348: update XDP_FULFILL_WORKLIST
1349: set WF_ITEM_TYPE = l_WFItemType,
1350: WF_ITEM_KEY = l_WFItemKey,
1351: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1352: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1353: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1354: */
1355:

Line 1352: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1348: update XDP_FULFILL_WORKLIST
1349: set WF_ITEM_TYPE = l_WFItemType,
1350: WF_ITEM_KEY = l_WFItemKey,
1351: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1352: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1353: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1354: */
1355:
1356: elsif l_wiwf = 'DYNAMIC' then

Line 1403: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1399:
1400: update XDP_FULFILL_WORKLIST
1401: set WF_ITEM_TYPE = l_WFItemType,
1402: WF_ITEM_KEY = l_WFItemKey,
1403: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1404: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1405: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1406:
1407: /* Enqueue all the Wormitems in the Workitem Queue */

Line 1404: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1400: update XDP_FULFILL_WORKLIST
1401: set WF_ITEM_TYPE = l_WFItemType,
1402: WF_ITEM_KEY = l_WFItemKey,
1403: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1404: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1405: where WORKITEM_INSTANCE_ID = p_WIInstanceID;
1406:
1407: /* Enqueue all the Wormitems in the Workitem Queue */
1408:

Line 2073: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2069: /*
2070: update XDP_FULFILL_WORKLIST
2071: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2072: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2073: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2074: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2075: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2076: */
2077: elsif l_wiwf = 'WORKFLOW' then

Line 2074: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2070: update XDP_FULFILL_WORKLIST
2071: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2072: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2073: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2074: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2075: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2076: */
2077: elsif l_wiwf = 'WORKFLOW' then
2078:

Line 2118: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2114: /*
2115: update XDP_FULFILL_WORKLIST
2116: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2117: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2118: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2119: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2120: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2121: */
2122: elsif l_wiwf = 'DYNAMIC' then

Line 2119: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2115: update XDP_FULFILL_WORKLIST
2116: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2117: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2118: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2119: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2120: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2121: */
2122: elsif l_wiwf = 'DYNAMIC' then
2123: /* The Workitem List is dynamic */

Line 2196: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2192:
2193: update XDP_FULFILL_WORKLIST
2194: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2195: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2196: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2197: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2198: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2199:
2200: /* Enqueue all the Wormitems in the Workitem Queue */

Line 2197: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2193: update XDP_FULFILL_WORKLIST
2194: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
2195: WF_ITEM_KEY = t_ChildKeys(l_Counter),
2196: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2197: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2198: where WORKITEM_INSTANCE_ID = l_WIInstanceID;
2199:
2200: /* Enqueue all the Wormitems in the Workitem Queue */
2201: FOR i in 1..l_Counter LOOP

Line 2444: last_updated_by = fnd_global.user_id,

2440: SET status_code = p_status_code ,
2441: wf_item_type = p_itemtype ,
2442: wf_item_key = p_itemkey ,
2443: last_update_date = sysdate,
2444: last_updated_by = fnd_global.user_id,
2445: last_update_login = fnd_global.login_id
2446: WHERE workitem_instance_id = p_workitem_instance_id;
2447:
2448: COMMIT;

Line 2445: last_update_login = fnd_global.login_id

2441: wf_item_type = p_itemtype ,
2442: wf_item_key = p_itemkey ,
2443: last_update_date = sysdate,
2444: last_updated_by = fnd_global.user_id,
2445: last_update_login = fnd_global.login_id
2446: WHERE workitem_instance_id = p_workitem_instance_id;
2447:
2448: COMMIT;
2449:

Line 2617: last_updated_by = FND_GLOBAL.USER_ID,

2613: UPDATE xdp_worklist_details
2614: SET parameter_value = p_newParamValue,
2615: is_value_evaluated = 'Y',
2616: modified_flag = 'Y',
2617: last_updated_by = FND_GLOBAL.USER_ID,
2618: last_update_date = sysdate,
2619: last_update_login = FND_GLOBAL.LOGIN_ID
2620: WHERE workitem_instance_id = p_WIInstanceID
2621: AND parameter_name = p_parameterName;

Line 2619: last_update_login = FND_GLOBAL.LOGIN_ID

2615: is_value_evaluated = 'Y',
2616: modified_flag = 'Y',
2617: last_updated_by = FND_GLOBAL.USER_ID,
2618: last_update_date = sysdate,
2619: last_update_login = FND_GLOBAL.LOGIN_ID
2620: WHERE workitem_instance_id = p_WIInstanceID
2621: AND parameter_name = p_parameterName;
2622: ELSE
2623: UPDATE xdp_worklist_details

Line 2626: last_updated_by = FND_GLOBAL.USER_ID,

2622: ELSE
2623: UPDATE xdp_worklist_details
2624: SET parameter_value = p_newParamValue,
2625: modified_flag = 'Y',
2626: last_updated_by = FND_GLOBAL.USER_ID,
2627: last_update_date = sysdate,
2628: last_update_login = FND_GLOBAL.LOGIN_ID
2629: WHERE workitem_instance_id = p_WIInstanceID
2630: AND parameter_name = p_parameterName;

Line 2628: last_update_login = FND_GLOBAL.LOGIN_ID

2624: SET parameter_value = p_newParamValue,
2625: modified_flag = 'Y',
2626: last_updated_by = FND_GLOBAL.USER_ID,
2627: last_update_date = sysdate,
2628: last_update_login = FND_GLOBAL.LOGIN_ID
2629: WHERE workitem_instance_id = p_WIInstanceID
2630: AND parameter_name = p_parameterName;
2631: END IF;
2632: