APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES

Line 1488: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE

1484: --End of Comments
1485: -------------------------------------------------------------------------------
1486: PROCEDURE get_temp_labor_requester (
1487: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1488: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE
1489: ) IS
1490: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1491: l_progress VARCHAR2(3) := '000';
1492:

Line 1512: po_requisition_lines_all PRL,

1508: FROM po_lines POL,
1509: po_line_locations PLL,
1510: -- For Shared Procurement, the destination OU may be different from
1511: -- the Purchasing OU:
1512: po_requisition_lines_all PRL,
1513: po_headers POH
1514: WHERE POL.po_line_id = p_po_line_id
1515: AND POL.po_line_id = PLL.po_line_id -- JOIN
1516: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN

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

1539: AND POD.deliver_to_person_id IS NOT NULL
1540: AND PLL.shipment_type <> 'PREPAYMENT'
1541: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1542:
1543: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1544: l_agent_id PO_HEADERS.agent_id%TYPE;
1545: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1546: BEGIN
1547: -- Determine the recipient of this notification using the 3 rules below:

Line 1695: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

1691: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1692: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1693: l_is_new_document VARCHAR2(1);
1694: l_contractor_or_job VARCHAR2(500);
1695: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
1696: l_approver_user_name WF_USERS.name%TYPE;
1697: l_item_key WF_ITEMS.item_key%TYPE;
1698: l_item_key_seq NUMBER;
1699: -- bug 12773562 : declaring local variable.

Line 1929: po_requisition_lines_all PRL

1925: l_req_header_id
1926: FROM po_lines POL,
1927: po_headers POH,
1928: po_line_locations PLL,
1929: po_requisition_lines_all PRL
1930: WHERE POL.po_line_id = p_po_line_id
1931: AND POL.po_header_id = POH.po_header_id -- JOIN
1932: AND POL.po_line_id = PLL.po_line_id -- JOIN
1933: AND PLL.line_location_id = PRL.line_location_id (+); -- JOIN