DBA Data[Home] [Help]

APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_PL_TABLES

Line 550: -- Log Undo information in FEM_PL_TABLES for rows inserted or merged into

546: RAISE API_Error;
547:
548: END IF;
549:
550: -- Log Undo information in FEM_PL_TABLES for rows inserted or merged into
551: -- FEM_BALANCES.
552:
553: -- FEM-OGL Intg: Replace v_stmt_type by pv_stmt_type
554: IF pv_exec_mode = 'S' THEN

Line 769: v_statement_type fem_pl_tables.statement_type%TYPE;

765: v_return_status VARCHAR2(1);
766: v_msg_count NUMBER;
767: v_msg_data VARCHAR2(2000);
768:
769: v_statement_type fem_pl_tables.statement_type%TYPE;
770: v_src_sys_code fem_source_systems_b.source_system_code%TYPE;
771:
772: i PLS_INTEGER;
773: j PLS_INTEGER;

Line 784: -- by this execution, in the entry already posted in FEM_PL_TABLES.

780: 'final_process_logging.begin',
781: p_msg_text => 'BEGIN');
782:
783: -- Update the total number of rows inserted and/or updated in FEM_BALANCES
784: -- by this execution, in the entry already posted in FEM_PL_TABLES.
785:
786: IF pv_exec_mode = 'S' THEN
787: v_statement_type := 'INSERT';
788: ELSE

Line 7401: -- Update the number of output rows in FEM_PL_TABLES for this Request

7397: IF (v_req.num_of_rows_posted > 0 AND p_exec_status = 'SUCCESS')
7398: THEN
7399: -- Initialize the FND Message API
7400: FND_MSG_PUB.Initialize;
7401: -- Update the number of output rows in FEM_PL_TABLES for this Request
7402: FEM_PL_PKG.Update_Num_of_Output_Rows
7403: (P_API_VERSION => pc_API_version,
7404: P_COMMIT => 'T',
7405: P_REQUEST_ID => v_req.request_id,