1 PACKAGE CSI_HZ_LOCATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: csivhzls.pls 120.2 2005/12/09 16:32:10 rmamidip noship $ */
3 -- start of comments
4 -- PACKAGE name : CSI_HZ_LOCATIONS_PVT
5 -- purpose :
6 -- history :
7 -- note :
8 -- END of comments
9
10 -- default NUMBER of records fetch per call
11 g_default_num_rec_fetch NUMBER := 30;
12
13 --+=================================================================+
14 --| Create_location procedure written for calling it from CSI forms |
15 --| This procedure validates for unique clli_code and calls |
16 --| hz_location_v2pub.create_location |
17 --+=================================================================+
18
19 PROCEDURE create_location(
20 p_api_version IN NUMBER,
21 p_commit IN VARCHAR2 := fnd_api.g_false,
22 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
23 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
24 p_country IN VARCHAR2,
25 p_address1 IN VARCHAR2,
26 p_address2 IN VARCHAR2,
27 p_address3 IN VARCHAR2,
28 p_address4 IN VARCHAR2,
29 p_city IN VARCHAR2,
30 p_postal_code IN VARCHAR2,
31 p_state IN VARCHAR2,
32 p_province IN VARCHAR2,
33 p_county IN VARCHAR2,
34 p_clli_code IN VARCHAR2,
35 p_description IN VARCHAR2,
36 p_last_update_date IN DATE ,
37 p_last_updated_by IN NUMBER ,
38 p_creation_date IN DATE ,
39 p_created_by IN NUMBER ,
40 p_created_by_module IN VARCHAR2,
41 x_location_id OUT NOCOPY NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 ) ;
46
47 --+=================================================================+
48 --| Update_location procedure written for calling it from CSI forms |
49 --| This procedure validates for unique clli_code and calls |
50 --| hz_location_v2pub.update_location |
51 --+=================================================================+
52
53 PROCEDURE update_location(
54 p_api_version IN NUMBER,
55 p_commit IN VARCHAR2 := fnd_api.g_false,
56 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
57 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
58 p_location_id IN NUMBER,
59 p_country IN VARCHAR2,
60 p_address1 IN VARCHAR2,
61 p_address2 IN VARCHAR2,
62 p_address3 IN VARCHAR2,
63 p_address4 IN VARCHAR2,
64 p_city IN VARCHAR2,
65 p_postal_code IN VARCHAR2,
66 p_state IN VARCHAR2,
67 p_province IN VARCHAR2,
68 p_county IN VARCHAR2,
69 p_clli_code IN VARCHAR2,
70 p_description IN VARCHAR2,
71 p_last_update_date IN DATE ,
72 p_last_updated_by IN NUMBER ,
73 p_creation_date IN DATE ,
74 p_created_by IN NUMBER ,
75 p_created_by_module IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2
79 ) ;
80
81 --+=================================================================+
82 --| Lock_location procedure written for calling it from CSI forms |
83 --+=================================================================+
84
85 PROCEDURE Lock_location(
86 p_location_id NUMBER ,
87 p_last_update_date DATE ,
88 p_last_updated_by NUMBER ,
89 p_creation_date DATE ,
90 p_created_by NUMBER ,
91 p_country VARCHAR2,
92 p_address1 VARCHAR2,
93 p_address2 VARCHAR2,
94 p_address3 VARCHAR2,
95 p_address4 VARCHAR2,
96 p_city VARCHAR2,
97 p_postal_code VARCHAR2,
98 p_state VARCHAR2,
99 p_province VARCHAR2,
100 p_county VARCHAR2,
101 p_clli_code VARCHAR2,
102 p_description VARCHAR2,
103 p_created_by_module VARCHAR2
104 ) ;
105
106
107 END CSI_HZ_LOCATIONS_PVT;