APPS.CSP_PLANNER_NOTIFICATIONS dependencies on INV_QUANTITY_TREE_PUB

Line 2066: INV_Quantity_Tree_PUB.Query_Quantities

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

Line 2248: INV_Quantity_Tree_PUB.Query_Quantities

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

Line 2446: INV_Quantity_Tree_PUB.Query_Quantities

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

Line 2491: INV_Quantity_Tree_PUB.Query_Quantities

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

Line 2538: INV_Quantity_Tree_PUB.Query_Quantities

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

Line 2583: INV_Quantity_Tree_PUB.Query_Quantities

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