APPS.PER_RI_CONFIG_UTILITIES dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 2585: l_exception_text hr_pump_batch_exceptions.exception_text%type;

2581: l_proc varchar2(72) := g_package || 'write_data_pump_exception_log';
2582: l_log_message varchar2(360);
2583: l_error_message varchar2(360);
2584:
2585: l_exception_text hr_pump_batch_exceptions.exception_text%type;
2586:
2587: cursor csr_dp_exception(cp_patch_header_id in number) IS
2588: select exception_text
2589: from hr_pump_batch_exceptions

Line 2589: from hr_pump_batch_exceptions

2585: l_exception_text hr_pump_batch_exceptions.exception_text%type;
2586:
2587: cursor csr_dp_exception(cp_patch_header_id in number) IS
2588: select exception_text
2589: from hr_pump_batch_exceptions
2590: where source_id in ( select batch_line_id
2591: from hr_pump_batch_lines
2592: where batch_id = cp_patch_header_id);
2593:

Line 2631: l_exception_text hr_pump_batch_exceptions.exception_text%type;

2627: l_proc varchar2(72) := g_package || 'check_data_pump_exception';
2628: l_log_message varchar2(360);
2629: l_error_message varchar2(360);
2630: l_exception boolean default FALSE;
2631: l_exception_text hr_pump_batch_exceptions.exception_text%type;
2632:
2633: cursor csr_dp_exception(cp_patch_header_id in number) IS
2634: select exception_text
2635: from hr_pump_batch_exceptions

Line 2635: from hr_pump_batch_exceptions

2631: l_exception_text hr_pump_batch_exceptions.exception_text%type;
2632:
2633: cursor csr_dp_exception(cp_patch_header_id in number) IS
2634: select exception_text
2635: from hr_pump_batch_exceptions
2636: where source_id in ( select batch_line_id
2637: from hr_pump_batch_lines
2638: where batch_id = cp_patch_header_id);
2639: BEGIN