1 PACKAGE HZ_LOCATION_PROFILE_PVT AS
2 /*$Header: ARHLCPVS.pls 120.1 2005/10/28 00:05:27 acng noship $*/
3
4 TYPE location_profile_rec_type IS RECORD (
5 location_profile_id NUMBER
6 ,location_id NUMBER
7 ,actual_content_source VARCHAR2(30)
8 ,effective_start_date DATE
9 ,effective_end_date DATE
10 ,validation_sst_flag VARCHAR2(1)
11 ,validation_status_code VARCHAR2(30)
12 ,date_validated DATE
13 ,address1 VARCHAR2(240)
14 ,address2 VARCHAR2(240)
15 ,address3 VARCHAR2(240)
16 ,address4 VARCHAR2(240)
17 ,city VARCHAR2(60)
18 ,postal_code VARCHAR2(60)
19 ,prov_state_admin_code VARCHAR2(60)
20 ,county VARCHAR2(60)
21 ,country VARCHAR2(2) );
22
23 TYPE location_profile_tbl_type IS TABLE OF location_profile_rec_type INDEX BY BINARY_INTEGER;
24
25 -- This procedure create a record in location profile
26 PROCEDURE create_location_profile (
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
28 ,p_location_profile_rec IN location_profile_rec_type
29 ,x_location_profile_id OUT NOCOPY NUMBER
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2 );
33
34 -- This procedure update a record in location profile
35 PROCEDURE update_location_profile (
36 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37 ,p_location_profile_rec IN location_profile_rec_type
38 -- ,px_object_version_number IN OUT NOCOPY NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2 );
42
43 PROCEDURE validate_mandatory_column(
44 p_create_update_flag IN VARCHAR2
45 ,p_location_profile_rec IN location_profile_rec_type
46 ,x_return_status IN OUT NOCOPY VARCHAR2 );
47
48 PROCEDURE set_effective_end_date (
49 p_location_profile_id IN NUMBER
50 ,x_return_status IN OUT NOCOPY VARCHAR2 );
51
52 PROCEDURE set_validation_status_code(
53 p_location_profile_id IN NUMBER
54 ,p_validation_status_code IN VARCHAR2
55 ,x_return_status IN OUT NOCOPY VARCHAR2 );
56
57 END HZ_LOCATION_PROFILE_PVT;