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 XDP_FA_RUNTIME_LIST

Line 247: UPDATE xdp_fa_runtime_list

243: lv_fa_status := XDP_UTILITIES.g_wait_for_resource;
244: END IF;
245: -- Change FA Instance status...
246:
247: UPDATE xdp_fa_runtime_list
248: SET status_code = lv_fa_status
249: WHERE fa_instance_id = l_fainstanceid ;
250:
251: /* Check if the FA is aborted. If so abort the process immediately */

Line 1455: from XDP_FA_RUNTIME_LIST

1451:
1452: is
1453: cursor c_FaList (wi_id number, prov_seq number) is
1454: select FA_INSTANCE_ID, PROVISIONING_SEQUENCE
1455: from XDP_FA_RUNTIME_LIST
1456: where WORKITEM_INSTANCE_ID = wi_id
1457: and STATUS_CODE = 'STANDBY'
1458: and PROVISIONING_SEQUENCE = (
1459: select MIN(PROVISIONING_SEQUENCE)

Line 1460: from XDP_FA_RUNTIME_LIST

1456: where WORKITEM_INSTANCE_ID = wi_id
1457: and STATUS_CODE = 'STANDBY'
1458: and PROVISIONING_SEQUENCE = (
1459: select MIN(PROVISIONING_SEQUENCE)
1460: from XDP_FA_RUNTIME_LIST
1461: where WORKITEM_INSTANCE_ID = wi_id
1462: and STATUS_CODE = 'STANDBY'
1463: and PROVISIONING_SEQUENCE > prov_seq);
1464:

Line 1574: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */

1570: RAISE e_CreatFAWFException;
1571: end if;
1572:
1573:
1574: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
1575:
1576: update XDP_FA_RUNTIME_LIST
1577: set WF_ITEM_TYPE = l_FAItemType,
1578: WF_ITEM_KEY = l_FAItemKey,

Line 1576: update XDP_FA_RUNTIME_LIST

1572:
1573:
1574: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
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

Line 1719: from XDP_FA_RUNTIME_LIST

1715: x_Progress VARCHAR2(2000);
1716:
1717: cursor c_UpdateFEID (p_FAInstanceID number) is
1718: select 'Update FE ID'
1719: from XDP_FA_RUNTIME_LIST
1720: where FA_INSTANCE_ID = p_FAInstanceID
1721: for update of FE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN;
1722:
1723: begin

Line 1845: update XDP_FA_RUNTIME_LIST set FE_ID = l_FeID,

1841: return 'FAILURE';
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;

Line 1897: update XDP_FA_RUNTIME_LIST set PROC_NAME = l_FaProvProc,

1893: end if;
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:

Line 2305: from XDP_FA_RUNTIME_LIST

2301: x_parameters VARCHAR2(4000);
2302:
2303: cursor c_UpdateFAStatus(FAInstanceID number)is
2304: select 'Update FA Status'
2305: from XDP_FA_RUNTIME_LIST
2306: where FA_INSTANCE_ID = FAInstanceID
2307: for update of STATUS_CODE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN;
2308:
2309: l_Status varchar2(1);

Line 2663: update XDP_FA_RUNTIME_LIST set STATUS_CODE = l_Result,

2659: end if;
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;

Line 2878: update XDP_FA_RUNTIME_LIST

2874:
2875: /* DO I ABORT the Processing ??
2876: */
2877: /* Stop the FA Processing.. Hence mark the status of the FA to be ABORTED
2878: update XDP_FA_RUNTIME_LIST
2879: set STATUS_CODE = 'ABORTED'
2880: where FA_INSTANCE_ID = l_FAInstanceID;
2881: */
2882:

Line 3243: from XDP_FA_RUNTIME_LIST

3239: l_tempKey varchar2(240);
3240:
3241: cursor c_GetIndFA (WIInstanceID number) is
3242: select FA_INSTANCE_ID, FULFILLMENT_ACTION_ID, PRIORITY
3243: from XDP_FA_RUNTIME_LIST
3244: where WORKITEM_INSTANCE_ID = WIInstanceID
3245: and STATUS_CODE = 'STANDBY'
3246: and (PROVISIONING_SEQUENCE IS NULL or PROVISIONING_SEQUENCE = 0) ;
3247:

Line 3250: from XDP_FA_RUNTIME_LIST

3246: and (PROVISIONING_SEQUENCE IS NULL or PROVISIONING_SEQUENCE = 0) ;
3247:
3248: cursor c_GetDepFA (WIInstanceID number) is
3249: select FA_INSTANCE_ID, FULFILLMENT_ACTION_ID, PRIORITY
3250: from XDP_FA_RUNTIME_LIST
3251: where WORKITEM_INSTANCE_ID = WIInstanceID
3252: and STATUS_CODE = 'STANDBY'
3253: and PROVISIONING_SEQUENCE > 0;
3254:

Line 3478: from XDP_FA_RUNTIME_LIST

3474: l_ErrDescription varchar2(1996);
3475:
3476: cursor c_FAList (wi_id number, prov_seq number) is
3477: select FULFILLMENT_ACTION_ID, FA_INSTANCE_ID, PROVISIONING_SEQUENCE, PRIORITY
3478: from XDP_FA_RUNTIME_LIST
3479: where WORKITEM_INSTANCE_ID = wi_id
3480: and PROVISIONING_SEQUENCE = (
3481: select MIN(PROVISIONING_SEQUENCE)
3482: from XDP_FA_RUNTIME_LIST

Line 3482: from XDP_FA_RUNTIME_LIST

3478: from XDP_FA_RUNTIME_LIST
3479: where WORKITEM_INSTANCE_ID = wi_id
3480: and PROVISIONING_SEQUENCE = (
3481: select MIN(PROVISIONING_SEQUENCE)
3482: from XDP_FA_RUNTIME_LIST
3483: where WORKITEM_INSTANCE_ID = wi_id
3484: and PROVISIONING_SEQUENCE > prov_seq);
3485:
3486: TYPE t_ChildKeyTable is table of varchar2(240) INDEX BY BINARY_INTEGER;

Line 3572: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */

3568: x_progress := 'XDPCORE_FA.LaunchFAProcessSeq. Error when adding item attribute CURRENT_FA_SEQUENCE.';
3569: raise e_AddAttributeException;
3570: end if;
3571:
3572: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
3573:
3574: update XDP_FA_RUNTIME_LIST
3575: set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
3576: WF_ITEM_KEY = t_childKeys(l_Counter),

Line 3574: update XDP_FA_RUNTIME_LIST

3570: end if;
3571:
3572: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
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

Line 4536: from XDP_FULFILL_ACTIONS XFA, XDP_FA_RUNTIME_LIST XFL

4532: is
4533:
4534: cursor c_GetLocateFEProc(FaID number) is
4535: select XFA.FE_ROUTING_PROC
4536: from XDP_FULFILL_ACTIONS XFA, XDP_FA_RUNTIME_LIST XFL
4537: where XFL.FA_INSTANCE_ID = FaID
4538: and XFA.FULFILLMENT_ACTION_ID = XFL.FULFILLMENT_ACTION_ID;
4539:
4540: l_LocateFEProc varchar2(80);

Line 4571: from XDP_FA_FULFILLMENT_PROC XFP, XDP_FA_RUNTIME_LIST XFL, XDP_FE_SW_GEN_LOOKUP XFS

4567: return varchar2
4568: is
4569: cursor c_GetFP(FaID number, FeTypeID number, FeSWGeneric varchar2, AdapterType varchar2) is
4570: select XFP.FULFILLMENT_PROC
4571: from XDP_FA_FULFILLMENT_PROC XFP, XDP_FA_RUNTIME_LIST XFL, XDP_FE_SW_GEN_LOOKUP XFS
4572: where XFL.FA_INSTANCE_ID = FaID
4573: and XFP.FULFILLMENT_ACTION_ID = XFL.FULFILLMENT_ACTION_ID
4574: and XFP.FE_SW_GEN_LOOKUP_ID = XFS.FE_SW_GEN_LOOKUP_ID
4575: and XFS.FETYPE_ID = FeTypeID

Line 4611: from XDP_FA_RUNTIME_LIST

4607: FEID OUT NOCOPY number)
4608: is
4609: cursor c_CheckFeID (FaID number) is
4610: select NVL(FE_ID, null)
4611: from XDP_FA_RUNTIME_LIST
4612: where FA_INSTANCE_ID = FaID;
4613: begin
4614: ConfigError := 'N';
4615:

Line 4791: xdp_fa_runtime_list

4787:
4788:
4789: cursor c_GetFAState(p_FAInstanceID number) is
4790: select status_code ,workitem_instance_id from
4791: xdp_fa_runtime_list
4792: where fa_instance_id = p_FAInstanceID
4793: for update;
4794:
4795: cursor c_GetWIState(p_WIInstanceID number) is

Line 5079: UPDATE xdp_fa_runtime_list

5075: p_itemkey IN VARCHAR2 ) IS
5076: PRAGMA AUTONOMOUS_TRANSACTION;
5077: x_progress VARCHAR2(2000) ;
5078: BEGIN
5079: UPDATE xdp_fa_runtime_list
5080: SET status_code = p_status_code ,
5081: wf_item_type = p_itemtype ,
5082: wf_item_key = p_itemkey ,
5083: last_update_date = sysdate ,

Line 5109: from XDP_FA_RUNTIME_LIST

5105: l_DepFound number := 0;
5106:
5107: cursor c_GetIndFAs (WIInstanceID number) is
5108: select FA_INSTANCE_ID, FULFILLMENT_ACTION_ID, PRIORITY
5109: from XDP_FA_RUNTIME_LIST
5110: where WORKITEM_INSTANCE_ID = WIInstanceID
5111: and STATUS_CODE = 'STANDBY'
5112: and (PROVISIONING_SEQUENCE IS NULL or PROVISIONING_SEQUENCE = 0) ;
5113:

Line 5116: from XDP_FA_RUNTIME_LIST

5112: and (PROVISIONING_SEQUENCE IS NULL or PROVISIONING_SEQUENCE = 0) ;
5113:
5114: cursor c_GetDepFAs (WIInstanceID number) is
5115: select FA_INSTANCE_ID, FULFILLMENT_ACTION_ID, PRIORITY
5116: from XDP_FA_RUNTIME_LIST
5117: where WORKITEM_INSTANCE_ID = WIInstanceID
5118: and STATUS_CODE = 'STANDBY'
5119: and PROVISIONING_SEQUENCE > 0;
5120:

Line 5178: from XDP_FA_RUNTIME_LIST

5174: l_tempKey varchar2(240);
5175:
5176: cursor c_GetIndFAs (WIInstanceID number) is
5177: select FA_INSTANCE_ID, FULFILLMENT_ACTION_ID, PRIORITY
5178: from XDP_FA_RUNTIME_LIST
5179: where WORKITEM_INSTANCE_ID = WIInstanceID
5180: and STATUS_CODE = 'STANDBY'
5181: and (PROVISIONING_SEQUENCE IS null or PROVISIONING_SEQUENCE = 0) ;
5182:

Line 5229: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */

5225: || ' Error: ' || SUBSTR(l_ErrStr, 1, 1500);
5226: RAISE e_CreatFAWFException;
5227: end if;
5228:
5229: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
5230:
5231: update XDP_FA_RUNTIME_LIST
5232: set WF_ITEM_TYPE = l_FAItemType,
5233: WF_ITEM_KEY = l_FAItemKey,

Line 5231: update XDP_FA_RUNTIME_LIST

5227: end if;
5228:
5229: /* Update the XDP_FA_RUNTIME_LIST table with the User defined Workitem Item Type and Item Key */
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

Line 5326: FROM xdp_fa_runtime_list lst

5322: BEGIN
5323: SELECT display_name into l_display_name
5324: FROM xdp_fulfill_actions_vl fas
5325: WHERE fas.fulfillment_action_id IN ( SELECT lst.fulfillment_action_id
5326: FROM xdp_fa_runtime_list lst
5327: WHERE fa_instance_id = p_FAInstanceID );
5328: return l_display_name;
5329:
5330: EXCEPTION

Line 5552: FROM xdp_fa_runtime_list

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 );
5555: UPDATE xdp_fa_runtime_list
5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,

Line 5555: UPDATE xdp_fa_runtime_list

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 );
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

Line 5609: UPDATE xdp_fa_runtime_list

5605: BEGIN
5606:
5607: FOR lv_rec IN c_getFEID LOOP
5608: l_feFound := TRUE;
5609: UPDATE xdp_fa_runtime_list
5610: SET fe_id = lv_rec.fe_id
5611: WHERE fa_instance_id = p_faInstanceID;
5612: -- commit autonomous transaction..
5613: COMMIT;