APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_REQUISITION_HEADERS_ALL

Line 47: FROM po_requisition_headers_all

43: EMERGENCY_PO_NUM,
44: NVL(CONTRACTOR_REQUISITION_FLAG, 'N'),
45: NVL(CONTRACTOR_STATUS, 'NULL'),
46: NOTE_TO_AUTHORIZER
47: FROM po_requisition_headers_all
48: WHERE REQUISITION_HEADER_ID = p_requisition_header_id;
49: /*****************************************************************************
50: * The following are local/Private procedure that support the workflow APIs: *
51: *****************************************************************************/

Line 564: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id

560: -- Indicates the caller of this procedure. If 'CANCEL', then the approval will
561: -- not insert into the action history.
562: --DocumentID
563: -- This value for this parameter depends on the DocumentType:
564: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
565: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
566: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
567: --DocumentNumber
568: -- (Obsolete) This parameter is ignored. This procedure will derive the

Line 577: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code

573: --DocumentType
574: -- 'REQUISITION', 'PO', 'PA', 'RELEASE'
575: --DocumentSubType
576: -- The value for this parameter depends on the DocumentType:
577: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
578: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
579: -- 'RELEASE': PO_RELEASES_ALL.release_type
580: --SubmitterAction
581: -- (Unused) This parameter is not currently used.

Line 2026: FROM po_requisition_headers_all

2022: */
2023: IF l_document_type='REQUISITION' THEN
2024: SELECT AUTHORIZATION_STATUS
2025: INTO l_authorization_status
2026: FROM po_requisition_headers_all
2027: WHERE REQUISITION_HEADER_ID = l_document_id;
2028: /* Bug#1810322: kagarwal
2029: ** Desc: If the original authorization status is IN PROCESS or PRE-APPROVED
2030: ** for Reqs then we need to store INCOMPLETE as the original authorization

Line 2840: ** it would reget the preparer_id from the po_requisition_headers_all

2836: ** Desc:Initially the Workflow sets the preparer_id, approver_empid
2837: ** as the value passed to it by the POXAPAPC.pld file. As it always
2838: ** assumed that an Incomplete Requisition would get approved by
2839: ** preparer only. Then when it calls the GetReqAttributes()
2840: ** it would reget the preparer_id from the po_requisition_headers_all
2841: ** table hence if the preparer_id and approver_empid are different
2842: ** then the action history would be wrongly updated.
2843: **
2844: ** Modifying the parameter l_employee_id to be passed to

Line 5251: FROM po_requisition_headers_all

5247: IS
5248: CURSOR get_req_orgid
5249: IS
5250: SELECT org_id
5251: FROM po_requisition_headers_all
5252: WHERE requisition_header_id = document_id;
5253: CURSOR get_po_orgid
5254: IS
5255: SELECT org_id FROM po_headers_all WHERE po_header_id = document_id;

Line 6826: FROM po_requisition_headers_all

6822: ;
6823: IF l_document_id IS NOT NULL THEN
6824: SELECT NVL(apps_source_code, 'PO')
6825: INTO l_apps_source_code
6826: FROM po_requisition_headers_all
6827: WHERE requisition_header_id=l_document_id;
6828: END IF;
6829: l_progress:='002-'||TO_CHAR(l_document_id);
6830: /* POR = Web Requisition 4.0 or higher */