1 PACKAGE MSD_APPLY_TEMPLATE_DEMAND_PLAN AS
2 /* $Header: msdatdps.pls 120.3 2006/03/31 06:16:33 brampall noship $ */
3
4 /* Public Procedures */
5
6 function apply_template(
7 p_new_dp_id in out nocopy number,
8 p_target_demand_plan_name in VARCHAR2,
9 p_target_demand_plan_descr in VARCHAR2,
10 p_shared_db_location in VARCHAR2,
11 p_source_dp_id in NUMBER,
12 p_organization_id in number,
13 p_instance_id in number,
14 p_errcode in out nocopy varchar2
15 ) return NUMBER;
16
17
18 function create_plan_using_template(
19 p_new_dp_id in out nocopy number,
20 p_target_demand_plan_name in VARCHAR2,
21 p_target_demand_plan_descr in VARCHAR2,
22 p_plan_type in VARCHAR2,
23 p_plan_start_date in date,
24 p_plan_end_date in date,
25 p_supply_plan_id in number,
26 p_supply_plan_name in VARCHAR2,
27 p_organization_id in number,
28 p_instance_id in number,
29 p_errcode in out nocopy varchar2
30 ) return boolean;
31
32 procedure remove_dimension(
33 p_demand_plan_id in number,
34 p_dimension_code in varchar2,
35 p_dp_dimension_code in varchar2);
36
37 procedure remove_parameter(
38 p_demand_plan_id in number,
39 p_parameter_id in number);
40
41 procedure remove_scenario(
42 p_demand_plan_id in number,
43 p_scenario_id in number);
44
45 procedure remove_scenario_event(
46 p_demand_plan_id in number,
47 p_scenario_id in number,
48 p_event_id in number);
49
50 procedure remove_scenario_output_lvl(
51 p_demand_plan_id in number,
52 p_scenario_id in number,
53 p_level_id in number);
54
55 procedure remove_event(
56 p_demand_plan_id in number,
57 p_dp_event_id in number);
58
59 procedure remove_price_list(
60 p_demand_plan_id in number,
61 p_dp_price_list_id in number);
62
63 procedure remove_calendar(
64 p_demand_plan_id in number,
65 p_calendar_type in varchar2,
66 p_calendar_code in varchar2);
67
68 procedure remove_hierarchy(
69 p_demand_plan_id in number,
70 p_dp_dimension_code in varchar2,
71 p_hierarchy_id in number);
72
73 procedure add_dimension(
74 p_demand_plan_id in number,
75 p_dimension_code in varchar2,
76 p_dp_dimension_code in varchar2);
77
78 procedure add_parameter(
79 p_demand_plan_id in number,
80 p_parameter_type in varchar2,
81 p_parameter_name in varchar2);
82
83
84 procedure add_scenario(
85 p_demand_plan_id in number,
86 p_scenario_name in varchar2);
87
88 procedure add_event(
89 p_demand_plan_id in number,
90 p_event_id in number);
91
92 procedure add_price_list(
93 p_demand_plan_id in number,
94 p_dp_price_list_id in number); /*--Bug # 4549068-- Instead of price_list_name, price_list_id will be passed.---*/
95
96 procedure add_calendar(
97 p_demand_plan_id in number,
98 p_calendar_type in varchar2,
99 p_calendar_code in varchar2);
100
101 procedure add_hierarchy(
102 p_demand_plan_id in number,
103 p_dp_dimension_code in varchar2,
104 p_hierarchy_id in number);
105
106 procedure add_scenario_event(
107 p_demand_plan_id in number,
108 p_scenario_id in number,
109 p_event_id in number);
110
111 procedure add_scenario_output_lvl(
112 p_demand_plan_id in number,
113 p_scenario_id in number,
114 p_level_id in number);
115
116 procedure change_output_period(
117 p_demand_plan_id in varchar2,
118 p_scenario_id in varchar2,
119 p_output_period_type_id in varchar2,
120 p_old_output_period_type_id in varchar2);
121
122 procedure change_hierarchy(
123 p_demand_plan_id in varchar2,
124 p_hierarchy_id in varchar2,
125 p_old_hierarchy_id in varchar2);
126
127 procedure change_output_level(
128 p_demand_plan_id in varchar2,
129 p_scenario_id in varchar2,
130 p_level_id in varchar2,
131 p_old_level_id in varchar2);
132
133 procedure change_scenario_stream(
134 p_demand_plan_id in varchar2,
135 p_scenario_id in varchar2,
136 p_stream_type in varchar2,
137 p_stream_name in varchar2,
138 p_old_stream_type in varchar2,
139 p_old_stream_name in varchar2);
140
141 Procedure create_seeded_definitions(p_demand_plan_id in number,
142 p_errcode in out nocopy varchar2
143 );
144
145 -- Bug 4729854
146 Procedure attach_supply_plan(p_new_dp_id in number,p_supply_plan_id in number,p_supply_plan_name in varchar2,p_old_supply_plan_id in number default null, p_old_supply_plan_name in varchar2 default null);
147
148 Procedure add_ascp_scenario(p_new_dp_id in number,p_supply_plan_id in number, p_supply_plan_name in varchar2);
149
150 Procedure add_ascp_input_parameter(p_new_dp_id in number,p_supply_plan_id in number,p_supply_plan_name in varchar2, p_old_supply_plan_id in number default null,p_old_supply_plan_name in varchar2 default null);
151
152 Procedure add_ascp_formula(p_new_dp_id in number,p_supply_plan_id in number, p_supply_plan_name in varchar2,p_old_supply_plan_id in number default null, p_old_supply_plan_name in varchar2 default null);
153
154 Procedure add_ascp_measure(p_new_dp_id in number,p_supply_plan_id in number, p_supply_plan_name in varchar2,p_old_supply_plan_id in number default null, p_old_supply_plan_name in varchar2 default null);
155
156 Procedure set_prd_lvl_for_liab_reports(p_demand_plan_id in number, p_errcode in out nocopy varchar2);
157
158 --Function get_supply_plan_name(p_supply_plan_id in number) return varchar2; -- Bug 4729854
159
160 Function get_supply_plan_start_date(p_supply_plan_id in number) return date;
161
162 Function get_supply_plan_end_date(p_supply_plan_id in number) return date;
163
164 Function get_parameter_id(p_demand_plan_id in number, p_parameter_type in varchar2, p_parameter_name in varchar2, p_parameter_component in varchar2) return number;
165
166 Function get_formula_id(p_demand_plan_id in number, p_formula_name in varchar2, p_supply_plan_name in varchar2) return number;
167
168 Function get_calendar_code(p_demand_plan_id in number,p_old_output_period_type_id in number) return varchar2;
169
170 Procedure replace_associate_parameters(p_new_dp_id in number);
171
172 procedure replace_parameter_tokens(p_demand_plan_id number);
173
174 END MSD_APPLY_TEMPLATE_DEMAND_PLAN ;
[Home] [Help]