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 prh

98: --
99:
100: CURSOR unapprove_req IS
101: SELECT Requisition_Header_ID, Segment1, Type_Lookup_Code, Preparer_ID
102: FROM PO_REQUISITION_HEADERS prh
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 1923: from po_requisition_headers

1919:
1920: If l_doc_type = 'REQUISITION' then
1921:
1922: select authorization_status into l_req_status
1923: from po_requisition_headers
1924: where requisition_header_id = l_doc_header_id;
1925:
1926: if NVL(l_req_status, 'INCOMPLETE') = 'RETURNED' then
1927:

Line 2928: from po_requisition_headers

2924: l_doc_type := 'REQUISITION';
2925:
2926: select preparer_id
2927: into l_agent_id
2928: from po_requisition_headers
2929: where requisition_header_id = p_DocumentID;
2930: --bug#3709971 modified the structure of item key from
2931: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2932: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 3450: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;

3446: l_item_end_date DATE;
3447: l_requester_user_name WF_USERS.name%TYPE;
3448: l_requester_disp_name WF_USERS.display_name%TYPE;
3449: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3450: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3451: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3452: BEGIN
3453: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'
3454: || p_po_line_id;