[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
2574: aname => 'PRICE_APPROVAL_FLAG');
2575:
2576: x_progress := 'ROUTE_TO_REQUESTER:001';
2577:
2578: IF((l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') OR (l_doc_type = 'RELEASE' AND l_doc_subtype = 'BLANKET')) THEN
2579:
2580:
2581: 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
2582: l_return_val:= 'Y' ;
2993: aname => 'DOC_SUB_TYPE');
2994:
2995: x_progress := 'AUTO_APP_BIZ_RULES:001';
2996:
2997: IF((l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') OR (l_doc_type = 'RELEASE' AND l_doc_subtype = 'BLANKET')) THEN
2998: IF ( AUTO_APP_BIZ_RULES_CHECK(l_po_header_id,l_po_release_id,l_doc_type)=FALSE) THEN
2999:
3000: wf_engine.SetItemAttrText( itemtype => itemtype,
3001: itemkey => itemkey,
3052: po_line_locations_all poll
3053: WHERE poll.line_location_id = porl.line_location_id AND
3054: NVL(poll.cancel_flag, 'N') = 'N' AND
3055: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3056: poll.shipment_type IN('STANDARD', 'BLANKET')
3057: AND poll.po_header_id=p_po_header_id_csr;
3058:
3059: -- Cursor for Checking for the multipe backing reqs is mapped to the releases
3060:
3064: po_line_locations_all poll
3065: WHERE poll.line_location_id = porl.line_location_id AND
3066: NVL(poll.cancel_flag, 'N') = 'N' AND
3067: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3068: poll.shipment_type IN('STANDARD', 'BLANKET')
3069: AND poll.po_header_id=p_po_header_id_csr
3070: AND poll.po_release_id = p_po_release_id_csr;
3071:
3072: