APPS.XDP_INTERFACES dependencies on XDP_FULFILL_WORKLIST

Line 167: -- Private API which will update xdp_fulfill_worklist status_code

163: return_code OUT NOCOPY NUMBER,
164: error_description OUT NOCOPY VARCHAR2) ;
165:
166: --
167: -- Private API which will update xdp_fulfill_worklist status_code
168: --
169: --
170:
171: PROCEDURE UPDATE_XDP_WI_INSTANCE_STATUS

Line 346: FROM xdp_fulfill_worklist fw,

342: l_return BOOLEAN := TRUE ;
343:
344: CURSOR c_fa IS
345: SELECT 'Y'
346: FROM xdp_fulfill_worklist fw,
347: xdp_fa_runtime_list fr
348: WHERE fw.order_id = p_order_id
349: AND fw.workitem_instance_id = fr.workitem_instance_id
350: AND fr.status_code IN ('IN PROGRESS');

Line 997: -- update status_code of the XDP_FULFILL_WORKLIST

993: END IF;
994: END IF;
995: END IF;
996:
997: -- update status_code of the XDP_FULFILL_WORKLIST
998:
999: UPDATE_XDP_WI_INSTANCE_STATUS
1000: (
1001: p_order_id => p_order_id ,

Line 1269: xdp_fulfill_worklist fwt

1265: frt.status_code ,
1266: frt.wf_item_type,
1267: frt.wf_item_key
1268: FROM xdp_fa_runtime_list frt,
1269: xdp_fulfill_worklist fwt
1270: WHERE fwt.order_id = l_order_id and
1271: fwt.workitem_instance_id = frt.workitem_instance_id;
1272:
1273: CURSOR c_wi(l_order_id number) IS

Line 1279: FROM xdp_fulfill_worklist

1275: wf_item_type,
1276: wf_item_key,
1277: status_code,
1278: msgid
1279: FROM xdp_fulfill_worklist
1280: WHERE order_id = l_order_id;
1281:
1282: CURSOR c_line(l_order_id number) IS
1283: SELECT line_item_id,

Line 1458: FROM xdp_fulfill_worklist fw

1454: FOR c_wi_rec in c_wi(p_sdp_order_id)
1455: LOOP
1456: SELECT fw.status_code
1457: INTO lv_state
1458: FROM xdp_fulfill_worklist fw
1459: WHERE workitem_instance_id = c_wi_rec.workitem_instance_id
1460: FOR UPDATE OF fw.status_code NOWAIT;
1461:
1462: IF lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') THEN

Line 1661: xdp_fulfill_worklist fwt

1657: CURSOR lc_fa(l_order_id NUMBER) IS
1658: SELECT fa_instance_id,
1659: frt.msgid
1660: FROM xdp_fa_runtime_list frt,
1661: xdp_fulfill_worklist fwt
1662: WHERE fwt.order_id = l_order_id and
1663: fwt.workitem_instance_id = frt.workitem_instance_id;
1664:
1665: CURSOR lc_wi(l_order_id number) IS

Line 1668: FROM xdp_fulfill_worklist

1664:
1665: CURSOR lc_wi(l_order_id number) IS
1666: SELECT workitem_instance_id,
1667: msgid
1668: FROM xdp_fulfill_worklist
1669: WHERE order_id = l_order_id;
1670:
1671: CURSOR lc_line(l_order_id number) IS
1672: SELECT line_item_id

Line 1757: update XDP_FULFILL_WORKLIST

1753: canceled_by = p_caller_name,
1754: cancel_provisioning_date = sysdate
1755: where order_id = p_sdp_order_id;
1756:
1757: update XDP_FULFILL_WORKLIST
1758: set last_updated_by = FND_GLOBAL.USER_ID,
1759: last_update_date = sysdate,
1760: last_update_login = FND_GLOBAL.LOGIN_ID,
1761: status_code = 'CANCELED',

Line 1811: from XDP_FULFILL_WORKLIST

1807:
1808: FOR lv_wi_rec in lc_wi(p_sdp_order_id)
1809: loop
1810: select status_code into lv_state
1811: from XDP_FULFILL_WORKLIST
1812: where workitem_instance_id = lv_wi_rec.workitem_instance_id;
1813:
1814: if lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') then
1815: null;

Line 1938: update XDP_FULFILL_WORKLIST

1934: IF lv_lock_status = G_LOCK_MSG_SUCCESS THEN
1935: -- Great, we had lock and remove the WI from queue
1936: lv_lock := 'N';
1937:
1938: update XDP_FULFILL_WORKLIST
1939: set last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_date = sysdate,
1941: last_update_login = FND_GLOBAL.LOGIN_ID,
1942: status_code = 'CANCELED',

Line 1961: FROM xdp_fulfill_worklist

1957: savepoint lv_wi_tag;
1958:
1959: SELECT status_code
1960: INTO lv_state
1961: FROM xdp_fulfill_worklist
1962: WHERE workitem_instance_id = p_wi_instance_id
1963: FOR UPDATE of status_code;
1964:
1965: if lv_state in ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED') THEN

Line 1969: update XDP_FULFILL_WORKLIST

1965: if lv_state in ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED') THEN
1966: rollback to lv_wi_tag;
1967: return;
1968: else
1969: update XDP_FULFILL_WORKLIST
1970: set last_updated_by = FND_GLOBAL.USER_ID,
1971: last_update_date = sysdate,
1972: last_update_login = FND_GLOBAL.LOGIN_ID,
1973: status_code = 'CANCELED',

Line 3908: -- Private API which will update xdp_fulfill_worklist status_code

3904: error_description := FND_MESSAGE.GET;
3905: END UPDATE_XDP_ORDER_LINE_STATUS;
3906:
3907: --
3908: -- Private API which will update xdp_fulfill_worklist status_code
3909: --
3910: --
3911:
3912: PROCEDURE UPDATE_XDP_WI_INSTANCE_STATUS

Line 3930: UPDATE xdp_fulfill_worklist

3926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'xdp.plsql.XDP_INTERFACES.UPDATE_XDP_WI_INSTANCE_STATUS', dbg_msg);
3927: END IF;
3928: END IF;
3929: END IF;
3930: UPDATE xdp_fulfill_worklist
3931: SET last_updated_by = FND_GLOBAL.USER_ID,
3932: last_update_date = sysdate,
3933: last_update_login = FND_GLOBAL.LOGIN_ID,
3934: status_code = p_status,