APPS.XDPCORE_LINE dependencies on XDP_ORDER_LINE_ITEMS

Line 1263: from XDP_ORDER_LINE_ITEMS

1259: e_AddAttributeException exception;
1260:
1261: cursor c_GetIndLines(OrderID number) is
1262: select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
1263: from XDP_ORDER_LINE_ITEMS
1264: where ORDER_ID = OrderID
1265: and IS_VIRTUAL_LINE_FLAG = 'N'
1266: and STATUS_CODE = 'READY'
1267: and LINE_SEQUENCE = 0;

Line 1271: from XDP_ORDER_LINE_ITEMS

1267: and LINE_SEQUENCE = 0;
1268:
1269: cursor c_GetDepLines(OrderID number) is
1270: select LINE_ITEM_ID
1271: from XDP_ORDER_LINE_ITEMS
1272: where ORDER_ID = OrderID
1273: and IS_VIRTUAL_LINE_FLAG = 'N'
1274: and STATUS_CODE = 'READY'
1275: and LINE_SEQUENCE > 0;

Line 1500: from XDP_ORDER_LINE_ITEMS

1496: e_AddAttributeException exception;
1497:
1498: cursor c_GetIndLines( OrderID number ) is
1499: select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
1500: from XDP_ORDER_LINE_ITEMS
1501: where ORDER_ID = OrderID
1502: and IS_VIRTUAL_LINE_FLAG = 'N'
1503: and STATUS_CODE = 'READY'
1504: and LINE_SEQUENCE = 0;

Line 1624: from XDP_ORDER_LINE_ITEMS

1620: e_AddAttributeException exception;
1621:
1622: cursor c_GetIndLines(OrderID number, BundleID number) is
1623: select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
1624: from XDP_ORDER_LINE_ITEMS
1625: where ORDER_ID = OrderID
1626: and IS_VIRTUAL_LINE_FLAG = 'N'
1627: and STATUS_CODE = 'READY'
1628: and LINE_SEQUENCE = 0

Line 1633: from XDP_ORDER_LINE_ITEMS

1629: and BUNDLE_ID = BundleID;
1630:
1631: cursor c_GetIndLinesNullBundle(OrderID number) is
1632: select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
1633: from XDP_ORDER_LINE_ITEMS
1634: where ORDER_ID = OrderID
1635: and IS_VIRTUAL_LINE_FLAG = 'N'
1636: and STATUS_CODE = 'READY'
1637: and LINE_SEQUENCE = 0

Line 1940: UPDATE xdp_order_line_items

1936: x_Progress VARCHAR2(2000);
1937:
1938: BEGIN
1939:
1940: UPDATE xdp_order_line_items
1941: SET status_code = p_status_code ,
1942: wf_item_type = p_itemtype,
1943: wf_item_key = p_itemkey,
1944: last_update_date = sysdate ,

Line 2142: from XDP_ORDER_LINE_ITEMS

2138: x_Progress VARCHAR2(2000);
2139:
2140: cursor c_GetIndLines(OrderID number) is
2141: select 'Y'
2142: from XDP_ORDER_LINE_ITEMS
2143: where ORDER_ID = OrderID
2144: and IS_VIRTUAL_LINE_FLAG = 'N'
2145: and STATUS_CODE = 'READY'
2146: and LINE_SEQUENCE = 0;

Line 2150: from XDP_ORDER_LINE_ITEMS

2146: and LINE_SEQUENCE = 0;
2147:
2148: cursor c_GetDepLines(OrderID number) is
2149: select 'Y'
2150: from XDP_ORDER_LINE_ITEMS
2151: where ORDER_ID = OrderID
2152: and IS_VIRTUAL_LINE_FLAG = 'N'
2153: and STATUS_CODE = 'READY'
2154: and LINE_SEQUENCE > 0;

Line 2203: FROM xdp_order_line_items

2199: l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => IsSerPartPackage.itemtype,
2200: itemkey => IsSerPartPackage.itemkey,
2201: aname => 'LINE_ITEM_ID');
2202: SELECT is_virtual_line_flag INTO l_flag
2203: FROM xdp_order_line_items
2204: WHERE line_item_id = l_LineItemID;
2205:
2206: return l_flag;
2207: exception

Line 2246: FROM xdp_order_line_items

2242: aname => 'ORDER_ID' );
2243:
2244: SELECT line_number
2245: INTO l_line_number
2246: FROM xdp_order_line_items
2247: WHERE line_item_id = l_line_item_id ;
2248:
2249:
2250: XNP_XDP_LINE_DONE_U.PUBLISH