APPS.PFT_PROFCAL_VALIDX_PUB dependencies on FEM_MP_PROCESS_CTL_T

Line 241: fem_mp_process_ctl_t.message%TYPE;

237: TYPE chaining_cursor IS REF CURSOR;
238: l_cv_chains chaining_cursor;
239:
240: TYPE v_msg_list_type IS VARRAY(20) OF
241: fem_mp_process_ctl_t.message%TYPE;
242: v_msg_list v_msg_list_type;
243:
244: e_process_single_rule_error EXCEPTION;
245: e_register_rule_error EXCEPTION;

Line 787: FROM fem_mp_process_ctl_t

783: v_msg_list := v_msg_list_type();
784:
785: SELECT DISTINCT(message)
786: BULK COLLECT INTO v_msg_list
787: FROM fem_mp_process_ctl_t
788: WHERE req_id = l_request_id
789: AND status = 2;
790:
791: FEM_ENGINES_PKG.Tech_Message(

Line 917: FROM fem_mp_process_ctl_t

913: v_msg_list := v_msg_list_type();
914:
915: SELECT DISTINCT(message)
916: BULK COLLECT INTO v_msg_list
917: FROM fem_mp_process_ctl_t
918: WHERE req_id = l_request_id
919: AND status = 2;
920:
921: FEM_ENGINES_PKG.Tech_Message(

Line 1062: FROM fem_mp_process_ctl_t

1058: v_msg_list := v_msg_list_type();
1059:
1060: SELECT DISTINCT(message)
1061: BULK COLLECT INTO v_msg_list
1062: FROM fem_mp_process_ctl_t
1063: WHERE req_id = l_request_id
1064: AND status = 2;
1065:
1066: FEM_ENGINES_PKG.Tech_Message(

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

1352: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1353: ,p_module => G_BLOCK||'.'||l_api_name
1354: ,p_msg_text => 'BEGIN');
1355:
1356: --Query the fem_mp_process_ctl_t table to get the number of rows
1357: --processed per request
1358: SELECT NVL(SUM(rows_processed),0),
1359: NVL(SUM(rows_rejected),0),
1360: NVL(SUM(rows_loaded),0)

Line 1364: FROM fem_mp_process_ctl_t t

1360: NVL(SUM(rows_loaded),0)
1361: INTO x_rows_processed,
1362: x_rows_rejected,
1363: x_rows_loaded
1364: FROM fem_mp_process_ctl_t t
1365: WHERE t.req_id = p_request_id
1366: AND t.process_num > 0;
1367:
1368:

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

1439: ,p_exe_step => 'VAL_IDX'
1440: ,p_exe_status_code => p_exe_status_code );
1441:
1442: IF (p_exe_status_code = g_exec_status_success) THEN
1443: -- query table fem_mp_process_ctl_t to get the number of rows processed
1444: Get_Nbr_RowsTable_Request( x_rows_processed => l_nbr_output_rows,
1445: x_rows_loaded => l_nbr_loaded_rows,
1446: x_rows_rejected => l_nbr_rejected_rows,
1447: p_request_id => p_request_id);