DBA Data[Home] [Help]

APPS.BSC_UPDATE_BASE_V2 dependencies on BSC_AW_UTILITY

Line 51: h_job_status bsc_aw_utility.parallel_job_tb;

47:
48: h_parallel_jobs VARCHAR2(1);
49: h_job_name VARCHAR2(100);
50: h_process VARCHAR2(32000);
51: h_job_status bsc_aw_utility.parallel_job_tb;
52:
53: h_aw_flag_t VARCHAR2(15);
54: h_correction_flag_t VARCHAR2(15);
55:

Line 230: IF h_num_partitions > 1 AND bsc_aw_utility.can_launch_dbms_job(h_num_partitions) = 'Y' THEN

226: BSC_BIA_WRAPPER.Analyze_Table(x_input_table);
227: commit;
228: END IF;
229:
230: IF h_num_partitions > 1 AND bsc_aw_utility.can_launch_dbms_job(h_num_partitions) = 'Y' THEN
231: h_parallel_jobs := 'Y';
232: bsc_aw_utility.clean_up_jobs('all');
233: IF x_aw_flag THEN
234: h_aw_flag_t := 'TRUE';

Line 232: bsc_aw_utility.clean_up_jobs('all');

228: END IF;
229:
230: IF h_num_partitions > 1 AND bsc_aw_utility.can_launch_dbms_job(h_num_partitions) = 'Y' THEN
231: h_parallel_jobs := 'Y';
232: bsc_aw_utility.clean_up_jobs('all');
233: IF x_aw_flag THEN
234: h_aw_flag_t := 'TRUE';
235: ELSE
236: h_aw_flag_t := 'FALSE';

Line 264: bsc_aw_utility.start_job(h_job_name, h_j, h_process, null);

260: h_num_partitions||','||
261: h_num_loads||','||
262: ''''||h_job_name||''''||
263: ');';
264: bsc_aw_utility.start_job(h_job_name, h_j, h_process, null);
265: END LOOP;
266: bsc_aw_utility.wait_on_jobs(null, h_job_status);
267:
268: FOR h_j IN 1..h_job_status.count LOOP

Line 266: bsc_aw_utility.wait_on_jobs(null, h_job_status);

262: ''''||h_job_name||''''||
263: ');';
264: bsc_aw_utility.start_job(h_job_name, h_j, h_process, null);
265: END LOOP;
266: bsc_aw_utility.wait_on_jobs(null, h_job_status);
267:
268: FOR h_j IN 1..h_job_status.count LOOP
269: IF h_job_status(h_j).status = 'error' THEN
270: h_error_message := h_job_status(h_j).message;

Line 3617: bsc_aw_utility.send_pipe_message(x_job_name, 'status=success');

3613: IF h_return_status = 'error' THEN
3614: RAISE e_error_calc_base_table;
3615: END IF;
3616:
3617: bsc_aw_utility.send_pipe_message(x_job_name, 'status=success');
3618:
3619: EXCEPTION
3620: WHEN e_get_info_data_columns THEN
3621: rollback;

Line 3622: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_data_columns');

3618:
3619: EXCEPTION
3620: WHEN e_get_info_data_columns THEN
3621: rollback;
3622: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_data_columns');
3623:
3624: WHEN e_get_info_key_columns THEN
3625: rollback;
3626: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_key_columns');

Line 3626: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_key_columns');

3622: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_data_columns');
3623:
3624: WHEN e_get_info_key_columns THEN
3625: rollback;
3626: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_key_columns');
3627:
3628: WHEN e_error_calc_base_table THEN
3629: rollback;
3630: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||h_error_message);

Line 3630: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||h_error_message);

3626: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_get_info_key_columns');
3627:
3628: WHEN e_error_calc_base_table THEN
3629: rollback;
3630: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||h_error_message);
3631:
3632: WHEN e_unexpected_error THEN
3633: rollback;
3634: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_unexpected_error');

Line 3634: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_unexpected_error');

3630: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||h_error_message);
3631:
3632: WHEN e_unexpected_error THEN
3633: rollback;
3634: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_unexpected_error');
3635:
3636: WHEN OTHERS THEN
3637: rollback;
3638: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||SQLERRM);

Line 3638: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||SQLERRM);

3634: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message=e_unexpected_error');
3635:
3636: WHEN OTHERS THEN
3637: rollback;
3638: bsc_aw_utility.send_pipe_message(x_job_name, 'status=error,message='||SQLERRM);
3639:
3640: END Update_Base_Table_Job;
3641:
3642: