DBA Data[Home] [Help]

APPS.AHL_PRD_VISITS_PVT_W dependencies on AHL_PRD_VISITS_PVT

Line 1: package body ahl_prd_visits_pvt_w as

1: package body ahl_prd_visits_pvt_w as
2: /* $Header: AHLWPSVB.pls 120.1 2006/05/03 00:45 bachandr noship $ */
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_p1(t out nocopy ahl_prd_visits_pvt.visit_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_p1(t out nocopy ahl_prd_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 169: procedure rosetta_table_copy_out_p1(t ahl_prd_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

165: end loop;
166: end if;
167: end if;
168: end rosetta_table_copy_in_p1;
169: procedure rosetta_table_copy_out_p1(t ahl_prd_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a1 out nocopy JTF_VARCHAR2_TABLE_100
171: , a2 out nocopy JTF_NUMBER_TABLE
172: , a3 out nocopy JTF_NUMBER_TABLE
173: , a4 out nocopy JTF_DATE_TABLE

Line 608: ddx_visit_rec ahl_prd_visits_pvt.visit_rec_type;

604: , x_msg_data out nocopy VARCHAR2
605: )
606:
607: as
608: ddx_visit_rec ahl_prd_visits_pvt.visit_rec_type;
609: ddindx binary_integer; indx binary_integer;
610: begin
611:
612: -- copy data to the local IN or IN-OUT args, if any

Line 624: ahl_prd_visits_pvt.get_visit_details(p_api_version,

620:
621:
622:
623: -- here's the delegated call to the old PL/SQL routine
624: ahl_prd_visits_pvt.get_visit_details(p_api_version,
625: p_init_msg_list,
626: p_commit,
627: p_validation_level,
628: p_module_type,

Line 715: end ahl_prd_visits_pvt_w;

711:
712:
713: end;
714:
715: end ahl_prd_visits_pvt_w;