APPS.PFT_PROFCAL_PROSP_IDENT_PUB dependencies on FEM_MP_PROCESS_CTL_T

Line 162: fem_mp_process_ctl_t.message%TYPE;

158: l_user_id NUMBER := FND_GLOBAL.User_Id;
159: l_login_id NUMBER := FND_GLOBAL.Login_Id;
160:
161: TYPE v_msg_list_type IS VARRAY(20) OF
162: fem_mp_process_ctl_t.message%TYPE;
163: v_msg_list v_msg_list_type;
164:
165: e_process_single_rule_error EXCEPTION;
166: e_register_rule_error EXCEPTION;

Line 288: FROM fem_mp_process_ctl_t

284: v_msg_list := v_msg_list_type();
285:
286: SELECT DISTINCT(message)
287: BULK COLLECT INTO v_msg_list
288: FROM fem_mp_process_ctl_t
289: WHERE req_id = l_request_id
290: AND status = 2;
291:
292: FEM_ENGINES_PKG.Tech_Message(p_severity => g_log_level_1

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

564: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
565: ,p_module => G_BLOCK||'.'||l_api_name
566: ,p_msg_text => 'BEGIN');
567:
568: --Query the fem_mp_process_ctl_t table to get the number of rows
569: --processed per request
570: SELECT NVL(SUM(rows_processed),0),
571: NVL(SUM(rows_rejected),0),
572: NVL(SUM(rows_loaded),0)

Line 576: FROM fem_mp_process_ctl_t t

572: NVL(SUM(rows_loaded),0)
573: INTO x_rows_processed,
574: x_rows_rejected,
575: x_rows_loaded
576: FROM fem_mp_process_ctl_t t
577: WHERE t.req_id = p_request_id
578: AND t.process_num > 0;
579:
580: IF (x_rows_processed = 0) THEN

Line 651: -- query table fem_mp_process_ctl_t to get the number of rows processed

647: ,p_exe_step => 'PROSP_IDENT'
648: ,p_exe_status_code => p_exe_status_code );
649:
650: IF (p_exe_status_code = g_exec_status_success) THEN
651: -- query table fem_mp_process_ctl_t to get the number of rows processed
652: Get_Nbr_RowsTable_Request(x_rows_processed => l_nbr_output_rows,
653: x_rows_loaded => l_nbr_loaded_rows,
654: x_rows_rejected => l_nbr_rejected_rows,
655: p_request_id => p_request_id);