1: package csp_sch_int_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cspvscis.pls 115.12 2004/02/25 01:32:36 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2: /* $Header: cspvscis.pls 115.12 2004/02/25 01:32:36 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: );
9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_DATE_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_DATE_TABLE
18: , a3 out nocopy JTF_NUMBER_TABLE
19: );
14: );
15: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_DATE_TABLE
18: , a3 out nocopy JTF_NUMBER_TABLE
19: );
20:
21: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_DATE_TABLE
18: , a3 out nocopy JTF_NUMBER_TABLE
19: );
20:
21: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_VARCHAR2_TABLE_100
23: , a2 JTF_NUMBER_TABLE
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
19: );
20:
21: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_VARCHAR2_TABLE_100
23: , a2 JTF_NUMBER_TABLE
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
26: , a5 JTF_VARCHAR2_TABLE_100
27: , a6 JTF_NUMBER_TABLE
20:
21: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_VARCHAR2_TABLE_100
23: , a2 JTF_NUMBER_TABLE
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
26: , a5 JTF_VARCHAR2_TABLE_100
27: , a6 JTF_NUMBER_TABLE
28: , a7 JTF_NUMBER_TABLE
23: , a2 JTF_NUMBER_TABLE
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
26: , a5 JTF_VARCHAR2_TABLE_100
27: , a6 JTF_NUMBER_TABLE
28: , a7 JTF_NUMBER_TABLE
29: , a8 JTF_NUMBER_TABLE
30: , a9 JTF_VARCHAR2_TABLE_100
31: );
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
26: , a5 JTF_VARCHAR2_TABLE_100
27: , a6 JTF_NUMBER_TABLE
28: , a7 JTF_NUMBER_TABLE
29: , a8 JTF_NUMBER_TABLE
30: , a9 JTF_VARCHAR2_TABLE_100
31: );
32: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a4 JTF_VARCHAR2_TABLE_100
26: , a5 JTF_VARCHAR2_TABLE_100
27: , a6 JTF_NUMBER_TABLE
28: , a7 JTF_NUMBER_TABLE
29: , a8 JTF_NUMBER_TABLE
30: , a9 JTF_VARCHAR2_TABLE_100
31: );
32: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a7 JTF_NUMBER_TABLE
29: , a8 JTF_NUMBER_TABLE
30: , a9 JTF_VARCHAR2_TABLE_100
31: );
32: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
30: , a9 JTF_VARCHAR2_TABLE_100
31: );
32: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_NUMBER_TABLE
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_VARCHAR2_TABLE_100
42: );
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_NUMBER_TABLE
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_VARCHAR2_TABLE_100
42: );
43:
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_NUMBER_TABLE
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_VARCHAR2_TABLE_100
42: );
43:
44: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_VARCHAR2_TABLE_100
42: );
43:
44: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
42: );
43:
44: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
43:
44: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
44: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
47: , a3 JTF_NUMBER_TABLE
48: , a4 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_NUMBER_TABLE
55: , a11 JTF_NUMBER_TABLE
49: , a5 JTF_NUMBER_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_NUMBER_TABLE
55: , a11 JTF_NUMBER_TABLE
56: , a12 JTF_VARCHAR2_TABLE_100
57: , a13 JTF_DATE_TABLE
50: , a6 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_NUMBER_TABLE
55: , a11 JTF_NUMBER_TABLE
56: , a12 JTF_VARCHAR2_TABLE_100
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_VARCHAR2_TABLE_100
51: , a7 JTF_NUMBER_TABLE
52: , a8 JTF_VARCHAR2_TABLE_100
53: , a9 JTF_NUMBER_TABLE
54: , a10 JTF_NUMBER_TABLE
55: , a11 JTF_NUMBER_TABLE
56: , a12 JTF_VARCHAR2_TABLE_100
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_VARCHAR2_TABLE_100
59: , a15 JTF_NUMBER_TABLE
55: , a11 JTF_NUMBER_TABLE
56: , a12 JTF_VARCHAR2_TABLE_100
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_VARCHAR2_TABLE_100
59: , a15 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
57: , a13 JTF_DATE_TABLE
58: , a14 JTF_VARCHAR2_TABLE_100
59: , a15 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
59: , a15 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: );
61: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
61: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_VARCHAR2_TABLE_100
74: , a13 out nocopy JTF_DATE_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_VARCHAR2_TABLE_100
74: , a13 out nocopy JTF_DATE_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_VARCHAR2_TABLE_100
74: , a13 out nocopy JTF_DATE_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_100
76: , a15 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_VARCHAR2_TABLE_100
74: , a13 out nocopy JTF_DATE_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_100
76: , a15 out nocopy JTF_NUMBER_TABLE
77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
75: , a14 out nocopy JTF_VARCHAR2_TABLE_100
76: , a15 out nocopy JTF_NUMBER_TABLE
77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_VARCHAR2_TABLE_100
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_VARCHAR2_TABLE_100
84: , a5 JTF_NUMBER_TABLE
85: );
86: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_VARCHAR2_TABLE_100
84: , a5 JTF_NUMBER_TABLE
85: );
86: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_VARCHAR2_TABLE_100
84: , a5 JTF_NUMBER_TABLE
85: );
86: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: );
86: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_NUMBER_TABLE
92: );
93:
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_NUMBER_TABLE
92: );
93:
94: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , a5 out nocopy JTF_NUMBER_TABLE
92: );
93:
94: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_NUMBER_TABLE
100: , a6 JTF_NUMBER_TABLE
93:
94: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_NUMBER_TABLE
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_NUMBER_TABLE
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_NUMBER_TABLE
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_DATE_TABLE
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_NUMBER_TABLE
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_NUMBER_TABLE
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_DATE_TABLE
104: , a10 JTF_DATE_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_NUMBER_TABLE
100: , a6 JTF_NUMBER_TABLE
101: , a7 JTF_NUMBER_TABLE
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_DATE_TABLE
104: , a10 JTF_DATE_TABLE
105: , a11 JTF_VARCHAR2_TABLE_100
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_DATE_TABLE
104: , a10 JTF_DATE_TABLE
105: , a11 JTF_VARCHAR2_TABLE_100
106: , a12 JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_100
110: );
103: , a9 JTF_DATE_TABLE
104: , a10 JTF_DATE_TABLE
105: , a11 JTF_VARCHAR2_TABLE_100
106: , a12 JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_100
110: );
111: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_100
110: );
111: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_100
110: );
111: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_DATE_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_DATE_TABLE
121: , a10 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_DATE_TABLE
121: , a10 out nocopy JTF_DATE_TABLE
122: , a11 out nocopy JTF_VARCHAR2_TABLE_100
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_DATE_TABLE
121: , a10 out nocopy JTF_DATE_TABLE
122: , a11 out nocopy JTF_VARCHAR2_TABLE_100
123: , a12 out nocopy JTF_NUMBER_TABLE
124: , a13 out nocopy JTF_NUMBER_TABLE
125: , a14 out nocopy JTF_VARCHAR2_TABLE_100
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100
127: );
120: , a9 out nocopy JTF_DATE_TABLE
121: , a10 out nocopy JTF_DATE_TABLE
122: , a11 out nocopy JTF_VARCHAR2_TABLE_100
123: , a12 out nocopy JTF_NUMBER_TABLE
124: , a13 out nocopy JTF_NUMBER_TABLE
125: , a14 out nocopy JTF_VARCHAR2_TABLE_100
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100
127: );
128:
125: , a14 out nocopy JTF_VARCHAR2_TABLE_100
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100
127: );
128:
129: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
127: );
128:
129: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_NUMBER_TABLE
128:
129: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_NUMBER_TABLE
136: , a7 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_NUMBER_TABLE
136: , a7 JTF_NUMBER_TABLE
137: , a8 JTF_VARCHAR2_TABLE_100
138: , a9 JTF_DATE_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_NUMBER_TABLE
136: , a7 JTF_NUMBER_TABLE
137: , a8 JTF_VARCHAR2_TABLE_100
138: , a9 JTF_DATE_TABLE
139: , a10 JTF_DATE_TABLE
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_NUMBER_TABLE
136: , a7 JTF_NUMBER_TABLE
137: , a8 JTF_VARCHAR2_TABLE_100
138: , a9 JTF_DATE_TABLE
139: , a10 JTF_DATE_TABLE
140: , a11 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_VARCHAR2_TABLE_100
138: , a9 JTF_DATE_TABLE
139: , a10 JTF_DATE_TABLE
140: , a11 JTF_VARCHAR2_TABLE_100
141: , a12 JTF_NUMBER_TABLE
142: , a13 JTF_NUMBER_TABLE
143: , a14 JTF_VARCHAR2_TABLE_100
144: , a15 JTF_VARCHAR2_TABLE_100
145: );
138: , a9 JTF_DATE_TABLE
139: , a10 JTF_DATE_TABLE
140: , a11 JTF_VARCHAR2_TABLE_100
141: , a12 JTF_NUMBER_TABLE
142: , a13 JTF_NUMBER_TABLE
143: , a14 JTF_VARCHAR2_TABLE_100
144: , a15 JTF_VARCHAR2_TABLE_100
145: );
146: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
142: , a13 JTF_NUMBER_TABLE
143: , a14 JTF_VARCHAR2_TABLE_100
144: , a15 JTF_VARCHAR2_TABLE_100
145: );
146: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
144: , a15 JTF_VARCHAR2_TABLE_100
145: );
146: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , a9 out nocopy JTF_DATE_TABLE
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_DATE_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
154: , a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_DATE_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_VARCHAR2_TABLE_100
162: );
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_DATE_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_VARCHAR2_TABLE_100
162: );
163:
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_VARCHAR2_TABLE_100
162: );
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
165: , a1 JTF_VARCHAR2_TABLE_100
166: , a2 JTF_VARCHAR2_TABLE_100
167: , a3 JTF_NUMBER_TABLE
168: , a4 JTF_VARCHAR2_TABLE_100
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
165: , a1 JTF_VARCHAR2_TABLE_100
166: , a2 JTF_VARCHAR2_TABLE_100
167: , a3 JTF_NUMBER_TABLE
168: , a4 JTF_VARCHAR2_TABLE_100
169: , a5 JTF_NUMBER_TABLE
170: );
171: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 JTF_VARCHAR2_TABLE_100
166: , a2 JTF_VARCHAR2_TABLE_100
167: , a3 JTF_NUMBER_TABLE
168: , a4 JTF_VARCHAR2_TABLE_100
169: , a5 JTF_NUMBER_TABLE
170: );
171: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , a3 JTF_NUMBER_TABLE
168: , a4 JTF_VARCHAR2_TABLE_100
169: , a5 JTF_NUMBER_TABLE
170: );
171: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_NUMBER_TABLE
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
170: );
171: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_NUMBER_TABLE
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_NUMBER_TABLE
177: );
178:
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_NUMBER_TABLE
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_NUMBER_TABLE
177: );
178:
179: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_NUMBER_TABLE
177: );
178:
179: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_100
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_VARCHAR2_TABLE_100
177: );
178:
179: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_100
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_VARCHAR2_TABLE_100
184: , a5 JTF_VARCHAR2_TABLE_300
185: , a6 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_VARCHAR2_TABLE_100
184: , a5 JTF_VARCHAR2_TABLE_300
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_VARCHAR2_TABLE_300
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_NUMBER_TABLE
185: , a6 JTF_NUMBER_TABLE
186: , a7 JTF_VARCHAR2_TABLE_300
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_NUMBER_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_NUMBER_TABLE
186: , a7 JTF_VARCHAR2_TABLE_300
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_NUMBER_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_NUMBER_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_VARCHAR2_TABLE_100
195: , a16 JTF_VARCHAR2_TABLE_100
196: , a17 JTF_DATE_TABLE
189: , a10 JTF_NUMBER_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_NUMBER_TABLE
194: , a15 JTF_VARCHAR2_TABLE_100
195: , a16 JTF_VARCHAR2_TABLE_100
196: , a17 JTF_DATE_TABLE
197: , a18 JTF_DATE_TABLE
197: , a18 JTF_DATE_TABLE
198: , a19 JTF_VARCHAR2_TABLE_100
199: , a20 JTF_VARCHAR2_TABLE_100
200: );
201: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100
199: , a20 JTF_VARCHAR2_TABLE_100
200: );
201: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100
206: , a5 out nocopy JTF_VARCHAR2_TABLE_300
207: , a6 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_NUMBER_TABLE
204: , a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100
206: , a5 out nocopy JTF_VARCHAR2_TABLE_300
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_VARCHAR2_TABLE_300
209: , a8 out nocopy JTF_VARCHAR2_TABLE_100
210: , a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , a10 out nocopy JTF_NUMBER_TABLE
207: , a6 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_VARCHAR2_TABLE_300
209: , a8 out nocopy JTF_VARCHAR2_TABLE_100
210: , a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , a13 out nocopy JTF_NUMBER_TABLE
215: , a14 out nocopy JTF_NUMBER_TABLE
208: , a7 out nocopy JTF_VARCHAR2_TABLE_300
209: , a8 out nocopy JTF_VARCHAR2_TABLE_100
210: , a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , a13 out nocopy JTF_NUMBER_TABLE
215: , a14 out nocopy JTF_NUMBER_TABLE
216: , a15 out nocopy JTF_VARCHAR2_TABLE_100
210: , a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , a13 out nocopy JTF_NUMBER_TABLE
215: , a14 out nocopy JTF_NUMBER_TABLE
216: , a15 out nocopy JTF_VARCHAR2_TABLE_100
217: , a16 out nocopy JTF_VARCHAR2_TABLE_100
218: , a17 out nocopy JTF_DATE_TABLE
211: , a10 out nocopy JTF_NUMBER_TABLE
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , a13 out nocopy JTF_NUMBER_TABLE
215: , a14 out nocopy JTF_NUMBER_TABLE
216: , a15 out nocopy JTF_VARCHAR2_TABLE_100
217: , a16 out nocopy JTF_VARCHAR2_TABLE_100
218: , a17 out nocopy JTF_DATE_TABLE
219: , a18 out nocopy JTF_DATE_TABLE
221: , a20 out nocopy JTF_VARCHAR2_TABLE_100
222: );
223:
224: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
225: , a1 JTF_NUMBER_TABLE
226: , a2 JTF_NUMBER_TABLE
227: , a3 JTF_VARCHAR2_TABLE_100
228: , a4 JTF_VARCHAR2_TABLE_100
229: , a5 JTF_VARCHAR2_TABLE_300
222: );
223:
224: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
225: , a1 JTF_NUMBER_TABLE
226: , a2 JTF_NUMBER_TABLE
227: , a3 JTF_VARCHAR2_TABLE_100
228: , a4 JTF_VARCHAR2_TABLE_100
229: , a5 JTF_VARCHAR2_TABLE_300
230: );
228: , a4 JTF_VARCHAR2_TABLE_100
229: , a5 JTF_VARCHAR2_TABLE_300
230: );
231: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: , a3 out nocopy JTF_VARCHAR2_TABLE_100
235: , a4 out nocopy JTF_VARCHAR2_TABLE_100
236: , a5 out nocopy JTF_VARCHAR2_TABLE_300
229: , a5 JTF_VARCHAR2_TABLE_300
230: );
231: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: , a3 out nocopy JTF_VARCHAR2_TABLE_100
235: , a4 out nocopy JTF_VARCHAR2_TABLE_100
236: , a5 out nocopy JTF_VARCHAR2_TABLE_300
237: );
235: , a4 out nocopy JTF_VARCHAR2_TABLE_100
236: , a5 out nocopy JTF_VARCHAR2_TABLE_300
237: );
238:
239: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
240: , a1 JTF_VARCHAR2_TABLE_100
241: , a2 JTF_VARCHAR2_TABLE_100
242: , a3 JTF_NUMBER_TABLE
243: , a4 JTF_NUMBER_TABLE
238:
239: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
240: , a1 JTF_VARCHAR2_TABLE_100
241: , a2 JTF_VARCHAR2_TABLE_100
242: , a3 JTF_NUMBER_TABLE
243: , a4 JTF_NUMBER_TABLE
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE
246: , a7 JTF_NUMBER_TABLE
239: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
240: , a1 JTF_VARCHAR2_TABLE_100
241: , a2 JTF_VARCHAR2_TABLE_100
242: , a3 JTF_NUMBER_TABLE
243: , a4 JTF_NUMBER_TABLE
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE
246: , a7 JTF_NUMBER_TABLE
247: );
241: , a2 JTF_VARCHAR2_TABLE_100
242: , a3 JTF_NUMBER_TABLE
243: , a4 JTF_NUMBER_TABLE
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE
246: , a7 JTF_NUMBER_TABLE
247: );
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_VARCHAR2_TABLE_100
242: , a3 JTF_NUMBER_TABLE
243: , a4 JTF_NUMBER_TABLE
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE
246: , a7 JTF_NUMBER_TABLE
247: );
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_VARCHAR2_TABLE_100
250: , a2 out nocopy JTF_VARCHAR2_TABLE_100
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE
246: , a7 JTF_NUMBER_TABLE
247: );
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_VARCHAR2_TABLE_100
250: , a2 out nocopy JTF_VARCHAR2_TABLE_100
251: , a3 out nocopy JTF_NUMBER_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE
247: );
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_VARCHAR2_TABLE_100
250: , a2 out nocopy JTF_VARCHAR2_TABLE_100
251: , a3 out nocopy JTF_NUMBER_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100
254: , a6 out nocopy JTF_NUMBER_TABLE
255: , a7 out nocopy JTF_NUMBER_TABLE
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_VARCHAR2_TABLE_100
250: , a2 out nocopy JTF_VARCHAR2_TABLE_100
251: , a3 out nocopy JTF_NUMBER_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100
254: , a6 out nocopy JTF_NUMBER_TABLE
255: , a7 out nocopy JTF_NUMBER_TABLE
256: );
250: , a2 out nocopy JTF_VARCHAR2_TABLE_100
251: , a3 out nocopy JTF_NUMBER_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100
254: , a6 out nocopy JTF_NUMBER_TABLE
255: , a7 out nocopy JTF_NUMBER_TABLE
256: );
257:
258: procedure get_availability_options(p_api_version_number NUMBER
251: , a3 out nocopy JTF_NUMBER_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100
254: , a6 out nocopy JTF_NUMBER_TABLE
255: , a7 out nocopy JTF_NUMBER_TABLE
256: );
257:
258: procedure get_availability_options(p_api_version_number NUMBER
259: , p_task_id NUMBER
256: );
257:
258: procedure get_availability_options(p_api_version_number NUMBER
259: , p_task_id NUMBER
260: , p2_a0 JTF_NUMBER_TABLE
261: , p2_a1 JTF_VARCHAR2_TABLE_100
262: , p3_a0 DATE
263: , p3_a1 DATE
264: , p_likelihood NUMBER
262: , p3_a0 DATE
263: , p3_a1 DATE
264: , p_likelihood NUMBER
265: , p_subinv_only number
266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a2 out nocopy JTF_DATE_TABLE
269: , p6_a3 out nocopy JTF_NUMBER_TABLE
270: , x_return_status out nocopy VARCHAR2
265: , p_subinv_only number
266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a2 out nocopy JTF_DATE_TABLE
269: , p6_a3 out nocopy JTF_NUMBER_TABLE
270: , x_return_status out nocopy VARCHAR2
271: , x_msg_data out nocopy VARCHAR2
272: , x_msg_count out nocopy NUMBER
273: );
287: , p0_a1 VARCHAR2
288: , p_organization_id NUMBER
289: , p_subinv_code VARCHAR2
290: , p_need_by_date DATE
291: , p4_a0 JTF_NUMBER_TABLE
292: , p4_a1 JTF_VARCHAR2_TABLE_100
293: , p4_a2 JTF_VARCHAR2_TABLE_100
294: , p4_a3 JTF_NUMBER_TABLE
295: , p4_a4 JTF_VARCHAR2_TABLE_100
290: , p_need_by_date DATE
291: , p4_a0 JTF_NUMBER_TABLE
292: , p4_a1 JTF_VARCHAR2_TABLE_100
293: , p4_a2 JTF_VARCHAR2_TABLE_100
294: , p4_a3 JTF_NUMBER_TABLE
295: , p4_a4 JTF_VARCHAR2_TABLE_100
296: , p4_a5 JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
292: , p4_a1 JTF_VARCHAR2_TABLE_100
293: , p4_a2 JTF_VARCHAR2_TABLE_100
294: , p4_a3 JTF_NUMBER_TABLE
295: , p4_a4 JTF_VARCHAR2_TABLE_100
296: , p4_a5 JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
294: , p4_a3 JTF_NUMBER_TABLE
295: , p4_a4 JTF_VARCHAR2_TABLE_100
296: , p4_a5 JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , p4_a5 JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_NUMBER_TABLE
305: , p6_a7 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_NUMBER_TABLE
305: , p6_a7 out nocopy JTF_NUMBER_TABLE
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a9 out nocopy JTF_DATE_TABLE
300: , p6_a2 out nocopy JTF_NUMBER_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_NUMBER_TABLE
305: , p6_a7 out nocopy JTF_NUMBER_TABLE
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a9 out nocopy JTF_DATE_TABLE
308: , p6_a10 out nocopy JTF_DATE_TABLE
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_NUMBER_TABLE
305: , p6_a7 out nocopy JTF_NUMBER_TABLE
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a9 out nocopy JTF_DATE_TABLE
308: , p6_a10 out nocopy JTF_DATE_TABLE
309: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a9 out nocopy JTF_DATE_TABLE
308: , p6_a10 out nocopy JTF_DATE_TABLE
309: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a12 out nocopy JTF_NUMBER_TABLE
311: , p6_a13 out nocopy JTF_NUMBER_TABLE
312: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
314: , x_return_status out nocopy VARCHAR2
307: , p6_a9 out nocopy JTF_DATE_TABLE
308: , p6_a10 out nocopy JTF_DATE_TABLE
309: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a12 out nocopy JTF_NUMBER_TABLE
311: , p6_a13 out nocopy JTF_NUMBER_TABLE
312: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
314: , x_return_status out nocopy VARCHAR2
315: , x_msg_data out nocopy VARCHAR2
328: , x_return_status out nocopy VARCHAR2
329: , x_msg_data out nocopy VARCHAR2
330: ) return number;
331: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
332: , p0_a1 JTF_NUMBER_TABLE
333: , p0_a2 JTF_NUMBER_TABLE
334: , p0_a3 JTF_VARCHAR2_TABLE_100
335: , p0_a4 JTF_VARCHAR2_TABLE_100
336: , p0_a5 JTF_VARCHAR2_TABLE_300
329: , x_msg_data out nocopy VARCHAR2
330: ) return number;
331: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
332: , p0_a1 JTF_NUMBER_TABLE
333: , p0_a2 JTF_NUMBER_TABLE
334: , p0_a3 JTF_VARCHAR2_TABLE_100
335: , p0_a4 JTF_VARCHAR2_TABLE_100
336: , p0_a5 JTF_VARCHAR2_TABLE_300
337: , p1_a0 JTF_NUMBER_TABLE
333: , p0_a2 JTF_NUMBER_TABLE
334: , p0_a3 JTF_VARCHAR2_TABLE_100
335: , p0_a4 JTF_VARCHAR2_TABLE_100
336: , p0_a5 JTF_VARCHAR2_TABLE_300
337: , p1_a0 JTF_NUMBER_TABLE
338: , p1_a1 JTF_VARCHAR2_TABLE_100
339: , p1_a2 JTF_VARCHAR2_TABLE_100
340: , p1_a3 JTF_NUMBER_TABLE
341: , p1_a4 JTF_VARCHAR2_TABLE_100
336: , p0_a5 JTF_VARCHAR2_TABLE_300
337: , p1_a0 JTF_NUMBER_TABLE
338: , p1_a1 JTF_VARCHAR2_TABLE_100
339: , p1_a2 JTF_VARCHAR2_TABLE_100
340: , p1_a3 JTF_NUMBER_TABLE
341: , p1_a4 JTF_VARCHAR2_TABLE_100
342: , p1_a5 JTF_NUMBER_TABLE
343: , p_include_alternate VARCHAR2
344: , p3_a0 out nocopy JTF_NUMBER_TABLE
338: , p1_a1 JTF_VARCHAR2_TABLE_100
339: , p1_a2 JTF_VARCHAR2_TABLE_100
340: , p1_a3 JTF_NUMBER_TABLE
341: , p1_a4 JTF_VARCHAR2_TABLE_100
342: , p1_a5 JTF_NUMBER_TABLE
343: , p_include_alternate VARCHAR2
344: , p3_a0 out nocopy JTF_NUMBER_TABLE
345: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
346: , p3_a2 out nocopy JTF_NUMBER_TABLE
340: , p1_a3 JTF_NUMBER_TABLE
341: , p1_a4 JTF_VARCHAR2_TABLE_100
342: , p1_a5 JTF_NUMBER_TABLE
343: , p_include_alternate VARCHAR2
344: , p3_a0 out nocopy JTF_NUMBER_TABLE
345: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
346: , p3_a2 out nocopy JTF_NUMBER_TABLE
347: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
348: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
342: , p1_a5 JTF_NUMBER_TABLE
343: , p_include_alternate VARCHAR2
344: , p3_a0 out nocopy JTF_NUMBER_TABLE
345: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
346: , p3_a2 out nocopy JTF_NUMBER_TABLE
347: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
348: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
349: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
350: , p3_a6 out nocopy JTF_NUMBER_TABLE
346: , p3_a2 out nocopy JTF_NUMBER_TABLE
347: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
348: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
349: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
350: , p3_a6 out nocopy JTF_NUMBER_TABLE
351: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
352: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
353: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
354: , p3_a10 out nocopy JTF_NUMBER_TABLE
350: , p3_a6 out nocopy JTF_NUMBER_TABLE
351: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
352: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
353: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
354: , p3_a10 out nocopy JTF_NUMBER_TABLE
355: , p3_a11 out nocopy JTF_NUMBER_TABLE
356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p3_a13 out nocopy JTF_NUMBER_TABLE
358: , p3_a14 out nocopy JTF_NUMBER_TABLE
351: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
352: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
353: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
354: , p3_a10 out nocopy JTF_NUMBER_TABLE
355: , p3_a11 out nocopy JTF_NUMBER_TABLE
356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p3_a13 out nocopy JTF_NUMBER_TABLE
358: , p3_a14 out nocopy JTF_NUMBER_TABLE
359: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
353: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
354: , p3_a10 out nocopy JTF_NUMBER_TABLE
355: , p3_a11 out nocopy JTF_NUMBER_TABLE
356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p3_a13 out nocopy JTF_NUMBER_TABLE
358: , p3_a14 out nocopy JTF_NUMBER_TABLE
359: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
360: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
361: , p3_a17 out nocopy JTF_DATE_TABLE
354: , p3_a10 out nocopy JTF_NUMBER_TABLE
355: , p3_a11 out nocopy JTF_NUMBER_TABLE
356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p3_a13 out nocopy JTF_NUMBER_TABLE
358: , p3_a14 out nocopy JTF_NUMBER_TABLE
359: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
360: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
361: , p3_a17 out nocopy JTF_DATE_TABLE
362: , p3_a18 out nocopy JTF_DATE_TABLE
367: , x_msg_count out nocopy NUMBER
368: );
369: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
370: , p_resource_id NUMBER
371: , p2_a0 JTF_NUMBER_TABLE
372: , p2_a1 JTF_VARCHAR2_TABLE_100
373: , p2_a2 JTF_VARCHAR2_TABLE_100
374: , p2_a3 JTF_NUMBER_TABLE
375: , p2_a4 JTF_VARCHAR2_TABLE_100
370: , p_resource_id NUMBER
371: , p2_a0 JTF_NUMBER_TABLE
372: , p2_a1 JTF_VARCHAR2_TABLE_100
373: , p2_a2 JTF_VARCHAR2_TABLE_100
374: , p2_a3 JTF_NUMBER_TABLE
375: , p2_a4 JTF_VARCHAR2_TABLE_100
376: , p2_a5 JTF_NUMBER_TABLE
377: , p_include_alternate VARCHAR2
378: , p4_a0 out nocopy JTF_NUMBER_TABLE
372: , p2_a1 JTF_VARCHAR2_TABLE_100
373: , p2_a2 JTF_VARCHAR2_TABLE_100
374: , p2_a3 JTF_NUMBER_TABLE
375: , p2_a4 JTF_VARCHAR2_TABLE_100
376: , p2_a5 JTF_NUMBER_TABLE
377: , p_include_alternate VARCHAR2
378: , p4_a0 out nocopy JTF_NUMBER_TABLE
379: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , p4_a2 out nocopy JTF_NUMBER_TABLE
374: , p2_a3 JTF_NUMBER_TABLE
375: , p2_a4 JTF_VARCHAR2_TABLE_100
376: , p2_a5 JTF_NUMBER_TABLE
377: , p_include_alternate VARCHAR2
378: , p4_a0 out nocopy JTF_NUMBER_TABLE
379: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , p4_a2 out nocopy JTF_NUMBER_TABLE
381: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
382: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
376: , p2_a5 JTF_NUMBER_TABLE
377: , p_include_alternate VARCHAR2
378: , p4_a0 out nocopy JTF_NUMBER_TABLE
379: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , p4_a2 out nocopy JTF_NUMBER_TABLE
381: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
382: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
383: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
384: , p4_a6 out nocopy JTF_NUMBER_TABLE
380: , p4_a2 out nocopy JTF_NUMBER_TABLE
381: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
382: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
383: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
384: , p4_a6 out nocopy JTF_NUMBER_TABLE
385: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
386: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
388: , p4_a10 out nocopy JTF_NUMBER_TABLE
384: , p4_a6 out nocopy JTF_NUMBER_TABLE
385: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
386: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
388: , p4_a10 out nocopy JTF_NUMBER_TABLE
389: , p4_a11 out nocopy JTF_NUMBER_TABLE
390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a13 out nocopy JTF_NUMBER_TABLE
392: , p4_a14 out nocopy JTF_NUMBER_TABLE
385: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
386: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
388: , p4_a10 out nocopy JTF_NUMBER_TABLE
389: , p4_a11 out nocopy JTF_NUMBER_TABLE
390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a13 out nocopy JTF_NUMBER_TABLE
392: , p4_a14 out nocopy JTF_NUMBER_TABLE
393: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
388: , p4_a10 out nocopy JTF_NUMBER_TABLE
389: , p4_a11 out nocopy JTF_NUMBER_TABLE
390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a13 out nocopy JTF_NUMBER_TABLE
392: , p4_a14 out nocopy JTF_NUMBER_TABLE
393: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
394: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
395: , p4_a17 out nocopy JTF_DATE_TABLE
388: , p4_a10 out nocopy JTF_NUMBER_TABLE
389: , p4_a11 out nocopy JTF_NUMBER_TABLE
390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a13 out nocopy JTF_NUMBER_TABLE
392: , p4_a14 out nocopy JTF_NUMBER_TABLE
393: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
394: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
395: , p4_a17 out nocopy JTF_DATE_TABLE
396: , p4_a18 out nocopy JTF_DATE_TABLE
401: , x_msg_count out nocopy NUMBER
402: );
403: procedure ws_check_organizations(p_resource_type VARCHAR2
404: , p_resource_id NUMBER
405: , p2_a0 JTF_NUMBER_TABLE
406: , p2_a1 JTF_VARCHAR2_TABLE_100
407: , p2_a2 JTF_VARCHAR2_TABLE_100
408: , p2_a3 JTF_NUMBER_TABLE
409: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p_resource_id NUMBER
405: , p2_a0 JTF_NUMBER_TABLE
406: , p2_a1 JTF_VARCHAR2_TABLE_100
407: , p2_a2 JTF_VARCHAR2_TABLE_100
408: , p2_a3 JTF_NUMBER_TABLE
409: , p2_a4 JTF_VARCHAR2_TABLE_100
410: , p2_a5 JTF_NUMBER_TABLE
411: , p_include_alternate VARCHAR2
412: , p4_a0 out nocopy JTF_NUMBER_TABLE
406: , p2_a1 JTF_VARCHAR2_TABLE_100
407: , p2_a2 JTF_VARCHAR2_TABLE_100
408: , p2_a3 JTF_NUMBER_TABLE
409: , p2_a4 JTF_VARCHAR2_TABLE_100
410: , p2_a5 JTF_NUMBER_TABLE
411: , p_include_alternate VARCHAR2
412: , p4_a0 out nocopy JTF_NUMBER_TABLE
413: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
414: , p4_a2 out nocopy JTF_NUMBER_TABLE
408: , p2_a3 JTF_NUMBER_TABLE
409: , p2_a4 JTF_VARCHAR2_TABLE_100
410: , p2_a5 JTF_NUMBER_TABLE
411: , p_include_alternate VARCHAR2
412: , p4_a0 out nocopy JTF_NUMBER_TABLE
413: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
414: , p4_a2 out nocopy JTF_NUMBER_TABLE
415: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p2_a5 JTF_NUMBER_TABLE
411: , p_include_alternate VARCHAR2
412: , p4_a0 out nocopy JTF_NUMBER_TABLE
413: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
414: , p4_a2 out nocopy JTF_NUMBER_TABLE
415: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
417: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
418: , p4_a6 out nocopy JTF_NUMBER_TABLE
414: , p4_a2 out nocopy JTF_NUMBER_TABLE
415: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
417: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
418: , p4_a6 out nocopy JTF_NUMBER_TABLE
419: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
420: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a10 out nocopy JTF_NUMBER_TABLE
418: , p4_a6 out nocopy JTF_NUMBER_TABLE
419: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
420: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a10 out nocopy JTF_NUMBER_TABLE
423: , p4_a11 out nocopy JTF_NUMBER_TABLE
424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
425: , p4_a13 out nocopy JTF_NUMBER_TABLE
426: , p4_a14 out nocopy JTF_NUMBER_TABLE
419: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
420: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a10 out nocopy JTF_NUMBER_TABLE
423: , p4_a11 out nocopy JTF_NUMBER_TABLE
424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
425: , p4_a13 out nocopy JTF_NUMBER_TABLE
426: , p4_a14 out nocopy JTF_NUMBER_TABLE
427: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a10 out nocopy JTF_NUMBER_TABLE
423: , p4_a11 out nocopy JTF_NUMBER_TABLE
424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
425: , p4_a13 out nocopy JTF_NUMBER_TABLE
426: , p4_a14 out nocopy JTF_NUMBER_TABLE
427: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
428: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
429: , p4_a17 out nocopy JTF_DATE_TABLE
422: , p4_a10 out nocopy JTF_NUMBER_TABLE
423: , p4_a11 out nocopy JTF_NUMBER_TABLE
424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
425: , p4_a13 out nocopy JTF_NUMBER_TABLE
426: , p4_a14 out nocopy JTF_NUMBER_TABLE
427: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
428: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
429: , p4_a17 out nocopy JTF_DATE_TABLE
430: , p4_a18 out nocopy JTF_DATE_TABLE
440: , p0_a3 NUMBER
441: , p0_a4 VARCHAR2
442: , p0_a5 NUMBER
443: , p_org_id NUMBER
444: , p2_a0 in out nocopy JTF_NUMBER_TABLE
445: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
446: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a3 in out nocopy JTF_NUMBER_TABLE
448: , p2_a4 in out nocopy JTF_NUMBER_TABLE
443: , p_org_id NUMBER
444: , p2_a0 in out nocopy JTF_NUMBER_TABLE
445: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
446: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a3 in out nocopy JTF_NUMBER_TABLE
448: , p2_a4 in out nocopy JTF_NUMBER_TABLE
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p2_a6 in out nocopy JTF_NUMBER_TABLE
451: , p2_a7 in out nocopy JTF_NUMBER_TABLE
444: , p2_a0 in out nocopy JTF_NUMBER_TABLE
445: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
446: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a3 in out nocopy JTF_NUMBER_TABLE
448: , p2_a4 in out nocopy JTF_NUMBER_TABLE
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p2_a6 in out nocopy JTF_NUMBER_TABLE
451: , p2_a7 in out nocopy JTF_NUMBER_TABLE
452: , x_return_status out nocopy VARCHAR2
446: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a3 in out nocopy JTF_NUMBER_TABLE
448: , p2_a4 in out nocopy JTF_NUMBER_TABLE
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p2_a6 in out nocopy JTF_NUMBER_TABLE
451: , p2_a7 in out nocopy JTF_NUMBER_TABLE
452: , x_return_status out nocopy VARCHAR2
453: , x_msg_data out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
447: , p2_a3 in out nocopy JTF_NUMBER_TABLE
448: , p2_a4 in out nocopy JTF_NUMBER_TABLE
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p2_a6 in out nocopy JTF_NUMBER_TABLE
451: , p2_a7 in out nocopy JTF_NUMBER_TABLE
452: , x_return_status out nocopy VARCHAR2
453: , x_msg_data out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: );