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 CN_JOB_TITLE_PVT

Line 1: package body cn_job_title_pvt_w as

1: package body cn_job_title_pvt_w as
2: /* $Header: cnwjobb.pls 115.5 2002/11/25 22:24:21 nkodkani ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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 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 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 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 315: ddp_rec cn_job_title_pvt.job_role_rec_type;

311: , x_job_role_id out nocopy NUMBER
312: )
313:
314: as
315: ddp_rec cn_job_title_pvt.job_role_rec_type;
316: ddindx binary_integer; indx binary_integer;
317: begin
318:
319: -- copy data to the local IN or IN-OUT args, if any

Line 353: cn_job_title_pvt.create_job_role(p_api_version,

349:
350:
351:
352: -- here's the delegated call to the old PL/SQL routine
353: cn_job_title_pvt.create_job_role(p_api_version,
354: p_init_msg_list,
355: p_commit,
356: p_validation_level,
357: ddp_rec,

Line 407: ddp_rec cn_job_title_pvt.job_role_rec_type;

403: , x_msg_data out nocopy VARCHAR2
404: )
405:
406: as
407: ddp_rec cn_job_title_pvt.job_role_rec_type;
408: ddindx binary_integer; indx binary_integer;
409: begin
410:
411: -- copy data to the local IN or IN-OUT args, if any

Line 444: cn_job_title_pvt.update_job_role(p_api_version,

440:
441:
442:
443: -- here's the delegated call to the old PL/SQL routine
444: cn_job_title_pvt.update_job_role(p_api_version,
445: p_init_msg_list,
446: p_commit,
447: p_validation_level,
448: ddp_rec,

Line 490: ddx_result_tbl cn_job_title_pvt.job_role_tbl_type;

486: , p1_a22 out nocopy JTF_NUMBER_TABLE
487: )
488:
489: as
490: ddx_result_tbl cn_job_title_pvt.job_role_tbl_type;
491: ddindx binary_integer; indx binary_integer;
492: begin
493:
494: -- copy data to the local IN or IN-OUT args, if any

Line 498: cn_job_title_pvt.get_job_details(p_job_title_id,

494: -- copy data to the local IN or IN-OUT args, if any
495:
496:
497: -- here's the delegated call to the old PL/SQL routine
498: cn_job_title_pvt.get_job_details(p_job_title_id,
499: ddx_result_tbl);
500:
501: -- copy data back from the local variables to OUT or IN-OUT args, if any
502:

Line 503: cn_job_title_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, p1_a0

499: ddx_result_tbl);
500:
501: -- copy data back from the local variables to OUT or IN-OUT args, if any
502:
503: cn_job_title_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, p1_a0
504: , p1_a1
505: , p1_a2
506: , p1_a3
507: , p1_a4

Line 542: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;

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;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 554: cn_job_title_pvt.get_job_titles(p_range_low,

550:
551:
552:
553: -- here's the delegated call to the old PL/SQL routine
554: cn_job_title_pvt.get_job_titles(p_range_low,
555: p_range_high,
556: p_search_name,
557: p_search_code,
558: x_total_rows,

Line 567: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p5_a0

563:
564:
565:
566:
567: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p5_a0
568: , p5_a1
569: , p5_a2
570: , p5_a3
571: , p5_a4

Line 583: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;

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;
584: ddindx binary_integer; indx binary_integer;
585: begin
586:
587: -- copy data to the local IN or IN-OUT args, if any

Line 590: cn_job_title_pvt.get_all_job_titles(ddx_result_tbl);

586:
587: -- copy data to the local IN or IN-OUT args, if any
588:
589: -- here's the delegated call to the old PL/SQL routine
590: cn_job_title_pvt.get_all_job_titles(ddx_result_tbl);
591:
592: -- copy data back from the local variables to OUT or IN-OUT args, if any
593: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0
594: , p0_a1

Line 593: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0

589: -- here's the delegated call to the old PL/SQL routine
590: cn_job_title_pvt.get_all_job_titles(ddx_result_tbl);
591:
592: -- copy data back from the local variables to OUT or IN-OUT args, if any
593: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0
594: , p0_a1
595: , p0_a2
596: , p0_a3
597: , p0_a4

Line 609: ddx_result_tbl cn_job_title_pvt.job_title_tbl_type;

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;
610: ddindx binary_integer; indx binary_integer;
611: begin
612:
613: -- copy data to the local IN or IN-OUT args, if any

Line 616: cn_job_title_pvt.get_job_roles(ddx_result_tbl);

612:
613: -- copy data to the local IN or IN-OUT args, if any
614:
615: -- here's the delegated call to the old PL/SQL routine
616: cn_job_title_pvt.get_job_roles(ddx_result_tbl);
617:
618: -- copy data back from the local variables to OUT or IN-OUT args, if any
619: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0
620: , p0_a1

Line 619: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0

615: -- here's the delegated call to the old PL/SQL routine
616: cn_job_title_pvt.get_job_roles(ddx_result_tbl);
617:
618: -- copy data back from the local variables to OUT or IN-OUT args, if any
619: cn_job_title_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p0_a0
620: , p0_a1
621: , p0_a2
622: , p0_a3
623: , p0_a4

Line 627: end cn_job_title_pvt_w;

623: , p0_a4
624: );
625: end;
626:
627: end cn_job_title_pvt_w;