18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: ) as
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
66: , a1 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
66: , a1 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
66: , a1 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
71: , a6 out NOCOPY JTF_NUMBER_TABLE
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
66: , a1 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
71: , a6 out NOCOPY JTF_NUMBER_TABLE
72: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
66: , a1 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
71: , a6 out NOCOPY JTF_NUMBER_TABLE
72: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
73: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
74: , a9 out NOCOPY JTF_NUMBER_TABLE
67: , a2 out NOCOPY JTF_NUMBER_TABLE
68: , a3 out NOCOPY JTF_NUMBER_TABLE
69: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
71: , a6 out NOCOPY JTF_NUMBER_TABLE
72: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
73: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
74: , a9 out NOCOPY JTF_NUMBER_TABLE
75: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
70: , a5 out NOCOPY JTF_NUMBER_TABLE
71: , a6 out NOCOPY JTF_NUMBER_TABLE
72: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
73: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
74: , a9 out NOCOPY JTF_NUMBER_TABLE
75: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
76: , a11 out NOCOPY JTF_NUMBER_TABLE
77: , a12 out NOCOPY JTF_VARCHAR2_TABLE_2000
78: ) as
72: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
73: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
74: , a9 out NOCOPY JTF_NUMBER_TABLE
75: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
76: , a11 out NOCOPY JTF_NUMBER_TABLE
77: , a12 out NOCOPY JTF_VARCHAR2_TABLE_2000
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_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
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_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
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_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_2000();
95: else
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_2000();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_2000();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_2000();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_2000();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_VARCHAR2_TABLE_100();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_NUMBER_TABLE();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_VARCHAR2_TABLE_100();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_VARCHAR2_TABLE_100();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_VARCHAR2_TABLE_100();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_2000();
109: if t.count > 0 then
103: a7 := JTF_VARCHAR2_TABLE_100();
104: a8 := JTF_VARCHAR2_TABLE_100();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_VARCHAR2_TABLE_100();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_2000();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
150: , p_date_format VARCHAR2
151: , p_lang_code VARCHAR2
152: , x_error_flag out NOCOPY VARCHAR2
153: , x_error_message out NOCOPY VARCHAR2
154: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
155: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
151: , p_lang_code VARCHAR2
152: , x_error_flag out NOCOPY VARCHAR2
153: , x_error_message out NOCOPY VARCHAR2
154: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
155: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
152: , x_error_flag out NOCOPY VARCHAR2
153: , x_error_message out NOCOPY VARCHAR2
154: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
155: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
160: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
153: , x_error_message out NOCOPY VARCHAR2
154: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
155: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
160: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
161: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
155: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
160: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
161: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
162: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
163: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
156: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
157: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
158: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
160: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
161: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
162: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
163: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
164: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
159: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
160: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
161: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
162: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
163: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
164: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
165: , p5_a11 in out NOCOPY JTF_NUMBER_TABLE
166: , p5_a12 in out NOCOPY JTF_VARCHAR2_TABLE_2000
167: )
161: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
162: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
163: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
164: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
165: , p5_a11 in out NOCOPY JTF_NUMBER_TABLE
166: , p5_a12 in out NOCOPY JTF_VARCHAR2_TABLE_2000
167: )
168: as
169: ddx_atp_line_tbl ibe_atp_pvt.atp_line_tbl_typ;