5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
22: procedure create_group_1(p_init_msg_list VARCHAR2
23: , x_return_status out nocopy VARCHAR2
24: , x_msg_count out nocopy NUMBER
25: , x_msg_data out nocopy VARCHAR2
26: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
23: , x_return_status out nocopy VARCHAR2
24: , x_msg_count out nocopy NUMBER
25: , x_msg_data out nocopy VARCHAR2
26: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
31: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
24: , x_msg_count out nocopy NUMBER
25: , x_msg_data out nocopy VARCHAR2
26: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
31: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
32: )
25: , x_msg_data out nocopy VARCHAR2
26: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
31: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
32: )
33:
26: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
31: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
32: )
33:
34: as
27: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
28: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
29: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
30: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
31: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
32: )
33:
34: as
35: ddp_dss_group hz_dss_groups_pub.dss_group_rec_type;
66: , x_object_version_number in out nocopy NUMBER
67: , x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER
69: , x_msg_data out nocopy VARCHAR2
70: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
67: , x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER
69: , x_msg_data out nocopy VARCHAR2
70: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
68: , x_msg_count out nocopy NUMBER
69: , x_msg_data out nocopy VARCHAR2
70: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
76: )
69: , x_msg_data out nocopy VARCHAR2
70: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
76: )
77:
70: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
76: )
77:
78: as
71: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
72: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
76: )
77:
78: as
79: ddp_dss_group hz_dss_groups_pub.dss_group_rec_type;
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p1_a0 NUMBER := 0-1962.0724
118: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p1_a0 NUMBER := 0-1962.0724
118: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
116: , x_msg_data out nocopy VARCHAR2
117: , p1_a0 NUMBER := 0-1962.0724
118: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
117: , p1_a0 NUMBER := 0-1962.0724
118: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
118: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
126: )
119: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
126: )
127:
120: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
126: )
127:
128: as
121: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
126: )
127:
128: as
129: ddp_dss_secured_criterion hz_dss_groups_pub.dss_secured_criterion_type;
167: , x_return_status out nocopy VARCHAR2
168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2
170: , p1_a0 NUMBER := 0-1962.0724
171: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
172: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
174: )
175:
168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2
170: , p1_a0 NUMBER := 0-1962.0724
171: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
172: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
174: )
175:
176: as
169: , x_msg_data out nocopy VARCHAR2
170: , p1_a0 NUMBER := 0-1962.0724
171: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
172: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
173: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
174: )
175:
176: as
177: ddp_dss_secured_module hz_dss_groups_pub.dss_secured_module_type;
210: , x_return_status out nocopy VARCHAR2
211: , x_msg_count out nocopy NUMBER
212: , x_msg_data out nocopy VARCHAR2
213: , p1_a0 NUMBER := 0-1962.0724
214: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
216: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
217: )
218:
211: , x_msg_count out nocopy NUMBER
212: , x_msg_data out nocopy VARCHAR2
213: , p1_a0 NUMBER := 0-1962.0724
214: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
216: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
217: )
218:
219: as
212: , x_msg_data out nocopy VARCHAR2
213: , p1_a0 NUMBER := 0-1962.0724
214: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
216: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
217: )
218:
219: as
220: ddp_dss_secured_module hz_dss_groups_pub.dss_secured_module_type;
253: , x_return_status out nocopy VARCHAR2
254: , x_msg_count out nocopy NUMBER
255: , x_msg_data out nocopy VARCHAR2
256: , p1_a0 NUMBER := 0-1962.0724
257: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
258: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
259: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
260: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
261: )
254: , x_msg_count out nocopy NUMBER
255: , x_msg_data out nocopy VARCHAR2
256: , p1_a0 NUMBER := 0-1962.0724
257: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
258: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
259: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
260: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
261: )
262:
255: , x_msg_data out nocopy VARCHAR2
256: , p1_a0 NUMBER := 0-1962.0724
257: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
258: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
259: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
260: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
261: )
262:
263: as
256: , p1_a0 NUMBER := 0-1962.0724
257: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
258: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
259: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
260: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
261: )
262:
263: as
264: ddp_dss_secured_class hz_dss_groups_pub.dss_secured_class_type;
298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p1_a0 NUMBER := 0-1962.0724
302: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p1_a0 NUMBER := 0-1962.0724
302: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
300: , x_msg_data out nocopy VARCHAR2
301: , p1_a0 NUMBER := 0-1962.0724
302: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a0 NUMBER := 0-1962.0724
302: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
302: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
310: )
303: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
310: )
311:
304: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
310: )
311:
312: as
305: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
306: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
307: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
308: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
309: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
310: )
311:
312: as
313: ddp_dss_secured_criterion hz_dss_groups_pub.dss_secured_criterion_type;
351: , x_return_status out nocopy VARCHAR2
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p1_a0 NUMBER := 0-1962.0724
355: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
356: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
357: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
359: )
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p1_a0 NUMBER := 0-1962.0724
355: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
356: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
357: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
359: )
360:
353: , x_msg_data out nocopy VARCHAR2
354: , p1_a0 NUMBER := 0-1962.0724
355: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
356: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
357: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
359: )
360:
361: as
354: , p1_a0 NUMBER := 0-1962.0724
355: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
356: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
357: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
359: )
360:
361: as
362: ddp_dss_secured_class hz_dss_groups_pub.dss_secured_class_type;
396: , x_return_status out nocopy VARCHAR2
397: , x_msg_count out nocopy NUMBER
398: , x_msg_data out nocopy VARCHAR2
399: , p1_a0 NUMBER := 0-1962.0724
400: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a2 NUMBER := 0-1962.0724
402: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
403: )
404:
398: , x_msg_data out nocopy VARCHAR2
399: , p1_a0 NUMBER := 0-1962.0724
400: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
401: , p1_a2 NUMBER := 0-1962.0724
402: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
403: )
404:
405: as
406: ddp_dss_secured_rel_type hz_dss_groups_pub.dss_secured_rel_type;
439: , x_return_status out nocopy VARCHAR2
440: , x_msg_count out nocopy NUMBER
441: , x_msg_data out nocopy VARCHAR2
442: , p1_a0 NUMBER := 0-1962.0724
443: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a2 NUMBER := 0-1962.0724
445: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
446: )
447:
441: , x_msg_data out nocopy VARCHAR2
442: , p1_a0 NUMBER := 0-1962.0724
443: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a2 NUMBER := 0-1962.0724
445: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
446: )
447:
448: as
449: ddp_dss_secured_rel_type hz_dss_groups_pub.dss_secured_rel_type;
481: , x_assignment_id out nocopy NUMBER
482: , x_return_status out nocopy VARCHAR2
483: , x_msg_count out nocopy NUMBER
484: , x_msg_data out nocopy VARCHAR2
485: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
482: , x_return_status out nocopy VARCHAR2
483: , x_msg_count out nocopy NUMBER
484: , x_msg_data out nocopy VARCHAR2
485: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
483: , x_msg_count out nocopy NUMBER
484: , x_msg_data out nocopy VARCHAR2
485: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
484: , x_msg_data out nocopy VARCHAR2
485: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
494: )
487: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
494: )
495:
488: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
494: )
495:
496: as
489: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
494: )
495:
496: as
497: ddp_dss_assignment hz_dss_groups_pub.dss_assignment_type;
534: , x_dss_instance_set_id out nocopy NUMBER
535: , x_return_status out nocopy VARCHAR2
536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2
538: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
539: , p1_a1 NUMBER := 0-1962.0724
540: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
541: )
542:
536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2
538: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
539: , p1_a1 NUMBER := 0-1962.0724
540: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
541: )
542:
543: as
544: ddp_dss_secured_entity hz_dss_groups_pub.dss_secured_entity_type;
575: , x_object_version_number in out nocopy NUMBER
576: , x_return_status out nocopy VARCHAR2
577: , x_msg_count out nocopy NUMBER
578: , x_msg_data out nocopy VARCHAR2
579: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
580: , p1_a1 NUMBER := 0-1962.0724
581: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
582: )
583:
577: , x_msg_count out nocopy NUMBER
578: , x_msg_data out nocopy VARCHAR2
579: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
580: , p1_a1 NUMBER := 0-1962.0724
581: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
582: )
583:
584: as
585: ddp_dss_secured_entity hz_dss_groups_pub.dss_secured_entity_type;