DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1257: po_requisition_lines_all prl

1253: por.segment1,
1254: pdt.type_name
1255: FROM po_requisition_headers por,
1256: po_document_types_vl pdt,
1257: po_requisition_lines_all prl
1258: WHERE prl.to_person_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
1259: AND por.requisition_header_id = prl.requisition_header_id
1260: AND pdt.document_type_code IN (''REQUISITION'')
1261: AND pdt.document_subtype = por.type_lookup_code

Line 1362: UPDATE po_requisition_lines_all

1358: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type );
1359:
1360: END IF;
1361:
1362: UPDATE po_requisition_lines_all
1363: SET to_person_id = p_new_personid,
1364: last_update_date = sysdate,
1365: last_updated_by = fnd_global.user_id,
1366: last_update_login = fnd_global.login_id