12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
17: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
17: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
17: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
16: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
17: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
17: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
18: p_priority IN jtf_prefab_policies_b.priority%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
19: p_description IN jtf_prefab_policies_tl.description%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
20: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
21: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
22: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
23: p_depth IN jtf_prefab_policies_b.depth%TYPE,
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
31:
24: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
31:
32: p_object_version_number OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
25: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
31:
32: p_object_version_number OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
33:
26: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
27: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
31:
32: p_object_version_number OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
28: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
29: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
30: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
31:
32: p_object_version_number OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2
40: l_api_version NUMBER := p_api_version;
41: l_row_id VARCHAR2(255) := NULL;
42:
43: CURSOR sequence_cursor IS
44: SELECT jtf_prefab_policies_b_s.NEXTVAL from dual;
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_POLICY;
48:
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196:
197: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
198: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196:
197: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
198: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196:
197: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
198: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
197: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
198: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
198: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
199: p_priority IN jtf_prefab_policies_b.priority%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
200: p_description IN jtf_prefab_policies_tl.description%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
201: p_enabled_flag IN jtf_prefab_policies_b.enabled_flag%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
202: p_application_id IN jtf_prefab_policies_b.application_id%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
203: p_all_applications_flag IN jtf_prefab_policies_b.all_applications_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
204: p_depth IN jtf_prefab_policies_b.depth%TYPE,
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
212:
205: p_all_responsibilities_flag IN jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
212:
213: p_object_version_number IN OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
206: p_all_users_flag IN jtf_prefab_policies_b.all_users_flag%TYPE,
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
212:
213: p_object_version_number IN OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
214:
207: p_refresh_interval IN jtf_prefab_policies_b.refresh_interval%TYPE,
208: p_interval_unit IN jtf_prefab_policies_b.interval_unit%TYPE,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
212:
213: p_object_version_number IN OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
214:
215: x_return_status OUT NOCOPY VARCHAR2,
209: p_start_time IN jtf_prefab_policies_b.start_time%TYPE,
210: p_end_time IN jtf_prefab_policies_b.end_time%TYPE,
211: p_run_always_flag IN jtf_prefab_policies_b.run_always_flag%TYPE,
212:
213: p_object_version_number IN OUT NOCOPY jtf_prefab_policies_b.object_version_number%TYPE,
214:
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340:
341: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
342:
343: p_object_version_number IN jtf_prefab_policies_b.object_version_number%TYPE,
344:
345: x_return_status OUT NOCOPY VARCHAR2,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340:
341: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
342:
343: p_object_version_number IN jtf_prefab_policies_b.object_version_number%TYPE,
344:
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2