PACKAGE: APPS.MSD_SALES_OPERATION_PLAN

Source

1 PACKAGE MSD_SALES_OPERATION_PLAN AUTHID CURRENT_USER AS
2 /* $Header: msdsopls.pls 120.1 2006/04/11 10:43:30 jarora noship $ */
3 
4 
5    C_DP         CONSTANT NUMBER := 1;
6    C_SOP        CONSTANT NUMBER := 2;
7    C_EOL        CONSTANT NUMBER := 3;
8 
9    C_CU         CONSTANT NUMBER := 1;
10    C_LT         CONSTANT NUMBER := 2;
11 
12    C_YES constant number := 1;
13    C_NO  constant number := 2;
14 
15    C_MSC_DEBUG   VARCHAR2(1)    := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
16 
17    C_NULL_DATE  CONSTANT DATE   :=   SYSDATE-36500;
18 
19 procedure msd_dp_pre_download_hook( errbuf   OUT NOCOPY VARCHAR2,
20 			            retcode  OUT NOCOPY NUMBER,
21                                     p_demand_plan_id IN NUMBER );
22 
23 procedure populate_bom (errbuf   OUT NOCOPY VARCHAR2,
24 			retcode  OUT NOCOPY NUMBER,
25                         p_demand_plan_id IN NUMBER);
26 
27 procedure populate_eol_bom (errbuf  OUT NOCOPY VARCHAR2,
28                             retcode OUT NOCOPY NUMBER,
29                             p_demand_plan_id IN NUMBER);
30 
31 function calculate_cu_and_lt ( p_cu_or_lt IN NUMBER,
32                                p_instance_id IN NUMBER,
33                                p_supply_plan_id IN NUMBER,
34                                p_assembly_pk IN VARCHAR2,
35                                p_component_pk IN VARCHAR2,
36                                p_res_comp IN VARCHAR2,
37                                p_effectivity_date DATE,
38                                p_disable_date DATE)
39 return number;
40 
41 function calc_eol_wur ( p_instance_id IN NUMBER,
42                         p_supply_plan_id IN NUMBER,
43                         p_assembly_pk IN VARCHAR2,
44                         p_component_pk IN VARCHAR2)
45 return number;
46 
47 function calc_eol_smb ( p_cu_or_lt IN NUMBER,
48                         p_instance_id IN NUMBER,
49                         p_supply_plan_id IN NUMBER,
50                         p_assembly_pk IN VARCHAR2,
51                         p_component_pk IN VARCHAR2)
52 return number;
53 
54 END MSD_SALES_OPERATION_PLAN ;