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 752: l_req_num po_requisition_headers.segment1%TYPE;

748: stmt_req1 VARCHAR2(4000);
749: stmt_req2 VARCHAR2(4000);
750: --Bug 14393408 End
751: l_req_rowid ROWID;
752: l_req_num po_requisition_headers.segment1%TYPE;
753: req_num_type VARCHAR2(100);
754: l_commit_count NUMBER := 0;
755: l_progress VARCHAR2(3) := '000';
756: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';

Line 895: po_requisition_headers por,

891: por.segment1,
892: pdt.type_name
893: FROM wf_notifications wfn,
894: wf_item_activity_statuses wfa,
895: po_requisition_headers por,
896: po_document_types_vl pdt,
897: wf_items wfi
898: WHERE wfn.notification_id = wfa.notification_id
899: AND wfi.item_key = wfa.item_key

Line 915: po_requisition_headers por,

911: por.segment1,
912: pdt.type_name
913: FROM wf_notifications wfn,
914: wf_item_activity_statuses wfa,
915: po_requisition_headers por,
916: po_document_types_vl pdt
917: WHERE wfn.notification_id = wfa.notification_id
918: AND wfa.item_type = por.wf_item_type
919: AND wfa.item_key = por.wf_item_key

Line 1170: l_req_num po_requisition_headers.segment1%TYPE;

1166: c_req g_req;
1167: stmt_req VARCHAR2(4000);
1168: req_num_type VARCHAR2(100);
1169: l_req_rowid ROWID;
1170: l_req_num po_requisition_headers.segment1%TYPE;
1171: l_commit_count NUMBER := 0;
1172: l_progress VARCHAR2(3) := '000';
1173: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Requestor';
1174: l_doc_type po_document_types_all.type_name%TYPE;

Line 1304: FROM po_requisition_headers por,

1300:
1301: stmt_req := 'SELECT prl.ROWID,
1302: por.segment1,
1303: pdt.type_name
1304: FROM po_requisition_headers por,
1305: po_document_types_vl pdt,
1306: po_requisition_lines_all prl
1307: WHERE prl.to_person_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
1308: AND por.requisition_header_id = prl.requisition_header_id