22: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
23: return d;
24: end;
25:
26: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_xml_element_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then
30: if a0.count > 0 then
40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ams_xml_element_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
44: procedure rosetta_table_copy_out_p1(t ams_xml_element_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: if t.count > 0 then
52: a0.extend(t.count);
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: if t.count > 0 then
52: a0.extend(t.count);
53: ddindx := t.first;
54: indx := 1;
104: end if;
105: end if;
106: end rosetta_table_copy_out_p2;
107:
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
105: end if;
106: end rosetta_table_copy_out_p2;
107:
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
106: end rosetta_table_copy_out_p2;
107:
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
107:
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
115: , a7 JTF_NUMBER_TABLE
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
115: , a7 JTF_NUMBER_TABLE
116: , a8 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
115: , a7 JTF_NUMBER_TABLE
116: , a8 JTF_NUMBER_TABLE
117: , a9 JTF_NUMBER_TABLE
118: , a10 JTF_VARCHAR2_TABLE_2000
119: , a11 JTF_VARCHAR2_TABLE_2000
112: , a4 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
115: , a7 JTF_NUMBER_TABLE
116: , a8 JTF_NUMBER_TABLE
117: , a9 JTF_NUMBER_TABLE
118: , a10 JTF_VARCHAR2_TABLE_2000
119: , a11 JTF_VARCHAR2_TABLE_2000
120: , a12 JTF_NUMBER_TABLE
113: , a5 JTF_DATE_TABLE
114: , a6 JTF_DATE_TABLE
115: , a7 JTF_NUMBER_TABLE
116: , a8 JTF_NUMBER_TABLE
117: , a9 JTF_NUMBER_TABLE
118: , a10 JTF_VARCHAR2_TABLE_2000
119: , a11 JTF_VARCHAR2_TABLE_2000
120: , a12 JTF_NUMBER_TABLE
121: , a13 JTF_VARCHAR2_TABLE_100
116: , a8 JTF_NUMBER_TABLE
117: , a9 JTF_NUMBER_TABLE
118: , a10 JTF_VARCHAR2_TABLE_2000
119: , a11 JTF_VARCHAR2_TABLE_2000
120: , a12 JTF_NUMBER_TABLE
121: , a13 JTF_VARCHAR2_TABLE_100
122: , a14 JTF_VARCHAR2_TABLE_100
123: , a15 JTF_VARCHAR2_TABLE_300
124: ) as
153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p5;
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
154: end if;
155: end if;
156: end rosetta_table_copy_in_p5;
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
155: end if;
156: end rosetta_table_copy_in_p5;
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
156: end rosetta_table_copy_in_p5;
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
164: , a7 OUT NOCOPY JTF_NUMBER_TABLE
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
164: , a7 OUT NOCOPY JTF_NUMBER_TABLE
165: , a8 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
164: , a7 OUT NOCOPY JTF_NUMBER_TABLE
165: , a8 OUT NOCOPY JTF_NUMBER_TABLE
166: , a9 OUT NOCOPY JTF_NUMBER_TABLE
167: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
168: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
164: , a7 OUT NOCOPY JTF_NUMBER_TABLE
165: , a8 OUT NOCOPY JTF_NUMBER_TABLE
166: , a9 OUT NOCOPY JTF_NUMBER_TABLE
167: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
168: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
169: , a12 OUT NOCOPY JTF_NUMBER_TABLE
162: , a5 OUT NOCOPY JTF_DATE_TABLE
163: , a6 OUT NOCOPY JTF_DATE_TABLE
164: , a7 OUT NOCOPY JTF_NUMBER_TABLE
165: , a8 OUT NOCOPY JTF_NUMBER_TABLE
166: , a9 OUT NOCOPY JTF_NUMBER_TABLE
167: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
168: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
169: , a12 OUT NOCOPY JTF_NUMBER_TABLE
170: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a8 OUT NOCOPY JTF_NUMBER_TABLE
166: , a9 OUT NOCOPY JTF_NUMBER_TABLE
167: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
168: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
169: , a12 OUT NOCOPY JTF_NUMBER_TABLE
170: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
171: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
172: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_300
173: ) as
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
184: a7 := JTF_NUMBER_TABLE();
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_VARCHAR2_TABLE_2000();
188: a11 := JTF_VARCHAR2_TABLE_2000();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_VARCHAR2_TABLE_2000();
188: a11 := JTF_VARCHAR2_TABLE_2000();
189: a12 := JTF_NUMBER_TABLE();
182: a5 := JTF_DATE_TABLE();
183: a6 := JTF_DATE_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_VARCHAR2_TABLE_2000();
188: a11 := JTF_VARCHAR2_TABLE_2000();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_VARCHAR2_TABLE_2000();
188: a11 := JTF_VARCHAR2_TABLE_2000();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_300();
193: else
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_300();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_300();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_300();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
201: a7 := JTF_NUMBER_TABLE();
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_NUMBER_TABLE();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_VARCHAR2_TABLE_2000();
205: a11 := JTF_VARCHAR2_TABLE_2000();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_VARCHAR2_TABLE_2000();
205: a11 := JTF_VARCHAR2_TABLE_2000();
206: a12 := JTF_NUMBER_TABLE();
199: a5 := JTF_DATE_TABLE();
200: a6 := JTF_DATE_TABLE();
201: a7 := JTF_NUMBER_TABLE();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_VARCHAR2_TABLE_2000();
205: a11 := JTF_VARCHAR2_TABLE_2000();
206: a12 := JTF_NUMBER_TABLE();
207: a13 := JTF_VARCHAR2_TABLE_100();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_NUMBER_TABLE();
204: a10 := JTF_VARCHAR2_TABLE_2000();
205: a11 := JTF_VARCHAR2_TABLE_2000();
206: a12 := JTF_NUMBER_TABLE();
207: a13 := JTF_VARCHAR2_TABLE_100();
208: a14 := JTF_VARCHAR2_TABLE_100();
209: a15 := JTF_VARCHAR2_TABLE_300();
210: if t.count > 0 then
334: procedure update_error_xml_element(p_api_version_number NUMBER
335: , p_init_msg_list VARCHAR2
336: , p_commit VARCHAR2
337: , p_validation_level NUMBER
338: , p_xml_element_ids JTF_NUMBER_TABLE
339: , p_xml_elements_data JTF_VARCHAR2_TABLE_2000
340: , p_xml_elements_col_name JTF_VARCHAR2_TABLE_2000
341: , x_return_status OUT NOCOPY VARCHAR2
342: , x_msg_count OUT NOCOPY NUMBER