1 Package ben_cwb_matrix_api as
2 /* $Header: bebcmapi.pkh 120.0.12010000.1 2008/07/29 10:53:45 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_cwb_matrix >---------------------------|
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_effective_date No date Session Date
19 -- p_business_group_id Yes number Business Group of Record
20 -- p_name Yes varchar2 Name of the Matrix
21 -- p_person_id No number Person Id
22 -- p_sheet_type Yes varchar2 Sheet Type
23 -- p_plan_id No number Plan Id
24 -- p_row_crit_cd Yes varchar2 Row Criterion Code
25 -- p_col_crit_cd No varchar2 Column Criterion Code
26 --
27 -- Post Success:
28 --
29 -- Out Parameters:
30 -- Name Type Description
31 -- p_cwb_matrix_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
44 (p_validate in boolean default false
45 ,p_effective_date in date
46 ,p_business_group_id in number
47 ,p_name in varchar2
48 ,p_plan_id in number default null
49 ,p_matrix_typ_cd in varchar2 default null
50 ,p_person_id in number default null
51 ,p_row_crit_cd in varchar2
52 ,p_col_crit_cd in varchar2 default null
53 ,p_alct_by_cd in varchar2 default 'PCT'
54 ,p_cwb_matrix_id out nocopy number
55 ,p_object_version_number out nocopy number
56 );
57 --
58 --
59 -- ----------------------------------------------------------------------------
60 -- |--------------------------< update_cwb_matrix >--------------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start Of Comments}
63 --
64 -- Description:
65 --
66 --
67 -- Prerequisites:
68 --
69 --
70 -- In Parameters:
71 -- Name Reqd Type Description
72 -- p_validate No boolean Commit or Rollback.
73 -- p_cwb_matrix_id Yes number PK of record
74 -- p_effective_date No date Session Date
75 -- p_business_group_id Yes number Business Group of Record
76 -- p_name Yes varchar2 Name of the Matrix
77 -- p_person_id No number Person Id
78 -- p_matrix_typ_cd Yes varchar2 Sheet Type
79 -- p_plan_id No number Plan Id
80 -- p_row_crit_cd Yes varchar2 Row Criterion Code
81 -- p_col_crit_cd No varchar2 Column Criterion Code
82 --
83 -- Post Success:
84 --
85 -- Out Parameters:
86 -- Name Type Description
87 -- p_object_version_number number OVN of record
88 --
89 --
90 -- Post Failure:
91 --
92 --
93 -- Access Status:
94 -- Public.
95 --
96 -- {End Of Comments}
97 --
98 procedure update_cwb_matrix
99 (p_validate in boolean default false
100 ,p_cwb_matrix_id in number
101 ,p_effective_date in date
102 ,p_business_group_id in number default hr_api.g_number
103 ,p_name in varchar2 default hr_api.g_varchar2
104 ,p_plan_id in number default hr_api.g_number
105 ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
106 ,p_person_id in number default hr_api.g_number
107 ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
108 ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
109 ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
110 ,p_object_version_number in out nocopy number
111 );
112 --
113 --
114 -- ----------------------------------------------------------------------------
115 -- |--------------------------< delete_cwb_matrix >---------------------------|
116 -- ----------------------------------------------------------------------------
117 -- {Start Of Comments}
118 --
119 -- Description:
120 --
121 --
122 -- Prerequisites:
123 --
124 --
125 -- In Parameters:
126 -- Name Reqd Type Description
127 -- p_validate No boolean Commit or Rollback.
128 -- p_cwb_matrix_id Yes number PK of record
129 -- p_effective_date No date Session Date
130 --
131 -- Post Success:
132 --
133 -- Out Parameters:
134 -- Name Type Description
135 -- p_object_version_number number OVN of record
136 --
137 --
138 -- Post Failure:
139 --
140 --
141 -- Access Status:
142 -- Public.
143 --
144 -- {End Of Comments}
145 --
146 procedure delete_cwb_matrix
147 (p_validate in boolean default false
148 ,p_cwb_matrix_id in number
149 ,p_effective_date in date
150 ,p_object_version_number in out nocopy number
151 );
152 --
153 --
154 -- ----------------------------------------------------------------------------
155 -- |-----------------------------------< lck >---------------------------------|
156 -- ----------------------------------------------------------------------------
157 -- {Start Of Comments}
158 --
159 -- Description:
160 --
161 --
162 -- Prerequisites:
163 --
164 --
165 -- In Parameters:
166 -- Name Reqd Type Description
167 -- p_cwb_matrix_id Yes number PK of record
168 -- p_object_version_number Yes number OVN of record
169 -- p_effective_date No date Session Date
170 --
171 -- Post Success:
172 --
173 --
174 -- Post Failure:
175 --
176 --
177 -- Access Status:
178 -- Public.
179 --
180 -- {End Of Comments}
181 --
182 procedure lck
183 (p_cwb_matrix_id in number
184 ,p_effective_date in date
185 ,p_object_version_number in number
186 );
187 --
188 end ben_cwb_matrix_api;