APPS.XDP_OA_UTIL dependencies on XDP_ORDER_LINE_ITEMS

Line 160: from xdp_order_line_items

156: select order_id,
157: line_number
158: into lv_order_id,
159: lv_line_number
160: from xdp_order_line_items
161: where line_item_id = p_line_item_id;
162:
163: g_order_id:= lv_order_id;
164:

Line 231: from xdp_order_line_items

227: if p_provisioning_date is not null then
228: lv_prov_date := p_provisioning_date;
229: else
230: select provisioning_date into lv_prov_date
231: from xdp_order_line_items
232: where line_item_id = p_line_item_id;
233: end if;
234:
235: insert into XDP_FULFILL_WORKLIST

Line 338: from xdp_order_line_items

334: into lv_instance_id
335: from dual;
336:
337: select order_id,line_number into lv_order_id,lv_line_number
338: from xdp_order_line_items
339: where line_item_id = p_line_item_id;
340:
341: g_order_id:= lv_order_id;
342:

Line 354: from xdp_order_line_items

350: if p_provisioning_date is not null then
351: lv_prov_date := p_provisioning_date;
352: else
353: select provisioning_date into lv_prov_date
354: from xdp_order_line_items
355: where line_item_id = p_line_item_id;
356: end if;
357:
358: insert into XDP_FULFILL_WORKLIST

Line 541: from xdp_order_line_items

537: return_code := 0;
538: SAVEPOINT lv_order_tag2;
539:
540: select status_code into lv_state
541: from xdp_order_line_items
542: where line_item_id = p_line_item_id and
543: order_id = p_sdp_order_id;
544:
545: if lv_state IN ('CANCELED','ABORTED') Then

Line 565: update xdp_order_line_items

561: p_sdp_order_id => p_sdp_order_id,
562: return_code => return_code,
563: error_description => error_description);
564: IF return_code = 0 THEN
565: update xdp_order_line_items
566: set last_updated_by = FND_GLOBAL.USER_ID,
567: last_update_date = sysdate,
568: last_update_login = FND_GLOBAL.LOGIN_ID,
569: status_code = 'CANCELED'

Line 1502: from xdp_order_line_items

1498: IS
1499: lv_line_list XDP_TYPES.ORDER_LINE_LIST;
1500: CURSOR lc_line IS
1501: select *
1502: from xdp_order_line_items
1503: where order_id = p_sdp_order_id and
1504: is_virtual_line_flag = 'N';
1505: lv_count number := 0;
1506: BEGIN

Line 1545: from xdp_order_line_items

1541: IS
1542: lv_line XDP_TYPES.LINE_ITEM;
1543: CURSOR lc_line IS
1544: select *
1545: from xdp_order_line_items
1546: where line_item_id = p_line_item_id;
1547: lv_count number := 0;
1548: BEGIN
1549:

Line 1742: 'XDP_ORDER_HEADERS OHR, XDP_ORDER_LINE_ITEMS OLM '||

1738: END IF;
1739:
1740: IF lv_order_flag = TRUE and lv_line_flag = TRUE THEN
1741: lv_plsql := 'SELECT DISTINCT OHR.ORDER_ID FROM '||
1742: 'XDP_ORDER_HEADERS OHR, XDP_ORDER_LINE_ITEMS OLM '||
1743: ' WHERE OHR.ORDER_ID = OLM.ORDER_ID AND '||
1744: p_where;
1745: ELSIF lv_order_flag = TRUE and lv_line_flag = FALSE THEN
1746: lv_plsql := 'SELECT DISTINCT OHR.ORDER_ID FROM '||

Line 1753: ' XDP_ORDER_LINE_ITEMS OLM '||

1749: p_where;
1750:
1751: ELSIF lv_order_flag = FALSE and lv_line_flag = TRUE THEN
1752: lv_plsql := 'SELECT DISTINCT OLM.ORDER_ID FROM '||
1753: ' XDP_ORDER_LINE_ITEMS OLM '||
1754: ' WHERE '||
1755: p_where;
1756: END IF;
1757:

Line 1874: ' XDP_ORDER_LINE_ITEMS OLM '||

1870: return;
1871: END IF;
1872:
1873: lv_plsql := 'SELECT DISTINCT OLM.LINE_ITEM_ID FROM '||
1874: ' XDP_ORDER_LINE_ITEMS OLM '||
1875: ' WHERE OLM.ORDER_ID = '||
1876: p_sdp_order_id ||
1877: ' AND ' ||
1878: p_where;

Line 2054: xdp_order_line_items

2050: IS
2051: lv_src_found BOOLEAN := FALSE;
2052: CURSOR lc_line IS
2053: select * from
2054: xdp_order_line_items
2055: where line_item_id = p_src_line_item_id;
2056: CURSOR lc_line_param IS
2057: select * from
2058: XDP_ORDER_LINEITEM_DETS