eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_API

Line 251: raise hr_API.validate_enabled;

247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate = 1 then
251: raise hr_API.validate_enabled;
252: end if;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 70);
255: --

Line 258: when hr_API.validate_enabled then

254: hr_utility.set_location(' Leaving:'||l_proc, 70);
255: --
256: exception
257: --
258: when hr_API.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
261: -- we must rollback to the savepoint
262: --

Line 272: hr_utility.set_location(' hr_API.validate_enabled:'||l_proc, 80);

268: --
269: p_copy_entity_txn_id := null;
270: p_cea_object_version_number := null;
271: hr_utility.set_location(' Leaving:'||l_proc, 80);
272: hr_utility.set_location(' hr_API.validate_enabled:'||l_proc, 80);
273: --
274: when app_exception.application_exception then
275: p_copy_entity_txn_id := null;
276: p_cea_object_version_number := null;

Line 302: ,p_transaction_category_id in number default hr_API.g_number

298: --
299: procedure update_PLAN_DESIGN_TXN
300: (p_validate in number default 0 --boolean default false
301: ,p_copy_entity_txn_id in number
302: ,p_transaction_category_id in number default hr_API.g_number
303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2

Line 303: ,p_txn_category_attribute_id in number default hr_API.g_number

299: procedure update_PLAN_DESIGN_TXN
300: (p_validate in number default 0 --boolean default false
301: ,p_copy_entity_txn_id in number
302: ,p_transaction_category_id in number default hr_API.g_number
303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date

Line 304: ,p_context_business_group_id in number default hr_api.g_number

300: (p_validate in number default 0 --boolean default false
301: ,p_copy_entity_txn_id in number
302: ,p_transaction_category_id in number default hr_API.g_number
303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date

Line 305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2

301: ,p_copy_entity_txn_id in number
302: ,p_transaction_category_id in number default hr_API.g_number
303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number

Line 306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2

302: ,p_transaction_category_id in number default hr_API.g_number
303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2

Line 307: ,p_action_date in date default hr_API.g_date

303: ,p_txn_category_attribute_id in number default hr_API.g_number
304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2

Line 308: ,p_src_effective_date in date default hr_API.g_date

304: ,p_context_business_group_id in number default hr_api.g_number
305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2

Line 309: ,p_number_of_copies in number default hr_API.g_number

305: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number

Line 310: ,p_process_name in varchar2 default hr_API.g_varchar2

306: ,p_proc_typ_cd in varchar2 default hr_API.g_varchar2
307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number
314: ,p_status in varchar2 default hr_API.g_varchar2

Line 311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2

307: ,p_action_date in date default hr_API.g_date
308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number
314: ,p_status in varchar2 default hr_API.g_varchar2
315: ,p_cet_object_version_number in out nocopy number

Line 312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2

308: ,p_src_effective_date in date default hr_API.g_date
309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number
314: ,p_status in varchar2 default hr_API.g_varchar2
315: ,p_cet_object_version_number in out nocopy number
316: ,p_effective_date in date

Line 313: ,p_increment_by in number default hr_API.g_number

309: ,p_number_of_copies in number default hr_API.g_number
310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number
314: ,p_status in varchar2 default hr_API.g_varchar2
315: ,p_cet_object_version_number in out nocopy number
316: ,p_effective_date in date
317: ,p_copy_entity_attrib_id in number

Line 314: ,p_status in varchar2 default hr_API.g_varchar2

310: ,p_process_name in varchar2 default hr_API.g_varchar2
311: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
312: ,p_sfl_step_name in varchar2 default hr_API.g_varchar2
313: ,p_increment_by in number default hr_API.g_number
314: ,p_status in varchar2 default hr_API.g_varchar2
315: ,p_cet_object_version_number in out nocopy number
316: ,p_effective_date in date
317: ,p_copy_entity_attrib_id in number
318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2

Line 318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2

314: ,p_status in varchar2 default hr_API.g_varchar2
315: ,p_cet_object_version_number in out nocopy number
316: ,p_effective_date in date
317: ,p_copy_entity_attrib_id in number
318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2

Line 319: ,p_information_category in varchar2 default hr_api.g_varchar2

315: ,p_cet_object_version_number in out nocopy number
316: ,p_effective_date in date
317: ,p_copy_entity_attrib_id in number
318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2

Line 320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2

316: ,p_effective_date in date
317: ,p_copy_entity_attrib_id in number
318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2

Line 321: ,p_export_file_name in varchar2 default hr_api.g_varchar2

317: ,p_copy_entity_attrib_id in number
318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2

Line 322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2

318: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2

Line 323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2

319: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2

Line 324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2

320: ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2

Line 325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2

321: ,p_export_file_name in varchar2 default hr_api.g_varchar2
322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2

Line 326: ,p_search_value1 in varchar2 default hr_api.g_varchar2

322: ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2

Line 327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2

323: ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2

Line 328: ,p_search_value2 in varchar2 default hr_api.g_varchar2

324: ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2

325: ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 330: ,p_search_value3 in varchar2 default hr_api.g_varchar2

326: ,p_search_value1 in varchar2 default hr_api.g_varchar2
327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2

327: ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 332: ,p_information13 in varchar2 default hr_api.g_varchar2

328: ,p_search_value2 in varchar2 default hr_api.g_varchar2
329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 333: ,p_information14 in varchar2 default hr_api.g_varchar2

329: ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 334: ,p_information15 in varchar2 default hr_api.g_varchar2

330: ,p_search_value3 in varchar2 default hr_api.g_varchar2
331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 335: ,p_information16 in varchar2 default hr_api.g_varchar2

331: ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 336: ,p_information17 in varchar2 default hr_api.g_varchar2

332: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 337: ,p_information18 in varchar2 default hr_api.g_varchar2

333: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 338: ,p_information19 in varchar2 default hr_api.g_varchar2

334: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 339: ,p_information20 in varchar2 default hr_api.g_varchar2

335: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 340: ,p_information21 in varchar2 default hr_api.g_varchar2

336: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 341: ,p_information22 in varchar2 default hr_api.g_varchar2

337: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 342: ,p_information23 in varchar2 default hr_api.g_varchar2

338: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 343: ,p_information24 in varchar2 default hr_api.g_varchar2

339: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 344: ,p_information25 in varchar2 default hr_api.g_varchar2

340: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 345: ,p_information26 in varchar2 default hr_api.g_varchar2

341: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 346: ,p_information27 in varchar2 default hr_api.g_varchar2

342: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information30 in varchar2 default hr_api.g_varchar2
350: ,p_upd_record_type in varchar2 default null

Line 347: ,p_information28 in varchar2 default hr_api.g_varchar2

343: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information30 in varchar2 default hr_api.g_varchar2
350: ,p_upd_record_type in varchar2 default null
351: ,p_cea_object_version_number in out nocopy number

Line 348: ,p_information29 in varchar2 default hr_api.g_varchar2

344: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information30 in varchar2 default hr_api.g_varchar2
350: ,p_upd_record_type in varchar2 default null
351: ,p_cea_object_version_number in out nocopy number
352: ) is

Line 349: ,p_information30 in varchar2 default hr_api.g_varchar2

345: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information30 in varchar2 default hr_api.g_varchar2
350: ,p_upd_record_type in varchar2 default null
351: ,p_cea_object_version_number in out nocopy number
352: ) is
353: --

Line 414: if p_action_date <> hr_api.g_date and

410: -- because all of BEN delivered lookups start from 01-Jan-1951
411: --
412: l_ben_start_date := to_date('01-01-1951', 'DD-MM-YYYY');
413: --
414: if p_action_date <> hr_api.g_date and
415: p_action_date < l_ben_start_date
416: then
417: --
418: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK'

Line 574: raise hr_API.validate_enabled;

570: --
571: -- When in validation only mode raise the Validate_Enabled exception
572: --
573: if p_validate = 1 then -- check what is 0
574: raise hr_API.validate_enabled;
575: end if;
576: --
577: -- Set all output arguments
578: --

Line 586: when hr_API.validate_enabled then

582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: --
584: exception
585: --
586: when hr_API.validate_enabled then
587: --
588: -- As the Validate_Enabled exception has been raised
589: -- we must rollback to the savepoint
590: --

Line 702: ,p_datetrack_mode => hr_api.g_correction

698: -- Update the records in PQH_COPY_ENTITY_TXNS table with status as 'Purged'
699: --
700: PQH_COPY_ENTITY_TXNS_api.update_COPY_ENTITY_TXN
701: (p_validate => false
702: ,p_datetrack_mode => hr_api.g_correction
703: ,p_copy_entity_txn_id => p_copy_entity_txn_id
704: ,p_start_with => null
705: ,p_status => 'PURGED'
706: ,p_object_version_number => l_object_version_number

Line 717: raise hr_API.validate_enabled;

713: --
714: -- When in validation only mode raise the Validate_Enabled exception
715: --
716: if p_validate = 1 then
717: raise hr_API.validate_enabled;
718: end if;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: --

Line 724: when hr_API.validate_enabled then

720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: --
722: exception
723: --
724: when hr_API.validate_enabled then
725: --
726: -- As the Validate_Enabled exception has been raised
727: -- we must rollback to the savepoint
728: --

Line 955: ,p_business_group_id in number default hr_api.g_number

951: (
952: p_validate in number default 0 -- false
953: ,p_copy_entity_result_id in number
954: ,p_copy_entity_txn_id in number
955: ,p_business_group_id in number default hr_api.g_number
956: ,p_number_of_copies in number default hr_api.g_number
957: ,p_object_version_number in out nocopy number
958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 956: ,p_number_of_copies in number default hr_api.g_number

952: p_validate in number default 0 -- false
953: ,p_copy_entity_result_id in number
954: ,p_copy_entity_txn_id in number
955: ,p_business_group_id in number default hr_api.g_number
956: ,p_number_of_copies in number default hr_api.g_number
957: ,p_object_version_number in out nocopy number
958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 959: ,p_information1 in varchar2 default hr_api.g_varchar2

955: ,p_business_group_id in number default hr_api.g_number
956: ,p_number_of_copies in number default hr_api.g_number
957: ,p_object_version_number in out nocopy number
958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2

Line 960: ,p_information8 in varchar2 default hr_api.g_varchar2

956: ,p_number_of_copies in number default hr_api.g_number
957: ,p_object_version_number in out nocopy number
958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2

Line 961: ,p_information175 in varchar2 default hr_api.g_varchar2

957: ,p_object_version_number in out nocopy number
958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2

Line 962: ,p_information176 in varchar2 default hr_api.g_varchar2

958: ,p_effective_date in date
959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2

Line 963: ,p_information177 in varchar2 default hr_api.g_varchar2

959: ,p_information1 in varchar2 default hr_api.g_varchar2
960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2

Line 964: ,p_information178 in varchar2 default hr_api.g_varchar2

960: ,p_information8 in varchar2 default hr_api.g_varchar2
961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2
968: ,p_mirror_entity_result_id in number default hr_api.g_number

Line 965: ,p_information179 in varchar2 default hr_api.g_varchar2

961: ,p_information175 in varchar2 default hr_api.g_varchar2
962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2
968: ,p_mirror_entity_result_id in number default hr_api.g_number
969: ) is

Line 966: ,p_information180 in varchar2 default hr_api.g_varchar2

962: ,p_information176 in varchar2 default hr_api.g_varchar2
963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2
968: ,p_mirror_entity_result_id in number default hr_api.g_number
969: ) is
970: l_number_of_copies number(15);

Line 967: ,p_called_from in varchar2 default hr_api.g_varchar2

963: ,p_information177 in varchar2 default hr_api.g_varchar2
964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2
968: ,p_mirror_entity_result_id in number default hr_api.g_number
969: ) is
970: l_number_of_copies number(15);
971: l_proc varchar2(72) := g_package||'update_plan_design_result';

Line 968: ,p_mirror_entity_result_id in number default hr_api.g_number

964: ,p_information178 in varchar2 default hr_api.g_varchar2
965: ,p_information179 in varchar2 default hr_api.g_varchar2
966: ,p_information180 in varchar2 default hr_api.g_varchar2
967: ,p_called_from in varchar2 default hr_api.g_varchar2
968: ,p_mirror_entity_result_id in number default hr_api.g_number
969: ) is
970: l_number_of_copies number(15);
971: l_proc varchar2(72) := g_package||'update_plan_design_result';
972: l_copy_entity_result_id number(15);

Line 1259: ,p_target_business_group_id in number default hr_api.g_number

1255: ,p_copy_entity_txn_id in number
1256: ,p_table_route_id in number
1257: ,p_table_route_id2 in number
1258: ,p_legislation_code in varchar2
1259: ,p_target_business_group_id in number default hr_api.g_number
1260: ,p_effective_date in date default null
1261: ,p_effective_date_to_copy in date default null
1262: ) is
1263: l_proc varchar2(72) := g_package||'auto_mapping';

Line 2182: ,p_business_group_id in number default hr_api.g_number

2178: ,p_target_id1 in number
2179: ,p_source_id2 in number
2180: ,p_target_value2 in varchar2
2181: ,p_target_id2 in number
2182: ,p_business_group_id in number default hr_api.g_number
2183: ,p_effective_date in date default null
2184: ) is
2185: --
2186: cursor c_result_set(p_copy_entity_txn_id number, p_table_route_id number) is

Line 4988: ,p_datetrack_mode => hr_api.g_correction

4984: end if;
4985: --
4986: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
4987: (p_copy_entity_txn_id => p_copy_entity_txn_id
4988: ,p_datetrack_mode => hr_api.g_correction
4989: ,p_status => l_status
4990: ,p_start_with => NULL /* To disable Continue Icon */
4991: ,p_object_version_number => l_copy_entity_txn.cet_object_version_number
4992: ,p_effective_date => trunc(l_copy_entity_txn.effective_date)

Line 5114: raise hr_API.validate_enabled;

5110:
5111: -- When in validation only mode raise the Validate_Enabled exception
5112: --
5113: if p_validate = 1 then -- p_validate is true
5114: raise hr_API.validate_enabled;
5115: end if;
5116: --
5117: hr_utility.set_location(' Leaving:'||l_proc, 70);
5118: --

Line 5121: when hr_API.validate_enabled then

5117: hr_utility.set_location(' Leaving:'||l_proc, 70);
5118: --
5119: exception
5120: --
5121: when hr_API.validate_enabled then
5122: --
5123: -- As the Validate_Enabled exception has been raised
5124: -- we must rollback to the savepoint
5125: --

Line 5312: ,p_datetrack_mode => hr_api.g_correction

5308: --
5309: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
5310: (
5311: p_copy_entity_txn_id => p_copy_entity_txn_id
5312: ,p_datetrack_mode => hr_api.g_correction
5313: ,p_status => l_txn_status
5314: ,p_start_with => l_start_with
5315: ,p_object_version_number => l_ovn
5316: ,p_effective_date => l_effective_date