APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_LINES

Line 958: , po_lines_all pol

954:
955: SELECT count(*)
956: INTO l_line_finally_closed
957: FROM po_line_locations_all poll
958: , po_lines_all pol
959: , po_releases_all por
960: , po_line_locations_all ppo_ll
961: WHERE poll.line_location_id = p_shipment_id
962: AND pol.po_line_id = poll.po_line_id

Line 1947: FROM po_lines pol

1943: d_progress := 21;
1944:
1945: SELECT pol.po_line_id
1946: BULK COLLECT INTO l_id_tbl
1947: FROM po_lines pol
1948: WHERE pol.po_line_id = p_line_id;
1949:
1950: ELSE
1951:

Line 1956: FROM po_lines pol

1952: d_progress := 22;
1953:
1954: SELECT pol.po_line_id
1955: BULK COLLECT INTO l_id_tbl
1956: FROM po_lines pol
1957: WHERE pol.po_header_id = p_document_id;
1958:
1959: END IF;
1960:

Line 1964: UPDATE po_lines pol

1960:
1961: d_progress := 25;
1962:
1963: FORALL i IN 1..l_id_tbl.COUNT
1964: UPDATE po_lines pol
1965: SET pol.last_update_date = SYSDATE
1966: , pol.last_updated_by = p_user_id
1967: , pol.last_update_login = p_login_id
1968: , pol.closed_date = DECODE(p_action,

Line 2816: l_rollup_code PO_LINES.closed_code%TYPE;

2812:
2813: l_ret_sts VARCHAR2(1);
2814:
2815: l_rollup_msg VARCHAR2(256);
2816: l_rollup_code PO_LINES.closed_code%TYPE;
2817:
2818: l_lineid_tbl g_tbl_number;
2819:
2820: l_hist_action VARCHAR2(30);

Line 2880: FROM po_lines pol

2876: d_progress := 30;
2877:
2878: SELECT pol.po_line_id
2879: BULK COLLECT INTO l_lineid_tbl
2880: FROM po_lines pol
2881: WHERE pol.po_line_id =
2882: ( SELECT poll.po_line_id
2883: FROM po_line_locations poll
2884: WHERE poll.line_location_id = p_shipment_id)

Line 2895: FROM po_lines pol

2891: d_progress := 40;
2892:
2893: SELECT pol.po_line_id
2894: BULK COLLECT INTO l_lineid_tbl
2895: FROM po_lines pol
2896: WHERE pol.po_line_id = p_line_id;
2897:
2898:
2899: ELSE

Line 2905: FROM po_lines pol

2901: d_progress := 50;
2902:
2903: SELECT pol.po_line_id
2904: BULK COLLECT INTO l_lineid_tbl
2905: FROM po_lines pol
2906: WHERE pol.po_header_id = p_document_id;
2907:
2908: END IF; -- p_shipment_id IS NOT NULL
2909:

Line 2974: UPDATE po_lines pol

2970: END IF;
2971:
2972: d_progress := 80;
2973:
2974: UPDATE po_lines pol
2975: SET pol.closed_code = l_rollup_code
2976: , pol.last_update_date = SYSDATE
2977: , pol.last_updated_by = p_user_id
2978: , pol.last_update_login = p_login_id

Line 3056: FROM po_lines pol

3052: 3, 'OPEN',
3053: 2, l_none_open_one_closed,
3054: 1, l_all_finally_closed)
3055: INTO l_rollup_code
3056: FROM po_lines pol
3057: WHERE pol.po_header_id = p_document_id;
3058:
3059: d_progress := 220;
3060: IF (PO_LOG.d_stmt) THEN