APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_REQUISITION_HEADERS

Line 84: - Open cursor PO_REQUISITION_HEADERS table to select

80: PROCEDURE NAME: Process_unapprove_reqs
81:
82: DESCRIPTION:
83: This procedure does the following:
84: - Open cursor PO_REQUISITION_HEADERS table to select
85: Incomplete or Requires_reapproval documents.
86:
87: - For each unapprove document, initiate the
88: PO Approval Reminder workflow notification.

Line 102: FROM PO_REQUISITION_HEADERS

98: --
99:
100: CURSOR unapprove_req IS
101: SELECT Requisition_Header_ID, Segment1, Type_Lookup_Code, Preparer_ID
102: FROM PO_REQUISITION_HEADERS
103: WHERE NVL(authorization_status,'INCOMPLETE') IN
104: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL', 'RETURNED')
105: AND NVL(cancel_flag,'N') = 'N'
106: AND NVL(closed_code,'OPEN') <> 'FINALLY CLOSED';

Line 1893: from po_requisition_headers

1889:
1890: If l_doc_type = 'REQUISITION' then
1891:
1892: select authorization_status into l_req_status
1893: from po_requisition_headers
1894: where requisition_header_id = l_doc_header_id;
1895:
1896: if NVL(l_req_status, 'INCOMPLETE') = 'RETURNED' then
1897:

Line 2894: from po_requisition_headers

2890: l_doc_type := 'REQUISITION';
2891:
2892: select preparer_id
2893: into l_agent_id
2894: from po_requisition_headers
2895: where requisition_header_id = p_DocumentID;
2896: --bug#3709971 modified the structure of item key from
2897: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2898: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 3416: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;

3412: l_item_end_date DATE;
3413: l_requester_user_name WF_USERS.name%TYPE;
3414: l_requester_disp_name WF_USERS.display_name%TYPE;
3415: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3416: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3417: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3418: BEGIN
3419: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'
3420: || p_po_line_id;