APPS.CSP_PLANNER_NOTIFICATIONS dependencies on INV_QUANTITY_TREE_PUB

Line 2069: INV_Quantity_Tree_PUB.Query_Quantities

2065:
2066: IF (l_organization_type = 'W') THEN
2067: IF (l_item_minmax_flag <> 2) THEN -- not minmax planned
2068: l_onhand_source := 2; --only nettable subinvs
2069: INV_Quantity_Tree_PUB.Query_Quantities
2070: ( p_api_version_number => 1.0
2071: , p_init_msg_lst => 'F'
2072: , x_return_status => l_return_status
2073: , x_msg_count => l_msg_count

Line 2251: INV_Quantity_Tree_PUB.Query_Quantities

2247: -- cleanup inv_min_max_Temp
2248: DELETE FROM INV_MIN_MAX_TEMP;
2249: END If;
2250: ELSE
2251: INV_Quantity_Tree_PUB.Query_Quantities
2252: ( p_api_version_number => 1.0
2253: , p_init_msg_lst => 'F'
2254: , x_return_status => l_return_status
2255: , x_msg_count => l_msg_count

Line 2449: INV_Quantity_Tree_PUB.Query_Quantities

2445: IF (l_organization_type = 'W') THEN
2446: l_repair_qty := 0;
2447: IF (l_condition_type = 'B') THEN
2448: FOR wsc IN d_wrhs_subinv_cur(rep.source_organization_id) LOOP
2449: INV_Quantity_Tree_PUB.Query_Quantities
2450: ( p_api_version_number => 1.0
2451: , p_init_msg_lst => 'F'
2452: , x_return_status => l_return_status
2453: , x_msg_count => l_msg_count

Line 2494: INV_Quantity_Tree_PUB.Query_Quantities

2490: ,p_parts_rec => l_parts_Rec);
2491: END IF;
2492: ELSE -- if warehouse is usable
2493: FOR wsc IN u_wrhs_subinv_cur(rep.source_organization_id) LOOP
2494: INV_Quantity_Tree_PUB.Query_Quantities
2495: ( p_api_version_number => 1.0
2496: , p_init_msg_lst => 'F'
2497: , x_return_status => l_return_status
2498: , x_msg_count => l_msg_count

Line 2541: INV_Quantity_Tree_PUB.Query_Quantities

2537: END IF;
2538: ELSE -- if FE organization
2539: FOR rsc IN u_wrhs_subinv_cur(rep.source_organization_id) LOOP
2540: --calculate ATT for each of the defective subinvs
2541: INV_Quantity_Tree_PUB.Query_Quantities
2542: ( p_api_version_number => 1.0
2543: , p_init_msg_lst => 'F'
2544: , x_return_status => l_return_status
2545: , x_msg_count => l_msg_count

Line 2586: INV_Quantity_Tree_PUB.Query_Quantities

2582: END LOOP;
2583: -- elsif supercessed_item,
2584: IF (p_supercess_item_yn = 'Y') THEN
2585: -- calculate repair quantity in current organization.
2586: INV_Quantity_Tree_PUB.Query_Quantities
2587: ( p_api_version_number => 1.0
2588: , p_init_msg_lst => 'F'
2589: , x_return_status => l_return_status
2590: , x_msg_count => l_msg_count