APPS.XDP_AQ_UTILITIES dependencies on XDP_FA_RUNTIME_LIST

Line 1231: xdp_fa_runtime_list xfr

1227: lv_fa_name varchar2(40);
1228: cursor c_GetFAName is
1229: select xf.fulfillment_action fulfillment_action
1230: from xdp_fulfill_actions xf,
1231: xdp_fa_runtime_list xfr
1232: where xfr.fa_instance_id = p_fa_instance_id
1233: and xfr.fulfillment_action_id = xf.fulfillment_action_id;
1234:
1235: BEGIN

Line 1267: update XDP_FA_RUNTIME_LIST

1263: message_properties => lv_MessageProperties,
1264: payload =>lv_wf_object,
1265: msgid => lv_MsgID);
1266:
1267: update XDP_FA_RUNTIME_LIST
1268: set last_updated_by = FND_GLOBAL.USER_ID,
1269: last_update_date = sysdate,
1270: last_update_login = FND_GLOBAL.LOGIN_ID,
1271: STATUS_CODE = 'READY',

Line 1341: FROM xdp_fa_runtime_list

1337: END;
1338:
1339: SELECT status_code
1340: INTO lv_state
1341: FROM xdp_fa_runtime_list
1342: WHERE fa_instance_id = lv_wf_object.fa_instance_id;
1343:
1344: -- if lv_state = 'SUSPENDED' THEN
1345: -- -- Update the msg delay to new high number

Line 1535: UPDATE xdp_fa_runtime_list

1531: msgid => lv_MsgID);
1532:
1533: -- Change status of the FA Instance to 'READY_FOR_RESOURCE'
1534:
1535: UPDATE xdp_fa_runtime_list
1536: SET status_code = 'READY_FOR_RESOURCE' ,
1537: msgid = lv_MsgID
1538: WHERE fa_instance_id = p_fa_instance_id ;
1539:

Line 1619: FROM xdp_fa_runtime_list frt,

1615: SELECT frt.status_code,
1616: fwt.status_code
1617: INTO lv_fa_state,
1618: lv_wi_state
1619: FROM xdp_fa_runtime_list frt,
1620: xdp_fulfill_worklist fwt
1621: WHERE fa_instance_id = lv_wf_object.fa_instance_id
1622: AND frt.workitem_instance_id = fwt.workitem_instance_id;
1623:

Line 1748: FROM xdp_fa_runtime_list frt

1744: END;
1745:
1746: SELECT frt.status_code
1747: INTO lv_fa_state
1748: FROM xdp_fa_runtime_list frt
1749: WHERE fa_instance_id = lv_wf_object.fa_instance_id;
1750:
1751: IF (lv_fa_state <> 'CANCELED' AND lv_fa_state <> 'ABORTED' AND lv_high_avail <> TRUE) THEN
1752: -- And resume work flow.