APPS.AHL_UMP_UF_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_ump_uf_pvt_w as
2: /* $Header: AHLUMFWS.pls 120.1 2008/01/18 01:22:58 sikumar ship $ */
3: procedure rosetta_table_copy_in_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_ump_uf_pvt_w as
2: /* $Header: AHLUMFWS.pls 120.1 2008/01/18 01:22:58 sikumar ship $ */
3: procedure rosetta_table_copy_in_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package ahl_ump_uf_pvt_w as
2: /* $Header: AHLUMFWS.pls 120.1 2008/01/18 01:22:58 sikumar ship $ */
3: procedure rosetta_table_copy_in_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 14: , a11 JTF_NUMBER_TABLE

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

Line 33: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_200
32: );
33: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 34: , a1 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_200
32: );
33: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE

Line 35: , a2 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_VARCHAR2_TABLE_200
32: );
33: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a6 out nocopy JTF_NUMBER_TABLE

35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

36: , a3 out nocopy JTF_DATE_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE

Line 44: , a11 out nocopy JTF_NUMBER_TABLE

40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_DATE_TABLE
43: , a10 out nocopy JTF_DATE_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_VARCHAR2_TABLE_100
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_VARCHAR2_TABLE_200
48: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 103: , p6_a0 in out nocopy JTF_NUMBER_TABLE

99: , p5_a30 in out nocopy VARCHAR2
100: , p5_a31 in out nocopy VARCHAR2
101: , p5_a32 in out nocopy VARCHAR2
102: , p5_a33 in out nocopy VARCHAR2
103: , p6_a0 in out nocopy JTF_NUMBER_TABLE
104: , p6_a1 in out nocopy JTF_NUMBER_TABLE
105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 104: , p6_a1 in out nocopy JTF_NUMBER_TABLE

100: , p5_a31 in out nocopy VARCHAR2
101: , p5_a32 in out nocopy VARCHAR2
102: , p5_a33 in out nocopy VARCHAR2
103: , p6_a0 in out nocopy JTF_NUMBER_TABLE
104: , p6_a1 in out nocopy JTF_NUMBER_TABLE
105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
108: , p6_a5 in out nocopy JTF_DATE_TABLE

Line 105: , p6_a2 in out nocopy JTF_NUMBER_TABLE

101: , p5_a32 in out nocopy VARCHAR2
102: , p5_a33 in out nocopy VARCHAR2
103: , p6_a0 in out nocopy JTF_NUMBER_TABLE
104: , p6_a1 in out nocopy JTF_NUMBER_TABLE
105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
108: , p6_a5 in out nocopy JTF_DATE_TABLE
109: , p6_a6 in out nocopy JTF_NUMBER_TABLE

Line 107: , p6_a4 in out nocopy JTF_NUMBER_TABLE

103: , p6_a0 in out nocopy JTF_NUMBER_TABLE
104: , p6_a1 in out nocopy JTF_NUMBER_TABLE
105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
108: , p6_a5 in out nocopy JTF_DATE_TABLE
109: , p6_a6 in out nocopy JTF_NUMBER_TABLE
110: , p6_a7 in out nocopy JTF_NUMBER_TABLE
111: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , p6_a6 in out nocopy JTF_NUMBER_TABLE

105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
108: , p6_a5 in out nocopy JTF_DATE_TABLE
109: , p6_a6 in out nocopy JTF_NUMBER_TABLE
110: , p6_a7 in out nocopy JTF_NUMBER_TABLE
111: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a9 in out nocopy JTF_DATE_TABLE
113: , p6_a10 in out nocopy JTF_DATE_TABLE

Line 110: , p6_a7 in out nocopy JTF_NUMBER_TABLE

106: , p6_a3 in out nocopy JTF_DATE_TABLE
107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
108: , p6_a5 in out nocopy JTF_DATE_TABLE
109: , p6_a6 in out nocopy JTF_NUMBER_TABLE
110: , p6_a7 in out nocopy JTF_NUMBER_TABLE
111: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a9 in out nocopy JTF_DATE_TABLE
113: , p6_a10 in out nocopy JTF_DATE_TABLE
114: , p6_a11 in out nocopy JTF_NUMBER_TABLE

Line 114: , p6_a11 in out nocopy JTF_NUMBER_TABLE

110: , p6_a7 in out nocopy JTF_NUMBER_TABLE
111: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a9 in out nocopy JTF_DATE_TABLE
113: , p6_a10 in out nocopy JTF_DATE_TABLE
114: , p6_a11 in out nocopy JTF_NUMBER_TABLE
115: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
118: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200

Line 145: , p9_a0 out nocopy JTF_NUMBER_TABLE

141: , p_unit_name VARCHAR2
142: , p_part_number VARCHAR2
143: , p_onward_end_date date
144: , p_add_unit_item_forecast VARCHAR2
145: , p9_a0 out nocopy JTF_NUMBER_TABLE
146: , p9_a1 out nocopy JTF_NUMBER_TABLE
147: , p9_a2 out nocopy JTF_NUMBER_TABLE
148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 146: , p9_a1 out nocopy JTF_NUMBER_TABLE

142: , p_part_number VARCHAR2
143: , p_onward_end_date date
144: , p_add_unit_item_forecast VARCHAR2
145: , p9_a0 out nocopy JTF_NUMBER_TABLE
146: , p9_a1 out nocopy JTF_NUMBER_TABLE
147: , p9_a2 out nocopy JTF_NUMBER_TABLE
148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE
150: , p9_a5 out nocopy JTF_DATE_TABLE

Line 147: , p9_a2 out nocopy JTF_NUMBER_TABLE

143: , p_onward_end_date date
144: , p_add_unit_item_forecast VARCHAR2
145: , p9_a0 out nocopy JTF_NUMBER_TABLE
146: , p9_a1 out nocopy JTF_NUMBER_TABLE
147: , p9_a2 out nocopy JTF_NUMBER_TABLE
148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE
150: , p9_a5 out nocopy JTF_DATE_TABLE
151: , p9_a6 out nocopy JTF_NUMBER_TABLE

Line 149: , p9_a4 out nocopy JTF_NUMBER_TABLE

145: , p9_a0 out nocopy JTF_NUMBER_TABLE
146: , p9_a1 out nocopy JTF_NUMBER_TABLE
147: , p9_a2 out nocopy JTF_NUMBER_TABLE
148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE
150: , p9_a5 out nocopy JTF_DATE_TABLE
151: , p9_a6 out nocopy JTF_NUMBER_TABLE
152: , p9_a7 out nocopy JTF_NUMBER_TABLE
153: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , p9_a6 out nocopy JTF_NUMBER_TABLE

147: , p9_a2 out nocopy JTF_NUMBER_TABLE
148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE
150: , p9_a5 out nocopy JTF_DATE_TABLE
151: , p9_a6 out nocopy JTF_NUMBER_TABLE
152: , p9_a7 out nocopy JTF_NUMBER_TABLE
153: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a9 out nocopy JTF_DATE_TABLE
155: , p9_a10 out nocopy JTF_DATE_TABLE

Line 152: , p9_a7 out nocopy JTF_NUMBER_TABLE

148: , p9_a3 out nocopy JTF_DATE_TABLE
149: , p9_a4 out nocopy JTF_NUMBER_TABLE
150: , p9_a5 out nocopy JTF_DATE_TABLE
151: , p9_a6 out nocopy JTF_NUMBER_TABLE
152: , p9_a7 out nocopy JTF_NUMBER_TABLE
153: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a9 out nocopy JTF_DATE_TABLE
155: , p9_a10 out nocopy JTF_DATE_TABLE
156: , p9_a11 out nocopy JTF_NUMBER_TABLE

Line 156: , p9_a11 out nocopy JTF_NUMBER_TABLE

152: , p9_a7 out nocopy JTF_NUMBER_TABLE
153: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a9 out nocopy JTF_DATE_TABLE
155: , p9_a10 out nocopy JTF_DATE_TABLE
156: , p9_a11 out nocopy JTF_NUMBER_TABLE
157: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
158: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
159: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200
160: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 179: , p3_a0 out nocopy JTF_NUMBER_TABLE

175: );
176: procedure get_uf_from_part(p_init_msg_list VARCHAR2
177: , p_csi_item_instance_id NUMBER
178: , p_onward_end_date date
179: , p3_a0 out nocopy JTF_NUMBER_TABLE
180: , p3_a1 out nocopy JTF_NUMBER_TABLE
181: , p3_a2 out nocopy JTF_NUMBER_TABLE
182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 180: , p3_a1 out nocopy JTF_NUMBER_TABLE

176: procedure get_uf_from_part(p_init_msg_list VARCHAR2
177: , p_csi_item_instance_id NUMBER
178: , p_onward_end_date date
179: , p3_a0 out nocopy JTF_NUMBER_TABLE
180: , p3_a1 out nocopy JTF_NUMBER_TABLE
181: , p3_a2 out nocopy JTF_NUMBER_TABLE
182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE
184: , p3_a5 out nocopy JTF_DATE_TABLE

Line 181: , p3_a2 out nocopy JTF_NUMBER_TABLE

177: , p_csi_item_instance_id NUMBER
178: , p_onward_end_date date
179: , p3_a0 out nocopy JTF_NUMBER_TABLE
180: , p3_a1 out nocopy JTF_NUMBER_TABLE
181: , p3_a2 out nocopy JTF_NUMBER_TABLE
182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE
184: , p3_a5 out nocopy JTF_DATE_TABLE
185: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 183: , p3_a4 out nocopy JTF_NUMBER_TABLE

179: , p3_a0 out nocopy JTF_NUMBER_TABLE
180: , p3_a1 out nocopy JTF_NUMBER_TABLE
181: , p3_a2 out nocopy JTF_NUMBER_TABLE
182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE
184: , p3_a5 out nocopy JTF_DATE_TABLE
185: , p3_a6 out nocopy JTF_NUMBER_TABLE
186: , p3_a7 out nocopy JTF_NUMBER_TABLE
187: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , p3_a6 out nocopy JTF_NUMBER_TABLE

181: , p3_a2 out nocopy JTF_NUMBER_TABLE
182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE
184: , p3_a5 out nocopy JTF_DATE_TABLE
185: , p3_a6 out nocopy JTF_NUMBER_TABLE
186: , p3_a7 out nocopy JTF_NUMBER_TABLE
187: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
188: , p3_a9 out nocopy JTF_DATE_TABLE
189: , p3_a10 out nocopy JTF_DATE_TABLE

Line 186: , p3_a7 out nocopy JTF_NUMBER_TABLE

182: , p3_a3 out nocopy JTF_DATE_TABLE
183: , p3_a4 out nocopy JTF_NUMBER_TABLE
184: , p3_a5 out nocopy JTF_DATE_TABLE
185: , p3_a6 out nocopy JTF_NUMBER_TABLE
186: , p3_a7 out nocopy JTF_NUMBER_TABLE
187: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
188: , p3_a9 out nocopy JTF_DATE_TABLE
189: , p3_a10 out nocopy JTF_DATE_TABLE
190: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 190: , p3_a11 out nocopy JTF_NUMBER_TABLE

186: , p3_a7 out nocopy JTF_NUMBER_TABLE
187: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
188: , p3_a9 out nocopy JTF_DATE_TABLE
189: , p3_a10 out nocopy JTF_DATE_TABLE
190: , p3_a11 out nocopy JTF_NUMBER_TABLE
191: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
192: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
193: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
194: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_200