1 PACKAGE MSC_X_CVMI_PLANNING AUTHID CURRENT_USER AS
2 /* $Header: MSCXCVPS.pls 115.5 2004/02/11 00:13:14 jguo noship $ */
3
4
5 PROCEDURE calculate_average_demand;
6
7 PROCEDURE calculate_average_demand
8 ( p_plan_id IN NUMBER
9 , p_inventory_item_id IN NUMBER
10 , p_organization_id IN NUMBER
11 , p_sr_instance_id IN NUMBER
12 , p_customer_id IN NUMBER
13 , p_customer_site_id IN NUMBER
14 , p_forecast_horizon IN NUMBER
15 , p_vmi_forecast_type IN NUMBER
16 , p_item_uom_code IN varchar2
17 , p_old_average_daily_demand IN NUMBER
18 );
19
20 FUNCTION aps_to_sce(
21 p_tp_key IN NUMBER
22 , p_map_type IN NUMBER
23 , p_sr_instance_id IN NUMBER DEFAULT NULL
24 ) RETURN NUMBER;
25
26 -- This function is used to convert APS tp key to SCE company key
27 FUNCTION sce_to_aps(
28 p_company_key IN NUMBER
29 , p_map_type IN NUMBER
30 ) RETURN NUMBER;
31
32 PROCEDURE print_debug_info(
33 p_debug_info IN VARCHAR2
34 );
35
36 PROCEDURE print_user_info(
37 p_user_info IN VARCHAR2
38 );
39
40 END MSC_X_CVMI_PLANNING;
41