APPS.CTO_CHANGE_ORDER_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 2504: From po_requisitions_interface_all

2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: Select 'Y' into l_req_exists
2504: From po_requisitions_interface_all
2505: Where interface_source_line_id = p_line_id
2506: and item_id = p_item_id
2507: and process_flag is null;
2508:

Line 2557: Delete from po_requisitions_interface_all

2553: Begin
2554:
2555: x_return_status := FND_API.G_RET_STS_SUCCESS;
2556:
2557: Delete from po_requisitions_interface_all
2558: Where interface_source_line_id = p_line_id
2559: and item_id = p_item_id;
2560:
2561: IF PG_DEBUG <> 0 THEN

Line 2620: Update po_requisitions_interface_all

2616: end if;
2617: return;
2618: end if;
2619:
2620: Update po_requisitions_interface_all
2621: Set quantity = nvl(p_qty, quantity),
2622: secondary_quantity = nvl(p_qty2, secondary_quantity), --OPM
2623: need_by_date = nvl(p_need_by_date, need_by_date)
2624: Where interface_source_line_id = p_line_id