9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pc_association_pub.pc_assos_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_300
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pc_association_pub.pc_assos_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_300
18: , a5 JTF_VARCHAR2_TABLE_100
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pc_association_pub.pc_assos_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_300
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pc_association_pub.pc_assos_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_300
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_300
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200
26: , a13 JTF_VARCHAR2_TABLE_200
80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_pc_association_pub.pc_assos_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_VARCHAR2_TABLE_300
81: end if;
82: end if;
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_pc_association_pub.pc_assos_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_VARCHAR2_TABLE_300
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: end if;
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_pc_association_pub.pc_assos_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_VARCHAR2_TABLE_300
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_pc_association_pub.pc_assos_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_VARCHAR2_TABLE_300
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_300
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_VARCHAR2_TABLE_100
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a11 out nocopy JTF_VARCHAR2_TABLE_200
96: , a12 out nocopy JTF_VARCHAR2_TABLE_200
89: , a5 out nocopy JTF_VARCHAR2_TABLE_100
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_VARCHAR2_TABLE_100
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a11 out nocopy JTF_VARCHAR2_TABLE_200
96: , a12 out nocopy JTF_VARCHAR2_TABLE_200
97: , a13 out nocopy JTF_VARCHAR2_TABLE_200
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_300();
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_300();
120: a5 := JTF_VARCHAR2_TABLE_100();
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_300();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_100();
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_300();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_300();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_200();
127: a12 := JTF_VARCHAR2_TABLE_200();
120: a5 := JTF_VARCHAR2_TABLE_100();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_200();
127: a12 := JTF_VARCHAR2_TABLE_200();
128: a13 := JTF_VARCHAR2_TABLE_200();
139: a24 := JTF_VARCHAR2_TABLE_200();
140: a25 := JTF_VARCHAR2_TABLE_200();
141: a26 := JTF_VARCHAR2_TABLE_100();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_VARCHAR2_TABLE_300();
140: a25 := JTF_VARCHAR2_TABLE_200();
141: a26 := JTF_VARCHAR2_TABLE_100();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_VARCHAR2_TABLE_300();
148: a5 := JTF_VARCHAR2_TABLE_100();
141: a26 := JTF_VARCHAR2_TABLE_100();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_VARCHAR2_TABLE_300();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_100();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_NUMBER_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_VARCHAR2_TABLE_300();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_VARCHAR2_TABLE_300();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_VARCHAR2_TABLE_100();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_200();
155: a12 := JTF_VARCHAR2_TABLE_200();
148: a5 := JTF_VARCHAR2_TABLE_100();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_VARCHAR2_TABLE_100();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_200();
155: a12 := JTF_VARCHAR2_TABLE_200();
156: a13 := JTF_VARCHAR2_TABLE_200();
239: , p_init_msg_list VARCHAR2
240: , p_commit VARCHAR2
241: , p_validation_level NUMBER
242: , p_module_type VARCHAR2
243: , p5_a0 in out nocopy JTF_NUMBER_TABLE
244: , p5_a1 in out nocopy JTF_NUMBER_TABLE
245: , p5_a2 in out nocopy JTF_NUMBER_TABLE
246: , p5_a3 in out nocopy JTF_NUMBER_TABLE
247: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
240: , p_commit VARCHAR2
241: , p_validation_level NUMBER
242: , p_module_type VARCHAR2
243: , p5_a0 in out nocopy JTF_NUMBER_TABLE
244: , p5_a1 in out nocopy JTF_NUMBER_TABLE
245: , p5_a2 in out nocopy JTF_NUMBER_TABLE
246: , p5_a3 in out nocopy JTF_NUMBER_TABLE
247: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
248: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
241: , p_validation_level NUMBER
242: , p_module_type VARCHAR2
243: , p5_a0 in out nocopy JTF_NUMBER_TABLE
244: , p5_a1 in out nocopy JTF_NUMBER_TABLE
245: , p5_a2 in out nocopy JTF_NUMBER_TABLE
246: , p5_a3 in out nocopy JTF_NUMBER_TABLE
247: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
248: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
242: , p_module_type VARCHAR2
243: , p5_a0 in out nocopy JTF_NUMBER_TABLE
244: , p5_a1 in out nocopy JTF_NUMBER_TABLE
245: , p5_a2 in out nocopy JTF_NUMBER_TABLE
246: , p5_a3 in out nocopy JTF_NUMBER_TABLE
247: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
248: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
248: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p5_a8 in out nocopy JTF_NUMBER_TABLE
252: , p5_a9 in out nocopy JTF_NUMBER_TABLE
253: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
255: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
248: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p5_a8 in out nocopy JTF_NUMBER_TABLE
252: , p5_a9 in out nocopy JTF_NUMBER_TABLE
253: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
255: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
256: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
369: , p_init_msg_list VARCHAR2
370: , p_commit VARCHAR2
371: , p_validation_level NUMBER
372: , p_module_type VARCHAR2
373: , p5_a0 in out nocopy JTF_NUMBER_TABLE
374: , p5_a1 in out nocopy JTF_NUMBER_TABLE
375: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p5_a3 in out nocopy JTF_NUMBER_TABLE
377: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
370: , p_commit VARCHAR2
371: , p_validation_level NUMBER
372: , p_module_type VARCHAR2
373: , p5_a0 in out nocopy JTF_NUMBER_TABLE
374: , p5_a1 in out nocopy JTF_NUMBER_TABLE
375: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p5_a3 in out nocopy JTF_NUMBER_TABLE
377: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
372: , p_module_type VARCHAR2
373: , p5_a0 in out nocopy JTF_NUMBER_TABLE
374: , p5_a1 in out nocopy JTF_NUMBER_TABLE
375: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p5_a3 in out nocopy JTF_NUMBER_TABLE
377: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p5_a8 in out nocopy JTF_NUMBER_TABLE
382: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
384: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_2000
390: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p5_a19 in out nocopy JTF_NUMBER_TABLE
393: , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
395: , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
396: , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200