1 Package ben_EXT_ELMT_IN_RCD_api as
2 /* $Header: bexerapi.pkh 120.0 2005/05/28 12:32:06 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_EXT_ELMT_IN_RCD >------------------------|
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_seq_num No number
18 -- p_strt_pos No number
19 -- p_dlmtr_val No varchar2
20 -- p_rqd_flag Yes varchar2
21 -- p_sprs_cd No varchar2
22 -- p_any_or_all_cd No varchar2
23 -- p_ext_data_elmt_id Yes number
24 -- p_ext_rcd_id Yes number
25 -- p_business_group_id Yes number Business Group of Record
26 -- p_legislation_code No varchar2
27 -- p_hide_flag Yes varchar2
28 -- p_effective_date Yes date Session Date.
29 --
30 -- Post Success:
31 --
32 -- Out Parameters:
33 -- Name Type Description
34 -- p_ext_data_elmt_in_rcd_id Yes number PK of record
35 -- p_object_version_number No number OVN of record
36 --
37 -- Post Failure:
38 --
39 -- Access Status:
40 -- Public.
41 --
42 -- {End Of Comments}
43 --
44 procedure create_EXT_ELMT_IN_RCD
45 (
46 p_validate in boolean default false
47 ,p_ext_data_elmt_in_rcd_id out nocopy number
48 ,p_seq_num in number default null
49 ,p_strt_pos in number default null
50 ,p_dlmtr_val in varchar2 default null
51 ,p_rqd_flag in varchar2 default 'N'
52 ,p_sprs_cd in varchar2 default null
53 ,p_any_or_all_cd in varchar2 default null
54 ,p_ext_data_elmt_id in number default null
55 ,p_ext_rcd_id in number default null
56 ,p_business_group_id in number default null
57 ,p_legislation_code in varchar2 default null
58 ,p_object_version_number out nocopy number
59 ,p_hide_flag in varchar2 default 'N'
60 ,p_effective_date in date
61 );
62 -- ----------------------------------------------------------------------------
63 -- |------------------------< update_EXT_ELMT_IN_RCD >------------------------|
64 -- ----------------------------------------------------------------------------
65 -- {Start Of Comments}
66 --
67 -- Description:
68 --
69 -- Prerequisites:
70 --
71 --
72 -- In Parameters:
73 -- Name Reqd Type Description
74 -- p_validate Yes boolean Commit or Rollback.
75 -- p_ext_data_elmt_in_rcd_id Yes number PK of record
76 -- p_seq_num No number
77 -- p_strt_pos No number
78 -- p_dlmtr_val No varchar2
79 -- p_rqd_flag Yes varchar2
80 -- p_sprs_cd No varchar2
81 -- p_any_or_all_cd No varchar2
82 -- p_ext_data_elmt_id Yes number
83 -- p_ext_rcd_id Yes number
84 -- p_business_group_id Yes number Business Group of Record
85 -- p_legislation_code No varchar2
86 -- p_hide_flag Yes varchar2
87 -- p_effective_date Yes date Session Date.
88 --
89 -- Post Success:
90 --
91 -- Name Type Description
92 -- p_object_version_number No number OVN of record
93 --
94 -- Post Failure:
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure update_EXT_ELMT_IN_RCD
102 (
103 p_validate in boolean default false
104 ,p_ext_data_elmt_in_rcd_id in number
105 ,p_seq_num in number default hr_api.g_number
106 ,p_strt_pos in number default hr_api.g_number
107 ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
108 ,p_rqd_flag in varchar2 default hr_api.g_varchar2
109 ,p_sprs_cd in varchar2 default hr_api.g_varchar2
110 ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
111 ,p_ext_data_elmt_id in number default hr_api.g_number
112 ,p_ext_rcd_id in number default hr_api.g_number
113 ,p_business_group_id in number default hr_api.g_number
114 ,p_legislation_code in varchar2 default hr_api.g_varchar2
115 ,p_object_version_number in out nocopy number
116 ,p_hide_flag in varchar2 default hr_api.g_varchar2
117 ,p_effective_date in date
118 );
119 --
120 -- ----------------------------------------------------------------------------
121 -- |------------------------< delete_EXT_ELMT_IN_RCD >------------------------|
122 -- ----------------------------------------------------------------------------
123 -- {Start Of Comments}
124 --
125 -- Description:
126 --
127 -- Prerequisites:
128 --
129 --
130 -- In Parameters:
131 -- Name Reqd Type Description
132 -- p_validate Yes boolean Commit or Rollback.
133 -- p_legislation_code No varchar2
134 -- p_ext_data_elmt_in_rcd_id Yes number PK of record
135 -- p_effective_date Yes date Session Date.
136 --
137 -- Post Success:
138 --
139 -- Name Type Description
140 -- p_object_version_number No number OVN of record
141 --
142 -- Post Failure:
143 --
144 -- Access Status:
145 -- Public.
146 --
147 -- {End Of Comments}
148 --
149 procedure delete_EXT_ELMT_IN_RCD
150 (
151 p_validate in boolean default false
152 ,p_ext_data_elmt_in_rcd_id in number
153 ,p_legislation_code in varchar2 default null
157 --
154 ,p_object_version_number in out nocopy number
155 ,p_effective_date in date
156 );
158 -- ----------------------------------------------------------------------------
159 -- |----------------------------------< lck >---------------------------------|
160 -- ----------------------------------------------------------------------------
161 -- {Start Of Comments}
162 --
163 -- Description:
164 --
165 -- Prerequisites:
166 --
167 --
168 -- In Parameters:
169 -- Name Reqd Type Description
170 -- p_ext_data_elmt_in_rcd_id Yes number PK of record
171 -- p_object_version_number Yes number OVN of record
172 --
173 -- Post Success:
174 --
175 -- Name Type Description
176 --
177 -- Post Failure:
178 --
179 -- Access Status:
180 -- Public.
181 --
182 -- {End Of Comments}
183 --
184 procedure lck
185 (
186 p_ext_data_elmt_in_rcd_id in number
187 ,p_object_version_number in number
188 );
189 --
190 end ben_EXT_ELMT_IN_RCD_api;