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_PL_REQUESTS

Line 355: FROM fem_pl_requests

351: SELECT cal_period_id, ledger_id, output_dataset_code,
352: creation_date, source_system_code
353: INTO v_cal_period_id, v_ledger_id, v_output_dataset_code,
354: v_object_execution_date, v_source_system_code
355: FROM fem_pl_requests
356: WHERE request_id = p_request_id;
357: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
358: END;
359:

Line 742: DELETE fem_pl_requests

738: AND object_id = p_object_id;
739:
740: -- Only delete request if there are no other executions
741: -- for that request.
742: DELETE fem_pl_requests
743: WHERE request_id = p_request_id
744: AND request_id NOT IN
745: (select request_id FROM fem_pl_object_executions);
746: END IF; -- OGL object type

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 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 1906: FROM fem_pl_requests

1902:
1903: -- Retrieve ledger, dataset code and calendar period for the candidate
1904: SELECT ledger_id, output_dataset_code, cal_period_id
1905: INTO v_ledger_id, v_output_dataset_code, v_cal_period_id
1906: FROM fem_pl_requests
1907: WHERE request_id = p_request_id;
1908:
1909: -- Retrieve initial list of type 2 dependents of the candidate.
1910: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)

Line 1915: FROM fem_pl_requests r

1911: SELECT DISTINCT x_upd_dep_calc_id, t1.request_id, t1.object_id
1912: FROM fem_pl_tables t1
1913: WHERE t1.request_id IN (
1914: SELECT r.request_id
1915: FROM fem_pl_requests r
1916: WHERE r.ledger_id = v_ledger_id
1917: AND r.cal_period_id = v_cal_period_id
1918: AND r.output_dataset_code = v_output_dataset_code)
1919: AND t1.table_name IN (

Line 1976: FROM fem_pl_requests r

1972: SELECT DISTINCT x_upd_dep_calc_id, c.request_id, c.object_id
1973: FROM fem_pl_tab_updated_cols c
1974: WHERE c.request_id IN (
1975: SELECT r.request_id
1976: FROM fem_pl_requests r
1977: WHERE r.ledger_id = v_ledger_id
1978: AND r.cal_period_id = v_cal_period_id
1979: AND r.output_dataset_code = v_output_dataset_code)
1980: AND (c.table_name, c.column_name) IN (

Line 2004: FROM fem_pl_requests r

2000: SELECT DISTINCT x_upd_dep_calc_id, t1.request_id, t1.object_id
2001: FROM fem_pl_tables t1
2002: WHERE t1.request_id IN (
2003: SELECT r.request_id
2004: FROM fem_pl_requests r
2005: WHERE r.ledger_id = v_ledger_id
2006: AND r.cal_period_id = v_cal_period_id
2007: AND r.output_dataset_code = v_output_dataset_code)
2008: AND t1.table_name IN (

Line 2377: fem_pl_requests r1, fem_pl_requests r2

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',
2381: 'RCM_PROCESS_RULE','TP_PROCESS_RULE',

Line 3723: FROM fem_pl_requests

3719: SELECT ' CAL_PERIOD_ID = '||cal_period_id||
3720: ' AND LEDGER_ID = '||ledger_id||
3721: ' AND DATASET_CODE = '||output_dataset_code
3722: INTO v_where_clause
3723: FROM fem_pl_requests
3724: WHERE request_id = p_request_id;
3725: ELSE -- atbl.undo_type = 'ZERO_COLUMN_BY_OBJECT'
3726: v_where_clause := ' LAST_UPDATED_BY_REQUEST_ID = '||p_request_id||
3727: ' AND LAST_UPDATED_BY_OBJECT_ID = '||p_object_id;

Line 3905: FROM fem_pl_requests

3901: SELECT ' CAL_PERIOD_ID = '||cal_period_id||
3902: ' AND LEDGER_ID = '||ledger_id||
3903: ' AND DATASET_CODE = '||output_dataset_code
3904: INTO v_where_clause
3905: FROM fem_pl_requests
3906: WHERE request_id = p_request_id;
3907: ELSE -- atbl.undo_type = 'ZERO_COLUMN_BY_OBJECT'
3908: v_where_clause := ' LAST_UPDATED_BY_REQUEST_ID = '||p_request_id||
3909: ' AND LAST_UPDATED_BY_OBJECT_ID = '||p_object_id;

Line 5711: FROM fem_pl_requests

5707: -- ============================================================================
5708:
5709: SELECT COUNT(*)
5710: INTO v_count
5711: FROM fem_pl_requests
5712: WHERE request_id = p_request_id;
5713:
5714: IF v_count = 0 THEN
5715: RAISE e_request_not_found;

Line 6661: v_request_id FEM_PL_REQUESTS.request_id%TYPE;

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;
6664: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6665: v_return_status VARCHAR2(1);

Line 6662: v_dep_req_id FEM_PL_REQUESTS.request_id%TYPE;

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;
6664: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6665: v_return_status VARCHAR2(1);
6666: v_chain_exists VARCHAR2(1);

Line 6664: v_exec_status_code FEM_PL_REQUESTS.exec_status_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;
6668: v_sql VARCHAR2(1000);

Line 6674: FROM fem_pl_requests R, fem_pl_tables T

6670: CURSOR c_pl_obj_execs (p_current_request_id NUMBER, p_object_id NUMBER,
6671: p_table_name VARCHAR2, p_cal_period_id NUMBER,
6672: p_ledger_id NUMBER, p_dataset_code NUMBER) IS
6673: SELECT R.request_id, T.object_id, T.table_name
6674: FROM fem_pl_requests R, fem_pl_tables T
6675: WHERE R.request_id = T.request_id
6676: AND R.request_id <> p_current_request_id
6677: AND T.object_id = p_object_id
6678: AND T.table_name = p_table_name

Line 6987: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;

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: --
6990: CURSOR c_object_name (p_object_id NUMBER) IS
6991: SELECT object_name

Line 7260: fem_pl_requests requests,

7256: and src_system.personal_flag = 'N')
7257: GROUP BY created_by_object_id, created_by_request_id, ledger_id, cal_period_id, source_system_code,
7258: dataset_code) bal,
7259: fem_pl_object_executions exe,
7260: fem_pl_requests requests,
7261: fem_pl_tables tab,
7262: fem_object_catalog_vl obj
7263: where bal.created_by_object_id = obj.object_id
7264: and obj.object_type_code = 'MAPPING_RULE'