APPS.FEM_PL_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 174: fem_object_catalog_b o,

170:
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;

Line 465: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

461: v_approval_edit_lock_exists VARCHAR2(1);
462: v_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
463: v_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
464: v_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
465: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
466: v_dep_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
467:
468: e_definition_is_seeded EXCEPTION;
469: e_data_edit_locked EXCEPTION;

Line 747: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

743: v_can_delete_object_def VARCHAR2(1);
744: v_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
745: v_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
746: v_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
747: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
748: v_dep_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
749: v_return_status VARCHAR2(1);
750:
751: e_cannot_del_version EXCEPTION;

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 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 1365: FROM fem_object_catalog_b

1361: ELSE
1362: -- Determine object type code for the object
1363: SELECT object_type_code
1364: INTO v_object_type_code
1365: FROM fem_object_catalog_b
1366: WHERE object_id = p_object_id;
1367:
1368: -- If no locks exist register object execution.
1369:

Line 2276: FROM fem_object_catalog_b

2272:
2273: -- Determine object type code for the object
2274: SELECT object_type_code
2275: INTO v_object_type_code
2276: FROM fem_object_catalog_b
2277: WHERE object_id = p_object_id;
2278:
2279: IF v_object_type_code IN ('XGL_INTEGRATION',
2280: 'SOURCE_DATA_LOADER','DATAX_LOADER') THEN

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

Line 4187: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;

4183: v_count NUMBER;
4184: e_unexp EXCEPTION;
4185: e_api_error EXCEPTION;
4186: v_exec_status_code FEM_PL_OBJECT_EXECUTIONS.exec_status_code%TYPE;
4187: v_object_type_code FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
4188: v_call_status BOOLEAN;
4189: v_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
4190: v_req_phase FND_CONCURRENT_REQUESTS.phase_code%TYPE;
4191: v_req_status FND_CONCURRENT_REQUESTS.status_code%TYPE;

Line 4277: FROM fem_object_catalog_b

4273: -- running, the engine should have registered the object execution already.
4274: WHEN no_data_found THEN
4275: SELECT object_type_code
4276: INTO v_object_type_code
4277: FROM fem_object_catalog_b
4278: WHERE object_id = p_object_id;
4279:
4280: IF v_object_type_code = 'MAPPING_PREVIEW' THEN
4281: -- needed because request_id is an IN OUT param