APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_ltp_space_schedule_pvt_w as
2: /* $Header: AHLWSPSS.pls 120.1 2006/05/04 08:00 anraj noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWSPSS.pls 120.1 2006/05/04 08:00 anraj noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
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

Line 25: , a1 out nocopy JTF_NUMBER_TABLE

21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_VARCHAR2_TABLE_100
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 27: , a3 out nocopy JTF_NUMBER_TABLE

23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_VARCHAR2_TABLE_100
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_NUMBER_TABLE
31: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 35: , a11 out nocopy JTF_NUMBER_TABLE

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

Line 37: , a13 out nocopy JTF_NUMBER_TABLE

33: , a9 out nocopy JTF_VARCHAR2_TABLE_100
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_VARCHAR2_TABLE_100
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_VARCHAR2_TABLE_100
39: , a15 out nocopy JTF_VARCHAR2_TABLE_100
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_DATE_TABLE

Line 48: , a2 JTF_NUMBER_TABLE

44: );
45:
46: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
47: , a1 JTF_VARCHAR2_TABLE_100
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_VARCHAR2_TABLE_100
51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100

Line 51: , a5 JTF_NUMBER_TABLE

47: , a1 JTF_VARCHAR2_TABLE_100
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_VARCHAR2_TABLE_100
51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100

Line 71: , a2 out nocopy JTF_NUMBER_TABLE

67: , a21 JTF_VARCHAR2_TABLE_100
68: );
69: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_VARCHAR2_TABLE_100
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a5 out nocopy JTF_NUMBER_TABLE

70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_VARCHAR2_TABLE_100
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_VARCHAR2_TABLE_100
76: , a7 out nocopy JTF_VARCHAR2_TABLE_100
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE

89: , a20 out nocopy JTF_VARCHAR2_TABLE_100
90: , a21 out nocopy JTF_VARCHAR2_TABLE_100
91: );
92:
93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE

Line 96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE

92:
93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );
99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );
99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
101: , a1 JTF_VARCHAR2_TABLE_100
102: , a2 JTF_VARCHAR2_TABLE_100
103: , a3 JTF_NUMBER_TABLE
104: , a4 JTF_VARCHAR2_TABLE_100

Line 103: , a3 JTF_NUMBER_TABLE

99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
101: , a1 JTF_VARCHAR2_TABLE_100
102: , a2 JTF_VARCHAR2_TABLE_100
103: , a3 JTF_NUMBER_TABLE
104: , a4 JTF_VARCHAR2_TABLE_100
105: , a5 JTF_VARCHAR2_TABLE_100
106: , a6 JTF_VARCHAR2_TABLE_100
107: , a7 JTF_VARCHAR2_TABLE_300

Line 114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

110: , a10 JTF_DATE_TABLE
111: , a11 JTF_DATE_TABLE
112: , a12 JTF_DATE_TABLE
113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_NUMBER_TABLE
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a3 out nocopy JTF_NUMBER_TABLE

113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_NUMBER_TABLE
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100
119: , a5 out nocopy JTF_VARCHAR2_TABLE_100
120: , a6 out nocopy JTF_VARCHAR2_TABLE_100
121: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 129: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE

125: , a11 out nocopy JTF_DATE_TABLE
126: , a12 out nocopy JTF_DATE_TABLE
127: );
128:
129: procedure derive_visit_end_date(p0_a0 in out nocopy JTF_NUMBER_TABLE
130: , p0_a1 in out nocopy JTF_DATE_TABLE
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2

Line 162: , p6_a2 out nocopy JTF_NUMBER_TABLE

158: , p5_a18 DATE
159: , p5_a19 DATE
160: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
161: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a5 out nocopy JTF_NUMBER_TABLE
166: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 165: , p6_a5 out nocopy JTF_NUMBER_TABLE

161: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a5 out nocopy JTF_NUMBER_TABLE
166: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 255: , p6_a0 out nocopy JTF_NUMBER_TABLE

251: , p5_a16 VARCHAR2
252: , p5_a17 DATE
253: , p5_a18 DATE
254: , p5_a19 DATE
255: , p6_a0 out nocopy JTF_NUMBER_TABLE
256: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a3 out nocopy JTF_NUMBER_TABLE
259: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , p6_a3 out nocopy JTF_NUMBER_TABLE

254: , p5_a19 DATE
255: , p6_a0 out nocopy JTF_NUMBER_TABLE
256: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a3 out nocopy JTF_NUMBER_TABLE
259: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300