APPS.POR_AME_APPROVAL_LIST dependencies on PO_CHANGE_REQUESTS

Line 1336: FROM po_change_requests

1332:
1333: if (pIsRcoApproval) then
1334: SELECT DISTINCT wf_item_type, wf_item_key
1335: INTO l_itemtype, l_itemkey
1336: FROM po_change_requests
1337: WHERE document_header_id= pReqHeaderId AND
1338: document_type = 'REQ' AND
1339: action_type IN ('MODIFICATION', 'CANCELLATION') AND
1340: creation_date = (select max(creation_date)

Line 1341: from PO_CHANGE_REQUESTS

1337: WHERE document_header_id= pReqHeaderId AND
1338: document_type = 'REQ' AND
1339: action_type IN ('MODIFICATION', 'CANCELLATION') AND
1340: creation_date = (select max(creation_date)
1341: from PO_CHANGE_REQUESTS
1342: where DOCUMENT_HEADER_ID = pReqHeaderId) AND
1343: request_status NOT IN ('ACCEPTED', 'REJECTED');
1344: else
1345: SELECT wf_item_type, wf_item_key

Line 1439: PO_CHANGE_REQUESTS pcr

1435: begin
1436: SELECT COUNT(1)
1437: INTO changeRequestExist
1438: FROM
1439: PO_CHANGE_REQUESTS pcr
1440: WHERE
1441: pcr.document_header_id = pReqHeaderId AND
1442: pcr.document_type = 'REQ' AND
1443: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 1922: PO_CHANGE_REQUESTS pcr

1918: begin
1919: SELECT COUNT(1)
1920: INTO changeRequestExist
1921: FROM
1922: PO_CHANGE_REQUESTS pcr
1923: WHERE
1924: pcr.document_header_id = pReqHeaderId AND
1925: pcr.document_type = 'REQ' AND
1926: pcr.action_type IN ('MODIFICATION', 'CANCELLATION') AND

Line 2511: FROM po_change_requests

2507:
2508: -- First check whether change request is there or not.
2509: BEGIN
2510: SELECT max(change_request_group_id) INTO l_change_request_group_id
2511: FROM po_change_requests
2512: WHERE document_header_id = p_req_header_id
2513: AND document_type = 'REQ';
2514: EXCEPTION
2515: WHEN OTHERS THEN

Line 2531: FROM po_change_requests

2527: 'MGR_APP', 'APPROVED',
2528: 'REJECTED','REJECTED',
2529: 'IN PROCESS' )
2530: INTO l_itemtype, l_itemkey, x_approval_status
2531: FROM po_change_requests
2532: WHERE document_header_id = p_req_header_id
2533: AND change_request_group_id = l_change_request_group_id
2534: AND document_type = 'REQ'
2535: AND action_type <> 'DERIVED'

Line 2775: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;

2771: p_doc_type po_document_types_all_b.document_type_code%type;
2772: p_doc_subtype po_document_types_all_b.document_subtype%type;
2773: l_authorizationStatus po_requisition_headers_all.AUTHORIZATION_STATUS%type;
2774: l_change_pending_flag po_requisition_headers_all.CHANGE_PENDING_FLAG%type;
2775: l_approval_reqd_flag PO_CHANGE_REQUESTS.APPROVAL_REQUIRED_FLAG%type;
2776:
2777: BEGIN
2778:
2779: if g_fnd_debug = 'Y' then

Line 2834: from PO_CHANGE_REQUESTS

2830: -- Simply return and do NOT build AME list
2831: begin
2832: select DISTINCT nvl(APPROVAL_REQUIRED_FLAG, 'N')
2833: into l_approval_reqd_flag
2834: from PO_CHANGE_REQUESTS
2835: where DOCUMENT_HEADER_ID = pReqHeaderId
2836: and action_type IN ('MODIFICATION', 'CANCELLATION')
2837: and creation_date = (select max(creation_date)
2838: from PO_CHANGE_REQUESTS

Line 2838: from PO_CHANGE_REQUESTS

2834: from PO_CHANGE_REQUESTS
2835: where DOCUMENT_HEADER_ID = pReqHeaderId
2836: and action_type IN ('MODIFICATION', 'CANCELLATION')
2837: and creation_date = (select max(creation_date)
2838: from PO_CHANGE_REQUESTS
2839: where DOCUMENT_HEADER_ID = pReqHeaderId);
2840: exception
2841: when others then
2842: l_approval_reqd_flag := 'Y';