[Home] [Help]
PACKAGE: APPS.IEB_SERVICEPLAN_PVT
Source
1 PACKAGE IEB_ServicePlan_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEBSVPS.pls 115.4 2003/11/07 17:29:31 gpagadal noship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- IEB_ServicePlan_PVT
8 -- Purpose
9 -- To provide easy to use apis for Blending admin.
10 -- History
11 -- 02-July-2003 gpagadal Created.
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 PROCEDURE Create_ServicePlan( x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2,
20 p_plan_id OUT NOCOPY NUMBER,
21 p_name IN VARCHAR2,
22 p_desc IN VARCHAR2,
23 p_direction IN VARCHAR2,
24 p_media_type_id IN NUMBER
25 );
26 PROCEDURE Create_IOCoverages ( x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 rec_obj IN SYSTEM.IEB_SERVICE_COVERAGES_OBJ
30 );
31 PROCEDURE Update_IOCoverages ( x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 rec_obj IN SYSTEM.IEB_SERVICE_COVERAGES_OBJ
35 );
36
37 PROCEDURE Delete_IOCoverages ( x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_direction IN VARCHAR2,
41 p_plan_id IN VARCHAR2
42 );
43
44 PROCEDURE Create_RegionalPlan( x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_plan_id OUT NOCOPY NUMBER,
48 p_base_plan_id in NUMBER,
49 p_name IN VARCHAR2,
50 p_desc IN VARCHAR2,
51 p_direction IN VARCHAR2,
52 p_media_type_id IN NUMBER
53 );
54 PROCEDURE Create_GroupPlanMap( x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_plan_id in NUMBER,
58 p_server_group_id IN NUMBER
59 );
60
61 PROCEDURE Create_Classification( x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_svc_cat_id in NUMBER,
65 p_classfn_name in VARCHAR2
66 );
67 PROCEDURE Delete_Classification( x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_svc_plan_id in NUMBER,
71 p_media_type_id in NUMBER
72 );
73 PROCEDURE Delete_Category( x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_svc_plan_id in NUMBER,
77 p_media_type_id in NUMBER
78 );
79
80 PROCEDURE Delete_Service_Plan ( x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,x_service_plan_id IN NUMBER);
83 PROCEDURE Create_CampCategory( x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_svc_plan_id in NUMBER,
87 p_name in VARCHAR2,
88 p_media_type_id in NUMBER
89 );
90
91
92 PROCEDURE Create_ClassfnCategory( x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_cat_id OUT NOCOPY NUMBER,
96 p_svc_plan_id in NUMBER,
97 p_name in VARCHAR2,
98 p_media_type_id in NUMBER,
99 p_server_id IN NUMBER
100 );
101
102
103 PROCEDURE Update_Category ( x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_base_plan_id in NUMBER,
107 p_media_type_id in NUMBER,
108 p_reg_plan_id in NUMBER
109 );
110
111
112 PROCEDURE Delete_Regional_Plan ( x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_base_plan_id IN NUMBER,
116 p_reg_plan_id IN NUMBER );
117
118 PROCEDURE Delete_SpecDateCoverages ( x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_direction IN VARCHAR2,
122 p_plan_id IN VARCHAR2,
123 p_spec_date IN VARCHAR2
124 );
125
126
127 PROCEDURE Delete_Regional_PlanMaps ( x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_reg_plan_id IN NUMBER,
131 p_base_plan_id IN NUMBER,
132 p_media_type_id IN NUMBER);
133
134 -- ===============================================================
135 -- Start of Comments
136 -- ===============================================================
137 -- API Name
138 -- Create_ServiceLevel
139 -- Type
140 -- Private
141 -- Pre-Req
142 --
143 -- Parameters
144 --
145 -- IN
146 --
147 -- rec_obj IN SYSTEM.IEU_WP_MACT_OBJ Required
148 -- is_create IN VARCHAR2 Required
149 --
150 --
151 -- OUT
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 --
156 -- End of Comments
157 -- ===============================================================
158
159
160 PROCEDURE Create_ServiceLevel ( x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 rec_obj IN SYSTEM.IEB_SERVICE_LEVELS_OBJ
164 );
165
166
167
168 PROCEDURE Update_ServiceLevel ( x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 rec_obj IN SYSTEM.IEB_SERVICE_LEVELS_OBJ
172 );
173
174
175 -- ===============================================================
176 -- Start of Comments
177 -- ===============================================================
178 -- API Name
179 -- Delete_Service_Level
180 -- Type
181 -- Private
182 -- Pre-Req
183 --
184 -- Parameters
185 --
186 -- IN
187 --
188 -- x_service_level_id IN NUMBER Required
189 --
190 -- End of Comments
191 -- ===============================================================
192
193 PROCEDURE Delete_Service_Level ( x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2, x_service_level_id IN NUMBER);
196
197
198
199
200 END IEB_ServicePlan_PVT;
201