1: package jtf_assign_pub_w AUTHID CURRENT_USER as
2: /* $Header: jtfampws.pls 120.2 2006/06/27 12:02:18 abraina ship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
9: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
9: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_DATE_TABLE
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
9: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_DATE_TABLE
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
14: );
15:
16: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
14: );
15:
16: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
14: );
15:
16: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_200
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_200
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_DATE_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_DATE_TABLE
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_DATE_TABLE
64: , a20 out nocopy JTF_DATE_TABLE
65: , a21 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_DATE_TABLE
64: , a20 out nocopy JTF_DATE_TABLE
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_200
67: , a23 out nocopy JTF_VARCHAR2_TABLE_100
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_DATE_TABLE
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_200
67: , a23 out nocopy JTF_VARCHAR2_TABLE_100
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98: , a1 JTF_VARCHAR2_TABLE_100
99: );
100: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96:
97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98: , a1 JTF_VARCHAR2_TABLE_100
99: );
100: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: );
103:
104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
100: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: );
103:
104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105: , a1 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103:
104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105: , a1 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: );
110:
111: procedure get_assign_resources(p_api_version NUMBER
136: , p_column_list VARCHAR2
137: , p_business_process_id NUMBER
138: , p_business_process_date date
139: , p_filter_excluded_resource VARCHAR2
140: , p32_a0 out nocopy JTF_NUMBER_TABLE
141: , p32_a1 out nocopy JTF_NUMBER_TABLE
142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
137: , p_business_process_id NUMBER
138: , p_business_process_date date
139: , p_filter_excluded_resource VARCHAR2
140: , p32_a0 out nocopy JTF_NUMBER_TABLE
141: , p32_a1 out nocopy JTF_NUMBER_TABLE
142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
145: , p32_a5 out nocopy JTF_DATE_TABLE
142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
145: , p32_a5 out nocopy JTF_DATE_TABLE
146: , p32_a6 out nocopy JTF_NUMBER_TABLE
147: , p32_a7 out nocopy JTF_NUMBER_TABLE
148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
145: , p32_a5 out nocopy JTF_DATE_TABLE
146: , p32_a6 out nocopy JTF_NUMBER_TABLE
147: , p32_a7 out nocopy JTF_NUMBER_TABLE
148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
145: , p32_a5 out nocopy JTF_DATE_TABLE
146: , p32_a6 out nocopy JTF_NUMBER_TABLE
147: , p32_a7 out nocopy JTF_NUMBER_TABLE
148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
146: , p32_a6 out nocopy JTF_NUMBER_TABLE
147: , p32_a7 out nocopy JTF_NUMBER_TABLE
148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , p32_a19 out nocopy JTF_DATE_TABLE
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , p32_a19 out nocopy JTF_DATE_TABLE
160: , p32_a20 out nocopy JTF_DATE_TABLE
161: , p32_a21 out nocopy JTF_NUMBER_TABLE
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , p32_a19 out nocopy JTF_DATE_TABLE
160: , p32_a20 out nocopy JTF_DATE_TABLE
161: , p32_a21 out nocopy JTF_NUMBER_TABLE
162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164: , p32_a24 out nocopy JTF_NUMBER_TABLE
165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
160: , p32_a20 out nocopy JTF_DATE_TABLE
161: , p32_a21 out nocopy JTF_NUMBER_TABLE
162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164: , p32_a24 out nocopy JTF_NUMBER_TABLE
165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
166: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2
168: , x_msg_count out nocopy NUMBER
364: , p_column_list VARCHAR2
365: , p_business_process_id NUMBER
366: , p_business_process_date date
367: , p_filter_excluded_resource VARCHAR2
368: , p20_a0 out nocopy JTF_NUMBER_TABLE
369: , p20_a1 out nocopy JTF_NUMBER_TABLE
370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
365: , p_business_process_id NUMBER
366: , p_business_process_date date
367: , p_filter_excluded_resource VARCHAR2
368: , p20_a0 out nocopy JTF_NUMBER_TABLE
369: , p20_a1 out nocopy JTF_NUMBER_TABLE
370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
373: , p20_a5 out nocopy JTF_DATE_TABLE
370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
373: , p20_a5 out nocopy JTF_DATE_TABLE
374: , p20_a6 out nocopy JTF_NUMBER_TABLE
375: , p20_a7 out nocopy JTF_NUMBER_TABLE
376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
373: , p20_a5 out nocopy JTF_DATE_TABLE
374: , p20_a6 out nocopy JTF_NUMBER_TABLE
375: , p20_a7 out nocopy JTF_NUMBER_TABLE
376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
373: , p20_a5 out nocopy JTF_DATE_TABLE
374: , p20_a6 out nocopy JTF_NUMBER_TABLE
375: , p20_a7 out nocopy JTF_NUMBER_TABLE
376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
374: , p20_a6 out nocopy JTF_NUMBER_TABLE
375: , p20_a7 out nocopy JTF_NUMBER_TABLE
376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387: , p20_a19 out nocopy JTF_DATE_TABLE
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387: , p20_a19 out nocopy JTF_DATE_TABLE
388: , p20_a20 out nocopy JTF_DATE_TABLE
389: , p20_a21 out nocopy JTF_NUMBER_TABLE
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387: , p20_a19 out nocopy JTF_DATE_TABLE
388: , p20_a20 out nocopy JTF_DATE_TABLE
389: , p20_a21 out nocopy JTF_NUMBER_TABLE
390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392: , p20_a24 out nocopy JTF_NUMBER_TABLE
393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
388: , p20_a20 out nocopy JTF_DATE_TABLE
389: , p20_a21 out nocopy JTF_NUMBER_TABLE
390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392: , p20_a24 out nocopy JTF_NUMBER_TABLE
393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
394: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
395: , x_return_status out nocopy VARCHAR2
396: , x_msg_count out nocopy NUMBER
421: , p_column_list VARCHAR2
422: , p_business_process_id NUMBER
423: , p_business_process_date date
424: , p_filter_excluded_resource VARCHAR2
425: , p27_a0 out nocopy JTF_NUMBER_TABLE
426: , p27_a1 out nocopy JTF_NUMBER_TABLE
427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
422: , p_business_process_id NUMBER
423: , p_business_process_date date
424: , p_filter_excluded_resource VARCHAR2
425: , p27_a0 out nocopy JTF_NUMBER_TABLE
426: , p27_a1 out nocopy JTF_NUMBER_TABLE
427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
430: , p27_a5 out nocopy JTF_DATE_TABLE
427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
430: , p27_a5 out nocopy JTF_DATE_TABLE
431: , p27_a6 out nocopy JTF_NUMBER_TABLE
432: , p27_a7 out nocopy JTF_NUMBER_TABLE
433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
430: , p27_a5 out nocopy JTF_DATE_TABLE
431: , p27_a6 out nocopy JTF_NUMBER_TABLE
432: , p27_a7 out nocopy JTF_NUMBER_TABLE
433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
430: , p27_a5 out nocopy JTF_DATE_TABLE
431: , p27_a6 out nocopy JTF_NUMBER_TABLE
432: , p27_a7 out nocopy JTF_NUMBER_TABLE
433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
431: , p27_a6 out nocopy JTF_NUMBER_TABLE
432: , p27_a7 out nocopy JTF_NUMBER_TABLE
433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444: , p27_a19 out nocopy JTF_DATE_TABLE
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444: , p27_a19 out nocopy JTF_DATE_TABLE
445: , p27_a20 out nocopy JTF_DATE_TABLE
446: , p27_a21 out nocopy JTF_NUMBER_TABLE
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444: , p27_a19 out nocopy JTF_DATE_TABLE
445: , p27_a20 out nocopy JTF_DATE_TABLE
446: , p27_a21 out nocopy JTF_NUMBER_TABLE
447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449: , p27_a24 out nocopy JTF_NUMBER_TABLE
450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
445: , p27_a20 out nocopy JTF_DATE_TABLE
446: , p27_a21 out nocopy JTF_NUMBER_TABLE
447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449: , p27_a24 out nocopy JTF_NUMBER_TABLE
450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
451: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
452: , x_return_status out nocopy VARCHAR2
453: , x_msg_count out nocopy NUMBER
522: , p_territory_flag VARCHAR2
523: , p_calendar_flag VARCHAR2
524: , p_business_process_id NUMBER
525: , p_business_process_date date
526: , p15_a0 out nocopy JTF_NUMBER_TABLE
527: , p15_a1 out nocopy JTF_NUMBER_TABLE
528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
523: , p_calendar_flag VARCHAR2
524: , p_business_process_id NUMBER
525: , p_business_process_date date
526: , p15_a0 out nocopy JTF_NUMBER_TABLE
527: , p15_a1 out nocopy JTF_NUMBER_TABLE
528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
531: , p15_a5 out nocopy JTF_DATE_TABLE
528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
531: , p15_a5 out nocopy JTF_DATE_TABLE
532: , p15_a6 out nocopy JTF_NUMBER_TABLE
533: , p15_a7 out nocopy JTF_NUMBER_TABLE
534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
531: , p15_a5 out nocopy JTF_DATE_TABLE
532: , p15_a6 out nocopy JTF_NUMBER_TABLE
533: , p15_a7 out nocopy JTF_NUMBER_TABLE
534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
531: , p15_a5 out nocopy JTF_DATE_TABLE
532: , p15_a6 out nocopy JTF_NUMBER_TABLE
533: , p15_a7 out nocopy JTF_NUMBER_TABLE
534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
532: , p15_a6 out nocopy JTF_NUMBER_TABLE
533: , p15_a7 out nocopy JTF_NUMBER_TABLE
534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545: , p15_a19 out nocopy JTF_DATE_TABLE
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545: , p15_a19 out nocopy JTF_DATE_TABLE
546: , p15_a20 out nocopy JTF_DATE_TABLE
547: , p15_a21 out nocopy JTF_NUMBER_TABLE
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545: , p15_a19 out nocopy JTF_DATE_TABLE
546: , p15_a20 out nocopy JTF_DATE_TABLE
547: , p15_a21 out nocopy JTF_NUMBER_TABLE
548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550: , p15_a24 out nocopy JTF_NUMBER_TABLE
551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
546: , p15_a20 out nocopy JTF_DATE_TABLE
547: , p15_a21 out nocopy JTF_NUMBER_TABLE
548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550: , p15_a24 out nocopy JTF_NUMBER_TABLE
551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
552: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
618: , p_territory_flag VARCHAR2
619: , p_calendar_flag VARCHAR2
620: , p_business_process_id NUMBER
621: , p_business_process_date date
622: , p15_a0 out nocopy JTF_NUMBER_TABLE
623: , p15_a1 out nocopy JTF_NUMBER_TABLE
624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
619: , p_calendar_flag VARCHAR2
620: , p_business_process_id NUMBER
621: , p_business_process_date date
622: , p15_a0 out nocopy JTF_NUMBER_TABLE
623: , p15_a1 out nocopy JTF_NUMBER_TABLE
624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
627: , p15_a5 out nocopy JTF_DATE_TABLE
624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
627: , p15_a5 out nocopy JTF_DATE_TABLE
628: , p15_a6 out nocopy JTF_NUMBER_TABLE
629: , p15_a7 out nocopy JTF_NUMBER_TABLE
630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
627: , p15_a5 out nocopy JTF_DATE_TABLE
628: , p15_a6 out nocopy JTF_NUMBER_TABLE
629: , p15_a7 out nocopy JTF_NUMBER_TABLE
630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
627: , p15_a5 out nocopy JTF_DATE_TABLE
628: , p15_a6 out nocopy JTF_NUMBER_TABLE
629: , p15_a7 out nocopy JTF_NUMBER_TABLE
630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
628: , p15_a6 out nocopy JTF_NUMBER_TABLE
629: , p15_a7 out nocopy JTF_NUMBER_TABLE
630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641: , p15_a19 out nocopy JTF_DATE_TABLE
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641: , p15_a19 out nocopy JTF_DATE_TABLE
642: , p15_a20 out nocopy JTF_DATE_TABLE
643: , p15_a21 out nocopy JTF_NUMBER_TABLE
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641: , p15_a19 out nocopy JTF_DATE_TABLE
642: , p15_a20 out nocopy JTF_DATE_TABLE
643: , p15_a21 out nocopy JTF_NUMBER_TABLE
644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646: , p15_a24 out nocopy JTF_NUMBER_TABLE
647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
642: , p15_a20 out nocopy JTF_DATE_TABLE
643: , p15_a21 out nocopy JTF_NUMBER_TABLE
644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646: , p15_a24 out nocopy JTF_NUMBER_TABLE
647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
648: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
649: , x_return_status out nocopy VARCHAR2
650: , x_msg_count out nocopy NUMBER
711: , p_territory_flag VARCHAR2
712: , p_calendar_flag VARCHAR2
713: , p_business_process_id NUMBER
714: , p_business_process_date date
715: , p15_a0 out nocopy JTF_NUMBER_TABLE
716: , p15_a1 out nocopy JTF_NUMBER_TABLE
717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
712: , p_calendar_flag VARCHAR2
713: , p_business_process_id NUMBER
714: , p_business_process_date date
715: , p15_a0 out nocopy JTF_NUMBER_TABLE
716: , p15_a1 out nocopy JTF_NUMBER_TABLE
717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
720: , p15_a5 out nocopy JTF_DATE_TABLE
717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
720: , p15_a5 out nocopy JTF_DATE_TABLE
721: , p15_a6 out nocopy JTF_NUMBER_TABLE
722: , p15_a7 out nocopy JTF_NUMBER_TABLE
723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
720: , p15_a5 out nocopy JTF_DATE_TABLE
721: , p15_a6 out nocopy JTF_NUMBER_TABLE
722: , p15_a7 out nocopy JTF_NUMBER_TABLE
723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
720: , p15_a5 out nocopy JTF_DATE_TABLE
721: , p15_a6 out nocopy JTF_NUMBER_TABLE
722: , p15_a7 out nocopy JTF_NUMBER_TABLE
723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
721: , p15_a6 out nocopy JTF_NUMBER_TABLE
722: , p15_a7 out nocopy JTF_NUMBER_TABLE
723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734: , p15_a19 out nocopy JTF_DATE_TABLE
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734: , p15_a19 out nocopy JTF_DATE_TABLE
735: , p15_a20 out nocopy JTF_DATE_TABLE
736: , p15_a21 out nocopy JTF_NUMBER_TABLE
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734: , p15_a19 out nocopy JTF_DATE_TABLE
735: , p15_a20 out nocopy JTF_DATE_TABLE
736: , p15_a21 out nocopy JTF_NUMBER_TABLE
737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739: , p15_a24 out nocopy JTF_NUMBER_TABLE
740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
735: , p15_a20 out nocopy JTF_DATE_TABLE
736: , p15_a21 out nocopy JTF_NUMBER_TABLE
737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739: , p15_a24 out nocopy JTF_NUMBER_TABLE
740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
741: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
742: , x_return_status out nocopy VARCHAR2
743: , x_msg_count out nocopy NUMBER
792: , p_end_date date
793: , p_territory_flag VARCHAR2
794: , p_calendar_flag VARCHAR2
795: , p_web_availability_flag VARCHAR2
796: , p13_a0 JTF_NUMBER_TABLE
797: , p13_a1 JTF_VARCHAR2_TABLE_100
798: , p_business_process_id NUMBER
799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
796: , p13_a0 JTF_NUMBER_TABLE
797: , p13_a1 JTF_VARCHAR2_TABLE_100
798: , p_business_process_id NUMBER
799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
801: , p16_a1 out nocopy JTF_NUMBER_TABLE
802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
797: , p13_a1 JTF_VARCHAR2_TABLE_100
798: , p_business_process_id NUMBER
799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
801: , p16_a1 out nocopy JTF_NUMBER_TABLE
802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
805: , p16_a5 out nocopy JTF_DATE_TABLE
802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
805: , p16_a5 out nocopy JTF_DATE_TABLE
806: , p16_a6 out nocopy JTF_NUMBER_TABLE
807: , p16_a7 out nocopy JTF_NUMBER_TABLE
808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
805: , p16_a5 out nocopy JTF_DATE_TABLE
806: , p16_a6 out nocopy JTF_NUMBER_TABLE
807: , p16_a7 out nocopy JTF_NUMBER_TABLE
808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
805: , p16_a5 out nocopy JTF_DATE_TABLE
806: , p16_a6 out nocopy JTF_NUMBER_TABLE
807: , p16_a7 out nocopy JTF_NUMBER_TABLE
808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
806: , p16_a6 out nocopy JTF_NUMBER_TABLE
807: , p16_a7 out nocopy JTF_NUMBER_TABLE
808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819: , p16_a19 out nocopy JTF_DATE_TABLE
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819: , p16_a19 out nocopy JTF_DATE_TABLE
820: , p16_a20 out nocopy JTF_DATE_TABLE
821: , p16_a21 out nocopy JTF_NUMBER_TABLE
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819: , p16_a19 out nocopy JTF_DATE_TABLE
820: , p16_a20 out nocopy JTF_DATE_TABLE
821: , p16_a21 out nocopy JTF_NUMBER_TABLE
822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824: , p16_a24 out nocopy JTF_NUMBER_TABLE
825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
820: , p16_a20 out nocopy JTF_DATE_TABLE
821: , p16_a21 out nocopy JTF_NUMBER_TABLE
822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824: , p16_a24 out nocopy JTF_NUMBER_TABLE
825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
826: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
836: , p_calling_doc_id NUMBER
837: , p_calling_doc_type VARCHAR2
838: , p_business_process_id NUMBER
839: , p_business_process_date date
840: , p12_a0 out nocopy JTF_NUMBER_TABLE
841: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2
1024: , p_continuous_task VARCHAR2
1025: , x_return_status in out nocopy VARCHAR2
1026: , x_msg_count in out nocopy NUMBER
1027: , x_msg_data in out nocopy VARCHAR2
1028: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1025: , x_return_status in out nocopy VARCHAR2
1026: , x_msg_count in out nocopy NUMBER
1027: , x_msg_data in out nocopy VARCHAR2
1028: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1048: , p14_a20 in out nocopy JTF_DATE_TABLE
1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1048: , p14_a20 in out nocopy JTF_DATE_TABLE
1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1048: , p14_a20 in out nocopy JTF_DATE_TABLE
1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1055: );
1056: end jtf_assign_pub_w;