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_p0(t out nocopy cn_imp_maps_pvt.v_tbl_type, a0 JTF_VARCHAR2_TABLE_200) as
17: ddindx binary_integer; indx binary_integer;
18: begin
19: if a0 is not null and a0.count > 0 then
20: if a0.count > 0 then
30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p0;
34: procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();
34: procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();
39: else
40: a0 := JTF_VARCHAR2_TABLE_200();
41: if t.count > 0 then
42: a0.extend(t.count);
36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();
39: else
40: a0 := JTF_VARCHAR2_TABLE_200();
41: if t.count > 0 then
42: a0.extend(t.count);
43: ddindx := t.first;
44: indx := 1;
53: end if;
54: end if;
55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
54: end if;
55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if a0 is not null and a0.count > 0 then
76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);
97: a2.extend(t.count);
144: , p9_a21 NUMBER
145: , p9_a22 DATE
146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
145: , p9_a22 DATE
146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER
146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER
154: )
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER
154: )
155:
245: , x_msg_count out nocopy NUMBER
246: , x_msg_data out nocopy VARCHAR2
247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
246: , x_msg_data out nocopy VARCHAR2
247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER
260: )
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER
260: )
261: