APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_RELEASES_ALL

Line 49: FROM po_releases_all pora

45: WHERE poha.po_header_id = p_po_header_id_csr;
46:
47: CURSOR getDocSubTypeRel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) IS
48: SELECT distinct(release_type)
49: FROM po_releases_all pora
50: WHERE pora.po_header_id = p_po_header_id_csr
51: AND pora.po_release_id = p_po_release_id_csr;
52:
53: CURSOR getOrgId(p_po_header_id_csr IN NUMBER) IS

Line 60: l_po_release_id po_releases_all.po_release_id%TYPE;

56: WHERE po_header_id = p_po_header_id_csr;
57:
58: l_chg_req_grp_id po_change_requests.change_request_group_id%TYPE;
59: l_po_header_id po_headers_all.po_header_id%TYPE;
60: l_po_release_id po_releases_all.po_release_id%TYPE;
61: l_doc_type po_change_requests.document_type%TYPE;
62: l_po_style varchar2(10);
63: l_doc_subtype varchar2(10);
64: l_promise_date_incr NUMBER;

Line 676: l_po_release_id po_releases_all.po_release_id%TYPE;

672: -- cursor to check for the Complex Work( Actuals Case)
673:
674:
675: l_po_header_id po_headers_all.po_header_id%TYPE;
676: l_po_release_id po_releases_all.po_release_id%TYPE;
677: l_change_group_id po_change_requests.change_request_group_id%type;
678: l_unitprice_lower_tol number;
679: l_unitprice_upper_tol number;
680: l_old_price po_change_requests.old_price%type;

Line 2778: l_po_release_id po_releases_all.po_release_id%TYPE;

2774: poh.po_header_id = p_po_header_id_csr AND
2775: poll.po_release_id = p_po_release_id_csr;
2776:
2777: l_po_header_id po_headers_all.po_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;

Line 2900: l_po_release_id po_releases_all.po_release_id%TYPE;

2896:
2897: IS
2898:
2899: l_po_header_id po_headers_all.po_header_id%TYPE;
2900: l_po_release_id po_releases_all.po_release_id%TYPE;
2901: l_return_val VARCHAR2(1);
2902: x_progress VARCHAR2(1000);
2903: l_po_style_type VARCHAR2(10);
2904: l_doc_type VARCHAR2(10);

Line 3392: FROM po_releases_all

3388: -- SCO created during Acknowledgement AND the supplier has rejected at least one shipment for the releases
3389: -- Cursor for checking whether sco is created during Acknowledgement or not.
3390: cursor c_sco_ack_ship_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3391: SELECT acceptance_required_flag,revision_num
3392: FROM po_releases_all
3393: WHERE po_header_id = p_po_header_id_csr
3394: AND po_release_id = p_po_release_id_csr;
3395:
3396: -- Cursor for checking the acknowledgement status of the shipment

Line 3836: l_po_release_id po_releases_all.po_release_id%type;

3832: resultout OUT NOCOPY VARCHAR2)
3833: IS
3834: l_change_group_id PO_CHANGE_REQUESTS.CHANGE_REQUEST_GROUP_ID%type;
3835: l_po_header_id po_headers_all.po_header_id%type;
3836: l_po_release_id po_releases_all.po_release_id%type;
3837: x_progress VARCHAR2(1000);
3838:
3839: BEGIN
3840: x_progress := 'INITIATE_RCO_FLOW:000';