APPS.PO_MASS_UPDATE_REQ_PVT dependencies on PO_REQUISITION_HEADERS

Line 322: l_req_num po_requisition_headers.segment1%TYPE;

318: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Preparer';
319:
320: -- Cursor Output Variables.
321: l_req_rowid ROWID;
322: l_req_num po_requisition_headers.segment1%TYPE;
323: l_doc_type po_document_types_all.type_name%TYPE;
324: l_auth_status po_headers.authorization_status%TYPE;
325: l_itemtype wf_items.item_type%TYPE;
326: l_itemkey wf_items.item_key%TYPE;

Line 456: FROM po_requisition_headers por,

452: pdt.type_name,
453: por.authorization_status,
454: por.wf_item_type,
455: por.wf_item_key
456: FROM po_requisition_headers por,
457: po_document_types_vl pdt
458: WHERE por.preparer_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
459: AND pdt.document_type_code IN (''REQUISITION'')
460: AND pdt.document_subtype = por.type_lookup_code

Line 568: UPDATE po_requisition_headers_all

564: PO_DEBUG.debug_var(l_log_head,l_progress,'l_itemkey',l_itemkey );
565:
566: END IF;
567:
568: UPDATE po_requisition_headers_all
569: SET preparer_id = p_new_personid,
570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id

Line 748: l_req_num po_requisition_headers.segment1%TYPE;

744:
745: c_req_approver g_req_approver;
746: stmt_req VARCHAR2(4000);
747: l_req_rowid ROWID;
748: l_req_num po_requisition_headers.segment1%TYPE;
749: req_num_type VARCHAR2(100);
750: l_commit_count NUMBER := 0;
751: l_progress VARCHAR2(3) := '000';
752: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';

Line 889: po_requisition_headers por,

885: por.segment1,
886: pdt.type_name
887: FROM wf_notifications wfn,
888: wf_item_activity_statuses wfa,
889: po_requisition_headers por,
890: po_document_types_vl pdt
891: WHERE wfn.notification_id = wfa.notification_id
892: AND wfa.item_type = por.wf_item_type
893: AND wfa.item_key = por.wf_item_key

Line 1125: l_req_num po_requisition_headers.segment1%TYPE;

1121: c_req g_req;
1122: stmt_req VARCHAR2(4000);
1123: req_num_type VARCHAR2(100);
1124: l_req_rowid ROWID;
1125: l_req_num po_requisition_headers.segment1%TYPE;
1126: l_commit_count NUMBER := 0;
1127: l_progress VARCHAR2(3) := '000';
1128: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Requestor';
1129: l_doc_type po_document_types_all.type_name%TYPE;

Line 1255: FROM po_requisition_headers por,

1251:
1252: stmt_req := 'SELECT prl.ROWID,
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