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_DATABASE_UTIL_PKG dependencies on FEM_PL_TEMP_OBJECTS

Line 603: -- logged by REQUEST_ID and OBJECT_ID in FEM_PL_TEMP_OBJECTS, so that it

599: -- Tables created by this procedure are expected to be temporary, i.e.
600: -- to be dropped by a call to Drop_Temp_DB_Objects before the end of the
601: -- concurrent process.
602: -- A synonym for the table is created in the APPS schema. The table is
603: -- logged by REQUEST_ID and OBJECT_ID in FEM_PL_TEMP_OBJECTS, so that it
604: -- can be undone by the Undo engine in case of failure. All DDL, including
605: -- synonym creation, is logged in FEM_DDL_LOG. This logging can be toggled
606: -- on/off by the process parameter 'DDL_LOGGING' in Admin=>Tuning Options.
607: -- Parameters:

Line 862: -- Log table in FEM_PL_TEMP_OBJECTS

858: p_value2 => p_table_name);
859: RAISE;
860: END;
861:
862: -- Log table in FEM_PL_TEMP_OBJECTS
863:
864: BEGIN
865: INSERT INTO fem_pl_temp_objects
866: (request_id,

Line 865: INSERT INTO fem_pl_temp_objects

861:
862: -- Log table in FEM_PL_TEMP_OBJECTS
863:
864: BEGIN
865: INSERT INTO fem_pl_temp_objects
866: (request_id,
867: object_id,
868: object_type,
869: object_name,

Line 887: UPDATE fem_pl_temp_objects

883: SYSDATE,
884: c_login_id);
885: EXCEPTION
886: WHEN DUP_VAL_ON_INDEX THEN
887: UPDATE fem_pl_temp_objects
888: SET created_by = c_user_id,
889: creation_date = SYSDATE,
890: last_updated_by = c_user_id,
891: last_update_date = SYSDATE,

Line 968: -- The index is logged by REQUEST_ID and OBJECT_ID in FEM_PL_TEMP_OBJECTS,

964: -- and 'TEMP_INDEX_NEXT_EXTENT', as set in the Admin=>Tuning Options UI.
965: -- Indexes created by this procedure are expected to be temporary, i.e.
966: -- to be dropped by a call to Drop_Temp_DB_Objects before the end of the
967: -- concurrent process.
968: -- The index is logged by REQUEST_ID and OBJECT_ID in FEM_PL_TEMP_OBJECTS,
969: -- so that it can be undone by the Undo engine in case of failure. All DDL
970: -- is logged in FEM_DDL_LOG. This logging can be toggled on/off by the
971: -- process parameter 'DDL_LOGGING' in Admin=>Tuning Options.
972: -- Parameters:

Line 1220: -- Log index in FEM_PL_TEMP_OBJECTS

1216: p_value3 => p_table_name);
1217: RAISE;
1218: END;
1219:
1220: -- Log index in FEM_PL_TEMP_OBJECTS
1221:
1222: BEGIN
1223: INSERT INTO fem_pl_temp_objects
1224: (request_id,

Line 1223: INSERT INTO fem_pl_temp_objects

1219:
1220: -- Log index in FEM_PL_TEMP_OBJECTS
1221:
1222: BEGIN
1223: INSERT INTO fem_pl_temp_objects
1224: (request_id,
1225: object_id,
1226: object_type,
1227: object_name,

Line 1245: UPDATE fem_pl_temp_objects

1241: SYSDATE,
1242: c_login_id);
1243: EXCEPTION
1244: WHEN DUP_VAL_ON_INDEX THEN
1245: UPDATE fem_pl_temp_objects
1246: SET created_by = c_user_id,
1247: creation_date = SYSDATE,
1248: last_updated_by = c_user_id,
1249: last_update_date = SYSDATE,

Line 1296: -- FEM_PL_TEMP_OBJECTS, so that it can be undone by the Undo engine in case

1292: -- Creates a view in the APPS schema, according to the view definition in
1293: -- p_view_def. Views created by this procedure are expected to be temporary,
1294: -- i.e. to be dropped by a call to Drop_Temp_DB_Objects before the end of the
1295: -- concurrent process. The view is logged by REQUEST_ID and OBJECT_ID in
1296: -- FEM_PL_TEMP_OBJECTS, so that it can be undone by the Undo engine in case
1297: -- of failure. All DDL is logged in FEM_DDL_LOG. This logging can be toggled
1298: -- on/off by the process parameter 'DDL_LOGGING' in Admin=>Tuning Options.
1299: -- Parameters:
1300: -- p_api_version:

Line 1437: -- Log view in FEM_PL_TEMP_OBJECTS

1433: p_value2 => p_view_name);
1434: RAISE;
1435: END;
1436:
1437: -- Log view in FEM_PL_TEMP_OBJECTS
1438:
1439: BEGIN
1440: INSERT INTO fem_pl_temp_objects
1441: (request_id,

Line 1440: INSERT INTO fem_pl_temp_objects

1436:
1437: -- Log view in FEM_PL_TEMP_OBJECTS
1438:
1439: BEGIN
1440: INSERT INTO fem_pl_temp_objects
1441: (request_id,
1442: object_id,
1443: object_type,
1444: object_name,

Line 1462: UPDATE fem_pl_temp_objects

1458: SYSDATE,
1459: c_login_id);
1460: EXCEPTION
1461: WHEN DUP_VAL_ON_INDEX THEN
1462: UPDATE fem_pl_temp_objects
1463: SET created_by = c_user_id,
1464: creation_date = SYSDATE,
1465: last_updated_by = c_user_id,
1466: last_update_date = SYSDATE,

Line 1509: -- logged in FEM_PL_TEMP_OBJECTS for the given Request ID and Object ID.

1505: p_step_name IN VARCHAR2 DEFAULT 'ALL') IS
1506: -- ===========================================================================
1507: -- DESCRIPTION
1508: -- Drops all temporary tables and synonyms, views, and indexes that are
1509: -- logged in FEM_PL_TEMP_OBJECTS for the given Request ID and Object ID.
1510: -- Parameters:
1511: -- p_api_version:
1512: -- Optional OA-compliance parameter.
1513: -- Default is 1.0 (and this is currently the only acceptable value).

Line 1532: -- FEM_PL_TEMP_OBJECTS for the given Request ID and Object ID have

1528: -- Valid values are 'T' and 'F'; default is 'T'.
1529: -- x_return_status:
1530: -- OA-compliance OUT parameter.
1531: -- For this procedure, success means that all temp objects logged in
1532: -- FEM_PL_TEMP_OBJECTS for the given Request ID and Object ID have
1533: -- been dropped or could not be dropped because they already did not
1534: -- exist, and x_return_status = 'S'. If an object exists, but cannot
1535: -- be dropped for some reason, his procedure returns 'E' for error in
1536: -- x_return_status, but it continues to try to drop all other temp DB

Line 1581: FROM fem_pl_temp_objects

1577: v_fnd_industry VARCHAR2(100);
1578:
1579: CURSOR c1(cp_obj_type IN VARCHAR2) IS
1580: SELECT object_type, object_name
1581: FROM fem_pl_temp_objects
1582: WHERE request_id = p_request_id
1583: AND object_id = p_object_id
1584: AND object_type = cp_obj_type
1585: ORDER BY object_name;

Line 1691: DELETE FROM fem_pl_temp_objects tobj

1687: END;
1688:
1689: END LOOP;
1690:
1691: DELETE FROM fem_pl_temp_objects tobj
1692: WHERE request_id = p_request_id
1693: AND object_id = p_object_id
1694: AND object_type = 'VIEW'
1695: AND NOT EXISTS

Line 1736: DELETE FROM fem_pl_temp_objects tobj

1732: END;
1733:
1734: END LOOP;
1735:
1736: DELETE FROM fem_pl_temp_objects tobj
1737: WHERE request_id = p_request_id
1738: AND object_id = p_object_id
1739: AND object_type = 'INDEX'
1740: AND NOT EXISTS

Line 1809: DELETE FROM fem_pl_temp_objects tobj

1805: END;
1806:
1807: END LOOP;
1808:
1809: DELETE FROM fem_pl_temp_objects tobj
1810: WHERE request_id = p_request_id
1811: AND object_id = p_object_id
1812: AND object_type = 'TABLE'
1813: AND NOT EXISTS