APPS.FEM_UD_PKG dependencies on FEM_OBJECT_TYPES

Line 592: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

588:
589: c_api_name CONSTANT VARCHAR2(30) := 'delete_execution_log';
590: c_api_version CONSTANT NUMBER := 1.0;
591: v_count_tmpobjs NUMBER := 0;
592: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
593: v_pb_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
594:
595: -- This cursor retrieves all temporary objects created by the object execution.
596: CURSOR c3 IS

Line 3500: FROM fem_object_catalog_b o, fem_object_types t

3496: -- Retrieve object_type of the object execution.
3497: BEGIN
3498: SELECT o.object_type_code, t.undo_flag
3499: INTO v_object_type_code, v_undo_flag
3500: FROM fem_object_catalog_b o, fem_object_types t
3501: WHERE o.object_id = p_object_id
3502: AND t.object_type_code = o.object_type_code;
3503:
3504: EXCEPTION

Line 3995: -- End table processing (Step 2 done only if fem_object_types.undo_flag = 'Y').

3991: p_msg_count => v_msg_count,
3992: p_msg_data => v_msg_data,
3993: p_user_msg => 'N',
3994: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name);
3995: -- End table processing (Step 2 done only if fem_object_types.undo_flag = 'Y').
3996:
3997: -- ============================================================================
3998: -- STEP 3:
3999: -- Delete data from the data location tables (FEM_DL_xxxx).

Line 4000: -- This is only required in cases where fem_object_Types.undo_flag='Y'.

3996:
3997: -- ============================================================================
3998: -- STEP 3:
3999: -- Delete data from the data location tables (FEM_DL_xxxx).
4000: -- This is only required in cases where fem_object_Types.undo_flag='Y'.
4001: -- ============================================================================
4002: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4003: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4004: p_msg_text => 'STEP 3: Delete data from the data location tables (FEM_DL_xxxx).');

Line 6985: v_undo_flag FEM_OBJECT_TYPES_B.undo_flag%TYPE;

6981: C_API_VERSION CONSTANT NUMBER := 1.0;
6982: --
6983: e_api_error EXCEPTION;
6984: e_objexec_running EXCEPTION;
6985: v_undo_flag FEM_OBJECT_TYPES_B.undo_flag%TYPE;
6986: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
6987: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6988: v_count NUMBER;
6989: --

Line 7048: FROM fem_object_catalog_b oc, fem_object_types_b ot

7044: -- This API should only be called to remove rules where its rule type
7045: -- Undo Flag attribute is set to N.
7046: SELECT undo_flag
7047: INTO v_undo_flag
7048: FROM fem_object_catalog_b oc, fem_object_types_b ot
7049: WHERE oc.object_id = p_object_id
7050: AND oc.object_type_code = ot.object_type_code;
7051:
7052: IF nvl(v_undo_flag,'XX') <> 'N' THEN