DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_LINKS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE

1: package body ahl_vwp_tasks_links_pvt_w as
2: /* $Header: AHLWTLNB.pls 120.0.12020000.2 2012/12/14 06:53:39 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body ahl_vwp_tasks_links_pvt_w as
2: /* $Header: AHLWTLNB.pls 120.0.12020000.2 2012/12/14 06:53:39 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWTLNB.pls 120.0.12020000.2 2012/12/14 06:53:39 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100

Line 80: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE

Line 81: , a1 out nocopy JTF_NUMBER_TABLE

77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE

Line 83: , a3 out nocopy JTF_NUMBER_TABLE

79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE

Line 85: , a5 out nocopy JTF_NUMBER_TABLE

81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE

Line 86: , a6 out nocopy JTF_NUMBER_TABLE

82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a7 out nocopy JTF_NUMBER_TABLE

83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_100
91: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , a8 out nocopy JTF_NUMBER_TABLE

84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_100
91: , a11 out nocopy JTF_VARCHAR2_TABLE_100
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , a9 out nocopy JTF_NUMBER_TABLE

85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_100
91: , a11 out nocopy JTF_VARCHAR2_TABLE_100
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: a0 := JTF_NUMBER_TABLE();

110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();

Line 115: a1 := JTF_NUMBER_TABLE();

111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();

Line 117: a3 := JTF_NUMBER_TABLE();

113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();

Line 119: a5 := JTF_NUMBER_TABLE();

115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_NUMBER_TABLE();
123: a9 := JTF_NUMBER_TABLE();

Line 120: a6 := JTF_NUMBER_TABLE();

116: a2 := JTF_DATE_TABLE();
117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_NUMBER_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_VARCHAR2_TABLE_100();

Line 121: a7 := JTF_NUMBER_TABLE();

117: a3 := JTF_NUMBER_TABLE();
118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_NUMBER_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_VARCHAR2_TABLE_100();

Line 122: a8 := JTF_NUMBER_TABLE();

118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_NUMBER_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_VARCHAR2_TABLE_100();
126: a12 := JTF_VARCHAR2_TABLE_100();

Line 123: a9 := JTF_NUMBER_TABLE();

119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_NUMBER_TABLE();
123: a9 := JTF_NUMBER_TABLE();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_VARCHAR2_TABLE_100();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_100();

Line 145: a0 := JTF_NUMBER_TABLE();

141: a27 := JTF_VARCHAR2_TABLE_200();
142: a28 := JTF_VARCHAR2_TABLE_200();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();

Line 146: a1 := JTF_NUMBER_TABLE();

142: a28 := JTF_VARCHAR2_TABLE_200();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();

Line 148: a3 := JTF_NUMBER_TABLE();

144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();

Line 150: a5 := JTF_NUMBER_TABLE();

146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_NUMBER_TABLE();

Line 151: a6 := JTF_NUMBER_TABLE();

147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_VARCHAR2_TABLE_100();

Line 152: a7 := JTF_NUMBER_TABLE();

148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_VARCHAR2_TABLE_100();

Line 153: a8 := JTF_NUMBER_TABLE();

149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();

Line 154: a9 := JTF_NUMBER_TABLE();

150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();

Line 258: , p9_a0 in out nocopy JTF_NUMBER_TABLE

254: , p_module_type VARCHAR2
255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p9_a0 in out nocopy JTF_NUMBER_TABLE
259: , p9_a1 in out nocopy JTF_NUMBER_TABLE
260: , p9_a2 in out nocopy JTF_DATE_TABLE
261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE

Line 259: , p9_a1 in out nocopy JTF_NUMBER_TABLE

255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p9_a0 in out nocopy JTF_NUMBER_TABLE
259: , p9_a1 in out nocopy JTF_NUMBER_TABLE
260: , p9_a2 in out nocopy JTF_DATE_TABLE
261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 261: , p9_a3 in out nocopy JTF_NUMBER_TABLE

257: , x_msg_data out nocopy VARCHAR2
258: , p9_a0 in out nocopy JTF_NUMBER_TABLE
259: , p9_a1 in out nocopy JTF_NUMBER_TABLE
260: , p9_a2 in out nocopy JTF_DATE_TABLE
261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 263: , p9_a5 in out nocopy JTF_NUMBER_TABLE

259: , p9_a1 in out nocopy JTF_NUMBER_TABLE
260: , p9_a2 in out nocopy JTF_DATE_TABLE
261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE
266: , p9_a8 in out nocopy JTF_NUMBER_TABLE
267: , p9_a9 in out nocopy JTF_NUMBER_TABLE

Line 264: , p9_a6 in out nocopy JTF_NUMBER_TABLE

260: , p9_a2 in out nocopy JTF_DATE_TABLE
261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE
266: , p9_a8 in out nocopy JTF_NUMBER_TABLE
267: , p9_a9 in out nocopy JTF_NUMBER_TABLE
268: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p9_a7 in out nocopy JTF_NUMBER_TABLE

261: , p9_a3 in out nocopy JTF_NUMBER_TABLE
262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE
266: , p9_a8 in out nocopy JTF_NUMBER_TABLE
267: , p9_a9 in out nocopy JTF_NUMBER_TABLE
268: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p9_a8 in out nocopy JTF_NUMBER_TABLE

262: , p9_a4 in out nocopy JTF_DATE_TABLE
263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE
266: , p9_a8 in out nocopy JTF_NUMBER_TABLE
267: , p9_a9 in out nocopy JTF_NUMBER_TABLE
268: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p9_a9 in out nocopy JTF_NUMBER_TABLE

263: , p9_a5 in out nocopy JTF_NUMBER_TABLE
264: , p9_a6 in out nocopy JTF_NUMBER_TABLE
265: , p9_a7 in out nocopy JTF_NUMBER_TABLE
266: , p9_a8 in out nocopy JTF_NUMBER_TABLE
267: , p9_a9 in out nocopy JTF_NUMBER_TABLE
268: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
271: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100