DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT_W dependencies on AHL_PRD_NONROUTINE_PVT

Line 1: package body ahl_prd_nonroutine_pvt_w as

1: package body ahl_prd_nonroutine_pvt_w as
2: /* $Header: AHLWPNRB.pls 120.9.12020000.2 2012/12/14 03:36:03 shnatu 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 JTF_DATE_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 JTF_DATE_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 175: procedure rosetta_table_copy_out_p2(t ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 out nocopy JTF_DATE_TABLE

171: end loop;
172: end if;
173: end if;
174: end rosetta_table_copy_in_p2;
175: procedure rosetta_table_copy_out_p2(t ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 out nocopy JTF_DATE_TABLE
176: , a1 out nocopy JTF_NUMBER_TABLE
177: , a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , a3 out nocopy JTF_NUMBER_TABLE
179: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 549: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 JTF_NUMBER_TABLE

545: end if;
546: end if;
547: end rosetta_table_copy_out_p2;
548:
549: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 JTF_NUMBER_TABLE
550: , a1 JTF_VARCHAR2_TABLE_100
551: , a2 JTF_NUMBER_TABLE
552: , a3 JTF_NUMBER_TABLE
553: , a4 JTF_NUMBER_TABLE

Line 586: procedure rosetta_table_copy_out_p4(t ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

582: end loop;
583: end if;
584: end if;
585: end rosetta_table_copy_in_p4;
586: procedure rosetta_table_copy_out_p4(t ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
587: , a1 out nocopy JTF_VARCHAR2_TABLE_100
588: , a2 out nocopy JTF_NUMBER_TABLE
589: , a3 out nocopy JTF_NUMBER_TABLE
590: , a4 out nocopy JTF_NUMBER_TABLE

Line 747: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;

743: , p9_a9 in out nocopy JTF_NUMBER_TABLE
744: )
745:
746: as
747: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;
748: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
749: ddindx binary_integer; indx binary_integer;
750: begin
751:

Line 748: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;

744: )
745:
746: as
747: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;
748: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
749: ddindx binary_integer; indx binary_integer;
750: begin
751:
752: -- copy data to the local IN or IN-OUT args, if any

Line 761: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p2(ddp_x_sr_task_tbl, p8_a0

757:
758:
759:
760:
761: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p2(ddp_x_sr_task_tbl, p8_a0
762: , p8_a1
763: , p8_a2
764: , p8_a3
765: , p8_a4

Line 834: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p4(ddp_x_mr_asso_tbl, p9_a0

830: , p8_a69
831: , p8_a70
832: );
833:
834: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p4(ddp_x_mr_asso_tbl, p9_a0
835: , p9_a1
836: , p9_a2
837: , p9_a3
838: , p9_a4

Line 847: ahl_prd_nonroutine_pvt.process_nonroutine_job(p_api_version,

843: , p9_a9
844: );
845:
846: -- here's the delegated call to the old PL/SQL routine
847: ahl_prd_nonroutine_pvt.process_nonroutine_job(p_api_version,
848: p_init_msg_list,
849: p_commit,
850: p_validation_level,
851: p_module_type,

Line 867: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p2(ddp_x_sr_task_tbl, p8_a0

863:
864:
865:
866:
867: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p2(ddp_x_sr_task_tbl, p8_a0
868: , p8_a1
869: , p8_a2
870: , p8_a3
871: , p8_a4

Line 940: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p4(ddp_x_mr_asso_tbl, p9_a0

936: , p8_a69
937: , p8_a70
938: );
939:
940: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p4(ddp_x_mr_asso_tbl, p9_a0
941: , p9_a1
942: , p9_a2
943: , p9_a3
944: , p9_a4

Line 953: end ahl_prd_nonroutine_pvt_w;

949: , p9_a9
950: );
951: end;
952:
953: end ahl_prd_nonroutine_pvt_w;