DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT_W dependencies on JTF_DATE_TABLE

Line 7: , a4 JTF_DATE_TABLE

3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_DATE_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300

Line 20: , a17 JTF_DATE_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE

Line 23: , a20 JTF_DATE_TABLE

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE

Line 26: , a23 JTF_DATE_TABLE

22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100

Line 27: , a24 JTF_DATE_TABLE

23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100

Line 86: , a4 out nocopy JTF_DATE_TABLE

82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE

Line 88: , a6 out nocopy JTF_DATE_TABLE

84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 99: , a17 out nocopy JTF_DATE_TABLE

95: , a13 out nocopy JTF_NUMBER_TABLE
96: , a14 out nocopy JTF_VARCHAR2_TABLE_100
97: , a15 out nocopy JTF_VARCHAR2_TABLE_100
98: , a16 out nocopy JTF_VARCHAR2_TABLE_100
99: , a17 out nocopy JTF_DATE_TABLE
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE

Line 102: , a20 out nocopy JTF_DATE_TABLE

98: , a16 out nocopy JTF_VARCHAR2_TABLE_100
99: , a17 out nocopy JTF_DATE_TABLE
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
106: , a24 out nocopy JTF_DATE_TABLE

Line 105: , a23 out nocopy JTF_DATE_TABLE

101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
106: , a24 out nocopy JTF_DATE_TABLE
107: , a25 out nocopy JTF_VARCHAR2_TABLE_100
108: , a26 out nocopy JTF_VARCHAR2_TABLE_100
109: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a24 out nocopy JTF_DATE_TABLE

102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
106: , a24 out nocopy JTF_DATE_TABLE
107: , a25 out nocopy JTF_VARCHAR2_TABLE_100
108: , a26 out nocopy JTF_VARCHAR2_TABLE_100
109: , a27 out nocopy JTF_VARCHAR2_TABLE_100
110: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , a5 JTF_DATE_TABLE

163: , a1 JTF_VARCHAR2_TABLE_100
164: , a2 JTF_VARCHAR2_TABLE_100
165: , a3 JTF_VARCHAR2_TABLE_100
166: , a4 JTF_VARCHAR2_TABLE_100
167: , a5 JTF_DATE_TABLE
168: , a6 JTF_DATE_TABLE
169: , a7 JTF_VARCHAR2_TABLE_100
170: );
171: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 168: , a6 JTF_DATE_TABLE

164: , a2 JTF_VARCHAR2_TABLE_100
165: , a3 JTF_VARCHAR2_TABLE_100
166: , a4 JTF_VARCHAR2_TABLE_100
167: , a5 JTF_DATE_TABLE
168: , a6 JTF_DATE_TABLE
169: , a7 JTF_VARCHAR2_TABLE_100
170: );
171: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , a5 out nocopy JTF_DATE_TABLE

172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100
179: );
180:

Line 177: , a6 out nocopy JTF_DATE_TABLE

173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100
179: );
180:
181: procedure process_visit(p_api_version NUMBER

Line 190: , p5_a4 in out nocopy JTF_DATE_TABLE

186: , p5_a0 in out nocopy JTF_NUMBER_TABLE
187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE

Line 192: , p5_a6 in out nocopy JTF_DATE_TABLE

188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300

Line 203: , p5_a17 in out nocopy JTF_DATE_TABLE

199: , p5_a13 in out nocopy JTF_NUMBER_TABLE
200: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a17 in out nocopy JTF_DATE_TABLE
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE

Line 206: , p5_a20 in out nocopy JTF_DATE_TABLE

202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a17 in out nocopy JTF_DATE_TABLE
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
210: , p5_a24 in out nocopy JTF_DATE_TABLE

Line 209: , p5_a23 in out nocopy JTF_DATE_TABLE

205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
210: , p5_a24 in out nocopy JTF_DATE_TABLE
211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

Line 210: , p5_a24 in out nocopy JTF_DATE_TABLE

206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
210: , p5_a24 in out nocopy JTF_DATE_TABLE
211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100