[Home] [Help]
2114: tax_code_id,
2115: tax_name,
2116: qty_rcv_tolerance
2117: )
2118: SELECT po_line_locations_interface_s.nextval,
2119: PLI.interface_header_id,
2120: PLI.interface_line_id,
2121: PLI.processing_id,
2122: PLI.process_code,
2203: WHERE PH.po_header_id = PHI.po_header_id)),1),
2204: -- In 'UPDATE' mode, the style_id corresponding to the base PO
2205: -- needs to be considered.
2206: PLI.interface_line_id,
2207: po_line_locations_interface_s.currval
2208: INTO l_style_id, l_interface_line_id, l_interface_line_location_id
2209: FROM po_headers_interface PHI,
2210: po_lines_interface PLI
2211: WHERE PLI.rowid = l_rowid_tbl(i)
2586: tax_code_id,
2587: tax_name,
2588: qty_rcv_tolerance
2589: )
2590: SELECT po_line_locations_interface_s.nextval,
2591: PLI.interface_header_id,
2592: PLI.interface_line_id,
2593: PLI.processing_id,
2594: PLI.process_code,
2672: WHERE PLI.interface_line_id = p_interface_line_id
2673: AND Nvl(PLI.advance_amount,0) > 0;
2674:
2675: IF (SQL%ROWCOUNT > 0) THEN
2676: SELECT po_line_locations_interface_s.CURRVAL
2677: INTO l_interface_line_location_id
2678: FROM DUAL;
2679:
2680: populate_advance_payitem_dist
2902: tax_code_id,
2903: tax_name,
2904: qty_rcv_tolerance
2905: )
2906: SELECT po_line_locations_interface_s.nextval,
2907: PLI.interface_header_id,
2908: PLI.interface_line_id,
2909: PLI.processing_id,
2910: PLI.process_code,
2985: FROM po_lines_interface PLI
2986: WHERE PLI.interface_line_id = p_interface_line_id;
2987:
2988: IF (SQL%ROWCOUNT > 0) THEN
2989: SELECT po_line_locations_interface_s.CURRVAL
2990: INTO l_interface_line_location_id
2991: FROM DUAL;
2992:
2993: populate_progress_payitem_dist