DBA Data[Home] [Help]

PACKAGE: APPS.MSC_X_CVMI_PLANNING

Source


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