APPS.AHL_UMP_UF_PVT_W dependencies on AHL_UMP_UF_PVT

Line 1: package body ahl_ump_uf_pvt_w as

1: package body ahl_ump_uf_pvt_w as
2: /* $Header: AHLUMFWB.pls 120.2 2008/01/18 01:22:41 sikumar 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_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_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_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 91: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p16;
91: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE

Line 329: ddp_x_uf_header_rec ahl_ump_uf_pvt.uf_header_rec_type;

325: , x_msg_data out nocopy VARCHAR2
326: )
327:
328: as
329: ddp_x_uf_header_rec ahl_ump_uf_pvt.uf_header_rec_type;
330: ddp_x_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:

Line 330: ddp_x_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;

326: )
327:
328: as
329: ddp_x_uf_header_rec ahl_ump_uf_pvt.uf_header_rec_type;
330: ddp_x_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:
334: -- copy data to the local IN or IN-OUT args, if any

Line 375: ahl_ump_uf_pvt_w.rosetta_table_copy_in_p16(ddp_x_uf_details_tbl, p6_a0

371: ddp_x_uf_header_rec.attribute13 := p5_a31;
372: ddp_x_uf_header_rec.attribute14 := p5_a32;
373: ddp_x_uf_header_rec.attribute15 := p5_a33;
374:
375: ahl_ump_uf_pvt_w.rosetta_table_copy_in_p16(ddp_x_uf_details_tbl, p6_a0
376: , p6_a1
377: , p6_a2
378: , p6_a3
379: , p6_a4

Line 410: ahl_ump_uf_pvt.process_utilization_forecast(p_api_version,

406:
407:
408:
409: -- here's the delegated call to the old PL/SQL routine
410: ahl_ump_uf_pvt.process_utilization_forecast(p_api_version,
411: p_init_msg_list,
412: p_commit,
413: p_validation_level,
414: p_module_type,

Line 462: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddp_x_uf_details_tbl, p6_a0

458: p5_a31 := ddp_x_uf_header_rec.attribute13;
459: p5_a32 := ddp_x_uf_header_rec.attribute14;
460: p5_a33 := ddp_x_uf_header_rec.attribute15;
461:
462: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddp_x_uf_details_tbl, p6_a0
463: , p6_a1
464: , p6_a2
465: , p6_a3
466: , p6_a4

Line 540: ddx_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;

536: )
537:
538: as
539: ddp_onward_end_date date;
540: ddx_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;
541: ddindx binary_integer; indx binary_integer;
542: begin
543:
544: -- copy data to the local IN or IN-OUT args, if any

Line 558: ahl_ump_uf_pvt.get_uf_from_pc(p_init_msg_list,

554:
555:
556:
557: -- here's the delegated call to the old PL/SQL routine
558: ahl_ump_uf_pvt.get_uf_from_pc(p_init_msg_list,
559: p_pc_node_id,
560: p_inventory_item_id,
561: p_inventory_org_id,
562: p_unit_config_header_id,

Line 580: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddx_uf_details_tbl, p9_a0

576:
577:
578:
579:
580: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddx_uf_details_tbl, p9_a0
581: , p9_a1
582: , p9_a2
583: , p9_a3
584: , p9_a4

Line 650: ddx_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;

646: )
647:
648: as
649: ddp_onward_end_date date;
650: ddx_uf_details_tbl ahl_ump_uf_pvt.uf_details_tbl_type;
651: ddindx binary_integer; indx binary_integer;
652: begin
653:
654: -- copy data to the local IN or IN-OUT args, if any

Line 662: ahl_ump_uf_pvt.get_uf_from_part(p_init_msg_list,

658:
659:
660:
661: -- here's the delegated call to the old PL/SQL routine
662: ahl_ump_uf_pvt.get_uf_from_part(p_init_msg_list,
663: p_csi_item_instance_id,
664: ddp_onward_end_date,
665: ddx_uf_details_tbl,
666: x_return_status);

Line 672: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddx_uf_details_tbl, p3_a0

668: -- copy data back from the local variables to OUT or IN-OUT args, if any
669:
670:
671:
672: ahl_ump_uf_pvt_w.rosetta_table_copy_out_p16(ddx_uf_details_tbl, p3_a0
673: , p3_a1
674: , p3_a2
675: , p3_a3
676: , p3_a4

Line 705: end ahl_ump_uf_pvt_w;

701: );
702:
703: end;
704:
705: end ahl_ump_uf_pvt_w;