DBA Data[Home] [Help]

APPS.PQH_RT_MATRIX_NODE_VALUES_API dependencies on HR_API

Line 81: when hr_api.cannot_find_prog_unit then

77: ,p_BUSINESS_GROUP_ID => p_business_group_id
78: ,p_LEGISLATION_CODE => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_rt_matrix_node_value'
84: ,p_hook_type => 'BP'
85: );

Line 82: hr_api.cannot_find_prog_unit_error

78: ,p_LEGISLATION_CODE => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_rt_matrix_node_value'
84: ,p_hook_type => 'BP'
85: );
86: end;

Line 144: when hr_api.cannot_find_prog_unit then

140: ,p_LEGISLATION_CODE => p_legislation_code
141: ,p_object_version_number => l_object_version_number
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'create_rt_matrix_node_value'
147: ,p_hook_type => 'AP'
148: );

Line 145: hr_api.cannot_find_prog_unit_error

141: ,p_object_version_number => l_object_version_number
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'create_rt_matrix_node_value'
147: ,p_hook_type => 'AP'
148: );
149: end;

Line 154: raise hr_api.validate_enabled;

150: --
151: -- When in validation only mode raise the Validate_Enabled exception
152: --
153: if p_validate then
154: raise hr_api.validate_enabled;
155: end if;
156: --
157: -- Set all IN OUT and OUT parameters with out values
158: --

Line 164: when hr_api.validate_enabled then

160: p_object_version_number := l_object_version_number;
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 70);
163: exception
164: when hr_api.validate_enabled then
165: --
166: -- As the Validate_Enabled exception has been raised
167: -- we must rollback to the savepoint
168: --

Line 205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2

201: ,p_effective_date in date
202: ,p_NODE_VALUE_ID in number
203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number

Line 206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2

202: ,p_NODE_VALUE_ID in number
203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number

Line 207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2

203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number

Line 208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2

204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number

Line 209: ,p_NUMBER_VALUE1 in number default hr_api.g_number

205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date

Line 210: ,p_NUMBER_VALUE2 in number default hr_api.g_number

206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date

Line 211: ,p_NUMBER_VALUE3 in number default hr_api.g_number

207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date

Line 212: ,p_NUMBER_VALUE4 in number default hr_api.g_number

208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date

Line 213: ,p_DATE_VALUE1 in date default hr_api.g_date

209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number

Line 214: ,p_DATE_VALUE2 in date default hr_api.g_date

210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2

Line 215: ,p_DATE_VALUE3 in date default hr_api.g_date

211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number

Line 216: ,p_DATE_VALUE4 in date default hr_api.g_date

212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )

Line 217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number

213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )
221: is

Line 218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2

214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )
221: is
222: --

Line 271: when hr_api.cannot_find_prog_unit then

267: ,p_object_version_number => l_object_version_number
268: );
269:
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'update_rt_matrix_node_value'
274: ,p_hook_type => 'BP'
275: );

Line 272: hr_api.cannot_find_prog_unit_error

268: );
269:
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'update_rt_matrix_node_value'
274: ,p_hook_type => 'BP'
275: );
276: end;

Line 334: when hr_api.cannot_find_prog_unit then

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

Line 335: hr_api.cannot_find_prog_unit_error

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

Line 344: raise hr_api.validate_enabled;

340: --
341: -- When in validation only mode raise the Validate_Enabled exception
342: --
343: if p_validate then
344: raise hr_api.validate_enabled;
345: end if;
346: --
347: -- Set all IN OUT and OUT parameters with out values
348: --

Line 353: when hr_api.validate_enabled then

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

Line 422: when hr_api.cannot_find_prog_unit then

418: ,p_object_version_number => p_object_version_number
419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_rt_matrix_node_value'
425: ,p_hook_type => 'BP'
426: );

Line 423: hr_api.cannot_find_prog_unit_error

419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_rt_matrix_node_value'
425: ,p_hook_type => 'BP'
426: );
427: end;

Line 454: when hr_api.cannot_find_prog_unit then

450: ,p_object_version_number => p_object_version_number
451: );
452:
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'delete_rt_matrix_node_value'
457: ,p_hook_type => 'AP'
458: );

Line 455: hr_api.cannot_find_prog_unit_error

451: );
452:
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'delete_rt_matrix_node_value'
457: ,p_hook_type => 'AP'
458: );
459: end;

Line 464: raise hr_api.validate_enabled;

460: --
461: -- When in validation only mode raise the Validate_Enabled exception
462: --
463: if p_validate then
464: raise hr_api.validate_enabled;
465: end if;
466: --
467: -- Set all IN OUT and OUT parameters with out values
468: --

Line 472: when hr_api.validate_enabled then

468: --
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: exception
472: when hr_api.validate_enabled then
473: --
474: -- As the Validate_Enabled exception has been raised
475: -- we must rollback to the savepoint
476: --