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