APPS.FEM_XGL_POST_ENGINE_PKG dependencies on FEM_MP_PROCESS_CTL_T

Line 1830: fem_mp_process_ctl_t.message%TYPE;

1826: v_tot_prev_err_rows_reproc NUMBER;
1827: v_tot_posted_rows NUMBER;
1828:
1829: TYPE v_msg_list_type IS VARRAY(20) OF
1830: fem_mp_process_ctl_t.message%TYPE;
1831: v_msg_list v_msg_list_type;
1832: i NUMBER;
1833:
1834: v_compl_code NUMBER;

Line 2107: FROM fem_mp_process_ctl_t

2103: -- ---------------------------------------------------------------------
2104:
2105: SELECT SUM(rows_loaded), SUM(rows_processed), SUM(rows_rejected)
2106: INTO v_tot_posted_rows, v_tot_prev_err_rows_reproc, v_tot_cur_data_err_rows
2107: FROM fem_mp_process_ctl_t
2108: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id;
2109:
2110: FEM_ENGINES_PKG.Tech_Message
2111: (p_severity => pc_log_level_statement,

Line 2152: FROM fem_mp_process_ctl_t

2148: v_msg_list := v_msg_list_type();
2149:
2150: SELECT DISTINCT(message)
2151: BULK COLLECT INTO v_msg_list
2152: FROM fem_mp_process_ctl_t
2153: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id
2154: AND status = 2;
2155:
2156: FEM_ENGINES_PKG.Tech_Message

Line 2819: -- STATUS colum in FEM_MP_PROCESS_CTL_T.

2815: -- 05-25-04 G Hall Added v_compl_code in call to Get_Proc_Key_Info.
2816: -- Arguments
2817: -- x_slice_status_cd 0 = Successful; 1 = Warning; 2 = Failed. The
2818: -- subrequest will put this value into the
2819: -- STATUS colum in FEM_MP_PROCESS_CTL_T.
2820: -- x_slice_msg NULL if successful; end-user error message
2821: -- if failed with unexpected error. The
2822: -- subrequest will put this value into the
2823: -- MESSAGE colum in FEM_MP_PROCESS_CTL_T.

Line 2823: -- MESSAGE colum in FEM_MP_PROCESS_CTL_T.

2819: -- STATUS colum in FEM_MP_PROCESS_CTL_T.
2820: -- x_slice_msg NULL if successful; end-user error message
2821: -- if failed with unexpected error. The
2822: -- subrequest will put this value into the
2823: -- MESSAGE colum in FEM_MP_PROCESS_CTL_T.
2824: -- x_slice_errors_reprocessed For XGL, used for reporting the number of
2825: -- previous data errors successfully reprocessed.
2826: -- The subrequest will put this value into the
2827: -- ROWS_PROCESSED column in FEM_MP_PROCESS_CTL_T.

Line 2827: -- ROWS_PROCESSED column in FEM_MP_PROCESS_CTL_T.

2823: -- MESSAGE colum in FEM_MP_PROCESS_CTL_T.
2824: -- x_slice_errors_reprocessed For XGL, used for reporting the number of
2825: -- previous data errors successfully reprocessed.
2826: -- The subrequest will put this value into the
2827: -- ROWS_PROCESSED column in FEM_MP_PROCESS_CTL_T.
2828: -- x_slice_output_rows The number of rows inserted or merged into
2829: -- FEM_BALANCES for the current data slice. The
2830: -- subrequest will put this value into the
2831: -- ROWS_LOADED column in FEM_MP_PROCESS_CTL_T.

Line 2831: -- ROWS_LOADED column in FEM_MP_PROCESS_CTL_T.

2827: -- ROWS_PROCESSED column in FEM_MP_PROCESS_CTL_T.
2828: -- x_slice_output_rows The number of rows inserted or merged into
2829: -- FEM_BALANCES for the current data slice. The
2830: -- subrequest will put this value into the
2831: -- ROWS_LOADED column in FEM_MP_PROCESS_CTL_T.
2832: -- x_slice_errors_reported The total number of rows not loaded due to
2833: -- data errors (whether it's a new error or an
2834: -- old one still not successfully reprocessed).
2835: -- The subrequest will put this value into the

Line 2836: -- ROWS_REJECTED column in FEM_MP_PROCESS_CTL_T.

2832: -- x_slice_errors_reported The total number of rows not loaded due to
2833: -- data errors (whether it's a new error or an
2834: -- old one still not successfully reprocessed).
2835: -- The subrequest will put this value into the
2836: -- ROWS_REJECTED column in FEM_MP_PROCESS_CTL_T.
2837: -- p_eng_sql Engine SQL statement shell. From the P_ENG_SQL
2838: -- parameter passed to the MP Master. For XGL, it
2839: -- contains a table partitioning clause appropriate
2840: -- for the data slice (or will be NULL for no table