APPS.GML_PO_RECV2_PKG dependencies on PO_HEADERS_ALL

Line 89: FROM po_headers_all

85: AND org_id = v_org_id;
86:
87: CURSOR po_cur IS
88: SELECT closed_code
89: FROM po_headers_all
90: WHERE po_header_id = v_po_header_id
91: AND org_id = v_org_id;
92:
93: v_closed_code po_lines_all.closed_code%TYPE;

Line 94: v_new_status po_headers_all.closed_code%TYPE;

90: WHERE po_header_id = v_po_header_id
91: AND org_id = v_org_id;
92:
93: v_closed_code po_lines_all.closed_code%TYPE;
94: v_new_status po_headers_all.closed_code%TYPE;
95: v_old_status po_headers_all.closed_code%TYPE;
96: v_all_lines_closed BOOLEAN :=TRUE;
97:
98: err_num NUMBER;

Line 95: v_old_status po_headers_all.closed_code%TYPE;

91: AND org_id = v_org_id;
92:
93: v_closed_code po_lines_all.closed_code%TYPE;
94: v_new_status po_headers_all.closed_code%TYPE;
95: v_old_status po_headers_all.closed_code%TYPE;
96: v_all_lines_closed BOOLEAN :=TRUE;
97:
98: err_num NUMBER;
99: err_msg VARCHAR2(100);

Line 132: UPDATE po_headers_all

128:
129: IF v_old_status IS NULL OR
130: v_new_status <> v_old_status THEN
131: BEGIN
132: UPDATE po_headers_all
133: SET closed_code = v_new_status,
134: last_update_date= v_last_update_date,
135: last_updated_by = v_last_updated_by
136: WHERE po_header_id = v_po_header_id AND

Line 385: FROM po_headers_all

381: WHERE line_location_id = v_line_location_id;
382:
383: CURSOR po_cur IS
384: SELECT segment1
385: FROM po_headers_all
386: WHERE po_header_id = v_po_header_id;
387:
388: CURSOR line_cur IS
389: SELECT line_num