APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_MP_PROCESS_CTL_T

Line 188: fem_mp_process_ctl_t.message%TYPE;

184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
188: fem_mp_process_ctl_t.message%TYPE;
189: v_msg_list v_msg_list_type;
190:
191: e_process_single_rule_error EXCEPTION;
192: e_register_rule_error EXCEPTION;

Line 726: --Query the fem_mp_process_ctl_t table to get the number of rows

722: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
723: ,p_module => G_BLOCK||'.'||l_api_name
724: ,p_msg_text => 'BEGIN');
725:
726: --Query the fem_mp_process_ctl_t table to get the number of rows
727: --processed per request
728: SELECT NVL(SUM(rows_processed),0),
729: NVL(SUM(rows_rejected),0),
730: NVL(SUM(rows_loaded),0)

Line 734: FROM fem_mp_process_ctl_t t

730: NVL(SUM(rows_loaded),0)
731: INTO x_rows_processed,
732: x_rows_rejected,
733: x_rows_loaded
734: FROM fem_mp_process_ctl_t t
735: WHERE t.req_id = p_request_id
736: AND t.process_num > 0;
737:
738: IF (x_rows_processed = 0) THEN

Line 805: /* -- query table fem_mp_process_ctl_t to get the number of rows processed

801: ,p_exe_step => 'RGN_CNT'
802: ,p_exe_status_code => p_exe_status_code );
803:
804: IF (p_exe_status_code = g_exec_status_success) THEN
805: /* -- query table fem_mp_process_ctl_t to get the number of rows processed
806: Get_Nbr_RowsTable_Request(x_rows_processed => l_nbr_output_rows,
807: x_rows_loaded => l_nbr_loaded_rows,
808: x_rows_rejected => l_nbr_rejected_rows,
809: p_request_id => p_request_id);*/