APPS.AHL_VWP_RULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 15: , a5 JTF_VARCHAR2_TABLE_100

11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p4(t ahl_vwp_rules_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_NUMBER_TABLE

Line 22: , a5 out nocopy JTF_VARCHAR2_TABLE_100

18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_NUMBER_TABLE
20: , a3 out nocopy JTF_NUMBER_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: );
24:
25: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_rules_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE

Line 28: , a3 JTF_VARCHAR2_TABLE_100

24:
25: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_rules_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE

Line 31: , a6 JTF_VARCHAR2_TABLE_100

27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE
35: , a10 JTF_VARCHAR2_TABLE_100

Line 35: , a10 JTF_VARCHAR2_TABLE_100

31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_VARCHAR2_TABLE_100
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_NUMBER_TABLE

Line 37: , a12 JTF_VARCHAR2_TABLE_100

33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_VARCHAR2_TABLE_100
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_NUMBER_TABLE
40: , a15 JTF_VARCHAR2_TABLE_300
41: , a16 JTF_NUMBER_TABLE

Line 42: , a17 JTF_VARCHAR2_TABLE_100

38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_NUMBER_TABLE
40: , a15 JTF_VARCHAR2_TABLE_300
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_NUMBER_TABLE
44: , a19 JTF_NUMBER_TABLE
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_VARCHAR2_TABLE_100

Line 46: , a21 JTF_VARCHAR2_TABLE_100

42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_NUMBER_TABLE
44: , a19 JTF_NUMBER_TABLE
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_VARCHAR2_TABLE_100
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE

Line 52: , a27 JTF_VARCHAR2_TABLE_100

48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_VARCHAR2_TABLE_100
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: , a30 JTF_VARCHAR2_TABLE_4000
56: , a31 JTF_VARCHAR2_TABLE_100

Line 53: , a28 JTF_VARCHAR2_TABLE_100

49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_VARCHAR2_TABLE_100
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: , a30 JTF_VARCHAR2_TABLE_4000
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_VARCHAR2_TABLE_100

Line 54: , a29 JTF_VARCHAR2_TABLE_100

50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_VARCHAR2_TABLE_100
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: , a30 JTF_VARCHAR2_TABLE_4000
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_VARCHAR2_TABLE_100
58: , a33 JTF_NUMBER_TABLE

Line 56: , a31 JTF_VARCHAR2_TABLE_100

52: , a27 JTF_VARCHAR2_TABLE_100
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: , a30 JTF_VARCHAR2_TABLE_4000
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_VARCHAR2_TABLE_100
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE

Line 57: , a32 JTF_VARCHAR2_TABLE_100

53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: , a30 JTF_VARCHAR2_TABLE_4000
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_VARCHAR2_TABLE_100
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE

Line 64: , a39 JTF_VARCHAR2_TABLE_100

60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_NUMBER_TABLE
63: , a38 JTF_NUMBER_TABLE
64: , a39 JTF_VARCHAR2_TABLE_100
65: , a40 JTF_VARCHAR2_TABLE_200
66: , a41 JTF_VARCHAR2_TABLE_200
67: , a42 JTF_VARCHAR2_TABLE_200
68: , a43 JTF_VARCHAR2_TABLE_200

Line 83: , a58 JTF_VARCHAR2_TABLE_100

79: , a54 JTF_VARCHAR2_TABLE_200
80: , a55 JTF_DATE_TABLE
81: , a56 JTF_DATE_TABLE
82: , a57 JTF_DATE_TABLE
83: , a58 JTF_VARCHAR2_TABLE_100
84: , a59 JTF_VARCHAR2_TABLE_100
85: , a60 JTF_NUMBER_TABLE
86: , a61 JTF_NUMBER_TABLE
87: , a62 JTF_VARCHAR2_TABLE_100

Line 84: , a59 JTF_VARCHAR2_TABLE_100

80: , a55 JTF_DATE_TABLE
81: , a56 JTF_DATE_TABLE
82: , a57 JTF_DATE_TABLE
83: , a58 JTF_VARCHAR2_TABLE_100
84: , a59 JTF_VARCHAR2_TABLE_100
85: , a60 JTF_NUMBER_TABLE
86: , a61 JTF_NUMBER_TABLE
87: , a62 JTF_VARCHAR2_TABLE_100
88: , a63 JTF_NUMBER_TABLE

Line 87: , a62 JTF_VARCHAR2_TABLE_100

83: , a58 JTF_VARCHAR2_TABLE_100
84: , a59 JTF_VARCHAR2_TABLE_100
85: , a60 JTF_NUMBER_TABLE
86: , a61 JTF_NUMBER_TABLE
87: , a62 JTF_VARCHAR2_TABLE_100
88: , a63 JTF_NUMBER_TABLE
89: , a64 JTF_VARCHAR2_TABLE_300
90: , a65 JTF_VARCHAR2_TABLE_100
91: , a66 JTF_DATE_TABLE

Line 90: , a65 JTF_VARCHAR2_TABLE_100

86: , a61 JTF_NUMBER_TABLE
87: , a62 JTF_VARCHAR2_TABLE_100
88: , a63 JTF_NUMBER_TABLE
89: , a64 JTF_VARCHAR2_TABLE_300
90: , a65 JTF_VARCHAR2_TABLE_100
91: , a66 JTF_DATE_TABLE
92: , a67 JTF_DATE_TABLE
93: , a68 JTF_VARCHAR2_TABLE_100
94: , a69 JTF_VARCHAR2_TABLE_100

Line 93: , a68 JTF_VARCHAR2_TABLE_100

89: , a64 JTF_VARCHAR2_TABLE_300
90: , a65 JTF_VARCHAR2_TABLE_100
91: , a66 JTF_DATE_TABLE
92: , a67 JTF_DATE_TABLE
93: , a68 JTF_VARCHAR2_TABLE_100
94: , a69 JTF_VARCHAR2_TABLE_100
95: , a70 JTF_VARCHAR2_TABLE_100
96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100

Line 94: , a69 JTF_VARCHAR2_TABLE_100

90: , a65 JTF_VARCHAR2_TABLE_100
91: , a66 JTF_DATE_TABLE
92: , a67 JTF_DATE_TABLE
93: , a68 JTF_VARCHAR2_TABLE_100
94: , a69 JTF_VARCHAR2_TABLE_100
95: , a70 JTF_VARCHAR2_TABLE_100
96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100
98: , a73 JTF_NUMBER_TABLE

Line 95: , a70 JTF_VARCHAR2_TABLE_100

91: , a66 JTF_DATE_TABLE
92: , a67 JTF_DATE_TABLE
93: , a68 JTF_VARCHAR2_TABLE_100
94: , a69 JTF_VARCHAR2_TABLE_100
95: , a70 JTF_VARCHAR2_TABLE_100
96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100
98: , a73 JTF_NUMBER_TABLE
99: , a74 JTF_VARCHAR2_TABLE_100

Line 97: , a72 JTF_VARCHAR2_TABLE_100

93: , a68 JTF_VARCHAR2_TABLE_100
94: , a69 JTF_VARCHAR2_TABLE_100
95: , a70 JTF_VARCHAR2_TABLE_100
96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100
98: , a73 JTF_NUMBER_TABLE
99: , a74 JTF_VARCHAR2_TABLE_100
100: , a75 JTF_VARCHAR2_TABLE_100
101: );

Line 99: , a74 JTF_VARCHAR2_TABLE_100

95: , a70 JTF_VARCHAR2_TABLE_100
96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100
98: , a73 JTF_NUMBER_TABLE
99: , a74 JTF_VARCHAR2_TABLE_100
100: , a75 JTF_VARCHAR2_TABLE_100
101: );
102: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE

Line 100: , a75 JTF_VARCHAR2_TABLE_100

96: , a71 JTF_NUMBER_TABLE
97: , a72 JTF_VARCHAR2_TABLE_100
98: , a73 JTF_NUMBER_TABLE
99: , a74 JTF_VARCHAR2_TABLE_100
100: , a75 JTF_VARCHAR2_TABLE_100
101: );
102: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE

Line 105: , a3 out nocopy JTF_VARCHAR2_TABLE_100

101: );
102: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_NUMBER_TABLE

Line 108: , a6 out nocopy JTF_VARCHAR2_TABLE_100

104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_NUMBER_TABLE
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , a10 out nocopy JTF_VARCHAR2_TABLE_100

108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_NUMBER_TABLE
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_NUMBER_TABLE
116: , a14 out nocopy JTF_NUMBER_TABLE

Line 114: , a12 out nocopy JTF_VARCHAR2_TABLE_100

110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_NUMBER_TABLE
116: , a14 out nocopy JTF_NUMBER_TABLE
117: , a15 out nocopy JTF_VARCHAR2_TABLE_300
118: , a16 out nocopy JTF_NUMBER_TABLE

Line 119: , a17 out nocopy JTF_VARCHAR2_TABLE_100

115: , a13 out nocopy JTF_NUMBER_TABLE
116: , a14 out nocopy JTF_NUMBER_TABLE
117: , a15 out nocopy JTF_VARCHAR2_TABLE_300
118: , a16 out nocopy JTF_NUMBER_TABLE
119: , a17 out nocopy JTF_VARCHAR2_TABLE_100
120: , a18 out nocopy JTF_NUMBER_TABLE
121: , a19 out nocopy JTF_NUMBER_TABLE
122: , a20 out nocopy JTF_NUMBER_TABLE
123: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 123: , a21 out nocopy JTF_VARCHAR2_TABLE_100

119: , a17 out nocopy JTF_VARCHAR2_TABLE_100
120: , a18 out nocopy JTF_NUMBER_TABLE
121: , a19 out nocopy JTF_NUMBER_TABLE
122: , a20 out nocopy JTF_NUMBER_TABLE
123: , a21 out nocopy JTF_VARCHAR2_TABLE_100
124: , a22 out nocopy JTF_NUMBER_TABLE
125: , a23 out nocopy JTF_NUMBER_TABLE
126: , a24 out nocopy JTF_NUMBER_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE

Line 129: , a27 out nocopy JTF_VARCHAR2_TABLE_100

125: , a23 out nocopy JTF_NUMBER_TABLE
126: , a24 out nocopy JTF_NUMBER_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_VARCHAR2_TABLE_100
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: , a30 out nocopy JTF_VARCHAR2_TABLE_4000
133: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , a28 out nocopy JTF_VARCHAR2_TABLE_100

126: , a24 out nocopy JTF_NUMBER_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_VARCHAR2_TABLE_100
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: , a30 out nocopy JTF_VARCHAR2_TABLE_4000
133: , a31 out nocopy JTF_VARCHAR2_TABLE_100
134: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a29 out nocopy JTF_VARCHAR2_TABLE_100

127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_VARCHAR2_TABLE_100
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: , a30 out nocopy JTF_VARCHAR2_TABLE_4000
133: , a31 out nocopy JTF_VARCHAR2_TABLE_100
134: , a32 out nocopy JTF_VARCHAR2_TABLE_100
135: , a33 out nocopy JTF_NUMBER_TABLE

Line 133: , a31 out nocopy JTF_VARCHAR2_TABLE_100

129: , a27 out nocopy JTF_VARCHAR2_TABLE_100
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: , a30 out nocopy JTF_VARCHAR2_TABLE_4000
133: , a31 out nocopy JTF_VARCHAR2_TABLE_100
134: , a32 out nocopy JTF_VARCHAR2_TABLE_100
135: , a33 out nocopy JTF_NUMBER_TABLE
136: , a34 out nocopy JTF_DATE_TABLE
137: , a35 out nocopy JTF_NUMBER_TABLE

Line 134: , a32 out nocopy JTF_VARCHAR2_TABLE_100

130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: , a30 out nocopy JTF_VARCHAR2_TABLE_4000
133: , a31 out nocopy JTF_VARCHAR2_TABLE_100
134: , a32 out nocopy JTF_VARCHAR2_TABLE_100
135: , a33 out nocopy JTF_NUMBER_TABLE
136: , a34 out nocopy JTF_DATE_TABLE
137: , a35 out nocopy JTF_NUMBER_TABLE
138: , a36 out nocopy JTF_DATE_TABLE

Line 141: , a39 out nocopy JTF_VARCHAR2_TABLE_100

137: , a35 out nocopy JTF_NUMBER_TABLE
138: , a36 out nocopy JTF_DATE_TABLE
139: , a37 out nocopy JTF_NUMBER_TABLE
140: , a38 out nocopy JTF_NUMBER_TABLE
141: , a39 out nocopy JTF_VARCHAR2_TABLE_100
142: , a40 out nocopy JTF_VARCHAR2_TABLE_200
143: , a41 out nocopy JTF_VARCHAR2_TABLE_200
144: , a42 out nocopy JTF_VARCHAR2_TABLE_200
145: , a43 out nocopy JTF_VARCHAR2_TABLE_200

Line 160: , a58 out nocopy JTF_VARCHAR2_TABLE_100

156: , a54 out nocopy JTF_VARCHAR2_TABLE_200
157: , a55 out nocopy JTF_DATE_TABLE
158: , a56 out nocopy JTF_DATE_TABLE
159: , a57 out nocopy JTF_DATE_TABLE
160: , a58 out nocopy JTF_VARCHAR2_TABLE_100
161: , a59 out nocopy JTF_VARCHAR2_TABLE_100
162: , a60 out nocopy JTF_NUMBER_TABLE
163: , a61 out nocopy JTF_NUMBER_TABLE
164: , a62 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , a59 out nocopy JTF_VARCHAR2_TABLE_100

157: , a55 out nocopy JTF_DATE_TABLE
158: , a56 out nocopy JTF_DATE_TABLE
159: , a57 out nocopy JTF_DATE_TABLE
160: , a58 out nocopy JTF_VARCHAR2_TABLE_100
161: , a59 out nocopy JTF_VARCHAR2_TABLE_100
162: , a60 out nocopy JTF_NUMBER_TABLE
163: , a61 out nocopy JTF_NUMBER_TABLE
164: , a62 out nocopy JTF_VARCHAR2_TABLE_100
165: , a63 out nocopy JTF_NUMBER_TABLE

Line 164: , a62 out nocopy JTF_VARCHAR2_TABLE_100

160: , a58 out nocopy JTF_VARCHAR2_TABLE_100
161: , a59 out nocopy JTF_VARCHAR2_TABLE_100
162: , a60 out nocopy JTF_NUMBER_TABLE
163: , a61 out nocopy JTF_NUMBER_TABLE
164: , a62 out nocopy JTF_VARCHAR2_TABLE_100
165: , a63 out nocopy JTF_NUMBER_TABLE
166: , a64 out nocopy JTF_VARCHAR2_TABLE_300
167: , a65 out nocopy JTF_VARCHAR2_TABLE_100
168: , a66 out nocopy JTF_DATE_TABLE

Line 167: , a65 out nocopy JTF_VARCHAR2_TABLE_100

163: , a61 out nocopy JTF_NUMBER_TABLE
164: , a62 out nocopy JTF_VARCHAR2_TABLE_100
165: , a63 out nocopy JTF_NUMBER_TABLE
166: , a64 out nocopy JTF_VARCHAR2_TABLE_300
167: , a65 out nocopy JTF_VARCHAR2_TABLE_100
168: , a66 out nocopy JTF_DATE_TABLE
169: , a67 out nocopy JTF_DATE_TABLE
170: , a68 out nocopy JTF_VARCHAR2_TABLE_100
171: , a69 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , a68 out nocopy JTF_VARCHAR2_TABLE_100

166: , a64 out nocopy JTF_VARCHAR2_TABLE_300
167: , a65 out nocopy JTF_VARCHAR2_TABLE_100
168: , a66 out nocopy JTF_DATE_TABLE
169: , a67 out nocopy JTF_DATE_TABLE
170: , a68 out nocopy JTF_VARCHAR2_TABLE_100
171: , a69 out nocopy JTF_VARCHAR2_TABLE_100
172: , a70 out nocopy JTF_VARCHAR2_TABLE_100
173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100

Line 171: , a69 out nocopy JTF_VARCHAR2_TABLE_100

167: , a65 out nocopy JTF_VARCHAR2_TABLE_100
168: , a66 out nocopy JTF_DATE_TABLE
169: , a67 out nocopy JTF_DATE_TABLE
170: , a68 out nocopy JTF_VARCHAR2_TABLE_100
171: , a69 out nocopy JTF_VARCHAR2_TABLE_100
172: , a70 out nocopy JTF_VARCHAR2_TABLE_100
173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100
175: , a73 out nocopy JTF_NUMBER_TABLE

Line 172: , a70 out nocopy JTF_VARCHAR2_TABLE_100

168: , a66 out nocopy JTF_DATE_TABLE
169: , a67 out nocopy JTF_DATE_TABLE
170: , a68 out nocopy JTF_VARCHAR2_TABLE_100
171: , a69 out nocopy JTF_VARCHAR2_TABLE_100
172: , a70 out nocopy JTF_VARCHAR2_TABLE_100
173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100
175: , a73 out nocopy JTF_NUMBER_TABLE
176: , a74 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , a72 out nocopy JTF_VARCHAR2_TABLE_100

170: , a68 out nocopy JTF_VARCHAR2_TABLE_100
171: , a69 out nocopy JTF_VARCHAR2_TABLE_100
172: , a70 out nocopy JTF_VARCHAR2_TABLE_100
173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100
175: , a73 out nocopy JTF_NUMBER_TABLE
176: , a74 out nocopy JTF_VARCHAR2_TABLE_100
177: , a75 out nocopy JTF_VARCHAR2_TABLE_100
178: );

Line 176: , a74 out nocopy JTF_VARCHAR2_TABLE_100

172: , a70 out nocopy JTF_VARCHAR2_TABLE_100
173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100
175: , a73 out nocopy JTF_NUMBER_TABLE
176: , a74 out nocopy JTF_VARCHAR2_TABLE_100
177: , a75 out nocopy JTF_VARCHAR2_TABLE_100
178: );
179:
180: procedure tech_dependency(p_visit_id NUMBER

Line 177: , a75 out nocopy JTF_VARCHAR2_TABLE_100

173: , a71 out nocopy JTF_NUMBER_TABLE
174: , a72 out nocopy JTF_VARCHAR2_TABLE_100
175: , a73 out nocopy JTF_NUMBER_TABLE
176: , a74 out nocopy JTF_VARCHAR2_TABLE_100
177: , a75 out nocopy JTF_VARCHAR2_TABLE_100
178: );
179:
180: procedure tech_dependency(p_visit_id NUMBER
181: , p_task_type VARCHAR2

Line 191: , p0_a5 JTF_VARCHAR2_TABLE_100

187: , p0_a1 JTF_NUMBER_TABLE
188: , p0_a2 JTF_NUMBER_TABLE
189: , p0_a3 JTF_NUMBER_TABLE
190: , p0_a4 JTF_DATE_TABLE
191: , p0_a5 JTF_VARCHAR2_TABLE_100
192: , p1_a0 JTF_NUMBER_TABLE
193: , p1_a1 JTF_NUMBER_TABLE
194: , p1_a2 JTF_NUMBER_TABLE
195: , p1_a3 JTF_NUMBER_TABLE

Line 197: , p1_a5 JTF_VARCHAR2_TABLE_100

193: , p1_a1 JTF_NUMBER_TABLE
194: , p1_a2 JTF_NUMBER_TABLE
195: , p1_a3 JTF_NUMBER_TABLE
196: , p1_a4 JTF_DATE_TABLE
197: , p1_a5 JTF_VARCHAR2_TABLE_100
198: , p2_a0 out nocopy JTF_NUMBER_TABLE
199: , p2_a1 out nocopy JTF_NUMBER_TABLE
200: , p2_a2 out nocopy JTF_NUMBER_TABLE
201: , p2_a3 out nocopy JTF_NUMBER_TABLE

Line 203: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

199: , p2_a1 out nocopy JTF_NUMBER_TABLE
200: , p2_a2 out nocopy JTF_NUMBER_TABLE
201: , p2_a3 out nocopy JTF_NUMBER_TABLE
202: , p2_a4 out nocopy JTF_DATE_TABLE
203: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
204: );
205: end ahl_vwp_rules_pvt_w;