12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_1600
31: ) as
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_1600
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
59: end loop;
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
77: , a14 out nocopy JTF_VARCHAR2_TABLE_1600
78: ) as
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
77: , a14 out nocopy JTF_VARCHAR2_TABLE_1600
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_DATE_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_DATE_TABLE();
93: a11 := JTF_NUMBER_TABLE();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_DATE_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_DATE_TABLE();
95: a13 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_DATE_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_DATE_TABLE();
95: a13 := JTF_NUMBER_TABLE();
96: a14 := JTF_VARCHAR2_TABLE_1600();
97: else
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_DATE_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_DATE_TABLE();
95: a13 := JTF_NUMBER_TABLE();
96: a14 := JTF_VARCHAR2_TABLE_1600();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
94: a12 := JTF_DATE_TABLE();
95: a13 := JTF_NUMBER_TABLE();
96: a14 := JTF_VARCHAR2_TABLE_1600();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
100: a2 := JTF_VARCHAR2_TABLE_100();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
95: a13 := JTF_NUMBER_TABLE();
96: a14 := JTF_VARCHAR2_TABLE_1600();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
100: a2 := JTF_VARCHAR2_TABLE_100();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
100: a2 := JTF_VARCHAR2_TABLE_100();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
100: a2 := JTF_VARCHAR2_TABLE_100();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
106: a8 := JTF_VARCHAR2_TABLE_100();
100: a2 := JTF_VARCHAR2_TABLE_100();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_NUMBER_TABLE();
108: a10 := JTF_DATE_TABLE();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_NUMBER_TABLE();
108: a10 := JTF_DATE_TABLE();
109: a11 := JTF_NUMBER_TABLE();
103: a5 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_NUMBER_TABLE();
108: a10 := JTF_DATE_TABLE();
109: a11 := JTF_NUMBER_TABLE();
110: a12 := JTF_DATE_TABLE();
111: a13 := JTF_NUMBER_TABLE();
105: a7 := JTF_NUMBER_TABLE();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_NUMBER_TABLE();
108: a10 := JTF_DATE_TABLE();
109: a11 := JTF_NUMBER_TABLE();
110: a12 := JTF_DATE_TABLE();
111: a13 := JTF_NUMBER_TABLE();
112: a14 := JTF_VARCHAR2_TABLE_1600();
113: if t.count > 0 then
107: a9 := JTF_NUMBER_TABLE();
108: a10 := JTF_DATE_TABLE();
109: a11 := JTF_NUMBER_TABLE();
110: a12 := JTF_DATE_TABLE();
111: a13 := JTF_NUMBER_TABLE();
112: a14 := JTF_VARCHAR2_TABLE_1600();
113: if t.count > 0 then
114: a0.extend(t.count);
115: a1.extend(t.count);