APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 2756: from po_requisition_headers_all porh,

2752:
2753: -- curosr to get the ReqHeaderId
2754: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
2755: select distinct porh.requisition_header_id
2756: from po_requisition_headers_all porh,
2757: po_requisition_lines_all porl,
2758: po_headers_all poh,
2759: po_line_locations_all poll
2760: where porh.requisition_header_id = porl.requisition_header_id AND

Line 2767: from po_requisition_headers_all porh,

2763: poh.po_header_id = p_po_header_id_csr;
2764:
2765: cursor c_getReqHdrId_r(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2766: select distinct porh.requisition_header_id
2767: from po_requisition_headers_all porh,
2768: po_requisition_lines_all porl,
2769: po_headers_all poh,
2770: po_line_locations_all poll
2771: where porh.requisition_header_id = porl.requisition_header_id AND

Line 2782: l_req_hdr_id po_requisition_headers_all.requisition_header_id%TYPE;

2778: l_po_release_id po_releases_all.po_release_id%TYPE;
2779: l_doc_type VARCHAR2(10);
2780: l_return_val VARCHAR2(1);
2781: l_change_group_id po_change_requests.change_request_group_id%TYPE;
2782: l_req_hdr_id po_requisition_headers_all.requisition_header_id%TYPE;
2783: x_progress VARCHAR2(1000);
2784: l_auto_app_flag VARCHAR2(1);
2785:
2786: BEGIN

Line 2836: update po_requisition_headers_all

2832: EXIT WHEN c_getReqHdrId_r%NOTFOUND;
2833: x_progress:= 'ROUTE_SCO_BIZ_RULES:004';
2834: log_message('ROUTE_SCO_BIZ_RULES','Locking the Req',l_req_hdr_id);
2835:
2836: update po_requisition_headers_all
2837: set change_pending_flag = 'Y'
2838: where requisition_header_id = l_req_hdr_id;
2839:
2840: END LOOP;

Line 2851: update po_requisition_headers_all

2847: EXIT WHEN c_getReqHdrId%NOTFOUND;
2848: x_progress:= 'ROUTE_SCO_BIZ_RULES:004a';
2849: log_message('ROUTE_SCO_BIZ_RULES','Locking the Req',l_req_hdr_id);
2850:
2851: update po_requisition_headers_all
2852: set change_pending_flag = 'Y'
2853: where requisition_header_id = l_req_hdr_id;
2854:
2855: END LOOP;

Line 3085: from po_requisition_headers_all porh,

3081: -- Check whether that Requisition is Locked or not
3082:
3083: cursor c_req_locks(p_po_header_id_csr IN NUMBER) is
3084: select count(1)
3085: from po_requisition_headers_all porh,
3086: po_requisition_lines_all porl,
3087: po_headers_all poh,
3088: po_line_locations_all poll
3089: where porh.requisition_header_id = porl.requisition_header_id AND

Line 3100: from po_requisition_headers_all porh,

3096: -- Check whether that Requisition is Locked or not for the releases
3097:
3098: cursor c_req_locks_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) is
3099: select count(1)
3100: from po_requisition_headers_all porh,
3101: po_requisition_lines_all porl,
3102: po_headers_all poh,
3103: po_line_locations_all poll
3104: where porh.requisition_header_id = porl.requisition_header_id AND

Line 4349: from po_requisition_headers_all porh,

4345:
4346: CURSOR l_planners_csr(c_po_header_id IN NUMBER)
4347: IS
4348: select porh.PREPARER_ID
4349: from po_requisition_headers_all porh,
4350: po_requisition_lines_all porl,
4351: po_headers_all poh,
4352: po_line_locations_all poll
4353: where porh.requisition_header_id = porl.requisition_header_id AND