APPS.FEM_UD_PKG dependencies on FEM_PL_TEMP_OBJECTS

Line 598: FROM fem_pl_temp_objects

594:
595: -- This cursor retrieves all temporary objects created by the object execution.
596: CURSOR c3 IS
597: SELECT object_name, object_type
598: FROM fem_pl_temp_objects
599: WHERE request_id = p_request_id
600: AND object_id = p_object_id
601: ORDER BY object_type, object_name;
602:

Line 633: -- Drop objects listed in FEM_PL_TEMP_OBJECTS

629: WHERE object_id = p_object_id;
630:
631: -- ============================================================================
632: -- STEP 1:
633: -- Drop objects listed in FEM_PL_TEMP_OBJECTS
634: -- If an object is not found, a message is posted and the loop continues
635: -- to drop the remaining objects.
636: -- ============================================================================
637: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

Line 639: p_msg_text => 'STEP 1: Drop objects listed in FEM_PL_TEMP_OBJECTS.');

635: -- to drop the remaining objects.
636: -- ============================================================================
637: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
638: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
639: p_msg_text => 'STEP 1: Drop objects listed in FEM_PL_TEMP_OBJECTS.');
640:
641: FOR tmpobj IN c3 LOOP
642:
643: v_count_tmpobjs := c3%ROWCOUNT;

Line 691: DELETE fem_pl_temp_objects

687: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
688: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
689: p_msg_text => 'STEP 2: Delete object execution from process lock tables (FEM_PL_xxxx).');
690:
691: DELETE fem_pl_temp_objects
692: WHERE request_id = p_request_id
693: AND object_id = p_object_id;
694:
695: -- Bug 4382068: Only remove data edit locks if object is of type

Line 5757: DELETE fem_pl_temp_objects

5753:
5754:
5755: IF v_return_status = pc_ret_sts_success THEN
5756:
5757: DELETE fem_pl_temp_objects
5758: WHERE request_id = p_request_id;
5759:
5760: DELETE fem_pl_obj_exec_steps
5761: WHERE request_id = p_request_id;