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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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
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
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
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
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
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
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
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