APPS.CTO_CHANGE_ORDER_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 2744: From po_requisitions_interface_all

2740:
2741: x_return_status := FND_API.G_RET_STS_SUCCESS;
2742:
2743: Select 'Y' into l_req_exists
2744: From po_requisitions_interface_all
2745: Where interface_source_line_id = p_line_id
2746: and item_id = p_item_id
2747: and process_flag is null;
2748:

Line 2797: Delete from po_requisitions_interface_all

2793: Begin
2794:
2795: x_return_status := FND_API.G_RET_STS_SUCCESS;
2796:
2797: Delete from po_requisitions_interface_all
2798: Where interface_source_line_id = p_line_id
2799: and item_id = p_item_id;
2800:
2801: IF PG_DEBUG <> 0 THEN

Line 2860: Update po_requisitions_interface_all

2856: end if;
2857: return;
2858: end if;
2859:
2860: Update po_requisitions_interface_all
2861: Set quantity = nvl(p_qty, quantity),
2862: secondary_quantity = nvl(p_qty2, secondary_quantity), --OPM
2863: need_by_date = nvl(p_need_by_date, need_by_date)
2864: Where interface_source_line_id = p_line_id