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