DBA Data[Home] [Help]

PACKAGE: APPS.BEN_EXT_ELMT_DECD_API

Source


1 Package ben_EXT_ELMT_DECD_api as
2 /* $Header: bexddapi.pkh 120.1 2005/06/08 13:09:11 tjesumic noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_EXT_ELMT_DECD >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 --   Name                           Reqd Type     Description
16 --   p_validate                     Yes  boolean  Commit or Rollback.
17 --   p_val                          No   varchar2
18 --   p_dcd_val                      No   varchar2
19 --   p_ext_data_elmt_id             Yes  number
20 --   p_business_group_id            Yes  number    Business Group of Record
21 --   p_legislation_code             No   varchar2
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 --   Name                                Type     Description
27 --   p_ext_data_elmt_decd_id        Yes  number    PK of record
28 --   p_object_version_number        No   number    OVN of record
29 --
30 -- Post Failure:
31 --
32 -- Access Status:
33 --   Public.
34 --
35 -- {End Of Comments}
36 --
37 procedure create_EXT_ELMT_DECD
38 (
39    p_validate                       in boolean    default false
40   ,p_ext_data_elmt_decd_id          out nocopy number
41   ,p_val                            in  varchar2  default null
42   ,p_dcd_val                        in  varchar2  default null
43   ,p_chg_evt_source                 in  varchar2  default null
44   ,p_ext_data_elmt_id               in  number    default null
45   ,p_business_group_id              in  number    default null
46   ,p_legislation_code               in  varchar2  default null
47   ,p_object_version_number          out nocopy number
48  );
49 -- ----------------------------------------------------------------------------
50 -- |------------------------< update_EXT_ELMT_DECD >------------------------|
51 -- ----------------------------------------------------------------------------
52 -- {Start Of Comments}
53 --
54 -- Description:
55 --
56 -- Prerequisites:
57 --
58 --
59 -- In Parameters:
60 --   Name                           Reqd Type     Description
61 --   p_validate                     Yes  boolean  Commit or Rollback.
62 --   p_ext_data_elmt_decd_id        Yes  number    PK of record
63 --   p_val                          No   varchar2
64 --   p_dcd_val                      No   varchar2
65 --   p_ext_data_elmt_id             Yes  number
66 --   p_business_group_id            Yes  number    Business Group of Record
67 --   p_legislation_code             No   varchar2
68 --
69 -- Post Success:
70 --
71 --   Name                           Type     Description
72 --   p_object_version_number        No   number    OVN of record
73 --
74 -- Post Failure:
75 --
76 -- Access Status:
77 --   Public.
78 --
79 -- {End Of Comments}
80 --
81 procedure update_EXT_ELMT_DECD
82   (
83    p_validate                       in boolean    default false
84   ,p_ext_data_elmt_decd_id          in  number
85   ,p_val                            in  varchar2  default hr_api.g_varchar2
86   ,p_dcd_val                        in  varchar2  default hr_api.g_varchar2
87   ,p_chg_evt_source                 in  varchar2  default hr_api.g_varchar2
88   ,p_ext_data_elmt_id               in  number    default hr_api.g_number
89   ,p_business_group_id              in  number    default hr_api.g_number
90   ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
91   ,p_object_version_number          in out nocopy number
92   );
93 --
94 -- ----------------------------------------------------------------------------
95 -- |------------------------< delete_EXT_ELMT_DECD >------------------------|
96 -- ----------------------------------------------------------------------------
97 -- {Start Of Comments}
98 --
99 -- Description:
100 --
101 -- Prerequisites:
102 --
103 --
104 -- In Parameters:
105 --   Name                           Reqd Type     Description
106 --   p_validate                     Yes  boolean  Commit or Rollback.
107 --   p_ext_data_elmt_decd_id        Yes  number    PK of record
108 --   p_legislation_code             No   varchar2
109 --
110 -- Post Success:
111 --
112 --   Name                           Type     Description
113 --   p_object_version_number        No   number    OVN of record
114 --
115 -- Post Failure:
116 --
117 -- Access Status:
118 --   Public.
119 --
120 -- {End Of Comments}
121 --
122 procedure delete_EXT_ELMT_DECD
123   (
124    p_validate                       in boolean        default false
125   ,p_ext_data_elmt_decd_id          in number
126   ,p_legislation_code               in varchar2 default null
127   ,p_object_version_number          in out nocopy number
128   );
129 --
130 -- ----------------------------------------------------------------------------
131 -- |----------------------------------< lck >---------------------------------|
132 -- ----------------------------------------------------------------------------
133 -- {Start Of Comments}
134 --
135 -- Description:
136 --
137 -- Prerequisites:
138 --
139 --
140 -- In Parameters:
141 --   Name                           Reqd Type     Description
142 --   p_ext_data_elmt_decd_id                 Yes  number   PK of record
143 --   p_object_version_number        Yes  number   OVN of record
144 --
145 -- Post Success:
146 --
147 --   Name                           Type     Description
148 --
149 -- Post Failure:
150 --
151 -- Access Status:
152 --   Public.
153 --
154 -- {End Of Comments}
155 --
156 procedure lck
157   (
158     p_ext_data_elmt_decd_id                 in number
159    ,p_object_version_number        in number
160   );
161 --
162 end ben_EXT_ELMT_DECD_api;