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 2843: l_po_release_id po_releases_all.po_release_id%TYPE;

2839: poh.po_header_id = p_po_header_id_csr AND
2840: poll.po_release_id = p_po_release_id_csr;
2841:
2842: l_po_header_id po_headers_all.po_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;

Line 2965: l_po_release_id po_releases_all.po_release_id%TYPE;

2961:
2962: IS
2963:
2964: l_po_header_id po_headers_all.po_header_id%TYPE;
2965: l_po_release_id po_releases_all.po_release_id%TYPE;
2966: l_return_val VARCHAR2(1);
2967: x_progress VARCHAR2(1000);
2968: l_po_style_type VARCHAR2(10);
2969: l_doc_type VARCHAR2(10);

Line 3504: FROM po_releases_all

3500: -- SCO created during Acknowledgement AND the supplier has rejected at least one shipment for the releases
3501: -- Cursor for checking whether sco is created during Acknowledgement or not.
3502: cursor c_sco_ack_ship_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3503: SELECT acceptance_required_flag,revision_num
3504: FROM po_releases_all
3505: WHERE po_header_id = p_po_header_id_csr
3506: AND po_release_id = p_po_release_id_csr;
3507:
3508: -- Cursor for checking the acknowledgement status of the shipment

Line 3953: l_po_release_id po_releases_all.po_release_id%type;

3949: resultout OUT NOCOPY VARCHAR2)
3950: IS
3951: l_change_group_id PO_CHANGE_REQUESTS.CHANGE_REQUEST_GROUP_ID%type;
3952: l_po_header_id po_headers_all.po_header_id%type;
3953: l_po_release_id po_releases_all.po_release_id%type;
3954: x_progress VARCHAR2(1000);
3955:
3956: BEGIN
3957: x_progress := 'INITIATE_RCO_FLOW:000';