DBA Data[Home] [Help]

APPS.PFT_PROFCAL_VALIDX_PUB dependencies on FEM_MULTI_PROC_PKG

Line 768: FEM_MULTI_PROC_PKG.Master(

764: ,p_module => G_BLOCK||'.'||l_api_name
765: ,p_msg_text => 'Submitting Region Count SQL to MP Master.p_eng_sql: '
766: ||l_rgn_cnt_sql);
767:
768: FEM_MULTI_PROC_PKG.Master(
769: p_rule_id => p_rule_obj_id
770: ,p_eng_step => 'VAL_IDX'
771: ,p_eng_sql => l_rgn_cnt_sql
772: ,p_data_table => l_process_table

Line 838: FEM_MULTI_PROC_PKG.Delete_Data_Slices (

834: -- commit the work
835: COMMIT;
836:
837: -- Purge Data Slices
838: FEM_MULTI_PROC_PKG.Delete_Data_Slices (
839: p_req_id => l_request_id);
840:
841: END IF;
842: END IF;

Line 898: FEM_MULTI_PROC_PKG.Master(

894: ,p_module => G_BLOCK||'.'||l_api_name
895: ,p_msg_text => 'Submitting Percentile SQL to MP Master.p_eng_sql: '
896: ||l_prof_ptile_sql);
897:
898: FEM_MULTI_PROC_PKG.Master(
899: p_rule_id => p_rule_obj_id
900: ,p_eng_step => 'VAL_IDX'
901: ,p_eng_sql => l_prof_ptile_sql
902: ,p_data_table => l_process_table

Line 967: FEM_MULTI_PROC_PKG.Delete_Data_Slices (

963: -- commit the work
964: COMMIT;
965:
966: -- Purge Data Slices
967: FEM_MULTI_PROC_PKG.Delete_Data_Slices (
968: p_req_id => l_request_id);
969:
970: END IF;
971: END IF;

Line 1043: FEM_MULTI_PROC_PKG.Master(

1039: ,p_module => G_BLOCK||'.'||l_api_name
1040: ,p_msg_text => 'Submitting Region Count SQL to MP Master.p_eng_sql: '
1041: ||l_prod_cd_sql);
1042:
1043: FEM_MULTI_PROC_PKG.Master(
1044: p_rule_id => p_rule_obj_id
1045: ,p_eng_step => 'VAL_IDX'
1046: ,p_eng_sql => l_prod_cd_sql
1047: ,p_data_table => l_process_table

Line 1112: FEM_MULTI_PROC_PKG.Delete_Data_Slices (

1108: -- commit the work
1109: COMMIT;
1110:
1111: -- Purge Data Slices
1112: FEM_MULTI_PROC_PKG.Delete_Data_Slices (
1113: p_req_id => l_request_id);
1114:
1115: END IF;
1116: END IF;