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_p3(t out nocopy csp_requirement_headers_pvt.requirement_header_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_headers_pvt.requirement_header_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy csp_requirement_headers_pvt.requirement_header_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_300
23: , a7 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_300
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_300
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_300
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_300
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_VARCHAR2_TABLE_200
44: , a28 JTF_VARCHAR2_TABLE_200
45: , a29 JTF_VARCHAR2_TABLE_200
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_VARCHAR2_TABLE_100
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_VARCHAR2_TABLE_100
50: , a34 JTF_NUMBER_TABLE
44: , a28 JTF_VARCHAR2_TABLE_200
45: , a29 JTF_VARCHAR2_TABLE_200
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_VARCHAR2_TABLE_100
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_VARCHAR2_TABLE_100
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_VARCHAR2_TABLE_100
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_VARCHAR2_TABLE_100
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_VARCHAR2_TABLE_100
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if a0 is not null and a0.count > 0 then
103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p3;
107: procedure rosetta_table_copy_out_p3(t csp_requirement_headers_pvt.requirement_header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_DATE_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
104: end if;
105: end if;
106: end rosetta_table_copy_in_p3;
107: procedure rosetta_table_copy_out_p3(t csp_requirement_headers_pvt.requirement_header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_DATE_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
106: end rosetta_table_copy_in_p3;
107: procedure rosetta_table_copy_out_p3(t csp_requirement_headers_pvt.requirement_header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_DATE_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_300
114: , a7 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_DATE_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_300
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_300
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , a11 out nocopy JTF_DATE_TABLE
111: , a4 out nocopy JTF_DATE_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_300
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , a11 out nocopy JTF_DATE_TABLE
119: , a12 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_300
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , a11 out nocopy JTF_DATE_TABLE
119: , a12 out nocopy JTF_NUMBER_TABLE
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , a11 out nocopy JTF_DATE_TABLE
119: , a12 out nocopy JTF_NUMBER_TABLE
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
121: , a14 out nocopy JTF_VARCHAR2_TABLE_100
122: , a15 out nocopy JTF_VARCHAR2_TABLE_200
123: , a16 out nocopy JTF_VARCHAR2_TABLE_200
133: , a26 out nocopy JTF_VARCHAR2_TABLE_200
134: , a27 out nocopy JTF_VARCHAR2_TABLE_200
135: , a28 out nocopy JTF_VARCHAR2_TABLE_200
136: , a29 out nocopy JTF_VARCHAR2_TABLE_200
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_VARCHAR2_TABLE_100
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_VARCHAR2_TABLE_100
141: , a34 out nocopy JTF_NUMBER_TABLE
135: , a28 out nocopy JTF_VARCHAR2_TABLE_200
136: , a29 out nocopy JTF_VARCHAR2_TABLE_200
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_VARCHAR2_TABLE_100
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_VARCHAR2_TABLE_100
141: , a34 out nocopy JTF_NUMBER_TABLE
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_VARCHAR2_TABLE_100
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_VARCHAR2_TABLE_100
141: , a34 out nocopy JTF_NUMBER_TABLE
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_NUMBER_TABLE
144: ) as
145: ddindx binary_integer; indx binary_integer;
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_VARCHAR2_TABLE_100
141: , a34 out nocopy JTF_NUMBER_TABLE
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_NUMBER_TABLE
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_DATE_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_DATE_TABLE();
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_DATE_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_NUMBER_TABLE();
147: if t is null or t.count = 0 then
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_DATE_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_VARCHAR2_TABLE_300();
155: a7 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_DATE_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_VARCHAR2_TABLE_300();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_NUMBER_TABLE();
151: a3 := JTF_NUMBER_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_VARCHAR2_TABLE_300();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_NUMBER_TABLE();
158: a10 := JTF_VARCHAR2_TABLE_100();
159: a11 := JTF_DATE_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_VARCHAR2_TABLE_300();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_NUMBER_TABLE();
158: a10 := JTF_VARCHAR2_TABLE_100();
159: a11 := JTF_DATE_TABLE();
160: a12 := JTF_NUMBER_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_VARCHAR2_TABLE_300();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_NUMBER_TABLE();
158: a10 := JTF_VARCHAR2_TABLE_100();
159: a11 := JTF_DATE_TABLE();
160: a12 := JTF_NUMBER_TABLE();
161: a13 := JTF_VARCHAR2_TABLE_100();
156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_NUMBER_TABLE();
158: a10 := JTF_VARCHAR2_TABLE_100();
159: a11 := JTF_DATE_TABLE();
160: a12 := JTF_NUMBER_TABLE();
161: a13 := JTF_VARCHAR2_TABLE_100();
162: a14 := JTF_VARCHAR2_TABLE_100();
163: a15 := JTF_VARCHAR2_TABLE_200();
164: a16 := JTF_VARCHAR2_TABLE_200();
174: a26 := JTF_VARCHAR2_TABLE_200();
175: a27 := JTF_VARCHAR2_TABLE_200();
176: a28 := JTF_VARCHAR2_TABLE_200();
177: a29 := JTF_VARCHAR2_TABLE_200();
178: a30 := JTF_NUMBER_TABLE();
179: a31 := JTF_VARCHAR2_TABLE_100();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_VARCHAR2_TABLE_100();
182: a34 := JTF_NUMBER_TABLE();
176: a28 := JTF_VARCHAR2_TABLE_200();
177: a29 := JTF_VARCHAR2_TABLE_200();
178: a30 := JTF_NUMBER_TABLE();
179: a31 := JTF_VARCHAR2_TABLE_100();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_VARCHAR2_TABLE_100();
182: a34 := JTF_NUMBER_TABLE();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_NUMBER_TABLE();
178: a30 := JTF_NUMBER_TABLE();
179: a31 := JTF_VARCHAR2_TABLE_100();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_VARCHAR2_TABLE_100();
182: a34 := JTF_NUMBER_TABLE();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_NUMBER_TABLE();
185: else
186: a0 := JTF_NUMBER_TABLE();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_VARCHAR2_TABLE_100();
182: a34 := JTF_NUMBER_TABLE();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_NUMBER_TABLE();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_DATE_TABLE();
182: a34 := JTF_NUMBER_TABLE();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_NUMBER_TABLE();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_DATE_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_DATE_TABLE();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_NUMBER_TABLE();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_DATE_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_DATE_TABLE();
191: a5 := JTF_NUMBER_TABLE();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_DATE_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_DATE_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_VARCHAR2_TABLE_300();
193: a7 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_DATE_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_DATE_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_VARCHAR2_TABLE_300();
193: a7 := JTF_NUMBER_TABLE();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_NUMBER_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_DATE_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_VARCHAR2_TABLE_300();
193: a7 := JTF_NUMBER_TABLE();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_NUMBER_TABLE();
196: a10 := JTF_VARCHAR2_TABLE_100();
197: a11 := JTF_DATE_TABLE();
190: a4 := JTF_DATE_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_VARCHAR2_TABLE_300();
193: a7 := JTF_NUMBER_TABLE();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_NUMBER_TABLE();
196: a10 := JTF_VARCHAR2_TABLE_100();
197: a11 := JTF_DATE_TABLE();
198: a12 := JTF_NUMBER_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_VARCHAR2_TABLE_300();
193: a7 := JTF_NUMBER_TABLE();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_NUMBER_TABLE();
196: a10 := JTF_VARCHAR2_TABLE_100();
197: a11 := JTF_DATE_TABLE();
198: a12 := JTF_NUMBER_TABLE();
199: a13 := JTF_VARCHAR2_TABLE_100();
194: a8 := JTF_NUMBER_TABLE();
195: a9 := JTF_NUMBER_TABLE();
196: a10 := JTF_VARCHAR2_TABLE_100();
197: a11 := JTF_DATE_TABLE();
198: a12 := JTF_NUMBER_TABLE();
199: a13 := JTF_VARCHAR2_TABLE_100();
200: a14 := JTF_VARCHAR2_TABLE_100();
201: a15 := JTF_VARCHAR2_TABLE_200();
202: a16 := JTF_VARCHAR2_TABLE_200();
212: a26 := JTF_VARCHAR2_TABLE_200();
213: a27 := JTF_VARCHAR2_TABLE_200();
214: a28 := JTF_VARCHAR2_TABLE_200();
215: a29 := JTF_VARCHAR2_TABLE_200();
216: a30 := JTF_NUMBER_TABLE();
217: a31 := JTF_VARCHAR2_TABLE_100();
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_VARCHAR2_TABLE_100();
220: a34 := JTF_NUMBER_TABLE();
214: a28 := JTF_VARCHAR2_TABLE_200();
215: a29 := JTF_VARCHAR2_TABLE_200();
216: a30 := JTF_NUMBER_TABLE();
217: a31 := JTF_VARCHAR2_TABLE_100();
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_VARCHAR2_TABLE_100();
220: a34 := JTF_NUMBER_TABLE();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_NUMBER_TABLE();
216: a30 := JTF_NUMBER_TABLE();
217: a31 := JTF_VARCHAR2_TABLE_100();
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_VARCHAR2_TABLE_100();
220: a34 := JTF_NUMBER_TABLE();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_NUMBER_TABLE();
223: if t.count > 0 then
224: a0.extend(t.count);
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_VARCHAR2_TABLE_100();
220: a34 := JTF_NUMBER_TABLE();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_NUMBER_TABLE();
223: if t.count > 0 then
224: a0.extend(t.count);
225: a1.extend(t.count);
226: a2.extend(t.count);