DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy cn_job_title_pvt.job_title_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_300
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin
21: if a0 is not null and a0.count > 0 then

Line 44: , a4 out nocopy JTF_VARCHAR2_TABLE_100

40: procedure rosetta_table_copy_out_p1(t cn_job_title_pvt.job_title_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_300
42: , a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then

Line 53: a4 := JTF_VARCHAR2_TABLE_100();

49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_300();
51: a2 := JTF_VARCHAR2_TABLE_300();
52: a3 := JTF_NUMBER_TABLE();
53: a4 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_VARCHAR2_TABLE_300();
57: a2 := JTF_VARCHAR2_TABLE_300();

Line 59: a4 := JTF_VARCHAR2_TABLE_100();

55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_VARCHAR2_TABLE_300();
57: a2 := JTF_VARCHAR2_TABLE_300();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_VARCHAR2_TABLE_100();
60: if t.count > 0 then
61: a0.extend(t.count);
62: a1.extend(t.count);
63: a2.extend(t.count);

Line 89: , a5 JTF_VARCHAR2_TABLE_100

85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_NUMBER_TABLE
87: , a3 JTF_DATE_TABLE
88: , a4 JTF_DATE_TABLE
89: , a5 JTF_VARCHAR2_TABLE_100
90: , a6 JTF_VARCHAR2_TABLE_100
91: , a7 JTF_VARCHAR2_TABLE_200
92: , a8 JTF_VARCHAR2_TABLE_200
93: , a9 JTF_VARCHAR2_TABLE_200

Line 90: , a6 JTF_VARCHAR2_TABLE_100

86: , a2 JTF_NUMBER_TABLE
87: , a3 JTF_DATE_TABLE
88: , a4 JTF_DATE_TABLE
89: , a5 JTF_VARCHAR2_TABLE_100
90: , a6 JTF_VARCHAR2_TABLE_100
91: , a7 JTF_VARCHAR2_TABLE_200
92: , a8 JTF_VARCHAR2_TABLE_200
93: , a9 JTF_VARCHAR2_TABLE_200
94: , a10 JTF_VARCHAR2_TABLE_200

Line 152: , a5 out nocopy JTF_VARCHAR2_TABLE_100

148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_DATE_TABLE
151: , a4 out nocopy JTF_DATE_TABLE
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_VARCHAR2_TABLE_200
155: , a8 out nocopy JTF_VARCHAR2_TABLE_200
156: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 153: , a6 out nocopy JTF_VARCHAR2_TABLE_100

149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_DATE_TABLE
151: , a4 out nocopy JTF_DATE_TABLE
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_VARCHAR2_TABLE_200
155: , a8 out nocopy JTF_VARCHAR2_TABLE_200
156: , a9 out nocopy JTF_VARCHAR2_TABLE_200
157: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 179: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 180: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 203: a5 := JTF_VARCHAR2_TABLE_100();

199: a1 := JTF_NUMBER_TABLE();
200: a2 := JTF_NUMBER_TABLE();
201: a3 := JTF_DATE_TABLE();
202: a4 := JTF_DATE_TABLE();
203: a5 := JTF_VARCHAR2_TABLE_100();
204: a6 := JTF_VARCHAR2_TABLE_100();
205: a7 := JTF_VARCHAR2_TABLE_200();
206: a8 := JTF_VARCHAR2_TABLE_200();
207: a9 := JTF_VARCHAR2_TABLE_200();

Line 204: a6 := JTF_VARCHAR2_TABLE_100();

200: a2 := JTF_NUMBER_TABLE();
201: a3 := JTF_DATE_TABLE();
202: a4 := JTF_DATE_TABLE();
203: a5 := JTF_VARCHAR2_TABLE_100();
204: a6 := JTF_VARCHAR2_TABLE_100();
205: a7 := JTF_VARCHAR2_TABLE_200();
206: a8 := JTF_VARCHAR2_TABLE_200();
207: a9 := JTF_VARCHAR2_TABLE_200();
208: a10 := JTF_VARCHAR2_TABLE_200();

Line 469: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

465: , p1_a1 out nocopy JTF_NUMBER_TABLE
466: , p1_a2 out nocopy JTF_NUMBER_TABLE
467: , p1_a3 out nocopy JTF_DATE_TABLE
468: , p1_a4 out nocopy JTF_DATE_TABLE
469: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
472: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
473: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 470: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

466: , p1_a2 out nocopy JTF_NUMBER_TABLE
467: , p1_a3 out nocopy JTF_DATE_TABLE
468: , p1_a4 out nocopy JTF_DATE_TABLE
469: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
472: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
473: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
474: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 538: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

534: , p5_a0 out nocopy JTF_NUMBER_TABLE
535: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_300
536: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300
537: , p5_a3 out nocopy JTF_NUMBER_TABLE
538: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
539: )
540:
541: as
542: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;

Line 579: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

575: procedure get_all_job_titles(p0_a0 out nocopy JTF_NUMBER_TABLE
576: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
577: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300
578: , p0_a3 out nocopy JTF_NUMBER_TABLE
579: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
580: )
581:
582: as
583: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;

Line 605: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100

601: procedure get_job_roles(p0_a0 out nocopy JTF_NUMBER_TABLE
602: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300
603: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300
604: , p0_a3 out nocopy JTF_NUMBER_TABLE
605: , p0_a4 out nocopy JTF_VARCHAR2_TABLE_100
606: )
607:
608: as
609: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;