APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_DOCUMENT_CANCEL_PVT

Line 2135: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE

2131: FROM financials_system_params_all fsp
2132: WHERE org_id = (SELECT org_id
2133: FROM po_releases_all
2134: WHERE po_release_id = p_doc_id
2135: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2136: UNION ALL
2137: SELECT org_id
2138: FROM po_headers_all
2139: WHERE po_header_id = p_doc_id

Line 2140: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE);

2136: UNION ALL
2137: SELECT org_id
2138: FROM po_headers_all
2139: WHERE po_header_id = p_doc_id
2140: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE);
2141:
2142:
2143:
2144:

Line 2213: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT

2209: AND poll.line_location_id IN
2210: ( SELECT line_location_id
2211: FROM po_line_locations_all
2212: WHERE line_location_id = p_line_location_id
2213: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT
2214: AND 0= (SELECT Count(1)
2215: FROM po_distributions_all pod
2216: WHERE pod.line_location_id=p_line_location_id
2217: AND NOT EXISTS (SELECT po_distribution_id

Line 2224: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE

2220: UNION ALL
2221: SELECT line_location_id
2222: FROM po_line_locations_all
2223: WHERE po_line_id = p_line_id
2224: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
2225: AND 0= (SELECT Count(1)
2226: FROM po_line_locations_all poll
2227: WHERE po_line_id=p_line_id
2228: AND NOT EXISTS (SELECT line_location_id

Line 2243: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE

2239: UNION ALL
2240: SELECT line_location_id
2241: FROM po_line_locations_all
2242: WHERE po_header_id = p_doc_id
2243: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2244: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2245: AND 0= (SELECT Count(1)
2246: FROM po_line_locations_all poll
2247: WHERE po_header_id = p_doc_id

Line 2244: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER

2240: SELECT line_location_id
2241: FROM po_line_locations_all
2242: WHERE po_header_id = p_doc_id
2243: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2244: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2245: AND 0= (SELECT Count(1)
2246: FROM po_line_locations_all poll
2247: WHERE po_header_id = p_doc_id
2248: AND NOT EXISTS (SELECT line_location_id

Line 2264: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE

2260: UNION ALL
2261: SELECT line_location_id
2262: FROM po_line_locations_all
2263: WHERE po_release_id = p_doc_id
2264: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2265: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2266: AND 0= (SELECT Count(1)
2267: FROM po_line_locations_all poll
2268: WHERE po_release_id = p_doc_id

Line 2265: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER

2261: SELECT line_location_id
2262: FROM po_line_locations_all
2263: WHERE po_release_id = p_doc_id
2264: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2265: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2266: AND 0= (SELECT Count(1)
2267: FROM po_line_locations_all poll
2268: WHERE po_release_id = p_doc_id
2269: AND NOT EXISTS (SELECT line_location_id

Line 2348: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT

2344: AND poll.line_location_id IN
2345: ( SELECT line_location_id
2346: FROM po_line_locations_all
2347: WHERE line_location_id = p_line_location_id
2348: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT
2349: UNION ALL
2350: SELECT line_location_id
2351: FROM po_line_locations_all
2352: WHERE po_line_id = p_line_id

Line 2353: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE

2349: UNION ALL
2350: SELECT line_location_id
2351: FROM po_line_locations_all
2352: WHERE po_line_id = p_line_id
2353: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
2354: UNION ALL
2355: SELECT line_location_id
2356: FROM po_line_locations_all
2357: WHERE po_header_id = p_doc_id

Line 2358: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE

2354: UNION ALL
2355: SELECT line_location_id
2356: FROM po_line_locations_all
2357: WHERE po_header_id = p_doc_id
2358: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2359: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2360: UNION ALL
2361: SELECT line_location_id
2362: FROM po_line_locations_all

Line 2359: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER

2355: SELECT line_location_id
2356: FROM po_line_locations_all
2357: WHERE po_header_id = p_doc_id
2358: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2359: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2360: UNION ALL
2361: SELECT line_location_id
2362: FROM po_line_locations_all
2363: WHERE po_release_id = p_doc_id

Line 2364: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE

2360: UNION ALL
2361: SELECT line_location_id
2362: FROM po_line_locations_all
2363: WHERE po_release_id = p_doc_id
2364: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2365: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER);
2366: x_msg_type :='E';
2367:
2368: IF d_debug_stmt THEN

Line 2365: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER);

2361: SELECT line_location_id
2362: FROM po_line_locations_all
2363: WHERE po_release_id = p_doc_id
2364: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2365: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER);
2366: x_msg_type :='E';
2367:
2368: IF d_debug_stmt THEN
2369: PO_DEBUG.debug_var(d_module, l_progress, 'x_msg_name', x_msg_name);