[Home] [Help]
PACKAGE: APPS.JTF_PREFAB_POLICY_PUB
Source
1 PACKAGE JTF_PREFAB_POLICY_PUB AUTHID CURRENT_USER as
2 /* $Header: jtfprefabpos.pls 120.4 2005/10/28 01:24:01 emekala ship $ */
3
4 PROCEDURE INSERT_POLICY(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8
9 p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
10 p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
11 p_priority IN jtf_prefab_policies_b.priority%TYPE,
12 p_description IN jtf_prefab_policies_tl.description%TYPE,
13 p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
14 p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
15 p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
16 p_depth IN jtf_prefab_policies_b.depth%TYPE,
17 p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
18 p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
19 p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
20 p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
21 p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
22 p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
23 p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
24
25 p_object_version_number OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
26
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE UPDATE_POLICY(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36
37 p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
38 p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
39 p_priority IN jtf_prefab_policies_b.priority%TYPE,
40 p_description IN jtf_prefab_policies_tl.description%TYPE,
41 p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
42 p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
43 p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
44 p_depth IN jtf_prefab_policies_b.depth%TYPE,
45 p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
46 p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
47 p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
48 p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
49 p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
50 p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
51 p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
52
53 p_object_version_number IN OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
54
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 procedure DELETE_POLICY(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64
65 p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
66
67 p_object_version_number IN jtf_prefab_policies_b.object_version_number%TYPE,
68
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE INSERT_UR_POLICY(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77 p_commit IN VARCHAR2 := FND_API.G_FALSE,
78
79 p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
80 p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
81 p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
82
83 p_object_version_number OUT NOCOPY jtf_prefab_ur_policies.object_version_number%TYPE,
84
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE DELETE_UR_POLICY (
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94
95 p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
96 p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
97 p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
98
99 p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
100
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE DELETE_UR_POLICY (
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110
111 p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
112
113 p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE CONFIGURE_SYS_POLICY (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124
125 p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
126 p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
127 p_memory IN jtf_prefab_sys_policies.memory%TYPE,
128 p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
129 p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
130 p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
131 p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
132 p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
133 p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
134 p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
135
136 p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE INSERT_WSH_POLICY(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146
147 p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
148 p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
149 p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
150 p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
151 p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
152 p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
153 p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
154 p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
155
156 p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
157
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 PROCEDURE UPDATE_WSH_POLICY(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167
168 p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
169 p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
170 p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
171 p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
172 p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
173 p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
174 p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
175 p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
176
177 p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
178
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2
182 );
183
184 procedure DELETE_WSH_POLICY(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187 p_commit IN VARCHAR2 := FND_API.G_FALSE,
188
189 p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
190
191 p_object_version_number IN jtf_prefab_wsh_poes_b.object_version_number%TYPE,
192
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2
196 );
197
198 PROCEDURE INSERT_WSHP_POLICY(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202
203 p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
204 p_port IN jtf_prefab_wshp_policies.port%TYPE,
205
206 p_object_version_number OUT NOCOPY jtf_prefab_wshp_policies.object_version_number%TYPE,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213 PROCEDURE DELETE_WSHP_POLICY (
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216 p_commit IN VARCHAR2 := FND_API.G_FALSE,
217
218 p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
219 p_port IN jtf_prefab_wshp_policies.port%TYPE,
220
221 p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
222
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2
226 );
227
228 PROCEDURE DELETE_WSHP_POLICY (
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231 p_commit IN VARCHAR2 := FND_API.G_FALSE,
232
233 p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
234
235 p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
236
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2
240 );
241
242 END JTF_PREFAB_POLICY_PUB;