APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_LINES_DRAFT_ALL

Line 1823: FROM po_lines_interface PLI,po_lines_draft_all pla

1819:
1820: CURSOR cur_target_lines(p_intf_line_id NUMBER)
1821: IS
1822: SELECT pla.po_line_id
1823: FROM po_lines_interface PLI,po_lines_draft_all pla
1824: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
1825: AND PLI.interface_line_id = p_intf_line_id
1826: AND PLI.line_num = pla.line_num
1827: AND pla.draft_id = po_autocreate_params.g_draft_id;

Line 2016: UPDATE po_lines_draft_all

2012: END IF;
2013:
2014: -- CLM UCA Project: Update clm_uda_pricing_total with the CP Total
2015: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2016: UPDATE po_lines_draft_all
2017: SET clm_uda_pricing_total = Decode(matching_basis, 'QUANTITY', quantity, amount)
2018: WHERE po_line_id = l_to_pk1_value
2019: AND draft_id = po_autocreate_params.g_draft_id
2020: AND order_type_lookup_code IN ('AMOUNT','FIXED PRICE');

Line 2613: FROM po_lines_draft_all

2609: AND ea.classification_code = To_Char(pudat.template_id )
2610: AND ead.EXECUTION_METHOD = 'XPD'
2611: AND poh.po_header_id = po_autocreate_params.g_po_header_id
2612: AND pudat.template_id = (SELECT uda_template_id
2613: FROM po_lines_draft_all
2614: WHERE po_header_id = poh.po_header_id
2615: AND ROWNUM < 2) ;
2616:
2617:

Line 2726: FROM po_lines_draft_all pld, po_lines_interface PLI

2722:
2723: CURSOR c_lines
2724: IS
2725: SELECT pld.po_line_id
2726: FROM po_lines_draft_all pld, po_lines_interface PLI
2727: WHERE
2728: --bug 13640946 commenting out the condition as template_id has been stamped in the drafts table before making thisa uda call.
2729: --pld.uda_template_id IS NULL AND
2730: PLI.interface_header_id = po_autocreate_params.g_interface_header_id

Line 2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll

2735:
2736: CURSOR c_shipments
2737: IS
2738: SELECT pll.line_location_id
2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2740: WHERE
2741: --bug 13640946 commenting out the condition as template_id has been stamped in the drafts table before making thisa uda call.
2742: --pll.uda_template_id IS NULL AND
2743: PLI.interface_header_id = po_autocreate_params.g_interface_header_id