APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_REQUISITION_HEADERS_ALL

Line 41: from po_requisition_headers_all

37: select REQUISITION_HEADER_ID,DESCRIPTION,AUTHORIZATION_STATUS,
38: TYPE_LOOKUP_CODE,PREPARER_ID,SEGMENT1,CLOSED_CODE,EMERGENCY_PO_NUM,
39: NVL(CONTRACTOR_REQUISITION_FLAG, 'N'),
40: NVL(CONTRACTOR_STATUS, 'NULL'), NOTE_TO_AUTHORIZER
41: from po_requisition_headers_all
42: where REQUISITION_HEADER_ID = p_requisition_header_id;
43:
44: /*****************************************************************************
45: * The following are local/Private procedure that support the workflow APIs: *

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

488: -- Indicates the caller of this procedure. If 'CANCEL', then the approval will
489: -- not insert into the action history.
490: --DocumentID
491: -- This value for this parameter depends on the DocumentType:
492: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
493: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
494: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
495: --DocumentNumber
496: -- (Obsolete) This parameter is ignored. This procedure will derive the

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

501: --DocumentType
502: -- 'REQUISITION', 'PO', 'PA', 'RELEASE'
503: --DocumentSubType
504: -- The value for this parameter depends on the DocumentType:
505: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
506: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
507: -- 'RELEASE': PO_RELEASES_ALL.release_type
508: --SubmitterAction
509: -- (Unused) This parameter is not currently used.

Line 2248: from po_requisition_headers_all

2244: IF l_document_type='REQUISITION' THEN
2245:
2246: select AUTHORIZATION_STATUS
2247: into l_authorization_status
2248: from po_requisition_headers_all
2249: where REQUISITION_HEADER_ID = l_document_id;
2250:
2251: /* Bug#1810322: kagarwal
2252: ** Desc: If the original authorization status is IN PROCESS or PRE-APPROVED

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

3256: ** Desc:Initially the Workflow sets the preparer_id, approver_empid
3257: ** as the value passed to it by the POXAPAPC.pld file. As it always
3258: ** assumed that an Incomplete Requisition would get approved by
3259: ** preparer only. Then when it calls the GetReqAttributes()
3260: ** it would reget the preparer_id from the po_requisition_headers_all
3261: ** table hence if the preparer_id and approver_empid are different
3262: ** then the action history would be wrongly updated.
3263: **
3264: ** Modifying the parameter l_employee_id to be passed to

Line 6170: from po_requisition_headers_all

6166: x_orgid IN OUT NOCOPY number) is
6167:
6168: cursor get_req_orgid is
6169: select org_id
6170: from po_requisition_headers_all
6171: where requisition_header_id = document_id;
6172:
6173: cursor get_po_orgid is
6174: select org_id

Line 7508: from po_requisition_headers_all

7504: IF l_document_id IS NOT NULL THEN
7505:
7506: select nvl(apps_source_code, 'PO')
7507: into l_apps_source_code
7508: from po_requisition_headers_all
7509: where requisition_header_id=l_document_id;
7510:
7511: END IF;
7512: