[Home] [Help]
PACKAGE: APPS.PER_RI_CONFIG_LOCATION_SWI
Source
1 Package per_ri_config_location_swi AUTHID CURRENT_USER As
2 /* $Header: pecnlswi.pkh 120.0 2005/05/31 06:57 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_location >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: per_ri_config_location_api.create_location
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_location
27 (p_validate in number default hr_api.g_false_num
28 ,p_configuration_code in varchar2
29 ,p_configuration_context in varchar2
30 ,p_location_code in varchar2
31 ,p_description in varchar2 default null
32 ,p_style in varchar2 default null
33 ,p_address_line_1 in varchar2 default null
34 ,p_address_line_2 in varchar2 default null
35 ,p_address_line_3 in varchar2 default null
36 ,p_town_or_city in varchar2 default null
37 ,p_country in varchar2 default null
38 ,p_postal_code in varchar2 default null
39 ,p_region_1 in varchar2 default null
40 ,p_region_2 in varchar2 default null
41 ,p_region_3 in varchar2 default null
42 ,p_telephone_number_1 in varchar2 default null
43 ,p_telephone_number_2 in varchar2 default null
44 ,p_telephone_number_3 in varchar2 default null
45 ,p_loc_information13 in varchar2 default null
46 ,p_loc_information14 in varchar2 default null
47 ,p_loc_information15 in varchar2 default null
48 ,p_loc_information16 in varchar2 default null
49 ,p_loc_information17 in varchar2 default null
50 ,p_loc_information18 in varchar2 default null
51 ,p_loc_information19 in varchar2 default null
52 ,p_loc_information20 in varchar2 default null
53 ,p_language_code in varchar2 default null
54 ,p_effective_date in date
55 ,p_object_version_number out nocopy number
56 ,p_location_id out nocopy number
57 ,p_return_status out nocopy varchar2
58 );
59 -- ----------------------------------------------------------------------------
60 -- |----------------------------< update_location >---------------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start of comments}
63 --
64 -- Description:
65 -- This procedure is the self-service wrapper procedure to the following
66 -- API: per_ri_config_location_api.update_location
67 --
68 -- Pre-requisites
69 -- All 'IN' parameters to this procedure have been appropriately derived.
70 --
71 -- Post Success:
72 -- p_return_status will return value indicating success.
73 --
74 -- Post Failure:
75 -- p_return_status will return value indication failure.
76 --
77 -- Access Status:
78 -- Internal Development use only.
79 --
80 -- {End of comments}
81 -- ----------------------------------------------------------------------------
82 PROCEDURE update_location
83 (p_validate in number default hr_api.g_false_num
84 ,p_location_id in number
85 ,p_configuration_code in varchar2
86 ,p_configuration_context in varchar2
87 ,p_location_code in varchar2
88 ,p_description in varchar2 default hr_api.g_varchar2
89 ,p_style in varchar2 default hr_api.g_varchar2
90 ,p_address_line_1 in varchar2 default hr_api.g_varchar2
91 ,p_address_line_2 in varchar2 default hr_api.g_varchar2
92 ,p_address_line_3 in varchar2 default hr_api.g_varchar2
93 ,p_town_or_city in varchar2 default hr_api.g_varchar2
94 ,p_country in varchar2 default hr_api.g_varchar2
95 ,p_postal_code in varchar2 default hr_api.g_varchar2
96 ,p_region_1 in varchar2 default hr_api.g_varchar2
97 ,p_region_2 in varchar2 default hr_api.g_varchar2
98 ,p_region_3 in varchar2 default hr_api.g_varchar2
99 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
100 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
101 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
102 ,p_loc_information13 in varchar2 default hr_api.g_varchar2
103 ,p_loc_information14 in varchar2 default hr_api.g_varchar2
104 ,p_loc_information15 in varchar2 default hr_api.g_varchar2
105 ,p_loc_information16 in varchar2 default hr_api.g_varchar2
106 ,p_loc_information17 in varchar2 default hr_api.g_varchar2
107 ,p_loc_information18 in varchar2 default hr_api.g_varchar2
108 ,p_loc_information19 in varchar2 default hr_api.g_varchar2
112 ,p_object_version_number in out nocopy number
109 ,p_loc_information20 in varchar2 default hr_api.g_varchar2
110 ,p_language_code in varchar2 default hr_api.g_varchar2
111 ,p_effective_date in date
113 ,p_return_status out nocopy varchar2
114 );
115 -- ----------------------------------------------------------------------------
116 -- |----------------------------< delete_location >---------------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start of comments}
119 --
120 -- Description:
121 -- This procedure is the self-service wrapper procedure to the following
122 -- API: per_ri_config_location_api.delete_location
123 --
124 -- Pre-requisites
125 -- All 'IN' parameters to this procedure have been appropriately derived.
126 --
127 -- Post Success:
128 -- p_return_status will return value indicating success.
129 --
130 -- Post Failure:
131 -- p_return_status will return value indication failure.
132 --
133 -- Access Status:
134 -- Internal Development use only.
135 --
136 -- {End of comments}
137 -- ----------------------------------------------------------------------------
138 PROCEDURE delete_location
139 (p_validate in number default hr_api.g_false_num
140 ,p_location_id in number
141 ,p_object_version_number in number
142 ,p_return_status out nocopy varchar2
143 );
144 end per_ri_config_location_swi;