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:
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
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
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
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
623: , p0_a4
624: );
625: end;
626:
627: end cn_job_title_pvt_w;