DBA Data[Home] [Help]

PACKAGE: APPS.HXC_ALIAS_DEFINITIONS_API

Source


1 Package hxc_alias_definitions_api as
2 /* $Header: hxchadapi.pkh 120.0 2005/05/29 05:32:25 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_alias_definition >---------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 --   Name                           Reqd Type     Description
17 --    p_validate                    No   Boolean  If TRUE then the database
18 --                                                remains unchanged. If FALSE
19 --                                                then a new alias definition is
20 --                                                created. The default is FALSE.
21 --    p_alias_definition_name       Yes  varchar2 Name for the alias
22 --    p_timecard_field              Yes  varchar2 The field on the timecard
23 --                                                for which this alias will
24 --                                                be used.
25 --    p_description                 No   varchar2 User description of the alias
26 --
27 --   p_prompt 			    No   varchar2 Prompt for the alternate Name
28 --						  defined.
29 --  p_alias_type_id		    Yes	 Number   ID of the alternate Name Type.
30 --
31 -- Post Success:
32 --
33 -- The following OUT parameters are set after the alias definition
34 -- has been created successfully:
35 --
36 --   Name                           Type     Description
37 --    p_alias_definition_id         number   Primary Key for entity
38 --    p_object_version_number       number   Object Version Number
39 --
40 -- Post Failure:
41 --
42 -- The alias definition will not be created and an application error will be
43 -- raised.
44 --
45 -- Access Status:
46 --   Public.
47 --
48 -- {End Of Comments}
49 --
50 procedure create_alias_definition
51   (p_validate                      in     boolean  default false
52   ,p_alias_definition_id	      out nocopy number
53   ,p_alias_definition_name	   in     varchar2
54   ,p_alias_context_code            in     varchar2 default null
55   ,p_business_group_id	           in     number   default null
56   ,p_legislation_code              in     varchar2 default null
57   ,p_description                   in     varchar2 default null
58   ,p_prompt                        in     varchar2 default null
59   ,p_timecard_field		   in     varchar2
60   ,p_object_version_number            out nocopy number
61   ,p_language_code                 in     varchar2  default hr_api.userenv_lang
62   ,p_alias_type_id                 in     number
63 --  ,p_effective_date                in     date
64 --  ,p_non_mandatory_arg             in     number   default null
65 --  ,p_some_warning                     out boolean
66   );
67 --
68 -- ----------------------------------------------------------------------------
69 -- |--------------------------< update_alias_definition >---------------------|
70 -- ----------------------------------------------------------------------------
71 -- {Start Of Comments}
72 --
73 -- Description:
74 --    This API updates an existing alias definition.
75 --
76 -- Prerequisites:
77 --    None.
78 --
79 -- In Parameters:
80 --   Name                           Reqd Type     Description
81 --    p_validate		    No   Boolean  If TRUE then the database
82 --                                                remains unchanged. If FALSE
83 --                                                then the alias definition is
84 --                                                updated. The default is FALSE.
85 --    p_alias_definition_id         Yes  number   Primary Key for entity
86 --    p_alias_definition_name       Yes  varchar2 Name for the alias
87 --    p_timecard_field       	    Yes  varchar2 The field on the timecard
88 --						  for which this alias will
89 --						  be used.
90 --    p_description                 No   varchar2 User description of the alias
91 --   p_prompt                       No   varchar2 Prompt for the alternate Name
92 --                                                defined.
93 --  p_alias_type_id                 Yes  Number   ID of the alternate Name Type.
94 --
95 --    p_object_version_number       No   number   Object Version Number of the
96 --						  existing record.
97 --
98 -- Post Success:
99 --
100 -- The following OUT parameters are set, after the alias definition has
101 -- been updated successfully:
102 --
103 --   Name                           Type     Description
104 --    p_object_version_number       number   Object Version Number of the
105 --					     updated record.
106 --
107 -- Post Failure:
108 --
109 -- The alias definition will not be updated and an application error will be
110 -- raised.
111 --
112 -- Access Status:
113 --   Public.
114 --
115 -- {End Of Comments}
116 --
117 procedure update_alias_definition
118   (p_validate                      in     boolean  default false
119   ,p_alias_definition_id           in     number
120   ,p_alias_definition_name         in     varchar2
121   ,p_alias_context_code            in     varchar2 default null
122   ,p_business_group_id	           in     number   default null
123   ,p_legislation_code              in     varchar2 default null
124   ,p_description                   in     varchar2 default null
125   ,p_prompt                        in     varchar2 default null
126   ,p_timecard_field                in     varchar2
127   ,p_object_version_number         in out nocopy number
128   ,p_language_code                 in     varchar2  default hr_api.userenv_lang
129   ,p_alias_type_id                 in     number
130   );
131 --
132 -- ----------------------------------------------------------------------------
133 -- |--------------------------< delete_alias_definition >---------------------|
134 -- ----------------------------------------------------------------------------
135 -- {Start Of Comments}
136 --
137 -- Description:
138 --    This API deletes an existing alias definition.
139 --
140 -- Prerequisites:
141 --    None.
142 --
143 -- In Parameters:
144 --   Name                           Reqd Type     Description
145 --    p_validate                    No   boolean  If TRUE then the database
146 --                                                remains unchanged. If FALSE
147 --                                                then the alias definition.
148 --                                                is deleted. Default is FALSE.
149 --    p_alias_definition_id         Yes  number   Primary Key for entity
150 --    p_object_version_number       Yes  number   Object Version Number
151 --
152 -- Post Success:
153 --
154 --   If the alias definition has been deleted successfully the process
155 --   completes with success, with no OUT parameters being set.
156 --
157 -- Post Failure:
158 --
159 --   The alias definition will not be deleted and an application error is
160 --   raised.
161 --
162 -- Access Status:
163 --   Public.
164 --
165 -- {End Of Comments}
166 --
167 procedure delete_alias_definition
168   (p_validate                      in     boolean  default false
169   ,p_alias_definition_id           in     number
170   ,p_object_version_number         in     number
171   );
172 --
173 end hxc_alias_definitions_api;