DBA Data[Home] [Help]

APPS.CN_PAY_ELEMENT_INPUTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p2(t out cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p2(t out cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p2(t out cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_DATE_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 35: , a13 JTF_VARCHAR2_TABLE_100

31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_200
37: , a15 JTF_VARCHAR2_TABLE_200
38: , a16 JTF_VARCHAR2_TABLE_200
39: , a17 JTF_VARCHAR2_TABLE_200

Line 97: procedure rosetta_table_copy_out_p2(t cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
98: , a1 out JTF_DATE_TABLE
99: , a2 out JTF_DATE_TABLE
100: , a3 out JTF_VARCHAR2_TABLE_100
101: , a4 out JTF_VARCHAR2_TABLE_100

Line 100: , a3 out JTF_VARCHAR2_TABLE_100

96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
98: , a1 out JTF_DATE_TABLE
99: , a2 out JTF_DATE_TABLE
100: , a3 out JTF_VARCHAR2_TABLE_100
101: , a4 out JTF_VARCHAR2_TABLE_100
102: , a5 out JTF_VARCHAR2_TABLE_100
103: , a6 out JTF_NUMBER_TABLE
104: , a7 out JTF_NUMBER_TABLE

Line 101: , a4 out JTF_VARCHAR2_TABLE_100

97: procedure rosetta_table_copy_out_p2(t cn_pay_element_inputs_pvt.pay_element_input_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
98: , a1 out JTF_DATE_TABLE
99: , a2 out JTF_DATE_TABLE
100: , a3 out JTF_VARCHAR2_TABLE_100
101: , a4 out JTF_VARCHAR2_TABLE_100
102: , a5 out JTF_VARCHAR2_TABLE_100
103: , a6 out JTF_NUMBER_TABLE
104: , a7 out JTF_NUMBER_TABLE
105: , a8 out JTF_NUMBER_TABLE

Line 102: , a5 out JTF_VARCHAR2_TABLE_100

98: , a1 out JTF_DATE_TABLE
99: , a2 out JTF_DATE_TABLE
100: , a3 out JTF_VARCHAR2_TABLE_100
101: , a4 out JTF_VARCHAR2_TABLE_100
102: , a5 out JTF_VARCHAR2_TABLE_100
103: , a6 out JTF_NUMBER_TABLE
104: , a7 out JTF_NUMBER_TABLE
105: , a8 out JTF_NUMBER_TABLE
106: , a9 out JTF_NUMBER_TABLE

Line 110: , a13 out JTF_VARCHAR2_TABLE_100

106: , a9 out JTF_NUMBER_TABLE
107: , a10 out JTF_NUMBER_TABLE
108: , a11 out JTF_NUMBER_TABLE
109: , a12 out JTF_NUMBER_TABLE
110: , a13 out JTF_VARCHAR2_TABLE_100
111: , a14 out JTF_VARCHAR2_TABLE_200
112: , a15 out JTF_VARCHAR2_TABLE_200
113: , a16 out JTF_VARCHAR2_TABLE_200
114: , a17 out JTF_VARCHAR2_TABLE_200

Line 130: a0 := JTF_VARCHAR2_TABLE_100();

126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_DATE_TABLE();
132: a2 := JTF_DATE_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_VARCHAR2_TABLE_100();

Line 133: a3 := JTF_VARCHAR2_TABLE_100();

129: if t is null or t.count = 0 then
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_DATE_TABLE();
132: a2 := JTF_DATE_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_VARCHAR2_TABLE_100();
135: a5 := JTF_VARCHAR2_TABLE_100();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();

Line 134: a4 := JTF_VARCHAR2_TABLE_100();

130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_DATE_TABLE();
132: a2 := JTF_DATE_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_VARCHAR2_TABLE_100();
135: a5 := JTF_VARCHAR2_TABLE_100();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_NUMBER_TABLE();

Line 135: a5 := JTF_VARCHAR2_TABLE_100();

131: a1 := JTF_DATE_TABLE();
132: a2 := JTF_DATE_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_VARCHAR2_TABLE_100();
135: a5 := JTF_VARCHAR2_TABLE_100();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_NUMBER_TABLE();
139: a9 := JTF_NUMBER_TABLE();

Line 143: a13 := JTF_VARCHAR2_TABLE_100();

139: a9 := JTF_NUMBER_TABLE();
140: a10 := JTF_NUMBER_TABLE();
141: a11 := JTF_NUMBER_TABLE();
142: a12 := JTF_NUMBER_TABLE();
143: a13 := JTF_VARCHAR2_TABLE_100();
144: a14 := JTF_VARCHAR2_TABLE_200();
145: a15 := JTF_VARCHAR2_TABLE_200();
146: a16 := JTF_VARCHAR2_TABLE_200();
147: a17 := JTF_VARCHAR2_TABLE_200();

Line 160: a0 := JTF_VARCHAR2_TABLE_100();

156: a26 := JTF_VARCHAR2_TABLE_200();
157: a27 := JTF_VARCHAR2_TABLE_200();
158: a28 := JTF_VARCHAR2_TABLE_200();
159: else
160: a0 := JTF_VARCHAR2_TABLE_100();
161: a1 := JTF_DATE_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();

Line 163: a3 := JTF_VARCHAR2_TABLE_100();

159: else
160: a0 := JTF_VARCHAR2_TABLE_100();
161: a1 := JTF_DATE_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();

Line 164: a4 := JTF_VARCHAR2_TABLE_100();

160: a0 := JTF_VARCHAR2_TABLE_100();
161: a1 := JTF_DATE_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_NUMBER_TABLE();

Line 165: a5 := JTF_VARCHAR2_TABLE_100();

161: a1 := JTF_DATE_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_NUMBER_TABLE();
169: a9 := JTF_NUMBER_TABLE();

Line 173: a13 := JTF_VARCHAR2_TABLE_100();

169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_NUMBER_TABLE();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_VARCHAR2_TABLE_100();
174: a14 := JTF_VARCHAR2_TABLE_200();
175: a15 := JTF_VARCHAR2_TABLE_200();
176: a16 := JTF_VARCHAR2_TABLE_200();
177: a17 := JTF_VARCHAR2_TABLE_200();

Line 265: , a4 JTF_VARCHAR2_TABLE_100

261: procedure rosetta_table_copy_in_p5(t out cn_pay_element_inputs_pvt.pay_element_input_out_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: , a4 JTF_VARCHAR2_TABLE_100
266: , a5 JTF_VARCHAR2_TABLE_100
267: , a6 JTF_DATE_TABLE
268: , a7 JTF_DATE_TABLE
269: , a8 JTF_VARCHAR2_TABLE_100

Line 266: , a5 JTF_VARCHAR2_TABLE_100

262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: , a4 JTF_VARCHAR2_TABLE_100
266: , a5 JTF_VARCHAR2_TABLE_100
267: , a6 JTF_DATE_TABLE
268: , a7 JTF_DATE_TABLE
269: , a8 JTF_VARCHAR2_TABLE_100
270: , a9 JTF_VARCHAR2_TABLE_100

Line 269: , a8 JTF_VARCHAR2_TABLE_100

265: , a4 JTF_VARCHAR2_TABLE_100
266: , a5 JTF_VARCHAR2_TABLE_100
267: , a6 JTF_DATE_TABLE
268: , a7 JTF_DATE_TABLE
269: , a8 JTF_VARCHAR2_TABLE_100
270: , a9 JTF_VARCHAR2_TABLE_100
271: , a10 JTF_NUMBER_TABLE
272: , a11 JTF_NUMBER_TABLE
273: , a12 JTF_NUMBER_TABLE

Line 270: , a9 JTF_VARCHAR2_TABLE_100

266: , a5 JTF_VARCHAR2_TABLE_100
267: , a6 JTF_DATE_TABLE
268: , a7 JTF_DATE_TABLE
269: , a8 JTF_VARCHAR2_TABLE_100
270: , a9 JTF_VARCHAR2_TABLE_100
271: , a10 JTF_NUMBER_TABLE
272: , a11 JTF_NUMBER_TABLE
273: , a12 JTF_NUMBER_TABLE
274: ) as

Line 308: , a4 out JTF_VARCHAR2_TABLE_100

304: procedure rosetta_table_copy_out_p5(t cn_pay_element_inputs_pvt.pay_element_input_out_tbl_type, a0 out JTF_NUMBER_TABLE
305: , a1 out JTF_NUMBER_TABLE
306: , a2 out JTF_NUMBER_TABLE
307: , a3 out JTF_NUMBER_TABLE
308: , a4 out JTF_VARCHAR2_TABLE_100
309: , a5 out JTF_VARCHAR2_TABLE_100
310: , a6 out JTF_DATE_TABLE
311: , a7 out JTF_DATE_TABLE
312: , a8 out JTF_VARCHAR2_TABLE_100

Line 309: , a5 out JTF_VARCHAR2_TABLE_100

305: , a1 out JTF_NUMBER_TABLE
306: , a2 out JTF_NUMBER_TABLE
307: , a3 out JTF_NUMBER_TABLE
308: , a4 out JTF_VARCHAR2_TABLE_100
309: , a5 out JTF_VARCHAR2_TABLE_100
310: , a6 out JTF_DATE_TABLE
311: , a7 out JTF_DATE_TABLE
312: , a8 out JTF_VARCHAR2_TABLE_100
313: , a9 out JTF_VARCHAR2_TABLE_100

Line 312: , a8 out JTF_VARCHAR2_TABLE_100

308: , a4 out JTF_VARCHAR2_TABLE_100
309: , a5 out JTF_VARCHAR2_TABLE_100
310: , a6 out JTF_DATE_TABLE
311: , a7 out JTF_DATE_TABLE
312: , a8 out JTF_VARCHAR2_TABLE_100
313: , a9 out JTF_VARCHAR2_TABLE_100
314: , a10 out JTF_NUMBER_TABLE
315: , a11 out JTF_NUMBER_TABLE
316: , a12 out JTF_NUMBER_TABLE

Line 313: , a9 out JTF_VARCHAR2_TABLE_100

309: , a5 out JTF_VARCHAR2_TABLE_100
310: , a6 out JTF_DATE_TABLE
311: , a7 out JTF_DATE_TABLE
312: , a8 out JTF_VARCHAR2_TABLE_100
313: , a9 out JTF_VARCHAR2_TABLE_100
314: , a10 out JTF_NUMBER_TABLE
315: , a11 out JTF_NUMBER_TABLE
316: , a12 out JTF_NUMBER_TABLE
317: ) as

Line 325: a4 := JTF_VARCHAR2_TABLE_100();

321: a0 := JTF_NUMBER_TABLE();
322: a1 := JTF_NUMBER_TABLE();
323: a2 := JTF_NUMBER_TABLE();
324: a3 := JTF_NUMBER_TABLE();
325: a4 := JTF_VARCHAR2_TABLE_100();
326: a5 := JTF_VARCHAR2_TABLE_100();
327: a6 := JTF_DATE_TABLE();
328: a7 := JTF_DATE_TABLE();
329: a8 := JTF_VARCHAR2_TABLE_100();

Line 326: a5 := JTF_VARCHAR2_TABLE_100();

322: a1 := JTF_NUMBER_TABLE();
323: a2 := JTF_NUMBER_TABLE();
324: a3 := JTF_NUMBER_TABLE();
325: a4 := JTF_VARCHAR2_TABLE_100();
326: a5 := JTF_VARCHAR2_TABLE_100();
327: a6 := JTF_DATE_TABLE();
328: a7 := JTF_DATE_TABLE();
329: a8 := JTF_VARCHAR2_TABLE_100();
330: a9 := JTF_VARCHAR2_TABLE_100();

Line 329: a8 := JTF_VARCHAR2_TABLE_100();

325: a4 := JTF_VARCHAR2_TABLE_100();
326: a5 := JTF_VARCHAR2_TABLE_100();
327: a6 := JTF_DATE_TABLE();
328: a7 := JTF_DATE_TABLE();
329: a8 := JTF_VARCHAR2_TABLE_100();
330: a9 := JTF_VARCHAR2_TABLE_100();
331: a10 := JTF_NUMBER_TABLE();
332: a11 := JTF_NUMBER_TABLE();
333: a12 := JTF_NUMBER_TABLE();

Line 330: a9 := JTF_VARCHAR2_TABLE_100();

326: a5 := JTF_VARCHAR2_TABLE_100();
327: a6 := JTF_DATE_TABLE();
328: a7 := JTF_DATE_TABLE();
329: a8 := JTF_VARCHAR2_TABLE_100();
330: a9 := JTF_VARCHAR2_TABLE_100();
331: a10 := JTF_NUMBER_TABLE();
332: a11 := JTF_NUMBER_TABLE();
333: a12 := JTF_NUMBER_TABLE();
334: else

Line 339: a4 := JTF_VARCHAR2_TABLE_100();

335: a0 := JTF_NUMBER_TABLE();
336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_VARCHAR2_TABLE_100();
341: a6 := JTF_DATE_TABLE();
342: a7 := JTF_DATE_TABLE();
343: a8 := JTF_VARCHAR2_TABLE_100();

Line 340: a5 := JTF_VARCHAR2_TABLE_100();

336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_VARCHAR2_TABLE_100();
341: a6 := JTF_DATE_TABLE();
342: a7 := JTF_DATE_TABLE();
343: a8 := JTF_VARCHAR2_TABLE_100();
344: a9 := JTF_VARCHAR2_TABLE_100();

Line 343: a8 := JTF_VARCHAR2_TABLE_100();

339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_VARCHAR2_TABLE_100();
341: a6 := JTF_DATE_TABLE();
342: a7 := JTF_DATE_TABLE();
343: a8 := JTF_VARCHAR2_TABLE_100();
344: a9 := JTF_VARCHAR2_TABLE_100();
345: a10 := JTF_NUMBER_TABLE();
346: a11 := JTF_NUMBER_TABLE();
347: a12 := JTF_NUMBER_TABLE();

Line 344: a9 := JTF_VARCHAR2_TABLE_100();

340: a5 := JTF_VARCHAR2_TABLE_100();
341: a6 := JTF_DATE_TABLE();
342: a7 := JTF_DATE_TABLE();
343: a8 := JTF_VARCHAR2_TABLE_100();
344: a9 := JTF_VARCHAR2_TABLE_100();
345: a10 := JTF_NUMBER_TABLE();
346: a11 := JTF_NUMBER_TABLE();
347: a12 := JTF_NUMBER_TABLE();
348: if t.count > 0 then

Line 677: , p11_a4 out JTF_VARCHAR2_TABLE_100

673: , p11_a0 out JTF_NUMBER_TABLE
674: , p11_a1 out JTF_NUMBER_TABLE
675: , p11_a2 out JTF_NUMBER_TABLE
676: , p11_a3 out JTF_NUMBER_TABLE
677: , p11_a4 out JTF_VARCHAR2_TABLE_100
678: , p11_a5 out JTF_VARCHAR2_TABLE_100
679: , p11_a6 out JTF_DATE_TABLE
680: , p11_a7 out JTF_DATE_TABLE
681: , p11_a8 out JTF_VARCHAR2_TABLE_100

Line 678: , p11_a5 out JTF_VARCHAR2_TABLE_100

674: , p11_a1 out JTF_NUMBER_TABLE
675: , p11_a2 out JTF_NUMBER_TABLE
676: , p11_a3 out JTF_NUMBER_TABLE
677: , p11_a4 out JTF_VARCHAR2_TABLE_100
678: , p11_a5 out JTF_VARCHAR2_TABLE_100
679: , p11_a6 out JTF_DATE_TABLE
680: , p11_a7 out JTF_DATE_TABLE
681: , p11_a8 out JTF_VARCHAR2_TABLE_100
682: , p11_a9 out JTF_VARCHAR2_TABLE_100

Line 681: , p11_a8 out JTF_VARCHAR2_TABLE_100

677: , p11_a4 out JTF_VARCHAR2_TABLE_100
678: , p11_a5 out JTF_VARCHAR2_TABLE_100
679: , p11_a6 out JTF_DATE_TABLE
680: , p11_a7 out JTF_DATE_TABLE
681: , p11_a8 out JTF_VARCHAR2_TABLE_100
682: , p11_a9 out JTF_VARCHAR2_TABLE_100
683: , p11_a10 out JTF_NUMBER_TABLE
684: , p11_a11 out JTF_NUMBER_TABLE
685: , p11_a12 out JTF_NUMBER_TABLE

Line 682: , p11_a9 out JTF_VARCHAR2_TABLE_100

678: , p11_a5 out JTF_VARCHAR2_TABLE_100
679: , p11_a6 out JTF_DATE_TABLE
680: , p11_a7 out JTF_DATE_TABLE
681: , p11_a8 out JTF_VARCHAR2_TABLE_100
682: , p11_a9 out JTF_VARCHAR2_TABLE_100
683: , p11_a10 out JTF_NUMBER_TABLE
684: , p11_a11 out JTF_NUMBER_TABLE
685: , p11_a12 out JTF_NUMBER_TABLE
686: , x_total_records out NUMBER