APPS.CSP_SCH_INT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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
8: );

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
11: , a1 JTF_VARCHAR2_TABLE_100

Line 11: , a1 JTF_VARCHAR2_TABLE_100

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: );
15: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

Line 16: , a1 out nocopy 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: );
20:

Line 22: , a1 JTF_VARCHAR2_TABLE_100

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
26: , a5 JTF_VARCHAR2_TABLE_100

Line 25: , a4 JTF_VARCHAR2_TABLE_100

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
29: , a8 JTF_NUMBER_TABLE

Line 26: , a5 JTF_VARCHAR2_TABLE_100

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
29: , a8 JTF_NUMBER_TABLE
30: , a9 JTF_VARCHAR2_TABLE_100

Line 30: , a9 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
34: , a2 out nocopy JTF_NUMBER_TABLE

Line 33: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
40: , a8 out nocopy JTF_NUMBER_TABLE

Line 37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a9 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
45: , a1 JTF_VARCHAR2_TABLE_100

Line 45: , a1 JTF_VARCHAR2_TABLE_100

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
49: , a5 JTF_NUMBER_TABLE

Line 50: , a6 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
54: , a10 JTF_NUMBER_TABLE

Line 52: , a8 JTF_VARCHAR2_TABLE_100

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
56: , a12 JTF_VARCHAR2_TABLE_100

Line 56: , a12 JTF_VARCHAR2_TABLE_100

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
60: );

Line 58: , a14 JTF_VARCHAR2_TABLE_100

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
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

Line 62: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
66: , a5 out nocopy JTF_NUMBER_TABLE

Line 67: , a6 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
71: , a10 out nocopy JTF_NUMBER_TABLE

Line 69: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
73: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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
77: );

Line 75: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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
77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE

Line 80: , a1 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
84: , a5 JTF_NUMBER_TABLE

Line 81: , a2 JTF_VARCHAR2_TABLE_100

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
84: , a5 JTF_NUMBER_TABLE
85: );

Line 83: , a4 JTF_VARCHAR2_TABLE_100

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
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
91: , a5 out nocopy JTF_NUMBER_TABLE

Line 88: , a2 out nocopy 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
91: , a5 out nocopy JTF_NUMBER_TABLE
92: );

Line 90: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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:
94: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

Line 95: , a1 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
99: , a5 JTF_NUMBER_TABLE

Line 98: , a4 JTF_VARCHAR2_TABLE_100

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
102: , a8 JTF_VARCHAR2_TABLE_100

Line 102: , a8 JTF_VARCHAR2_TABLE_100

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
106: , a12 JTF_NUMBER_TABLE

Line 105: , a11 JTF_VARCHAR2_TABLE_100

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
106: , a12 JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_100

Line 108: , a14 JTF_VARCHAR2_TABLE_100

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
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a15 JTF_VARCHAR2_TABLE_100

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
112: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: , a2 out nocopy JTF_NUMBER_TABLE

Line 112: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
116: , a5 out nocopy JTF_NUMBER_TABLE

Line 115: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
123: , a12 out nocopy JTF_NUMBER_TABLE

Line 122: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 125: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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:
129: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

Line 126: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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:
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

Line 130: , a1 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
134: , a5 JTF_NUMBER_TABLE

Line 133: , a4 JTF_VARCHAR2_TABLE_100

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
137: , a8 JTF_VARCHAR2_TABLE_100

Line 137: , a8 JTF_VARCHAR2_TABLE_100

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
141: , a12 JTF_NUMBER_TABLE

Line 140: , a11 JTF_VARCHAR2_TABLE_100

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
141: , a12 JTF_NUMBER_TABLE
142: , a13 JTF_NUMBER_TABLE
143: , a14 JTF_VARCHAR2_TABLE_100
144: , a15 JTF_VARCHAR2_TABLE_100

Line 143: , a14 JTF_VARCHAR2_TABLE_100

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
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , a15 JTF_VARCHAR2_TABLE_100

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
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE

Line 147: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
151: , a5 out nocopy JTF_NUMBER_TABLE

Line 150: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
154: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
158: , a12 out nocopy JTF_NUMBER_TABLE

Line 157: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 160: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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:
164: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

Line 161: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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:
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

Line 165: , a1 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
169: , a5 JTF_NUMBER_TABLE

Line 166: , a2 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
169: , a5 JTF_NUMBER_TABLE
170: );

Line 168: , a4 JTF_VARCHAR2_TABLE_100

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
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 172: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
176: , a5 out nocopy JTF_NUMBER_TABLE

Line 173: , a2 out nocopy 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
176: , a5 out nocopy JTF_NUMBER_TABLE
177: );

Line 175: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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:
179: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

Line 180: , a1 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
184: , a5 JTF_VARCHAR2_TABLE_300

Line 182: , a3 JTF_VARCHAR2_TABLE_100

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
186: , a7 JTF_VARCHAR2_TABLE_300

Line 183: , a4 JTF_VARCHAR2_TABLE_100

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
186: , a7 JTF_VARCHAR2_TABLE_300
187: , a8 JTF_VARCHAR2_TABLE_100

Line 187: , a8 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
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100

Line 188: , a9 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
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_VARCHAR2_TABLE_100
192: , a13 JTF_NUMBER_TABLE

Line 191: , a12 JTF_VARCHAR2_TABLE_100

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
195: , a16 JTF_VARCHAR2_TABLE_100

Line 194: , a15 JTF_VARCHAR2_TABLE_100

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
198: , a19 JTF_VARCHAR2_TABLE_100

Line 195: , a16 JTF_VARCHAR2_TABLE_100

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
198: , a19 JTF_VARCHAR2_TABLE_100
199: , a20 JTF_VARCHAR2_TABLE_100

Line 198: , a19 JTF_VARCHAR2_TABLE_100

194: , a15 JTF_VARCHAR2_TABLE_100
195: , a16 JTF_VARCHAR2_TABLE_100
196: , a17 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

Line 199: , a20 JTF_VARCHAR2_TABLE_100

195: , a16 JTF_VARCHAR2_TABLE_100
196: , a17 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

Line 202: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
206: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 204: , a3 out nocopy 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
208: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 205: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
208: , a7 out nocopy JTF_VARCHAR2_TABLE_300
209: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 209: , a8 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
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 210: , a9 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
212: , a11 out nocopy JTF_NUMBER_TABLE
213: , a12 out nocopy JTF_VARCHAR2_TABLE_100
214: , a13 out nocopy JTF_NUMBER_TABLE

Line 213: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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
217: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 216: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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
220: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 217: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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
220: , a19 out nocopy JTF_VARCHAR2_TABLE_100
221: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 220: , a19 out nocopy JTF_VARCHAR2_TABLE_100

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
220: , a19 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 221: , a20 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
220: , a19 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 224: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100

220: , a19 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 227: , a3 JTF_VARCHAR2_TABLE_100

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: );
231: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: , a4 JTF_VARCHAR2_TABLE_100

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: );
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

Line 231: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

227: , a3 JTF_VARCHAR2_TABLE_100
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

Line 234: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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: );
238:

Line 235: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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: );
238:
239: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE

Line 240: , a1 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
244: , a5 JTF_VARCHAR2_TABLE_100

Line 241: , a2 JTF_VARCHAR2_TABLE_100

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
244: , a5 JTF_VARCHAR2_TABLE_100
245: , a6 JTF_NUMBER_TABLE

Line 244: , a5 JTF_VARCHAR2_TABLE_100

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: );
248: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE

Line 249: , a1 out nocopy 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
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 250: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
253: , a5 out nocopy JTF_VARCHAR2_TABLE_100
254: , a6 out nocopy JTF_NUMBER_TABLE

Line 253: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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: );
257:

Line 261: , p2_a1 JTF_VARCHAR2_TABLE_100

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
265: , p_subinv_only number

Line 267: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
271: , x_msg_data out nocopy VARCHAR2

Line 292: , p4_a1 JTF_VARCHAR2_TABLE_100

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
296: , p4_a5 JTF_NUMBER_TABLE

Line 293: , p4_a2 JTF_VARCHAR2_TABLE_100

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
296: , p4_a5 JTF_NUMBER_TABLE
297: , p_timezone_id NUMBER

Line 295: , p4_a4 JTF_VARCHAR2_TABLE_100

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
299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 299: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
303: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
310: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 309: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 312: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

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
316: , x_msg_count out nocopy NUMBER

Line 313: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
316: , x_msg_count out nocopy NUMBER
317: , p_called_from VARCHAR2

Line 331: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100

327: , p0_a7 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

Line 334: , p0_a3 JTF_VARCHAR2_TABLE_100

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
338: , p1_a1 JTF_VARCHAR2_TABLE_100

Line 335: , p0_a4 JTF_VARCHAR2_TABLE_100

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
338: , p1_a1 JTF_VARCHAR2_TABLE_100
339: , p1_a2 JTF_VARCHAR2_TABLE_100

Line 338: , p1_a1 JTF_VARCHAR2_TABLE_100

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
342: , p1_a5 JTF_NUMBER_TABLE

Line 339: , p1_a2 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
342: , p1_a5 JTF_NUMBER_TABLE
343: , p_include_alternate VARCHAR2

Line 341: , p1_a4 JTF_VARCHAR2_TABLE_100

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
345: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 345: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
349: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 347: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
351: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 348: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
351: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
352: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 352: , p3_a8 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
355: , p3_a11 out nocopy JTF_NUMBER_TABLE
356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 353: , p3_a9 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
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

Line 356: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
360: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 359: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
363: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 360: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
363: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
364: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 363: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
363: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
364: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_data out nocopy VARCHAR2
367: , x_msg_count out nocopy NUMBER

Line 364: , p3_a20 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
363: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
364: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_data out nocopy VARCHAR2
367: , x_msg_count out nocopy NUMBER
368: );

Line 372: , p2_a1 JTF_VARCHAR2_TABLE_100

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
376: , p2_a5 JTF_NUMBER_TABLE

Line 373: , p2_a2 JTF_VARCHAR2_TABLE_100

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
376: , p2_a5 JTF_NUMBER_TABLE
377: , p_include_alternate VARCHAR2

Line 375: , p2_a4 JTF_VARCHAR2_TABLE_100

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
379: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 379: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
383: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 381: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
385: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 382: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
385: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
386: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 386: , p4_a8 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
389: , p4_a11 out nocopy JTF_NUMBER_TABLE
390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 387: , p4_a9 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
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

Line 390: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
394: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 393: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
397: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 394: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
397: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 397: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
397: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_data out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER

Line 398: , p4_a20 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
397: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_data out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: );

Line 406: , p2_a1 JTF_VARCHAR2_TABLE_100

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
410: , p2_a5 JTF_NUMBER_TABLE

Line 407: , p2_a2 JTF_VARCHAR2_TABLE_100

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
410: , p2_a5 JTF_NUMBER_TABLE
411: , p_include_alternate VARCHAR2

Line 409: , p2_a4 JTF_VARCHAR2_TABLE_100

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
413: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 413: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
417: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 415: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
419: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 416: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
419: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
420: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 420: , p4_a8 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
423: , p4_a11 out nocopy JTF_NUMBER_TABLE
424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p4_a9 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
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

Line 424: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
428: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 427: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
431: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 428: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

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
431: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 431: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
431: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
433: , x_return_status out nocopy VARCHAR2
434: , x_msg_data out nocopy VARCHAR2
435: , x_msg_count out nocopy NUMBER

Line 432: , p4_a20 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
431: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
433: , x_return_status out nocopy VARCHAR2
434: , x_msg_data out nocopy VARCHAR2
435: , x_msg_count out nocopy NUMBER
436: );

Line 445: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 446: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p2_a6 in out nocopy JTF_NUMBER_TABLE

Line 449: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

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
453: , x_msg_data out nocopy VARCHAR2