APPS.POR_AME_APPROVAL_LIST dependencies on PO_CHANGE_REQUESTS

Line 1277: FROM po_change_requests

1273:
1274: if (pIsRcoApproval) then
1275: SELECT DISTINCT wf_item_type, wf_item_key
1276: INTO l_itemtype, l_itemkey
1277: FROM po_change_requests
1278: WHERE document_header_id= pReqHeaderId AND
1279: document_type = 'REQ' AND
1280: action_type IN ('MODIFICATION', 'CANCELLATION') AND
1281: creation_date = (select max(creation_date)

Line 1282: from PO_CHANGE_REQUESTS

1278: WHERE document_header_id= pReqHeaderId AND
1279: document_type = 'REQ' AND
1280: action_type IN ('MODIFICATION', 'CANCELLATION') AND
1281: creation_date = (select max(creation_date)
1282: from PO_CHANGE_REQUESTS
1283: where DOCUMENT_HEADER_ID = pReqHeaderId) AND
1284: request_status NOT IN ('ACCEPTED', 'REJECTED');
1285: else
1286: SELECT wf_item_type, wf_item_key

Line 1380: PO_CHANGE_REQUESTS pcr

1376: begin
1377: SELECT COUNT(1)
1378: INTO changeRequestExist
1379: FROM
1380: PO_CHANGE_REQUESTS pcr
1381: WHERE
1382: pcr.document_header_id = pReqHeaderId AND
1383: pcr.document_type = 'REQ' AND
1384: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 1857: PO_CHANGE_REQUESTS pcr

1853: begin
1854: SELECT COUNT(1)
1855: INTO changeRequestExist
1856: FROM
1857: PO_CHANGE_REQUESTS pcr
1858: WHERE
1859: pcr.document_header_id = pReqHeaderId AND
1860: pcr.document_type = 'REQ' AND
1861: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 2441: FROM po_change_requests

2437:
2438: -- First check whether change request is there or not.
2439: BEGIN
2440: SELECT max(change_request_group_id) INTO l_change_request_group_id
2441: FROM po_change_requests
2442: WHERE document_header_id = p_req_header_id
2443: AND document_type = 'REQ';
2444: EXCEPTION
2445: WHEN OTHERS THEN

Line 2461: FROM po_change_requests

2457: 'MGR_APP', 'APPROVED',
2458: 'REJECTED','REJECTED',
2459: 'IN PROCESS' )
2460: INTO l_itemtype, l_itemkey, x_approval_status
2461: FROM po_change_requests
2462: WHERE document_header_id = p_req_header_id
2463: AND change_request_group_id = l_change_request_group_id
2464: AND document_type = 'REQ'
2465: AND action_type <> 'DERIVED'

Line 2705: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;

2701: p_doc_type po_document_types_all_b.document_type_code%type;
2702: p_doc_subtype po_document_types_all_b.document_subtype%type;
2703: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2704: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2705: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;
2706:
2707: BEGIN
2708:
2709: if g_fnd_debug = 'Y' then

Line 2764: from PO_CHANGE_REQUESTS

2760: -- Simply return and do NOT build AME list
2761: begin
2762: select DISTINCT nvl(APPROVAL_REQUIRED_FLAG, 'N')
2763: into l_approval_reqd_flag
2764: from PO_CHANGE_REQUESTS
2765: where DOCUMENT_HEADER_ID = pReqHeaderId
2766: and action_type IN ('MODIFICATION', 'CANCELLATION')
2767: and creation_date = (select max(creation_date)
2768: from PO_CHANGE_REQUESTS

Line 2768: from PO_CHANGE_REQUESTS

2764: from PO_CHANGE_REQUESTS
2765: where DOCUMENT_HEADER_ID = pReqHeaderId
2766: and action_type IN ('MODIFICATION', 'CANCELLATION')
2767: and creation_date = (select max(creation_date)
2768: from PO_CHANGE_REQUESTS
2769: where DOCUMENT_HEADER_ID = pReqHeaderId);
2770: exception
2771: when others then
2772: l_approval_reqd_flag := 'Y';