[Home] [Help]
119: aname => 'PO_RELEASE_ID');
120:
121: x_progress := 'INIT_TOL_VALUES:001';
122:
123: -- Getting the Doc types and subtypes coz the flow is valid for Standard PO's and Blanket Releases
124:
125: OPEN getDocType(l_chg_req_grp_id);
126: LOOP
127: FETCH getDocType
2549: aname => 'PRICE_APPROVAL_FLAG');
2550:
2551: x_progress := 'ROUTE_TO_REQUESTER:001';
2552:
2553: IF((l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') OR (l_doc_type = 'RELEASE' AND l_doc_subtype = 'BLANKET')) THEN
2554:
2555:
2556: IF ( ROUTETOREQUESTER ( l_po_header_id,l_change_group_id,l_doc_type,l_prmdate_app_flag,l_shi_qty_app_flag,l_unit_price_app_flag)=TRUE) THEN
2557: l_return_val:= 'Y' ;
2928: aname => 'DOC_SUB_TYPE');
2929:
2930: x_progress := 'AUTO_APP_BIZ_RULES:001';
2931:
2932: IF((l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') OR (l_doc_type = 'RELEASE' AND l_doc_subtype = 'BLANKET')) THEN
2933: IF ( AUTO_APP_BIZ_RULES_CHECK(l_po_header_id,l_po_release_id,l_doc_type)=FALSE) THEN
2934:
2935: wf_engine.SetItemAttrText( itemtype => itemtype,
2936: itemkey => itemkey,
2987: po_line_locations_all poll
2988: WHERE poll.line_location_id = porl.line_location_id AND
2989: NVL(poll.cancel_flag, 'N') = 'N' AND
2990: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
2991: poll.shipment_type IN('STANDARD', 'BLANKET')
2992: AND poll.po_header_id=p_po_header_id_csr;
2993:
2994: -- Cursor for Checking for the multipe backing reqs is mapped to the releases
2995:
2999: po_line_locations_all poll
3000: WHERE poll.line_location_id = porl.line_location_id AND
3001: NVL(poll.cancel_flag, 'N') = 'N' AND
3002: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3003: poll.shipment_type IN('STANDARD', 'BLANKET')
3004: AND poll.po_header_id=p_po_header_id_csr
3005: AND poll.po_release_id = p_po_release_id_csr;
3006:
3007: