APPS.PO_AME_SETUP_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 36: po_requisition_headers_all prh

32: SELECT gls.currency_code
33: INTO l_currency_code
34: FROM financials_system_params_all fsp,
35: gl_sets_of_books gls,
36: po_requisition_headers_all prh
37: WHERE fsp.set_of_books_id = gls.set_of_books_id and
38: fsp.org_id = prh.org_id and --
39: prh.requisition_header_id = reqHeaderId;
40: RETURN l_currency_code;

Line 76: FROM fnd_user fu, po_requisition_headers_all prh

72: BEGIN
73: BEGIN
74: SELECT fu.user_id
75: INTO l_user_id
76: FROM fnd_user fu, po_requisition_headers_all prh
77: WHERE prh.requisition_header_id = reqHeaderId and
78: prh.preparer_id = fu.employee_id;
79: EXCEPTION
80: when others then

Line 300: l_org_id po_requisition_headers_all.org_id%TYPE;

296: -------------------------------------------------------------------------------
297: FUNCTION get_changed_req_total(ReqHeaderId IN NUMBER)
298: RETURN NUMBER IS
299: l_req_total NUMBER := 0;
300: l_org_id po_requisition_headers_all.org_id%TYPE;
301:
302: BEGIN
303: select org_id
304: into l_org_id

Line 305: from po_requisition_headers_all

301:
302: BEGIN
303: select org_id
304: into l_org_id
305: from po_requisition_headers_all
306: where requisition_header_id = ReqHeaderId;
307:
308: IF l_org_id is NOT NULL THEN
309: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 359: from po_requisition_headers_all

355: newReqNumber po_requisition_headers.segment1%TYPE;
356:
357: begin
358: select segment1, org_id into reqNumber, orgId
359: from po_requisition_headers_all
360: where requisition_header_id = oldReqHeaderId;
361:
362: newReqNumber := '##' || reqNumber;
363:

Line 366: from po_requisition_headers_all

362: newReqNumber := '##' || reqNumber;
363:
364: begin
365: select requisition_header_id into newReqHeaderId
366: from po_requisition_headers_all
367: where segment1 = newReqNumber
368: and org_id = orgId ; --
369: exception
370: when NO_DATA_FOUND then

Line 429: FROM fnd_user fu, po_requisition_headers_all prh

425:
426: BEGIN
427: SELECT fu.user_id
428: INTO l_user_id
429: FROM fnd_user fu, po_requisition_headers_all prh
430: WHERE prh.requisition_header_id = reqHeaderId and
431: prh.preparer_id = fu.employee_id;
432: EXCEPTION
433: when others then

Line 490: FROM po_document_types_all_b pdt, po_requisition_headers_all prh

486:
487: BEGIN
488: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
489: INTO l_can_approve
490: FROM po_document_types_all_b pdt, po_requisition_headers_all prh
491: WHERE prh.requisition_header_id = reqHeaderId and
492: pdt.org_id = prh.org_id and --
493: prh.type_lookup_code = pdt.document_subtype and
494: pdt.DOCUMENT_TYPE_CODE='REQUISITION';