1 Package ben_cwb_matrix_dtl_api as
2 /* $Header: bebcdapi.pkh 120.0.12010000.1 2008/07/29 10:53:17 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_cwb_matrix_dtl >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate No boolean Commit or Rollback.
18 -- p_business_group_id Yes number Business Group of Record
19 -- p_cwb_matrix_id Yes number Matrix Id of the Master table
20 -- p_row_crit_val Yes varchar2 Row Criterion Code
21 -- p_col_crit_val No varchar2 Column Criterion Code
22 -- p_pct_emp_cndr No number Percent of Employees Considered
23 -- p_pct_val No number Percent of Eligible Salary
24 -- p_emp_amt No number Per Employee Amount
25 --
26 --
27 -- Post Success:
28 --
29 -- Out Parameters:
30 -- Name Type Description
31 -- p_cwb_matrix_dtl_id number PK of record
32 -- p_object_version_number number OVN of record
33 --
34 --
35 -- Post Failure:
36 --
37 --
38 -- Access Status:
39 -- Public.
40 --
41 -- {End Of Comments}
42 --
43 procedure create_cwb_matrix_dtl
44 (p_validate in boolean default false
45 ,p_business_group_id in number
46 ,p_cwb_matrix_id in number
47 ,p_row_crit_val in varchar2
48 ,p_col_crit_val in varchar2 default null
49 ,p_pct_emp_cndr in number default null
50 ,p_pct_val in number default null
51 ,p_emp_amt in number default null
52 ,p_cwb_matrix_dtl_id out nocopy number
53 ,p_object_version_number out nocopy number
54 );
55 --
56 --
57 -- ----------------------------------------------------------------------------
58 -- |--------------------------< update_cwb_matrix_dtl >------------------------|
59 -- ----------------------------------------------------------------------------
60 -- {Start Of Comments}
61 --
62 -- Description:
63 --
64 --
65 -- Prerequisites:
66 --
67 --
68 -- In Parameters:
69 -- Name Reqd Type Description
70 -- p_validate No boolean Commit or Rollback.
71 -- p_business_group_id Yes number Business Group of Record
72 -- p_cwb_matrix_dtl_id Yes number PK of record
73 -- p_cwb_matrix_id Yes number Matrix Id of the Master table
74 -- p_row_crit_val Yes varchar2 Row Criterion Code
75 -- p_col_crit_val No varchar2 Column Criterion Code
76 -- p_pct_emp_cndr No number Percent of Employees Considered
77 -- p_pct_val No number Percent of Eligible Salary
78 -- p_emp_amt No number Per Employee Amount
79 --
80 -- Post Success:
81 --
82 -- Out Parameters:
83 -- Name Type Description
84 -- p_object_version_number number OVN of record
85 --
86 --
87 -- Post Failure:
88 --
89 --
90 -- Access Status:
91 -- Public.
92 --
93 -- {End Of Comments}
94 --
95 procedure update_cwb_matrix_dtl
96 (p_validate in boolean default false
97 ,p_cwb_matrix_dtl_id in number
98 ,p_cwb_matrix_id in number default hr_api.g_number
99 ,p_business_group_id in number default hr_api.g_number
100 ,p_row_crit_val in varchar2 default hr_api.g_varchar2
101 ,p_col_crit_val in varchar2 default hr_api.g_varchar2
102 ,p_pct_emp_cndr in number default hr_api.g_number
103 ,p_pct_val in number default hr_api.g_number
104 ,p_emp_amt in number default hr_api.g_number
105 ,p_object_version_number in out nocopy number
106 );
107 --
108 --
109 -- ----------------------------------------------------------------------------
110 -- |--------------------------< delete_cwb_matrix_dtl >------------------------|
111 -- ----------------------------------------------------------------------------
112 -- {Start Of Comments}
113 --
114 -- Description:
115 --
116 --
117 -- Prerequisites:
118 --
119 --
120 -- In Parameters:
121 -- Name Reqd Type Description
122 -- p_validate Yes boolean Commit or Rollback.
123 -- p_cwb_matrix_dtl_id Yes number PK of record
124 --
125 -- Post Success:
126 --
127 -- Out Parameters:
128 -- Name Type Description
129 -- p_object_version_number number OVN of record
130 --
131 --
132 -- Post Failure:
133 --
134 --
135 -- Access Status:
136 -- Public.
137 --
138 -- {End Of Comments}
139 --
140 procedure delete_cwb_matrix_dtl
141 (p_validate in boolean default false
142 ,p_cwb_matrix_dtl_id in number
143 ,p_object_version_number in out nocopy number
144 );
145 --
146 --
147 -- ----------------------------------------------------------------------------
148 -- |-----------------------------------< lck >---------------------------------|
149 -- ----------------------------------------------------------------------------
150 -- {Start Of Comments}
151 --
152 -- Description:
153 --
154 --
155 -- Prerequisites:
156 --
157 --
158 -- In Parameters:
159 -- Name Reqd Type Description
160 -- p_cwb_matrix_dtl_id Yes number PK of record
161 -- p_object_version_number Yes number OVN of record
162 --
163 -- Post Success:
164 --
165 --
166 -- Post Failure:
167 --
168 --
169 -- Access Status:
170 -- Public.
171 --
172 -- {End Of Comments}
173 --
174 procedure lck
175 (p_cwb_matrix_dtl_id in number
176 ,p_object_version_number in number
177 );
178 --
179 end ben_cwb_matrix_dtl_api;