APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_LINES

Line 1035: , po_lines_all pol

1031:
1032: SELECT count(*)
1033: INTO l_line_finally_closed
1034: FROM po_line_locations_all poll
1035: , po_lines_all pol
1036: , po_releases_all por
1037: , po_line_locations_all ppo_ll
1038: WHERE poll.line_location_id = p_shipment_id
1039: AND pol.po_line_id = poll.po_line_id

Line 2024: FROM po_lines pol

2020: d_progress := 21;
2021:
2022: SELECT pol.po_line_id
2023: BULK COLLECT INTO l_id_tbl
2024: FROM po_lines pol
2025: WHERE pol.po_line_id = p_line_id;
2026:
2027: ELSE
2028:

Line 2033: FROM po_lines pol

2029: d_progress := 22;
2030:
2031: SELECT pol.po_line_id
2032: BULK COLLECT INTO l_id_tbl
2033: FROM po_lines pol
2034: WHERE pol.po_header_id = p_document_id;
2035:
2036: END IF;
2037:

Line 2041: UPDATE po_lines pol

2037:
2038: d_progress := 25;
2039:
2040: FORALL i IN 1..l_id_tbl.COUNT
2041: UPDATE po_lines pol
2042: SET pol.last_update_date = SYSDATE
2043: , pol.last_updated_by = p_user_id
2044: , pol.last_update_login = p_login_id
2045: , pol.closed_date = DECODE(p_action,

Line 2413: UPDATE po_lines pol

2409: IF(p_line_id IS NOT NULL) THEN
2410:
2411: d_progress := 2;
2412:
2413: UPDATE po_lines pol
2414: SET pol.last_update_date = SYSDATE
2415: , pol.last_updated_by = p_user_id
2416: , pol.last_update_login = p_login_id
2417: , pol.closed_date = SYSDATE

Line 2428: UPDATE po_lines pol

2424:
2425: ELSE
2426: d_progress :=3;
2427:
2428: UPDATE po_lines pol
2429: SET pol.last_update_date = SYSDATE
2430: , pol.last_updated_by = p_user_id
2431: , pol.last_update_login = p_login_id
2432: , pol.closed_date = SYSDATE

Line 3109: l_rollup_code PO_LINES.closed_code%TYPE;

3105:
3106: l_ret_sts VARCHAR2(1);
3107:
3108: l_rollup_msg VARCHAR2(256);
3109: l_rollup_code PO_LINES.closed_code%TYPE;
3110:
3111: l_lineid_tbl g_tbl_number;
3112:
3113: l_hist_action VARCHAR2(30);

Line 3173: FROM po_lines pol

3169: d_progress := 30;
3170:
3171: SELECT pol.po_line_id
3172: BULK COLLECT INTO l_lineid_tbl
3173: FROM po_lines pol
3174: WHERE pol.po_line_id =
3175: ( SELECT poll.po_line_id
3176: FROM po_line_locations poll
3177: WHERE poll.line_location_id = p_shipment_id)

Line 3188: FROM po_lines pol

3184: d_progress := 40;
3185:
3186: SELECT pol.po_line_id
3187: BULK COLLECT INTO l_lineid_tbl
3188: FROM po_lines pol
3189: WHERE pol.po_line_id = p_line_id;
3190:
3191:
3192: ELSE

Line 3198: FROM po_lines pol

3194: d_progress := 50;
3195:
3196: SELECT pol.po_line_id
3197: BULK COLLECT INTO l_lineid_tbl
3198: FROM po_lines pol
3199: WHERE pol.po_header_id = p_document_id;
3200:
3201: END IF; -- p_shipment_id IS NOT NULL
3202:

Line 3267: UPDATE po_lines pol

3263: END IF;
3264:
3265: d_progress := 80;
3266:
3267: UPDATE po_lines pol
3268: SET pol.closed_code = l_rollup_code
3269: , pol.last_update_date = SYSDATE
3270: , pol.last_updated_by = p_user_id
3271: , pol.last_update_login = p_login_id

Line 3349: FROM po_lines pol

3345: 3, 'OPEN',
3346: 2, l_none_open_one_closed,
3347: 1, l_all_finally_closed)
3348: INTO l_rollup_code
3349: FROM po_lines pol
3350: WHERE pol.po_header_id = p_document_id;
3351:
3352: d_progress := 220;
3353: IF (PO_LOG.d_stmt) THEN