APPS.CN_JOB_TITLE_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 14: , a1 JTF_VARCHAR2_TABLE_300

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
18: ) as

Line 15: , a2 JTF_VARCHAR2_TABLE_300

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
18: ) as
19: ddindx binary_integer; indx binary_integer;

Line 41: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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
45: ) as

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
45: ) as
46: ddindx binary_integer; indx binary_integer;

Line 50: a1 := JTF_VARCHAR2_TABLE_300();

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

Line 51: a2 := JTF_VARCHAR2_TABLE_300();

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();
54: else
55: a0 := JTF_NUMBER_TABLE();

Line 56: a1 := 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();
60: if t.count > 0 then

Line 57: a2 := JTF_VARCHAR2_TABLE_300();

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();
60: if t.count > 0 then
61: a0.extend(t.count);

Line 535: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_300

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
539: )

Line 536: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
539: )
540:

Line 576: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300

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
580: )

Line 577: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
580: )
581:

Line 602: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_300

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
606: )

Line 603: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
606: )
607: