APPS.WMS_DEPLOY dependencies on PO_HEADERS_ALL

Line 401: l_po_name po_headers_all.segment1%TYPE;

397: END get_item_suffix_for_lov;
398:
399: FUNCTION get_po_client_code(p_po_header_id NUMBER)
400: RETURN VARCHAR2 AS
401: l_po_name po_headers_all.segment1%TYPE;
402: l_client_code mtl_client_parameters.client_code%TYPE := NULL;
403: l_delimiter VARCHAR2(1) := '-' ;
404: l_item_name VARCHAR2(800);
405: BEGIN

Line 409: FROM po_headers_all

405: BEGIN
406: BEGIN
407: SELECT segment1
408: INTO l_po_name
409: FROM po_headers_all
410: WHERE po_header_id = p_po_header_id;
411:
412: EXCEPTION
413: WHEN OTHERS THEN

Line 481: FROM po_headers_all

477: BEGIN
478: BEGIN
479: SELECT segment1
480: INTO l_po_num
481: FROM po_headers_all
482: WHERE po_header_id = p_po_header_id;
483:
484: EXCEPTION
485: WHEN OTHERS THEN

Line 510: FROM po_headers_all

506: IF wms_deployment_mode='L' then
507: x_po_num := get_client_po_num(x_po_header_id);
508: ELSE SELECT segment1
509: INTO x_po_num
510: FROM po_headers_all
511: WHERE po_header_id = x_po_header_id;
512: END IF;
513:
514: EXCEPTION