PACKAGE: APPS.CSP_ITEM_PL_PARAMS_PVT

Source

1 PACKAGE CSP_ITEM_PL_PARAMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvpips.pls 120.0 2006/01/11 16:22:51 phegde noship $ */
3 --
4 -- Purpose: Insert or update table mtl_item_pl_params based on some conditions
5 --
6 -- MODIFICATION HISTORY
7 -- Person      Date      Comments
8 -- ---------   ------    ------------------------------------------
9 --  phegde      01/05/06  created package
10 
11 
12   PROCEDURE merge_item_params
13      (  p_organization_id       NUMBER
14        ,p_inventory_item_id     NUMBER
15        ,p_excess_service_level  NUMBER
16        ,p_repair_service_level  NUMBER
17        ,p_newbuy_service_level  NUMBER
18        ,p_excess_edq_factor     NUMBER
19        ,p_repair_edq_factor     NUMBER
20        ,p_newbuy_edq_factor     NUMBER
21        ,p_excess_edq_multiple   NUMBER
22        ,p_repair_edq_multiple   NUMBER
23        ,p_newbuy_edq_multiple   NUMBER
24      );
25 
26 END;