DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_APPROVAL_LIST_HEADERS

Line 143: FROM po_approval_list_headers

139: -- delete approval list lines
140: DELETE FROM po_approval_list_lines
141: WHERE approval_list_header_id IN
142: (SELECT approval_list_header_id
143: FROM po_approval_list_headers
144: WHERE document_id = p_header_id
145: AND document_type = 'REQUISITION');
146:
147: l_progress := '100';

Line 150: DELETE FROM po_approval_list_headers

146:
147: l_progress := '100';
148:
149: -- delete approval list header
150: DELETE FROM po_approval_list_headers
151: WHERE document_id = p_header_id
152: AND document_type = 'REQUISITION';
153:
154: l_progress := '110';

Line 1347: UPDATE po_approval_list_headers

1343:
1344: l_progress := '150';
1345:
1346: -- flip the approval list
1347: UPDATE po_approval_list_headers
1348: SET document_id = p_origHeaderId
1349: WHERE document_id = p_tempHeaderId
1350: AND document_type = 'REQUISITION';
1351: