DBA Data[Home] [Help]

APPS.FEM_UD_PKG dependencies on FEM_MULTI_PROC_PKG

Line 3634: fem_multi_proc_pkg.master(

3630: v_mp_stmt_id := atbl.table_name||'_DELETE_'||v_count_tbls;
3631:
3632: -- submit statement to MP engine.
3633: -- EXECUTE IMMEDIATE v_sql_stmt||' '||v_where_clause; (pre MP testing)
3634: fem_multi_proc_pkg.master(
3635: x_prg_stat => v_mp_prg_stat,
3636: x_exception_code => v_mp_exception_code,
3637: p_rule_id => v_undo_list_obj_id,
3638: p_eng_step => v_mp_step_name,

Line 3679: fem_multi_proc_pkg.delete_data_slices(

3675: p_value1 => v_rows_processed,
3676: p_token2 => 'TABLE_NAME',
3677: p_value2 => v_tab_name);
3678:
3679: fem_multi_proc_pkg.delete_data_slices(
3680: p_req_id => pv_request_id);
3681:
3682: ELSIF atbl.statement_type = 'UPDATE' AND
3683: atbl.undo_type IN ('ZERO_COLUMN_BY_PERIOD',

Line 3735: fem_multi_proc_pkg.master(

3731: v_mp_stmt_id := atbl.table_name||'_UPDATE_'||v_count_tbls;
3732:
3733: -- submit statement to MP engine.
3734: -- EXECUTE IMMEDIATE v_sql_stmt||' '||v_where_clause; (pre MP testing)
3735: fem_multi_proc_pkg.master(
3736: x_prg_stat => v_mp_prg_stat,
3737: x_exception_code => v_mp_exception_code,
3738: p_rule_id => v_undo_list_obj_id,
3739: p_eng_step => v_mp_step_name,

Line 3779: fem_multi_proc_pkg.delete_data_slices(

3775: p_value2 => v_tab_name);
3776:
3777: END IF;
3778:
3779: fem_multi_proc_pkg.delete_data_slices(
3780: p_req_id => pv_request_id);
3781:
3782: ELSIF atbl.statement_type = 'MERGE' THEN
3783: -- For Merge statements, do a DELETE and an UPDATE.

Line 3821: fem_multi_proc_pkg.master(

3817: v_mp_stmt_id := atbl.table_name||'_MERGE_DEL_'||v_count_tbls;
3818:
3819: -- submit statement to MP engine.
3820: -- EXECUTE IMMEDIATE v_sql_stmt||' '||v_where_clause; (pre MP testing)
3821: fem_multi_proc_pkg.master(
3822: x_prg_stat => v_mp_prg_stat,
3823: x_exception_code => v_mp_exception_code,
3824: p_rule_id => v_undo_list_obj_id,
3825: p_eng_step => v_mp_step_name,

Line 3863: fem_multi_proc_pkg.delete_data_slices(

3859: p_value1 => v_rows_processed,
3860: p_token2 => 'TABLE_NAME',
3861: p_value2 => v_tab_name);
3862:
3863: fem_multi_proc_pkg.delete_data_slices(
3864: p_req_id => pv_request_id);
3865:
3866:
3867: -------------------

Line 3918: fem_multi_proc_pkg.master(

3914: v_mp_stmt_id := atbl.table_name||'_MERGE_UPD_'||v_count_tbls;
3915:
3916: -- submit statement to MP engine.
3917: -- EXECUTE IMMEDIATE v_sql_stmt||' '||v_where_clause; (pre MP testing)
3918: fem_multi_proc_pkg.master(
3919: x_prg_stat => v_mp_prg_stat,
3920: x_exception_code => v_mp_exception_code,
3921: p_rule_id => v_undo_list_obj_id,
3922: p_eng_step => v_mp_step_name,

Line 3963: fem_multi_proc_pkg.delete_data_slices(

3959: p_value1 => v_rows_processed,
3960: p_token2 => 'TABLE_NAME',
3961: p_value2 => v_tab_name);
3962:
3963: fem_multi_proc_pkg.delete_data_slices(
3964: p_req_id => pv_request_id);
3965:
3966: END IF; -- v_count_cols = 0
3967: