APPS.XDP_INTERFACES dependencies on XDP_ORDER_LINE_ITEMS

Line 155: -- Private API which will update xdp_order_line_items status_code

151: return_code OUT NOCOPY NUMBER,
152: error_description OUT NOCOPY VARCHAR2) ;
153:
154: --
155: -- Private API which will update xdp_order_line_items status_code
156: --
157: --
158: PROCEDURE UPDATE_XDP_ORDER_LINE_STATUS
159: (p_order_id IN NUMBER,

Line 504: FROM xdp_order_line_items xoli, xdp_order_headers xoh

500: --Cursor to fetch the item_keys for the SFM-OM Interface flows to be cancelled.
501: */
502: CURSOR lc_intf_flow_keys (p_order_number NUMBER) IS
503: SELECT line_number
504: FROM xdp_order_line_items xoli, xdp_order_headers xoh
505: WHERE xoli.order_id = xoh.order_id
506: AND xoh.order_source = 'OE_ORDER_HEADERS_ALL'
507: AND xoh.order_id = p_order_number;
508:

Line 660: -- SFM-OM Interface flows have item_key = 'XDPOMINT' and item_key = .

656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_ORDER', dbg_msg);
657: END IF;
658: END IF;
659:
660: -- SFM-OM Interface flows have item_key = 'XDPOMINT' and item_key = .
661: -- For each interface workflow process generated for this order
662: FOR l_intf_flow_key IN lc_intf_flow_keys (p_sdp_order_id)
663: LOOP
664: BEGIN --For the exceptions from the WF API call.

Line 972: -- update status_code of the XDP_ORDER_LINE_ITEMS

968: END IF;
969: END IF;
970: END IF;
971:
972: -- update status_code of the XDP_ORDER_LINE_ITEMS
973:
974: UPDATE_XDP_ORDER_LINE_STATUS
975: (p_order_id => p_order_id ,
976: p_lineitem_id => null ,

Line 1287: FROM xdp_order_line_items

1283: SELECT line_item_id,
1284: wf_item_key,
1285: wf_item_type,
1286: status_code
1287: FROM xdp_order_line_items
1288: WHERE order_id = l_order_id
1289: ORDER By is_package_flag;
1290:
1291: BEGIN

Line 1507: FROM xdp_order_line_items

1503: LOOP
1504:
1505: SELECT status_code
1506: INTO lv_state
1507: FROM xdp_order_line_items
1508: WHERE line_item_id = c_line_rec.line_item_id
1509: FOR UPDATE OF STATUS_CODE NOWAIT;
1510:
1511: IF lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') THEN

Line 1673: FROM xdp_order_line_items

1669: WHERE order_id = l_order_id;
1670:
1671: CURSOR lc_line(l_order_id number) IS
1672: SELECT line_item_id
1673: FROM xdp_order_line_items
1674: WHERE order_id = l_order_id
1675: ORDER By is_package_flag;
1676:
1677: BEGIN

Line 1748: update xdp_order_line_items

1744: canceled_by = p_caller_name,
1745: cancel_provisioning_date = sysdate
1746: where order_id = p_sdp_order_id;
1747:
1748: update xdp_order_line_items
1749: set last_updated_by = FND_GLOBAL.USER_ID,
1750: last_update_date = sysdate,
1751: last_update_login = FND_GLOBAL.LOGIN_ID,
1752: status_code = 'CANCELED',

Line 1836: from xdp_order_line_items

1832: savepoint lv_line_tag;
1833:
1834: select status_code
1835: into lv_state
1836: from xdp_order_line_items
1837: where line_item_id = lv_line_rec.line_item_id
1838: for update of status_code;
1839:
1840: if lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') then

Line 1843: update xdp_order_line_items

1839:
1840: if lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') then
1841: rollback to lv_line_tag;
1842: else
1843: update xdp_order_line_items
1844: set
1845: last_updated_by = FND_GLOBAL.USER_ID,
1846: last_update_date = sysdate,
1847: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2391: from XDP_ORDER_LINE_ITEMS

2387: x_status,
2388: x_state ,
2389: x_completion_date,
2390: x_cancellation_date
2391: from XDP_ORDER_LINE_ITEMS
2392: WHERE order_id = p_sdp_order_id and
2393: line_number = p_line_number ;
2394:
2395:

Line 2442: XDP_ORDER_LINE_ITEMS olm,

2438: x_state ,
2439: x_completion_date,
2440: x_cancellation_date
2441: from
2442: XDP_ORDER_LINE_ITEMS olm,
2443: XDP_ORDER_HEADERS ohr
2444: WHERE
2445: olm.order_id = ohr.order_id and
2446: ohr.external_order_number = (p_order_number) and

Line 2491: XDP_ORDER_LINE_ITEMS olm,

2487: olm.status_code,
2488: olm.completion_date,
2489: olm.cancel_provisioning_date
2490: from
2491: XDP_ORDER_LINE_ITEMS olm,
2492: XDP_ORDER_HEADERS ohr
2493: WHERE
2494: olm.order_id = ohr.order_id and
2495: ohr.external_order_number = (p_order_number) and

Line 2692: FROM xdp_order_line_items

2688: BEGIN
2689:
2690: SELECT line_item_id
2691: INTO l_line_item_id
2692: FROM xdp_order_line_items
2693: WHERE order_id = p_order_id
2694: AND NVL(LINE_NUMBER,0) = NVL(p_line_number,0);
2695:
2696: x_parameter_value := XDP_ENGINE.Get_Line_Param_Value(l_line_item_id,p_parameter_name);

Line 3280: xdp_order_line_items

3276: attribute18,
3277: attribute19,
3278: attribute20
3279: FROM
3280: xdp_order_line_items
3281: WHERE
3282: order_id = p_order_id
3283: AND
3284: is_virtual_line_flag = 'N';

Line 3865: -- Private API which will update xdp_order_line_items status_code

3861: error_description := FND_MESSAGE.GET;
3862: END UPDATE_XDP_ORDER_STATUS;
3863:
3864: --
3865: -- Private API which will update xdp_order_line_items status_code
3866: --
3867: --
3868:
3869: PROCEDURE UPDATE_XDP_ORDER_LINE_STATUS

Line 3888: UPDATE xdp_order_line_items

3884: END IF;
3885: END IF;
3886: END IF;
3887:
3888: UPDATE xdp_order_line_items
3889: SET last_updated_by = FND_GLOBAL.USER_ID,
3890: last_update_date = sysdate,
3891: last_update_login = FND_GLOBAL.LOGIN_ID,
3892: status_code = p_status,

Line 4062: FROM xdp_order_line_items xoli

4058: BEGIN
4059: BEGIN
4060: SELECT line_item_id
4061: INTO l_line_item_id
4062: FROM xdp_order_line_items xoli
4063: WHERE xoli.order_id = p_order_id
4064: AND xoli.line_number = p_line_number;
4065: EXCEPTION
4066: WHEN NO_DATA_FOUND THEN

Line 4128: FROM xdp_order_line_items xoli

4124: BEGIN
4125: BEGIN
4126: SELECT line_item_id
4127: INTO l_line_item_id
4128: FROM xdp_order_line_items xoli
4129: WHERE xoli.order_id = p_order_id
4130: AND xoli.line_number = p_line_number;
4131: EXCEPTION
4132: WHEN NO_DATA_FOUND THEN