eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_job_title_pvt.job_title_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
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

Line 16: , a3 JTF_NUMBER_TABLE

12:
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

Line 40: procedure rosetta_table_copy_out_p1(t cn_job_title_pvt.job_title_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
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

Line 43: , a3 out nocopy JTF_NUMBER_TABLE

39: end rosetta_table_copy_in_p1;
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

Line 49: a0 := JTF_NUMBER_TABLE();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
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();

Line 52: a3 := JTF_NUMBER_TABLE();

48: if t is null or t.count = 0 then
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();

Line 55: a0 := JTF_NUMBER_TABLE();

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();
58: a3 := JTF_NUMBER_TABLE();
59: a4 := JTF_VARCHAR2_TABLE_100();

Line 58: a3 := JTF_NUMBER_TABLE();

54: else
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);

Line 84: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_NUMBER_TABLE
87: , a3 JTF_DATE_TABLE
88: , a4 JTF_DATE_TABLE

Line 85: , a1 JTF_NUMBER_TABLE

81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 86: , a2 JTF_NUMBER_TABLE

82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_job_title_pvt.job_role_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 106: , a22 JTF_NUMBER_TABLE

102: , a18 JTF_VARCHAR2_TABLE_200
103: , a19 JTF_VARCHAR2_TABLE_200
104: , a20 JTF_VARCHAR2_TABLE_200
105: , a21 JTF_VARCHAR2_TABLE_200
106: , a22 JTF_NUMBER_TABLE
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin
110: if a0 is not null and a0.count > 0 then

Line 147: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

143: end loop;
144: end if;
145: end if;
146: end rosetta_table_copy_in_p3;
147: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 148: , a1 out nocopy JTF_NUMBER_TABLE

144: end if;
145: end if;
146: end rosetta_table_copy_in_p3;
147: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 149: , a2 out nocopy JTF_NUMBER_TABLE

145: end if;
146: end rosetta_table_copy_in_p3;
147: procedure rosetta_table_copy_out_p3(t cn_job_title_pvt.job_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 169: , a22 out nocopy JTF_NUMBER_TABLE

165: , a18 out nocopy JTF_VARCHAR2_TABLE_200
166: , a19 out nocopy JTF_VARCHAR2_TABLE_200
167: , a20 out nocopy JTF_VARCHAR2_TABLE_200
168: , a21 out nocopy JTF_VARCHAR2_TABLE_200
169: , a22 out nocopy JTF_NUMBER_TABLE
170: ) as
171: ddindx binary_integer; indx binary_integer;
172: begin
173: if t is null or t.count = 0 then

Line 174: a0 := JTF_NUMBER_TABLE();

170: ) as
171: ddindx binary_integer; indx binary_integer;
172: begin
173: if t is null or t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_NUMBER_TABLE();
177: a3 := JTF_DATE_TABLE();
178: a4 := JTF_DATE_TABLE();

Line 175: a1 := JTF_NUMBER_TABLE();

171: ddindx binary_integer; indx binary_integer;
172: begin
173: if t is null or t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
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();

Line 176: a2 := JTF_NUMBER_TABLE();

172: begin
173: if t is null or t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
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();

Line 196: a22 := JTF_NUMBER_TABLE();

192: a18 := JTF_VARCHAR2_TABLE_200();
193: a19 := JTF_VARCHAR2_TABLE_200();
194: a20 := JTF_VARCHAR2_TABLE_200();
195: a21 := JTF_VARCHAR2_TABLE_200();
196: a22 := JTF_NUMBER_TABLE();
197: else
198: a0 := JTF_NUMBER_TABLE();
199: a1 := JTF_NUMBER_TABLE();
200: a2 := JTF_NUMBER_TABLE();

Line 198: a0 := JTF_NUMBER_TABLE();

194: a20 := JTF_VARCHAR2_TABLE_200();
195: a21 := JTF_VARCHAR2_TABLE_200();
196: a22 := JTF_NUMBER_TABLE();
197: else
198: a0 := JTF_NUMBER_TABLE();
199: a1 := JTF_NUMBER_TABLE();
200: a2 := JTF_NUMBER_TABLE();
201: a3 := JTF_DATE_TABLE();
202: a4 := JTF_DATE_TABLE();

Line 199: a1 := JTF_NUMBER_TABLE();

195: a21 := JTF_VARCHAR2_TABLE_200();
196: a22 := JTF_NUMBER_TABLE();
197: else
198: a0 := JTF_NUMBER_TABLE();
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();

Line 200: a2 := JTF_NUMBER_TABLE();

196: a22 := JTF_NUMBER_TABLE();
197: else
198: a0 := JTF_NUMBER_TABLE();
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();

Line 220: a22 := JTF_NUMBER_TABLE();

216: a18 := JTF_VARCHAR2_TABLE_200();
217: a19 := JTF_VARCHAR2_TABLE_200();
218: a20 := JTF_VARCHAR2_TABLE_200();
219: a21 := JTF_VARCHAR2_TABLE_200();
220: a22 := JTF_NUMBER_TABLE();
221: if t.count > 0 then
222: a0.extend(t.count);
223: a1.extend(t.count);
224: a2.extend(t.count);

Line 464: , p1_a0 out nocopy JTF_NUMBER_TABLE

460:
461: end;
462:
463: procedure get_job_details(p_job_title_id NUMBER
464: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 465: , p1_a1 out nocopy JTF_NUMBER_TABLE

461: end;
462:
463: procedure get_job_details(p_job_title_id NUMBER
464: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 466: , p1_a2 out nocopy JTF_NUMBER_TABLE

462:
463: procedure get_job_details(p_job_title_id NUMBER
464: , p1_a0 out nocopy JTF_NUMBER_TABLE
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

Line 486: , p1_a22 out nocopy JTF_NUMBER_TABLE

482: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
483: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
484: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
485: , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
486: , p1_a22 out nocopy JTF_NUMBER_TABLE
487: )
488:
489: as
490: ddx_result_tbl cn_job_title_pvt.job_role_tbl_type;

Line 534: , p5_a0 out nocopy JTF_NUMBER_TABLE

530: , p_range_high NUMBER
531: , p_search_name VARCHAR2
532: , p_search_code VARCHAR2
533: , x_total_rows out nocopy NUMBER
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

Line 537: , p5_a3 out nocopy JTF_NUMBER_TABLE

533: , x_total_rows out nocopy NUMBER
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

Line 575: procedure get_all_job_titles(p0_a0 out nocopy JTF_NUMBER_TABLE

571: , p5_a4
572: );
573: end;
574:
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

Line 578: , p0_a3 out nocopy JTF_NUMBER_TABLE

574:
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

Line 601: procedure get_job_roles(p0_a0 out nocopy JTF_NUMBER_TABLE

597: , p0_a4
598: );
599: end;
600:
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

Line 604: , p0_a3 out nocopy JTF_NUMBER_TABLE

600:
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