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_FA dependencies on FND_GLOBAL

Line 232: FND_GLOBAL.USER_ID,

228: EnqueueFPQueue.itemtype,
229: l_ChannelUsageCode,
230: EnqueueFPQueue.itemkey,
231: p_system_hold,
232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.USER_ID,
235: sysdate,
236: FND_GLOBAL.LOGIN_ID);

Line 234: FND_GLOBAL.USER_ID,

230: EnqueueFPQueue.itemkey,
231: p_system_hold,
232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.USER_ID,
235: sysdate,
236: FND_GLOBAL.LOGIN_ID);
237:
238:

Line 236: FND_GLOBAL.LOGIN_ID);

232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.USER_ID,
235: sysdate,
236: FND_GLOBAL.LOGIN_ID);
237:
238:
239:
240: IF p_system_hold = 'Y' THEN

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

1575:
1576: update XDP_FA_RUNTIME_LIST
1577: set WF_ITEM_TYPE = l_FAItemType,
1578: WF_ITEM_KEY = l_FAItemKey,
1579: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1580: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1581: where FA_INSTANCE_ID = l_FAInstanceID;
1582:
1583: /* Enqueue the FA into the FA Queue */

Line 1580: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1576: update XDP_FA_RUNTIME_LIST
1577: set WF_ITEM_TYPE = l_FAItemType,
1578: WF_ITEM_KEY = l_FAItemKey,
1579: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1580: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1581: where FA_INSTANCE_ID = l_FAInstanceID;
1582:
1583: /* Enqueue the FA into the FA Queue */
1584:

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

1842: end;
1843:
1844: FOR v_UpdateFEID in c_UpdateFEID(l_FAInstanceID) LOOP
1845: update XDP_FA_RUNTIME_LIST set FE_ID = l_FeID,
1846: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1847: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1848: where current of c_UpdateFEID;
1849: END LOOP;
1850:

Line 1847: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1843:
1844: FOR v_UpdateFEID in c_UpdateFEID(l_FAInstanceID) LOOP
1845: update XDP_FA_RUNTIME_LIST set FE_ID = l_FeID,
1846: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1847: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1848: where current of c_UpdateFEID;
1849: END LOOP;
1850:
1851: end if;

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

1894:
1895: -- skilaru 04/05/02
1896: -- fa runtime list with the FP name ( fix for the bug # 1945013 )
1897: update XDP_FA_RUNTIME_LIST set PROC_NAME = l_FaProvProc,
1898: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1899: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1900: where fa_instance_id = l_FAInstanceID;
1901:
1902: XDPCORE.CheckNAddItemAttrText (itemtype => GetFE.itemtype,

Line 1899: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1895: -- skilaru 04/05/02
1896: -- fa runtime list with the FP name ( fix for the bug # 1945013 )
1897: update XDP_FA_RUNTIME_LIST set PROC_NAME = l_FaProvProc,
1898: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1899: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1900: where fa_instance_id = l_FAInstanceID;
1901:
1902: XDPCORE.CheckNAddItemAttrText (itemtype => GetFE.itemtype,
1903: itemkey => GetFE.itemkey,

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

2660:
2661: /* Set the status of Execution */
2662: FOR v_UpdateFAStatus in c_UpdateFAStatus(l_FAInstanceID) LOOP
2663: update XDP_FA_RUNTIME_LIST set STATUS_CODE = l_Result,
2664: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2665: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2666: where current of c_UpdateFAStatus;
2667: END LOOP;
2668:

Line 2665: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2661: /* Set the status of Execution */
2662: FOR v_UpdateFAStatus in c_UpdateFAStatus(l_FAInstanceID) LOOP
2663: update XDP_FA_RUNTIME_LIST set STATUS_CODE = l_Result,
2664: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2665: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2666: where current of c_UpdateFAStatus;
2667: END LOOP;
2668:
2669:

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

3573:
3574: update XDP_FA_RUNTIME_LIST
3575: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
3576: WF_ITEM_KEY = t_childKeys(l_Counter),
3577: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3578: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3579: where FA_INSTANCE_ID = l_FAInstanceID;
3580:
3581: FOR i in 1..l_Counter LOOP

Line 3578: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3574: update XDP_FA_RUNTIME_LIST
3575: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
3576: WF_ITEM_KEY = t_childKeys(l_Counter),
3577: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3578: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3579: where FA_INSTANCE_ID = l_FAInstanceID;
3580:
3581: FOR i in 1..l_Counter LOOP
3582: /* Enqueue all the FA's into the FA Queue */

Line 5084: last_updated_by = fnd_global.user_id ,

5080: SET status_code = p_status_code ,
5081: wf_item_type = p_itemtype ,
5082: wf_item_key = p_itemkey ,
5083: last_update_date = sysdate ,
5084: last_updated_by = fnd_global.user_id ,
5085: last_update_login = fnd_global.login_id
5086: WHERE fa_instance_id = p_fa_instance_id ;
5087:
5088: COMMIT;

Line 5085: last_update_login = fnd_global.login_id

5081: wf_item_type = p_itemtype ,
5082: wf_item_key = p_itemkey ,
5083: last_update_date = sysdate ,
5084: last_updated_by = fnd_global.user_id ,
5085: last_update_login = fnd_global.login_id
5086: WHERE fa_instance_id = p_fa_instance_id ;
5087:
5088: COMMIT;
5089:

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

5230:
5231: update XDP_FA_RUNTIME_LIST
5232: set WF_ITEM_TYPE = l_FAItemType,
5233: WF_ITEM_KEY = l_FAItemKey,
5234: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5235: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
5236: where FA_INSTANCE_ID = l_FAInstanceID;
5237:
5238: /* Enqueue the FA into the FA Queue */

Line 5235: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

5231: update XDP_FA_RUNTIME_LIST
5232: set WF_ITEM_TYPE = l_FAItemType,
5233: WF_ITEM_KEY = l_FAItemKey,
5234: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5235: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
5236: where FA_INSTANCE_ID = l_FAInstanceID;
5237:
5238: /* Enqueue the FA into the FA Queue */
5239:

Line 5470: last_updated_by = FND_GLOBAL.USER_ID,

5466: lv_error_count := lv_error_count + 1;
5467:
5468: UPDATE xdp_error_count
5469: SET error_count = lv_error_count,
5470: last_updated_by = FND_GLOBAL.USER_ID,
5471: last_update_date = sysdate,
5472: last_update_login = FND_GLOBAL.USER_ID
5473: WHERE CURRENT OF cur_error_count;
5474: -- for code readability sake.. we should always have only one record

Line 5472: last_update_login = FND_GLOBAL.USER_ID

5468: UPDATE xdp_error_count
5469: SET error_count = lv_error_count,
5470: last_updated_by = FND_GLOBAL.USER_ID,
5471: last_update_date = sysdate,
5472: last_update_login = FND_GLOBAL.USER_ID
5473: WHERE CURRENT OF cur_error_count;
5474: -- for code readability sake.. we should always have only one record
5475: EXIT;
5476: END LOOP;

Line 5496: FND_GLOBAL.USER_ID,

5492: VALUES (
5493: XDP_UTILITIES.g_fp_object_type,
5494: p_fp_name,
5495: 1,
5496: FND_GLOBAL.USER_ID,
5497: sysdate,
5498: FND_GLOBAL.USER_ID,
5499: sysdate,
5500: FND_GLOBAL.LOGIN_ID);

Line 5498: FND_GLOBAL.USER_ID,

5494: p_fp_name,
5495: 1,
5496: FND_GLOBAL.USER_ID,
5497: sysdate,
5498: FND_GLOBAL.USER_ID,
5499: sysdate,
5500: FND_GLOBAL.LOGIN_ID);
5501: --This is the first error while executing the FP..
5502: lv_result := 'THRESHOLD_NOT_REACHED';

Line 5500: FND_GLOBAL.LOGIN_ID);

5496: FND_GLOBAL.USER_ID,
5497: sysdate,
5498: FND_GLOBAL.USER_ID,
5499: sysdate,
5500: FND_GLOBAL.LOGIN_ID);
5501: --This is the first error while executing the FP..
5502: lv_result := 'THRESHOLD_NOT_REACHED';
5503:
5504: END IF;

Line 5548: last_updated_by = FND_GLOBAL.USER_ID,

5544: IF (lv_error_count > lv_error_threshold) THEN
5545: -- reset System Hold to 'N' so that adapter will pick it up..
5546: UPDATE xdp_adapter_job_queue
5547: SET system_hold = 'N',
5548: last_updated_by = FND_GLOBAL.USER_ID,
5549: last_update_date = sysdate,
5550: last_update_login = FND_GLOBAL.USER_ID
5551: WHERE fa_instance_id in ( SELECT fa_instance_id
5552: FROM xdp_fa_runtime_list

Line 5550: last_update_login = FND_GLOBAL.USER_ID

5546: UPDATE xdp_adapter_job_queue
5547: SET system_hold = 'N',
5548: last_updated_by = FND_GLOBAL.USER_ID,
5549: last_update_date = sysdate,
5550: last_update_login = FND_GLOBAL.USER_ID
5551: WHERE fa_instance_id in ( SELECT fa_instance_id
5552: FROM xdp_fa_runtime_list
5553: WHERE proc_name = p_fp_name
5554: AND status_code = XDP_UTILITIES.g_system_hold );

Line 5557: last_updated_by = FND_GLOBAL.USER_ID,

5553: WHERE proc_name = p_fp_name
5554: AND status_code = XDP_UTILITIES.g_system_hold );
5555: UPDATE xdp_fa_runtime_list
5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,
5557: last_updated_by = FND_GLOBAL.USER_ID,
5558: last_update_date = sysdate,
5559: last_update_login = FND_GLOBAL.USER_ID
5560: WHERE proc_name = p_fp_name
5561: AND status_code = XDP_UTILITIES.g_system_hold;

Line 5559: last_update_login = FND_GLOBAL.USER_ID

5555: UPDATE xdp_fa_runtime_list
5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,
5557: last_updated_by = FND_GLOBAL.USER_ID,
5558: last_update_date = sysdate,
5559: last_update_login = FND_GLOBAL.USER_ID
5560: WHERE proc_name = p_fp_name
5561: AND status_code = XDP_UTILITIES.g_system_hold;
5562: END IF;
5563:

Line 5567: last_updated_by = FND_GLOBAL.USER_ID,

5563:
5564: -- finally set the error count to Zero..
5565: UPDATE xdp_error_count
5566: SET error_count = 0,
5567: last_updated_by = FND_GLOBAL.USER_ID,
5568: last_update_date = sysdate,
5569: last_update_login = FND_GLOBAL.USER_ID
5570: WHERE CURRENT OF cur_error_count;
5571: -- for code readability sake.. we should always have only one record

Line 5569: last_update_login = FND_GLOBAL.USER_ID

5565: UPDATE xdp_error_count
5566: SET error_count = 0,
5567: last_updated_by = FND_GLOBAL.USER_ID,
5568: last_update_date = sysdate,
5569: last_update_login = FND_GLOBAL.USER_ID
5570: WHERE CURRENT OF cur_error_count;
5571: -- for code readability sake.. we should always have only one record
5572: EXIT;
5573: END LOOP;