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 120.6.12020000.2 2012/07/17 08:04:34 htank ship $ */
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: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_NUMBER_TABLE

Line 21: , a1 out nocopy JTF_VARCHAR2_TABLE_100

17: , a7 JTF_VARCHAR2_TABLE_4000
18: , a8 JTF_VARCHAR2_TABLE_4000
19: );
20: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_VARCHAR2_TABLE_100
22: , a2 out nocopy JTF_DATE_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_NUMBER_TABLE

Line 32: , a1 JTF_VARCHAR2_TABLE_100

28: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
29: );
30:
31: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
32: , a1 JTF_VARCHAR2_TABLE_100
33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100

Line 35: , a4 JTF_VARCHAR2_TABLE_100

31: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
32: , a1 JTF_VARCHAR2_TABLE_100
33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE

Line 36: , a5 JTF_VARCHAR2_TABLE_100

32: , a1 JTF_VARCHAR2_TABLE_100
33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100

Line 40: , a9 JTF_VARCHAR2_TABLE_100

36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE

Line 43: , a1 out nocopy JTF_VARCHAR2_TABLE_100

39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE

Line 47: , a5 out nocopy JTF_VARCHAR2_TABLE_100

43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100

Line 55: , a1 JTF_VARCHAR2_TABLE_100

51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_NUMBER_TABLE
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE

Line 60: , a6 JTF_VARCHAR2_TABLE_100

56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_NUMBER_TABLE
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE

Line 62: , a8 JTF_VARCHAR2_TABLE_100

58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100

Line 66: , a12 JTF_VARCHAR2_TABLE_100

62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100

Line 68: , a14 JTF_VARCHAR2_TABLE_100

64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 70: , a16 JTF_VARCHAR2_TABLE_100

66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE

Line 73: , a1 out nocopy JTF_VARCHAR2_TABLE_100

69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE

Line 78: , a6 out nocopy JTF_VARCHAR2_TABLE_100

74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE

Line 80: , a8 out nocopy JTF_VARCHAR2_TABLE_100

76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , a12 out nocopy JTF_VARCHAR2_TABLE_100

80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a14 out nocopy JTF_VARCHAR2_TABLE_100

82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:

Line 88: , a16 out nocopy JTF_VARCHAR2_TABLE_100

84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100

Line 92: , a1 JTF_VARCHAR2_TABLE_100

88: , a16 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE

Line 93: , a2 JTF_VARCHAR2_TABLE_100

89: );
90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );

Line 95: , a4 JTF_VARCHAR2_TABLE_100

91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a1 out nocopy JTF_VARCHAR2_TABLE_100

95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE

Line 100: , a2 out nocopy JTF_VARCHAR2_TABLE_100

96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE
104: );

Line 102: , a4 out nocopy JTF_VARCHAR2_TABLE_100

98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

Line 107: , a1 JTF_VARCHAR2_TABLE_100

103: , a5 out nocopy JTF_NUMBER_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE

Line 110: , a4 JTF_VARCHAR2_TABLE_100

106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100

Line 114: , a8 JTF_VARCHAR2_TABLE_100

110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE

Line 117: , a11 JTF_VARCHAR2_TABLE_100

113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100

Line 120: , a14 JTF_VARCHAR2_TABLE_100

116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a15 JTF_VARCHAR2_TABLE_100

117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE

Line 124: , a1 out nocopy JTF_VARCHAR2_TABLE_100

120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE

Line 127: , a4 out nocopy JTF_VARCHAR2_TABLE_100

123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a8 out nocopy JTF_VARCHAR2_TABLE_100

127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE

Line 134: , a11 out nocopy JTF_VARCHAR2_TABLE_100

130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a14 out nocopy JTF_VARCHAR2_TABLE_100

133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

Line 138: , a15 out nocopy JTF_VARCHAR2_TABLE_100

134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100

Line 142: , a1 JTF_VARCHAR2_TABLE_100

138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE

Line 145: , a4 JTF_VARCHAR2_TABLE_100

141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100

Line 149: , a8 JTF_VARCHAR2_TABLE_100

145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE

Line 152: , a11 JTF_VARCHAR2_TABLE_100

148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE
154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100

Line 155: , a14 JTF_VARCHAR2_TABLE_100

151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE
154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a15 JTF_VARCHAR2_TABLE_100

152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE
154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE

Line 159: , a1 out nocopy JTF_VARCHAR2_TABLE_100

155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE

Line 162: , a4 out nocopy JTF_VARCHAR2_TABLE_100

158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , a8 out nocopy JTF_VARCHAR2_TABLE_100

162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE

Line 169: , a11 out nocopy JTF_VARCHAR2_TABLE_100

165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE
171: , a13 out nocopy JTF_NUMBER_TABLE
172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 172: , a14 out nocopy JTF_VARCHAR2_TABLE_100

168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE
171: , a13 out nocopy JTF_NUMBER_TABLE
172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );
175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

Line 173: , a15 out nocopy JTF_VARCHAR2_TABLE_100

169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE
171: , a13 out nocopy JTF_NUMBER_TABLE
172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );
175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100

Line 177: , a1 JTF_VARCHAR2_TABLE_100

173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );
175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE

Line 178: , a2 JTF_VARCHAR2_TABLE_100

174: );
175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );

Line 180: , a4 JTF_VARCHAR2_TABLE_100

176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 184: , a1 out nocopy JTF_VARCHAR2_TABLE_100

180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE

Line 185: , a2 out nocopy JTF_VARCHAR2_TABLE_100

181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE
189: );

Line 187: , a4 out nocopy JTF_VARCHAR2_TABLE_100

183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE
189: );
190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

Line 192: , a1 JTF_VARCHAR2_TABLE_100

188: , a5 out nocopy JTF_NUMBER_TABLE
189: );
190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100
193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300

Line 194: , a3 JTF_VARCHAR2_TABLE_100

190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100
193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300

Line 195: , a4 JTF_VARCHAR2_TABLE_100

191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100
193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100

Line 199: , a8 JTF_VARCHAR2_TABLE_100

195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100

Line 200: , a9 JTF_VARCHAR2_TABLE_100

196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE

Line 203: , a12 JTF_VARCHAR2_TABLE_100

199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100

Line 206: , a15 JTF_VARCHAR2_TABLE_100

202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE
209: , a18 JTF_DATE_TABLE
210: , a19 JTF_VARCHAR2_TABLE_100

Line 207: , a16 JTF_VARCHAR2_TABLE_100

203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE
209: , a18 JTF_DATE_TABLE
210: , a19 JTF_VARCHAR2_TABLE_100
211: , a20 JTF_VARCHAR2_TABLE_100

Line 210: , a19 JTF_VARCHAR2_TABLE_100

206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE
209: , a18 JTF_DATE_TABLE
210: , a19 JTF_VARCHAR2_TABLE_100
211: , a20 JTF_VARCHAR2_TABLE_100
212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 211: , a20 JTF_VARCHAR2_TABLE_100

207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE
209: , a18 JTF_DATE_TABLE
210: , a19 JTF_VARCHAR2_TABLE_100
211: , a20 JTF_VARCHAR2_TABLE_100
212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE

Line 214: , a1 out nocopy JTF_VARCHAR2_TABLE_100

210: , a19 JTF_VARCHAR2_TABLE_100
211: , a20 JTF_VARCHAR2_TABLE_100
212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 216: , a3 out nocopy JTF_VARCHAR2_TABLE_100

212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 217: , a4 out nocopy JTF_VARCHAR2_TABLE_100

213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 221: , a8 out nocopy JTF_VARCHAR2_TABLE_100

217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 222: , a9 out nocopy JTF_VARCHAR2_TABLE_100

218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE

Line 225: , a12 out nocopy JTF_VARCHAR2_TABLE_100

221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: , a15 out nocopy JTF_VARCHAR2_TABLE_100

224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE
231: , a18 out nocopy JTF_DATE_TABLE
232: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 229: , a16 out nocopy JTF_VARCHAR2_TABLE_100

225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE
231: , a18 out nocopy JTF_DATE_TABLE
232: , a19 out nocopy JTF_VARCHAR2_TABLE_100
233: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 232: , a19 out nocopy JTF_VARCHAR2_TABLE_100

228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE
231: , a18 out nocopy JTF_DATE_TABLE
232: , a19 out nocopy JTF_VARCHAR2_TABLE_100
233: , a20 out nocopy JTF_VARCHAR2_TABLE_100
234: );
235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100

Line 233: , a20 out nocopy JTF_VARCHAR2_TABLE_100

229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE
231: , a18 out nocopy JTF_DATE_TABLE
232: , a19 out nocopy JTF_VARCHAR2_TABLE_100
233: , a20 out nocopy JTF_VARCHAR2_TABLE_100
234: );
235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE

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

232: , a19 out nocopy JTF_VARCHAR2_TABLE_100
233: , a20 out nocopy JTF_VARCHAR2_TABLE_100
234: );
235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE
238: , a2 JTF_NUMBER_TABLE
239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100

Line 239: , a3 JTF_VARCHAR2_TABLE_100

235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE
238: , a2 JTF_NUMBER_TABLE
239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300
242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 240: , a4 JTF_VARCHAR2_TABLE_100

236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE
238: , a2 JTF_NUMBER_TABLE
239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300
242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE

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

239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300
242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE
245: , a2 out nocopy JTF_NUMBER_TABLE
246: , a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , a3 out nocopy JTF_VARCHAR2_TABLE_100

242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE
245: , a2 out nocopy JTF_NUMBER_TABLE
246: , a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , a5 out nocopy JTF_VARCHAR2_TABLE_300
249: );
250:

Line 247: , a4 out nocopy JTF_VARCHAR2_TABLE_100

243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE
245: , a2 out nocopy JTF_NUMBER_TABLE
246: , a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , a5 out nocopy JTF_VARCHAR2_TABLE_300
249: );
250:
251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE

Line 252: , a1 JTF_VARCHAR2_TABLE_100

248: , a5 out nocopy JTF_VARCHAR2_TABLE_300
249: );
250:
251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100

Line 253: , a2 JTF_VARCHAR2_TABLE_100

249: );
250:
251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE

Line 256: , a5 JTF_VARCHAR2_TABLE_100

252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE

Line 261: , a1 out nocopy JTF_VARCHAR2_TABLE_100

257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , a2 out nocopy JTF_VARCHAR2_TABLE_100

258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE

Line 265: , a5 out nocopy JTF_VARCHAR2_TABLE_100

261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE
267: , a7 out nocopy JTF_NUMBER_TABLE
268: );
269:

Line 273: , p2_a1 JTF_VARCHAR2_TABLE_100

269:
270: procedure get_availability_options(p_api_version_number NUMBER
271: , p_task_id NUMBER
272: , p2_a0 JTF_NUMBER_TABLE
273: , p2_a1 JTF_VARCHAR2_TABLE_100
274: , p3_a0 DATE
275: , p3_a1 DATE
276: , p_likelihood NUMBER
277: , p_subinv_only number

Line 282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

278: , p_mandatory number
279: , p_trunk number
280: , p_warehouse number
281: , p9_a0 out nocopy JTF_NUMBER_TABLE
282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a2 out nocopy JTF_DATE_TABLE
284: , p9_a3 out nocopy JTF_NUMBER_TABLE
285: , p9_a4 out nocopy JTF_NUMBER_TABLE
286: , p9_a5 out nocopy JTF_NUMBER_TABLE

Line 320: , p4_a1 JTF_VARCHAR2_TABLE_100

316: , p_organization_id NUMBER
317: , p_subinv_code VARCHAR2
318: , p_need_by_date date
319: , p4_a0 JTF_NUMBER_TABLE
320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE

Line 321: , p4_a2 JTF_VARCHAR2_TABLE_100

317: , p_subinv_code VARCHAR2
318: , p_need_by_date date
319: , p4_a0 JTF_NUMBER_TABLE
320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER

Line 323: , p4_a4 JTF_VARCHAR2_TABLE_100

319: , p4_a0 JTF_NUMBER_TABLE
320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE
339: , p6_a13 out nocopy JTF_NUMBER_TABLE
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE
339: , p6_a13 out nocopy JTF_NUMBER_TABLE
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
342: , x_return_status out nocopy VARCHAR2
343: , x_msg_data out nocopy VARCHAR2
344: , x_msg_count out nocopy NUMBER

Line 341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE
339: , p6_a13 out nocopy JTF_NUMBER_TABLE
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
342: , x_return_status out nocopy VARCHAR2
343: , x_msg_data out nocopy VARCHAR2
344: , x_msg_count out nocopy NUMBER
345: , p_called_from VARCHAR2

Line 359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100

355: , p0_a7 VARCHAR2
356: , x_return_status out nocopy VARCHAR2
357: , x_msg_data out nocopy VARCHAR2
358: ) return number;
359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360: , p0_a1 JTF_NUMBER_TABLE
361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100

Line 362: , p0_a3 JTF_VARCHAR2_TABLE_100

358: ) return number;
359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360: , p0_a1 JTF_NUMBER_TABLE
361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100

Line 363: , p0_a4 JTF_VARCHAR2_TABLE_100

359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360: , p0_a1 JTF_NUMBER_TABLE
361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100

Line 366: , p1_a1 JTF_VARCHAR2_TABLE_100

362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE

Line 367: , p1_a2 JTF_VARCHAR2_TABLE_100

363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2

Line 369: , p1_a4 JTF_VARCHAR2_TABLE_100

365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE

Line 384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE
390: , p3_a18 out nocopy JTF_DATE_TABLE
391: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE
390: , p3_a18 out nocopy JTF_DATE_TABLE
391: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
392: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 391: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100

387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE
390: , p3_a18 out nocopy JTF_DATE_TABLE
391: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
392: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
393: , x_return_status out nocopy VARCHAR2
394: , x_msg_data out nocopy VARCHAR2
395: , x_msg_count out nocopy NUMBER

Line 392: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100

388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE
390: , p3_a18 out nocopy JTF_DATE_TABLE
391: , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
392: , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
393: , x_return_status out nocopy VARCHAR2
394: , x_msg_data out nocopy VARCHAR2
395: , x_msg_count out nocopy NUMBER
396: );

Line 400: , p2_a1 JTF_VARCHAR2_TABLE_100

396: );
397: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
398: , p_resource_id NUMBER
399: , p2_a0 JTF_NUMBER_TABLE
400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE

Line 401: , p2_a2 JTF_VARCHAR2_TABLE_100

397: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
398: , p_resource_id NUMBER
399: , p2_a0 JTF_NUMBER_TABLE
400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2

Line 403: , p2_a4 JTF_VARCHAR2_TABLE_100

399: , p2_a0 JTF_NUMBER_TABLE
400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE
424: , p4_a18 out nocopy JTF_DATE_TABLE
425: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE
424: , p4_a18 out nocopy JTF_DATE_TABLE
425: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
426: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE
424: , p4_a18 out nocopy JTF_DATE_TABLE
425: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
426: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_data out nocopy VARCHAR2
429: , x_msg_count out nocopy NUMBER

Line 426: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE
424: , p4_a18 out nocopy JTF_DATE_TABLE
425: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
426: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_data out nocopy VARCHAR2
429: , x_msg_count out nocopy NUMBER
430: );

Line 434: , p2_a1 JTF_VARCHAR2_TABLE_100

430: );
431: procedure ws_check_organizations(p_resource_type VARCHAR2
432: , p_resource_id NUMBER
433: , p2_a0 JTF_NUMBER_TABLE
434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE

Line 435: , p2_a2 JTF_VARCHAR2_TABLE_100

431: procedure ws_check_organizations(p_resource_type VARCHAR2
432: , p_resource_id NUMBER
433: , p2_a0 JTF_NUMBER_TABLE
434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2

Line 437: , p2_a4 JTF_VARCHAR2_TABLE_100

433: , p2_a0 JTF_NUMBER_TABLE
434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE
458: , p4_a18 out nocopy JTF_DATE_TABLE
459: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE
458: , p4_a18 out nocopy JTF_DATE_TABLE
459: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
460: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 459: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100

455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE
458: , p4_a18 out nocopy JTF_DATE_TABLE
459: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
460: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_data out nocopy VARCHAR2
463: , x_msg_count out nocopy NUMBER

Line 460: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE
458: , p4_a18 out nocopy JTF_DATE_TABLE
459: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
460: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_data out nocopy VARCHAR2
463: , x_msg_count out nocopy NUMBER
464: );

Line 473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100

469: , p0_a4 VARCHAR2
470: , p0_a5 NUMBER
471: , p_org_id NUMBER
472: , p2_a0 in out nocopy JTF_NUMBER_TABLE
473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100

470: , p0_a5 NUMBER
471: , p_org_id NUMBER
472: , p2_a0 in out nocopy JTF_NUMBER_TABLE
473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE

Line 477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100

473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE
479: , p2_a7 in out nocopy JTF_NUMBER_TABLE
480: , x_return_status out nocopy VARCHAR2
481: , x_msg_data out nocopy VARCHAR2

Line 496: , p0_a1 JTF_VARCHAR2_TABLE_100

492: , p_lead_time NUMBER
493: , p_org_id NUMBER
494: ) return date;
495: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE
496: , p0_a1 JTF_VARCHAR2_TABLE_100
497: , p_task_id NUMBER
498: , p_need_by_date date
499: , p_trunk number
500: , p_warehouse number

Line 503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

499: , p_trunk number
500: , p_warehouse number
501: , p_mandatory number
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a2 out nocopy JTF_DATE_TABLE
505: , p6_a3 out nocopy JTF_NUMBER_TABLE
506: , p6_a4 out nocopy JTF_NUMBER_TABLE
507: , p6_a5 out nocopy JTF_NUMBER_TABLE