APPS.FEM_PL_PKG dependencies on FEM_OBJECT_TYPES

Line 145: -- generating results (i.e FEM_OBJECT_TYPES.DATA_EDIT_LOCK_FLAG='Y') then,

141: ) IS
142: -- ==========================================================================
143: -- Check if data lock exists for the object definition
144: -- If object is one which cannot be modified if it has been read whilst
145: -- generating results (i.e FEM_OBJECT_TYPES.DATA_EDIT_LOCK_FLAG='Y') then,
146: -- Check to see if object definition read by existing executions.
147: -- If object definition read, OR,
148: -- object definition is a seeded definition (i.e ID < 10000), then,
149: -- it means data lock exists.

Line 175: fem_object_types t

171: SELECT t.data_edit_lock_flag
172: INTO v_data_edit_lock_flag
173: FROM fem_object_definition_b d,
174: fem_object_catalog_b o,
175: fem_object_types t
176: WHERE d.object_definition_id = p_object_definition_id
177: AND d.object_id = o.object_id
178: AND o.object_type_code = t.object_type_code;
179:

Line 1006: -- ELSIF an executable locked object (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = Y) THEN

1002: -- ELSIF object_type in ('RCM_PROCESS_RULE','TP_PROCESS_RULE') THEN
1003: -- Call specialized procedure (fem_pl_pkg.rcm_proc_Exec_Lock_Exists)
1004: -- ELSIF object_type = 'MAPPING_PREVIEW' THEN
1005: -- Call specialized procedure (fem_pl_pkg.Preview_Exec_Lock_Exists)
1006: -- ELSIF an executable locked object (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = Y) THEN
1007: -- Call specialized procedure (fem_pl_pkg.mapping_Exec_Lock_Exists)
1008: -- ELSIF not an executable locked object
1009: -- (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = N) THEN
1010: -- Set execution state (IF object execution is

Line 1009: -- (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = N) THEN

1005: -- Call specialized procedure (fem_pl_pkg.Preview_Exec_Lock_Exists)
1006: -- ELSIF an executable locked object (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = Y) THEN
1007: -- Call specialized procedure (fem_pl_pkg.mapping_Exec_Lock_Exists)
1008: -- ELSIF not an executable locked object
1009: -- (i.e FEM_OBJECT_TYPES.EXECUTABLE_LOCK = N) THEN
1010: -- Set execution state (IF object execution is
1011: -- already registered and is running THEN x_exec_state='RESTART' ELSE
1012: -- x_exec_state = 'NORMAL).
1013: -- Return F.

Line 1051: FROM fem_object_types t, fem_object_catalog_b o

1047: -- Retrieve object type code and check to see if the object
1048: -- type is executable locked.
1049: SELECT t.executable_lock_flag, o.object_type_code
1050: INTO v_executable_lock_flag, v_object_type_code
1051: FROM fem_object_types t, fem_object_catalog_b o
1052: WHERE o.object_id = p_object_id
1053: AND o.object_type_code = t.object_type_code;
1054:
1055: IF v_approval_edit_lock_exists = 'T' THEN

Line 1263: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

1259: v_hierarchy_name VARCHAR2(150);
1260: l_api_name CONSTANT VARCHAR2(30) := 'register_object_execution';
1261: l_api_version CONSTANT NUMBER := 1.0;
1262: v_undo_flag VARCHAR2(1);
1263: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
1264: v_display_flag VARCHAR2(1);
1265:
1266: -- This cursor retrieves all previous executions of an
1267: -- object that has the same parameters as the current

Line 1316: FROM fem_object_catalog_b o, fem_object_types t

1312: WHERE request_id = p_request_id;
1313:
1314: -- Retrieve undo_flag
1315: SELECT undo_flag INTO v_undo_flag
1316: FROM fem_object_catalog_b o, fem_object_types t
1317: WHERE o.object_id = p_object_id
1318: AND o.object_type_code = t.object_type_code;
1319:
1320: -- Acquire table lock

Line 2230: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

2226:
2227: l_api_name CONSTANT VARCHAR2(30) := 'update_num_of_output_rows';
2228: l_api_version CONSTANT NUMBER := 1.0;
2229:
2230: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
2231:
2232: BEGIN
2233:
2234: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

Line 2982: FROM fem_object_types t, fem_object_catalog_b o

2978: dev_status => v_dstatus,
2979: message => v_message);
2980:
2981: SELECT always_rerunnable_flag INTO v_always_rerunnable_flag
2982: FROM fem_object_types t, fem_object_catalog_b o
2983: WHERE o.object_id = p_object_id
2984: AND o.object_type_code = t.object_type_code;
2985:
2986: IF v_always_rerunnable_flag = 'Y' THEN