DBA Data[Home] [Help]

APPS.BEN_CWB_MATRIX_DTL_API dependencies on HR_API

Line 51: when hr_api.cannot_find_prog_unit then

47: ,p_pct_val => p_pct_val
48: ,p_emp_amt => p_emp_amt
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'create_cwb_matrix_dtl'
54: ,p_hook_type => 'BP'
55: );

Line 52: hr_api.cannot_find_prog_unit_error

48: ,p_emp_amt => p_emp_amt
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'create_cwb_matrix_dtl'
54: ,p_hook_type => 'BP'
55: );
56: end;

Line 88: when hr_api.cannot_find_prog_unit then

84: ,p_object_version_number => l_object_version_number
85: );
86:
87: exception
88: when hr_api.cannot_find_prog_unit then
89: hr_api.cannot_find_prog_unit_error
90: (p_module_name => 'create_cwb_matrix_dtl'
91: ,p_hook_type => 'AP'
92: );

Line 89: hr_api.cannot_find_prog_unit_error

85: );
86:
87: exception
88: when hr_api.cannot_find_prog_unit then
89: hr_api.cannot_find_prog_unit_error
90: (p_module_name => 'create_cwb_matrix_dtl'
91: ,p_hook_type => 'AP'
92: );
93: end;

Line 98: raise hr_api.validate_enabled;

94: --
95: -- When in validation only mode raise the Validate_Enabled exception
96: --
97: if p_validate then
98: raise hr_api.validate_enabled;
99: end if;
100: --
101: -- Set all output arguments
102: --

Line 109: when hr_api.validate_enabled then

105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: exception
109: when hr_api.validate_enabled then
110: --
111: -- As the Validate_Enabled exception has been raised
112: -- we must rollback to the savepoint
113: --

Line 142: ,p_cwb_matrix_id in number default hr_api.g_number

138: --
139: procedure update_cwb_matrix_dtl
140: (p_validate in boolean default false
141: ,p_cwb_matrix_dtl_id in number
142: ,p_cwb_matrix_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number

Line 143: ,p_business_group_id in number default hr_api.g_number

139: procedure update_cwb_matrix_dtl
140: (p_validate in boolean default false
141: ,p_cwb_matrix_dtl_id in number
142: ,p_cwb_matrix_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number

Line 144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2

140: (p_validate in boolean default false
141: ,p_cwb_matrix_dtl_id in number
142: ,p_cwb_matrix_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number
148: ,p_emp_amt in number default hr_api.g_number

Line 145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2

141: ,p_cwb_matrix_dtl_id in number
142: ,p_cwb_matrix_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number
148: ,p_emp_amt in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number

Line 146: ,p_pct_emp_cndr in number default hr_api.g_number

142: ,p_cwb_matrix_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number
148: ,p_emp_amt in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is

Line 147: ,p_pct_val in number default hr_api.g_number

143: ,p_business_group_id in number default hr_api.g_number
144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number
148: ,p_emp_amt in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --

Line 148: ,p_emp_amt in number default hr_api.g_number

144: ,p_row_crit_val in varchar2 default hr_api.g_varchar2
145: ,p_col_crit_val in varchar2 default hr_api.g_varchar2
146: ,p_pct_emp_cndr in number default hr_api.g_number
147: ,p_pct_val in number default hr_api.g_number
148: ,p_emp_amt in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --
152: -- Declare cursors and local variables

Line 186: when hr_api.cannot_find_prog_unit then

182: ,p_object_version_number => p_object_version_number
183: );
184:
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'update_cwb_matrix_dtl'
189: ,p_hook_type => 'BP'
190: );

Line 187: hr_api.cannot_find_prog_unit_error

183: );
184:
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'update_cwb_matrix_dtl'
189: ,p_hook_type => 'BP'
190: );
191: end;

Line 226: when hr_api.cannot_find_prog_unit then

222: ,p_object_version_number => l_object_version_number
223: );
224:
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'update_cwb_matrix_dtl'
229: ,p_hook_type => 'AP'
230: );

Line 227: hr_api.cannot_find_prog_unit_error

223: );
224:
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'update_cwb_matrix_dtl'
229: ,p_hook_type => 'AP'
230: );
231: --

Line 239: raise hr_api.validate_enabled;

235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all output arguments
243: --

Line 249: when hr_api.validate_enabled then

245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: --
248: exception
249: when hr_api.validate_enabled then
250: --
251: -- As the Validate_Enabled exception has been raised
252: -- we must rollback to the savepoint
253: --

Line 309: when hr_api.cannot_find_prog_unit then

305: ,p_object_version_number => p_object_version_number
306: );
307:
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'delete_cwb_matrix_dtl'
312: ,p_hook_type => 'BP'
313: );

Line 310: hr_api.cannot_find_prog_unit_error

306: );
307:
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'delete_cwb_matrix_dtl'
312: ,p_hook_type => 'BP'
313: );
314: end;

Line 335: when hr_api.cannot_find_prog_unit then

331: ,p_object_version_number => l_object_version_number
332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'delete_cwb_matrix_dtl'
338: ,p_hook_type => 'AP'
339: );

Line 336: hr_api.cannot_find_prog_unit_error

332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'delete_cwb_matrix_dtl'
338: ,p_hook_type => 'AP'
339: );
340: --

Line 348: raise hr_api.validate_enabled;

344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then
348: raise hr_api.validate_enabled;
349: end if;
350: --
351:
352:

Line 356: when hr_api.validate_enabled then

352:
353: hr_utility.set_location(' Leaving:'||l_proc, 70);
354: --
355: exception
356: when hr_api.validate_enabled then
357: --
358: -- As the Validate_Enabled exception has been raised
359: -- we must rollback to the savepoint
360: --