APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 2821: from po_requisition_headers_all porh,

2817:
2818: -- curosr to get the ReqHeaderId
2819: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
2820: select distinct porh.requisition_header_id
2821: from po_requisition_headers_all porh,
2822: po_requisition_lines_all porl,
2823: po_headers_all poh,
2824: po_line_locations_all poll
2825: where porh.requisition_header_id = porl.requisition_header_id AND

Line 2832: from po_requisition_headers_all porh,

2828: poh.po_header_id = p_po_header_id_csr;
2829:
2830: cursor c_getReqHdrId_r(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2831: select distinct porh.requisition_header_id
2832: from po_requisition_headers_all porh,
2833: po_requisition_lines_all porl,
2834: po_headers_all poh,
2835: po_line_locations_all poll
2836: where porh.requisition_header_id = porl.requisition_header_id AND

Line 2847: l_req_hdr_id po_requisition_headers_all.requisition_header_id%TYPE;

2843: l_po_release_id po_releases_all.po_release_id%TYPE;
2844: l_doc_type VARCHAR2(10);
2845: l_return_val VARCHAR2(1);
2846: l_change_group_id po_change_requests.change_request_group_id%TYPE;
2847: l_req_hdr_id po_requisition_headers_all.requisition_header_id%TYPE;
2848: x_progress VARCHAR2(1000);
2849: l_auto_app_flag VARCHAR2(1);
2850:
2851: BEGIN

Line 2901: update po_requisition_headers_all

2897: EXIT WHEN c_getReqHdrId_r%NOTFOUND;
2898: x_progress:= 'ROUTE_SCO_BIZ_RULES:004';
2899: log_message('ROUTE_SCO_BIZ_RULES','Locking the Req',l_req_hdr_id);
2900:
2901: update po_requisition_headers_all
2902: set change_pending_flag = 'Y'
2903: where requisition_header_id = l_req_hdr_id;
2904:
2905: END LOOP;

Line 2916: update po_requisition_headers_all

2912: EXIT WHEN c_getReqHdrId%NOTFOUND;
2913: x_progress:= 'ROUTE_SCO_BIZ_RULES:004a';
2914: log_message('ROUTE_SCO_BIZ_RULES','Locking the Req',l_req_hdr_id);
2915:
2916: update po_requisition_headers_all
2917: set change_pending_flag = 'Y'
2918: where requisition_header_id = l_req_hdr_id;
2919:
2920: END LOOP;

Line 3150: from po_requisition_headers_all porh,

3146: -- Check whether that Requisition is Locked or not
3147:
3148: cursor c_req_locks(p_po_header_id_csr IN NUMBER) is
3149: select count(1)
3150: from po_requisition_headers_all porh,
3151: po_requisition_lines_all porl,
3152: po_headers_all poh,
3153: po_line_locations_all poll
3154: where porh.requisition_header_id = porl.requisition_header_id AND

Line 3165: from po_requisition_headers_all porh,

3161: -- Check whether that Requisition is Locked or not for the releases
3162:
3163: cursor c_req_locks_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) is
3164: select count(1)
3165: from po_requisition_headers_all porh,
3166: po_requisition_lines_all porl,
3167: po_headers_all poh,
3168: po_line_locations_all poll
3169: where porh.requisition_header_id = porl.requisition_header_id AND

Line 4496: from po_requisition_headers_all porh,

4492:
4493: CURSOR l_planners_csr(c_po_header_id IN NUMBER)
4494: IS
4495: select UNIQUE(porh.PREPARER_ID)
4496: from po_requisition_headers_all porh,
4497: po_requisition_lines_all porl,
4498: po_headers_all poh,
4499: po_line_locations_all poll
4500: where porh.requisition_header_id = porl.requisition_header_id AND