DBA Data[Home] [Help]

PACKAGE: APPS.HXC_ALIAS_TYPES_API

Source


1 Package hxc_alias_types_api as
2 /* $Header: hxchatapi.pkh 120.0 2005/05/29 05:34:15 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <create_alias_types> >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --	Creates Alternate name type.
12 --
13 -- Prerequisites:
14 --
15 --
16 -- In Parameters:
17 --   Name                           Reqd Type     Description
18 --
19 --  p_validate                      No   boolean  Creates new alias_type if
20 --						  the value is true.
21 --  p_alias_type		    Yes  varchar2 Indicates the Alias Type
22 --						  i.e either 'Static' or
23 --						  'Dynamic'.
24 --  p_reference_object              Yes  varchar2  Indicates the reference
25 --						   object on which the type
26 --						   is based.
27 -- Post Success:
28 -- When the alias type is created properly the following parameters are set.
29 --
30 -- Out Parameters:
31 --     Name                         Type            Description
32 --  p_alias_type_id                number          The alias type id for the
33 --						   type created.
34 --  p_object_version_number        number          The object version number
35 --						   of the type created.
36 --
37 -- Post Failure:
38 --     Alias type will not be created and raise an application error.
39 --
40 -- Access Status:
41 --   Public.
42 --
43 -- {End Of Comments}
44 --
45 procedure create_alias_types
46   (p_validate                      in     boolean  default false,
47    p_alias_type                    in     varchar2,
48    p_reference_object              in     varchar2,
49    p_alias_type_id                 out nocopy    number,
50    p_object_version_number         out nocopy    number
51   );
52 --
53 
54 -- ----------------------------------------------------------------------------
55 -- |--------------------------< update_alias_types >--------------------------|
56 -- ----------------------------------------------------------------------------
57 -- {Start Of Comments}
58 --
59 -- Description:
60 --
61 --	Updates Alternate name type.
62 --
63 -- Prerequisites:
64 --
65 --
66 -- In Parameters:
67 --   Name                           Reqd Type     Description
68 --
69 --  p_validate                      No   boolean  Creates new alias_type if
70 --						  the value is true.
71 --  p_alias_type_id                  Yes  Number    Identifies the alias type.
72 --  p_alias_type		    Yes  varchar2 Indicates the Alias Type
73 --						  i.e either 'Static' or
74 --						  'Dynamic'.
75 --  p_reference_object              Yes  varchar2  Indicates the reference
76 --						   object on which the type
77 --						   is based.
78 
79 --
80 -- Post Success:
81 --   When the alias type is updated properly the following parameters are set.
82 --
83 -- Out Parameters:
84 --     Name                         Type            Description
85 --  p_object_version_number        number          The object version number
86 --						   of the alias type updated.
87 --
88 --
89 -- Post Failure:
90 --     Alias type will not be updated and raise an application error.
91 --
92 -- Access Status:
93 --   Public.
94 --
95 -- {End Of Comments}
96 --
97 procedure update_alias_types
98   (p_validate                      in     boolean  default false,
99    p_alias_type                    in     varchar2,
100    p_reference_object              in     varchar2,
101    p_alias_type_id                 in     number,
102    p_object_version_number         in out nocopy    number
103   );
104 --
105 
106 -- ----------------------------------------------------------------------------
107 -- |--------------------------< delete_alias_types >--------------------------|
108 -- ----------------------------------------------------------------------------
109 -- {Start Of Comments}
110 --
111 -- Description:
112 --
113 --	Deletes Alternate name type.
114 --
115 -- Prerequisites:
116 --
117 --
118 -- In Parameters:
119 --   Name                           Reqd Type     Description
120 --
121 --   p_validate                     No   boolean  If TRUE then the database
122 --                                                remains unchanged. If FALSE
123 --                                                then the alias type
124 --                                                is deleted. Default is FALSE.
125 --  p_alias_type_id                 Yes  Number    Identifies the alias type.
126 --  p_object_version_number         Yes  Number    The object version number
127 --						   of the alias type to be
128 --						   deleted.
129 
130 -- Post Success:
131 --   When the alias type is updated properly the following parameters are set.
132 --
133 --     Name                         Type            Description
134 --
135 --
136 -- Post Failure:
137 --     Alias type will not be deleted and raise an application error.
138 --
139 -- Access Status:
140 --   Public.
141 --
142 -- {End Of Comments}
143 --
144 procedure delete_alias_types
145   (p_validate                      in     boolean  default false,
146    p_alias_type_id                 in     number,
147    p_object_version_number         in     number
148   );
149 --
150 end hxc_alias_types_api;