DBA Data[Home] [Help]

APPS.OKL_CGR_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 56: , a1 out nocopy JTF_VARCHAR2_TABLE_200

52: end if;
53: end if;
54: end rosetta_table_copy_in_p2;
55: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE

Line 68: a1 := JTF_VARCHAR2_TABLE_200();

64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();

Line 77: a1 := JTF_VARCHAR2_TABLE_200();

73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();

Line 118: , a4 JTF_VARCHAR2_TABLE_2000

114: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 JTF_NUMBER_TABLE
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: , a3 JTF_VARCHAR2_TABLE_100
118: , a4 JTF_VARCHAR2_TABLE_2000
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE

Line 155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

151: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
152: , a1 out nocopy JTF_VARCHAR2_TABLE_100
153: , a2 out nocopy JTF_VARCHAR2_TABLE_100
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE

Line 169: a4 := JTF_VARCHAR2_TABLE_2000();

165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_VARCHAR2_TABLE_100();
167: a2 := JTF_VARCHAR2_TABLE_100();
168: a3 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_VARCHAR2_TABLE_2000();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();

Line 180: a4 := JTF_VARCHAR2_TABLE_2000();

176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_VARCHAR2_TABLE_100();
178: a2 := JTF_VARCHAR2_TABLE_100();
179: a3 := JTF_VARCHAR2_TABLE_100();
180: a4 := JTF_VARCHAR2_TABLE_2000();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();

Line 223: , a3 JTF_VARCHAR2_TABLE_200

219:
220: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE

Line 224: , a4 JTF_VARCHAR2_TABLE_2000

220: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE

Line 260: , a3 out nocopy JTF_VARCHAR2_TABLE_200

256: end rosetta_table_copy_in_p8;
257: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_NUMBER_TABLE
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE

Line 261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

257: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_NUMBER_TABLE
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE

Line 274: a3 := JTF_VARCHAR2_TABLE_200();

270: if t is null or t.count = 0 then
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();

Line 275: a4 := JTF_VARCHAR2_TABLE_2000();

271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();

Line 285: a3 := JTF_VARCHAR2_TABLE_200();

281: else
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();

Line 286: a4 := JTF_VARCHAR2_TABLE_2000();

282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();

Line 413: , p5_a3 JTF_VARCHAR2_TABLE_200

409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE

Line 414: , p5_a4 JTF_VARCHAR2_TABLE_2000

410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE

Line 423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE

Line 549: , p5_a3 JTF_VARCHAR2_TABLE_200

545: , x_msg_data out nocopy VARCHAR2
546: , p5_a0 JTF_NUMBER_TABLE
547: , p5_a1 JTF_NUMBER_TABLE
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE

Line 550: , p5_a4 JTF_VARCHAR2_TABLE_2000

546: , p5_a0 JTF_NUMBER_TABLE
547: , p5_a1 JTF_NUMBER_TABLE
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE

Line 684: , p5_a3 JTF_VARCHAR2_TABLE_200

680: , x_msg_data out nocopy VARCHAR2
681: , p5_a0 JTF_NUMBER_TABLE
682: , p5_a1 JTF_NUMBER_TABLE
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE

Line 685: , p5_a4 JTF_VARCHAR2_TABLE_2000

681: , p5_a0 JTF_NUMBER_TABLE
682: , p5_a1 JTF_NUMBER_TABLE
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE

Line 694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE

Line 820: , p5_a3 JTF_VARCHAR2_TABLE_200

816: , x_msg_data out nocopy VARCHAR2
817: , p5_a0 JTF_NUMBER_TABLE
818: , p5_a1 JTF_NUMBER_TABLE
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE

Line 821: , p5_a4 JTF_VARCHAR2_TABLE_2000

817: , p5_a0 JTF_NUMBER_TABLE
818: , p5_a1 JTF_NUMBER_TABLE
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE

Line 931: , p5_a3 JTF_VARCHAR2_TABLE_200

927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_NUMBER_TABLE
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE

Line 932: , p5_a4 JTF_VARCHAR2_TABLE_2000

928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_NUMBER_TABLE
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE