PACKAGE: APPS.FLM_MMM_CALCULATION

Source

1 PACKAGE flm_mmm_calculation AS
2 /* $Header: FLMMMMCS.pls 120.0.12000000.1 2007/01/19 09:30:36 appldev ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA   |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : FLMMMMCS.pls                                               |
9 | DESCRIPTION  : This package contains functions used to calculate values   |
10 |                for the New Mixed Model Map Form		            |
11 | Coders       : Liye Ma 	(01/09/02 - 03/30/02)                       |
12 |    		 Hadi Wenas 	(04/01/02 - present )                       |
13 +===========================================================================*/
14 
15 -- Constants
16 C_DEMAND_TYPE_FORECAST	CONSTANT NUMBER	:= 1;
17 C_DEMAND_TYPE_MDS	CONSTANT NUMBER	:= 2;
18 C_DEMAND_TYPE_MPS	CONSTANT NUMBER	:= 3;
19 C_DEMAND_TYPE_AP	CONSTANT NUMBER	:= 4;
20 C_DEMAND_TYPE_SO	CONSTANT NUMBER := 5;
21 C_DEMAND_TYPE_PO	CONSTANT NUMBER := 6;
22 
23 C_REPLAN_FLAG_YES	CONSTANT VARCHAR2(5) := 'YES';
24 C_REPLAN_FLAG_NO	CONSTANT VARCHAR2(5) := 'NO';
25 
26 C_ERROR_CODE_SUCCESS	CONSTANT NUMBER := 0;
27 C_ERROR_CODE_FAILURE	CONSTANT NUMBER := 1;
28 
29 C_BUCKET_DAYS		CONSTANT NUMBER := 1;
30 C_BUCKET_WEEKS		CONSTANT NUMBER := 2;
31 C_BUCKET_PERIODS	CONSTANT NUMBER := 3;
32 
33 C_CALC_OPTION_NO_IPK		CONSTANT NUMBER	:= 1;
34 C_CALC_OPTION_ONE_RESOURCE	CONSTANT NUMBER	:= 2;
35 C_CALC_OPTION_RES_ASSIGNED	CONSTANT NUMBER	:= 3;
36 C_CALC_OPTION_IPK_ASSIGNED	CONSTANT NUMBER	:= 4;
37 
38 -- Types
39 TYPE t_demand_rec IS RECORD (
40 	assembly_item_id	NUMBER,
41 	line_id			NUMBER,
42 	average_daily_demand	NUMBER);
43 
44 TYPE t_demand_table IS TABLE OF t_demand_rec
45 	INDEX BY BINARY_INTEGER;
46 
47 -- Public Functions
48 FUNCTION get_offset_date (i_organization_id	IN NUMBER,
49 			  i_start_date          IN DATE,
50                 	  i_bucket_type         IN NUMBER
51 	) RETURN DATE;
52 
53 -- Public Procedures
54 PROCEDURE calculate(
55 	i_plan_id			IN	NUMBER,
56 	i_organization_id		IN	NUMBER,
57 	i_calculation_operation_type	IN	NUMBER,
58 	i_product_family_id		IN	NUMBER,
59 	i_line_id			IN	NUMBER,
60 	i_demand_type			IN	NUMBER,
61 	i_demand_code			IN	VARCHAR2,
62 	i_start_date			IN	DATE,
63 	i_end_date			IN	DATE,
64 	i_demand_days			IN	NUMBER,
65 	i_hours_per_day			IN	NUMBER,
66 	i_boost_percent			IN	NUMBER,
67 	i_calculation_option		IN	NUMBER,
68 	i_calendar_code			IN	VARCHAR2,
69     	i_exception_set_id  		IN	NUMBER,
70     	i_last_calendar_date 		IN	DATE,
71 	i_replan_flag			IN	VARCHAR2,
72 	o_error_code			OUT NOCOPY	NUMBER,
73 	o_error_msg			OUT NOCOPY	VARCHAR2);
74 
75 PROCEDURE recalculate(
76 	i_plan_id			IN	NUMBER,
77 	i_organization_id		IN	NUMBER,
78 	i_calculation_operation_type	IN	NUMBER,
79 	i_calculation_option		IN	NUMBER,
80 	i_standard_operation_id		IN	NUMBER,
81 	o_error_code			OUT NOCOPY	NUMBER,
82 	o_error_msg			OUT NOCOPY	VARCHAR2);
83 
84 PROCEDURE update_assigned_with_needed(
85 	i_plan_id		IN	NUMBER,
86 	i_organization_id	IN	NUMBER,
87 	i_line_id		IN	NUMBER,
88 	i_standard_operation_id	IN	NUMBER,
89 	i_resource_id		IN	NUMBER,
90 	i_calc_op_type		IN	NUMBER,
91 	o_error_code		OUT NOCOPY	NUMBER);
92 
93 PROCEDURE save(
94 	i_plan_id		IN	NUMBER,
95 	i_organization_id	IN	NUMBER,
96 	i_operation_type	IN	NUMBER);
97 
98 END flm_mmm_calculation;