APPS.AHL_COMPLETIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package ahl_completions_pvt_w as
2: /* $Header: AHLWPRCS.pls 120.1 2005/07/04 10:46 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWPRCS.pls 120.1 2005/07/04 10:46 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

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

Line 22: , a19 JTF_VARCHAR2_TABLE_100

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

Line 23: , a20 JTF_VARCHAR2_TABLE_100

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

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE

Line 30: , a2 out nocopy JTF_VARCHAR2_TABLE_100

26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE

Line 31: , a3 out nocopy JTF_VARCHAR2_TABLE_100

27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE

Line 40: , a12 out nocopy JTF_VARCHAR2_TABLE_100

36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE

Line 41: , a13 out nocopy JTF_VARCHAR2_TABLE_100

37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a17 out nocopy JTF_VARCHAR2_TABLE_100

41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a19 out nocopy JTF_VARCHAR2_TABLE_100

43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE

Line 48: , a20 out nocopy JTF_VARCHAR2_TABLE_100

44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE
52: );

Line 49: , a21 out nocopy JTF_VARCHAR2_TABLE_100

45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE
52: );
53:

Line 50: , a22 out nocopy JTF_VARCHAR2_TABLE_100

46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE

Line 57: , a3 JTF_VARCHAR2_TABLE_100

53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000

Line 68: , a14 JTF_VARCHAR2_TABLE_100

64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE

Line 69: , a15 JTF_VARCHAR2_TABLE_100

65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE

Line 74: , a3 out nocopy JTF_VARCHAR2_TABLE_100

70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 85: , a14 out nocopy JTF_VARCHAR2_TABLE_100

81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE

Line 86: , a15 out nocopy JTF_VARCHAR2_TABLE_100

82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE
85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE

Line 91: , a2 JTF_VARCHAR2_TABLE_100

87: );
88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100

Line 92: , a3 JTF_VARCHAR2_TABLE_100

88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200

Line 95: , a6 JTF_VARCHAR2_TABLE_100

91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE

Line 104: , a2 out nocopy JTF_VARCHAR2_TABLE_100

100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 105: , a3 out nocopy JTF_VARCHAR2_TABLE_100

101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_200

Line 108: , a6 out nocopy JTF_VARCHAR2_TABLE_100

104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE

Line 122: , a6 JTF_VARCHAR2_TABLE_100

118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE

Line 131: , a6 out nocopy JTF_VARCHAR2_TABLE_100

127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);

Line 139: , a1 JTF_VARCHAR2_TABLE_100

135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE

Line 146: , a8 JTF_VARCHAR2_TABLE_100

142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_NUMBER_TABLE
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_VARCHAR2_TABLE_100
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: );
150: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 151: , a1 out nocopy JTF_VARCHAR2_TABLE_100

147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: );
150: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
151: , a1 out nocopy JTF_VARCHAR2_TABLE_100
152: , a2 out nocopy JTF_NUMBER_TABLE
153: , a3 out nocopy JTF_NUMBER_TABLE
154: , a4 out nocopy JTF_NUMBER_TABLE
155: , a5 out nocopy JTF_NUMBER_TABLE

Line 158: , a8 out nocopy JTF_VARCHAR2_TABLE_100

154: , a4 out nocopy JTF_NUMBER_TABLE
155: , a5 out nocopy JTF_NUMBER_TABLE
156: , a6 out nocopy JTF_NUMBER_TABLE
157: , a7 out nocopy JTF_NUMBER_TABLE
158: , a8 out nocopy JTF_VARCHAR2_TABLE_100
159: , a9 out nocopy JTF_NUMBER_TABLE
160: , a10 out nocopy JTF_NUMBER_TABLE
161: );
162:

Line 231: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100

227: , x_msg_data out nocopy VARCHAR2
228: , p3_a0 in out nocopy JTF_NUMBER_TABLE
229: , p3_a1 in out nocopy JTF_NUMBER_TABLE
230: , p3_a2 in out nocopy JTF_NUMBER_TABLE
231: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p3_a4 in out nocopy JTF_NUMBER_TABLE
233: , p3_a5 in out nocopy JTF_NUMBER_TABLE
234: , p3_a6 in out nocopy JTF_NUMBER_TABLE
235: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 242: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100

238: , p3_a10 in out nocopy JTF_DATE_TABLE
239: , p3_a11 in out nocopy JTF_DATE_TABLE
240: , p3_a12 in out nocopy JTF_DATE_TABLE
241: , p3_a13 in out nocopy JTF_DATE_TABLE
242: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
244: );
245: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
246: , p1_a0 in out nocopy JTF_NUMBER_TABLE

Line 243: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

239: , p3_a11 in out nocopy JTF_DATE_TABLE
240: , p3_a12 in out nocopy JTF_DATE_TABLE
241: , p3_a13 in out nocopy JTF_DATE_TABLE
242: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
244: );
245: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
246: , p1_a0 in out nocopy JTF_NUMBER_TABLE
247: , p1_a1 in out nocopy JTF_NUMBER_TABLE

Line 249: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100

245: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
246: , p1_a0 in out nocopy JTF_NUMBER_TABLE
247: , p1_a1 in out nocopy JTF_NUMBER_TABLE
248: , p1_a2 in out nocopy JTF_NUMBER_TABLE
249: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p1_a4 in out nocopy JTF_NUMBER_TABLE
251: , p1_a5 in out nocopy JTF_NUMBER_TABLE
252: , p1_a6 in out nocopy JTF_NUMBER_TABLE
253: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 260: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100

256: , p1_a10 in out nocopy JTF_DATE_TABLE
257: , p1_a11 in out nocopy JTF_DATE_TABLE
258: , p1_a12 in out nocopy JTF_DATE_TABLE
259: , p1_a13 in out nocopy JTF_DATE_TABLE
260: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
262: );
263: end ahl_completions_pvt_w;

Line 261: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100

257: , p1_a11 in out nocopy JTF_DATE_TABLE
258: , p1_a12 in out nocopy JTF_DATE_TABLE
259: , p1_a13 in out nocopy JTF_DATE_TABLE
260: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
262: );
263: end ahl_completions_pvt_w;