APPS.PO_AME_SETUP_PVT dependencies on PO_REQUISITION_HEADERS

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 198: l_org_id po_requisition_headers_all.org_id%TYPE;

194: -------------------------------------------------------------------------------
195: FUNCTION get_changed_req_total(ReqHeaderId IN NUMBER)
196: RETURN NUMBER IS
197: l_req_total NUMBER := 0;
198: l_org_id po_requisition_headers_all.org_id%TYPE;
199:
200: BEGIN
201: select org_id
202: into l_org_id

Line 203: from po_requisition_headers_all

199:
200: BEGIN
201: select org_id
202: into l_org_id
203: from po_requisition_headers_all
204: where requisition_header_id = ReqHeaderId;
205:
206: IF l_org_id is NOT NULL THEN
207: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 250: reqNumber po_requisition_headers.segment1%TYPE;

246: -------------------------------------------------------------------------------
247: function get_new_req_header_id (oldReqHeaderId IN NUMBER) return number IS
248:
249: l_api_name varchar2(50):= 'get_new_req_header_id';
250: reqNumber po_requisition_headers.segment1%TYPE;
251: orgId po_requisition_headers.org_id%TYPE;
252: newReqHeaderId po_requisition_headers.requisition_header_id%TYPE;
253: newReqNumber po_requisition_headers.segment1%TYPE;
254:

Line 251: orgId po_requisition_headers.org_id%TYPE;

247: function get_new_req_header_id (oldReqHeaderId IN NUMBER) return number IS
248:
249: l_api_name varchar2(50):= 'get_new_req_header_id';
250: reqNumber po_requisition_headers.segment1%TYPE;
251: orgId po_requisition_headers.org_id%TYPE;
252: newReqHeaderId po_requisition_headers.requisition_header_id%TYPE;
253: newReqNumber po_requisition_headers.segment1%TYPE;
254:
255: begin

Line 252: newReqHeaderId po_requisition_headers.requisition_header_id%TYPE;

248:
249: l_api_name varchar2(50):= 'get_new_req_header_id';
250: reqNumber po_requisition_headers.segment1%TYPE;
251: orgId po_requisition_headers.org_id%TYPE;
252: newReqHeaderId po_requisition_headers.requisition_header_id%TYPE;
253: newReqNumber po_requisition_headers.segment1%TYPE;
254:
255: begin
256: select segment1, org_id into reqNumber, orgId

Line 253: newReqNumber po_requisition_headers.segment1%TYPE;

249: l_api_name varchar2(50):= 'get_new_req_header_id';
250: reqNumber po_requisition_headers.segment1%TYPE;
251: orgId po_requisition_headers.org_id%TYPE;
252: newReqHeaderId po_requisition_headers.requisition_header_id%TYPE;
253: newReqNumber po_requisition_headers.segment1%TYPE;
254:
255: begin
256: select segment1, org_id into reqNumber, orgId
257: from po_requisition_headers_all

Line 257: from po_requisition_headers_all

253: newReqNumber po_requisition_headers.segment1%TYPE;
254:
255: begin
256: select segment1, org_id into reqNumber, orgId
257: from po_requisition_headers_all
258: where requisition_header_id = oldReqHeaderId;
259:
260: newReqNumber := '##' || reqNumber;
261:

Line 264: from po_requisition_headers_all

260: newReqNumber := '##' || reqNumber;
261:
262: begin
263: select requisition_header_id into newReqHeaderId
264: from po_requisition_headers_all
265: where segment1 = newReqNumber
266: and org_id = orgId ; --
267: exception
268: when NO_DATA_FOUND then

Line 314: FROM fnd_user fu, po_requisition_headers_all prh

310: BEGIN
311: BEGIN
312: SELECT fu.user_id
313: INTO l_user_id
314: FROM fnd_user fu, po_requisition_headers_all prh
315: WHERE prh.requisition_header_id = reqHeaderId and
316: prh.preparer_id = fu.employee_id;
317: EXCEPTION
318: when others then

Line 362: FROM po_document_types_all_b pdt, po_requisition_headers_all prh

358:
359: BEGIN
360: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
361: INTO l_can_approve
362: FROM po_document_types_all_b pdt, po_requisition_headers_all prh
363: WHERE prh.requisition_header_id = reqHeaderId and
364: pdt.org_id = prh.org_id and --
365: prh.type_lookup_code = pdt.document_subtype and
366: pdt.DOCUMENT_TYPE_CODE='REQUISITION';