APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES

Line 1256: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE

1252: --End of Comments
1253: -------------------------------------------------------------------------------
1254: PROCEDURE get_temp_labor_requester (
1255: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1256: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE
1257: ) IS
1258: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1259: l_progress VARCHAR2(3) := '000';
1260:

Line 1280: po_requisition_lines_all PRL,

1276: FROM po_lines POL,
1277: po_line_locations PLL,
1278: -- For Shared Procurement, the destination OU may be different from
1279: -- the Purchasing OU:
1280: po_requisition_lines_all PRL,
1281: po_headers POH
1282: WHERE POL.po_line_id = p_po_line_id
1283: AND POL.po_line_id = PLL.po_line_id -- JOIN
1284: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN

Line 1311: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;

1307: AND POD.deliver_to_person_id IS NOT NULL
1308: AND PLL.shipment_type <> 'PREPAYMENT'
1309: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1310:
1311: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1312: l_agent_id PO_HEADERS.agent_id%TYPE;
1313: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1314: BEGIN
1315: -- Determine the recipient of this notification using the 3 rules below:

Line 1463: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

1459: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1461: l_is_new_document VARCHAR2(1);
1462: l_contractor_or_job VARCHAR2(500);
1463: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
1464: l_approver_user_name WF_USERS.name%TYPE;
1465: l_item_key WF_ITEMS.item_key%TYPE;
1466: l_item_key_seq NUMBER;
1467: BEGIN

Line 1678: po_requisition_lines_all PRL

1674: l_req_header_id
1675: FROM po_lines POL,
1676: po_headers POH,
1677: po_line_locations PLL,
1678: po_requisition_lines_all PRL
1679: WHERE POL.po_line_id = p_po_line_id
1680: AND POL.po_header_id = POH.po_header_id -- JOIN
1681: AND POL.po_line_id = PLL.po_line_id -- JOIN
1682: AND PLL.line_location_id = PRL.line_location_id (+); -- JOIN