eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_UD_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 593: v_pb_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

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
597: SELECT object_name, object_type

Line 628: FROM fem_object_catalog_b

624: x_return_status := pc_ret_sts_success;
625:
626: SELECT object_type_code
627: INTO v_object_type_code
628: FROM fem_object_catalog_b
629: WHERE object_id = p_object_id;
630:
631: -- ============================================================================
632: -- STEP 1:

Line 1061: FROM fem_object_catalog_b o, fem_object_definition_b d

1057: BEGIN
1058:
1059: SELECT object_definition_id
1060: INTO v_undo_list_obj_def_id
1061: FROM fem_object_catalog_b o, fem_object_definition_b d
1062: WHERE o.object_id = p_undo_list_obj_id
1063: AND o.object_type_code = 'UNDO'
1064: AND o.object_id = d.object_id;
1065:

Line 1263: FROM fem_pl_object_executions pl, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2

1259: -- dataset code and source system as the current candidate.
1260: -- Bug 5011140 (FP:4596447): Also retrieve all TP Process Rule executions.
1261: CURSOR c1 IS
1262: SELECT pl.request_id, pl.object_id
1263: FROM fem_pl_object_executions pl, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2
1264: WHERE pl.object_id = o.object_id
1265: AND o.object_id = p_object_id
1266: AND o.object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION',
1267: 'RCM_PROCESS_RULE','TP_PROCESS_RULE',

Line 1312: FROM fem_user_folders u, fem_object_catalog_b o

1308: -- STEP V1: Check to see if user can execute the rule. In FEM.D, if a user
1309: -- can read a rule, then they can execute a rule.
1310: -- ============================================================================
1311: SELECT count(*) INTO v_count
1312: FROM fem_user_folders u, fem_object_catalog_b o
1313: WHERE o.object_id = p_object_id
1314: AND o.folder_id = u.folder_id
1315: AND u.user_id = pv_apps_user_id;
1316:

Line 1654: FROM fem_ud_list_candidates c, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2

1650: -- dataset code and source system as the current candidate.
1651: -- Bug 5011140 (FP:4596447): Also retrieve all TP Process Rule executions.
1652: CURSOR c1 IS
1653: SELECT c.request_id, c.object_id
1654: FROM fem_ud_list_candidates c, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2
1655: WHERE c.object_id = o.object_id
1656: AND o.object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION',
1657: 'RCM_PROCESS_RULE','TP_PROCESS_RULE',
1658: 'SOURCE_DATA_LOADER','DATAX_LOADER')

Line 2376: FROM fem_pl_object_executions pl, fem_object_catalog_b o,

2372: -- dependencies list to give the user a more complete picture of what
2373: -- is being undone in the Undo Confirmation Page.
2374: CURSOR c_repeat_execs (p_req_id NUMBER, p_obj_id NUMBER) IS
2375: SELECT pl.request_id, pl.object_id
2376: FROM fem_pl_object_executions pl, fem_object_catalog_b o,
2377: fem_pl_requests r1, fem_pl_requests r2
2378: WHERE pl.object_id = o.object_id
2379: AND o.object_id = p_obj_id
2380: AND o.object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION',

Line 2398: FROM fem_ud_list_dependents d, fem_object_catalog_b o, fem_user_folders u

2394: -- cursor is used to validate the dependents. Use this query when
2395: -- p_preview_flag = 'N'
2396: CURSOR c3 IS
2397: SELECT d.dependent_request_id, d.dependent_object_id, u.folder_id
2398: FROM fem_ud_list_dependents d, fem_object_catalog_b o, fem_user_folders u
2399: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
2400: AND d.request_id = p_request_id
2401: AND d.object_id = p_object_id
2402: AND d.dependent_object_id = o.object_id

Line 2411: FROM fem_ud_prview_dependents d, fem_object_catalog_b o, fem_user_folders u

2407: -- cursor is used to validate the dependents. Use this query when
2408: -- p_preview_flag = 'Y'
2409: CURSOR c4 IS
2410: SELECT d.dependent_request_id, d.dependent_object_id, u.folder_id
2411: FROM fem_ud_prview_dependents d, fem_object_catalog_b o, fem_user_folders u
2412: WHERE d.ud_session_id = p_ud_session_id
2413: AND d.request_id = p_request_id
2414: AND d.object_id = p_object_id
2415: AND d.dependent_object_id = o.object_id

Line 3069: FROM fem_user_folders u, fem_object_catalog_b o

3065: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3066: p_msg_text => 'Checking to make sure user can read/execute the object');
3067:
3068: SELECT count(*) INTO v_count
3069: FROM fem_user_folders u, fem_object_catalog_b o
3070: WHERE o.object_id = a_candidate.object_id
3071: AND o.folder_id = u.folder_id
3072: AND u.user_id = pv_apps_user_id;
3073:

Line 3170: FROM fem_user_folders u, fem_object_catalog_b o

3166: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3167: p_msg_text => 'Checking to make sure user can read/execute the object');
3168:
3169: SELECT count(*) INTO v_count
3170: FROM fem_user_folders u, fem_object_catalog_b o
3171: WHERE o.object_id = a_candidate.object_id
3172: AND o.folder_id = u.folder_id
3173: AND u.user_id = pv_apps_user_id;
3174:

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 4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

4564: BEGIN
4565:
4566: SELECT u.undo_list_obj_def_id
4567: INTO v_undo_list_obj_def_id
4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
4569: WHERE o.object_id = p_undo_list_obj_id
4570: AND o.object_type_code = 'UNDO'
4571: AND o.object_id = d.object_id
4572: AND d.object_definition_id = u.undo_list_obj_def_id;

Line 4591: -- FROM fem_object_catalog_b o, fem_user_folders u

4587: -- BEGIN
4588:
4589: -- SELECT 'Y'
4590: -- INTO v_can_user_read_rule_flag
4591: -- FROM fem_object_catalog_b o, fem_user_folders u
4592: -- WHERE o.object_id = p_undo_list_obj_id
4593: -- AND o.folder_id = u.folder_id
4594: -- AND u.user_id = pv_apps_user_id;
4595:

Line 5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

5144: v_check_status BOOLEAN;
5145:
5146: CURSOR c1 IS
5147: SELECT o.object_id
5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
5149: WHERE o.object_type_code = 'UNDO'
5150: AND o.object_id = d.object_id
5151: AND d.object_definition_id = u.undo_list_obj_def_id
5152: AND (u.execution_date < SYSDATE OR u.execution_date = SYSDATE)

Line 5324: FROM fem_user_folders u, fem_object_catalog_b o

5320: -- ============================================================================
5321: -- V01b: Check to make sure user can execute/read the object.
5322: -- ============================================================================
5323: SELECT count(*) INTO v_count
5324: FROM fem_user_folders u, fem_object_catalog_b o
5325: WHERE o.object_id = p_object_id
5326: AND o.folder_id = u.folder_id
5327: AND u.user_id = pv_apps_user_id;
5328:

Line 5794: FROM fem_object_catalog_b o, fem_pl_object_executions p

5790: -- V05: Check to make sure user can execute/read all objects in the request.
5791: -- ============================================================================
5792:
5793: SELECT count(*) INTO v_count
5794: FROM fem_object_catalog_b o, fem_pl_object_executions p
5795: WHERE p.request_id = p_request_id
5796: AND p.object_id = o.object_id
5797: AND o.folder_id NOT IN
5798: (SELECT folder_id

Line 6659: v_object_type FEM_OBJECT_CATALOG_B.object_type_code%TYPE;

6655: --
6656: e_api_error EXCEPTION;
6657: e_objexec_running EXCEPTION;
6658: e_chain_exists EXCEPTION;
6659: v_object_type FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
6660: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
6661: v_request_id FEM_PL_REQUESTS.request_id%TYPE;
6662: v_dep_req_id FEM_PL_REQUESTS.request_id%TYPE;
6663: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

Line 6663: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

6659: v_object_type FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
6660: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
6661: v_request_id FEM_PL_REQUESTS.request_id%TYPE;
6662: v_dep_req_id FEM_PL_REQUESTS.request_id%TYPE;
6663: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
6664: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6665: v_return_status VARCHAR2(1);
6666: v_chain_exists VARCHAR2(1);
6667: v_count NUMBER;

Line 6723: FROM fem_object_catalog_b

6719: -- This API is only exposed for TP Process Rules at the moment.
6720: -- Any other object types will result in error.
6721: SELECT object_type_code
6722: INTO v_object_type
6723: FROM fem_object_catalog_b
6724: WHERE object_id = p_object_id;
6725:
6726: IF nvl(v_object_type,'BADTYPE') <> 'TP_PROCESS_RULE' THEN
6727: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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