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.FND_OAM_DSCFG_COMPILER_PKG dependencies on DBMS_SQL

Line 1314: l_object_ids DBMS_SQL.NUMBER_TABLE;

1310: IS
1311: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_COMPILABLE_OBJECTS';
1312:
1313: -- temp variables for bulk collecting objects
1314: l_object_ids DBMS_SQL.NUMBER_TABLE;
1315: l_object_types DBMS_SQL.VARCHAR2_TABLE;
1316: l_target_types DBMS_SQL.VARCHAR2_TABLE;
1317: l_target_ids DBMS_SQL.NUMBER_TABLE;
1318:

Line 1315: l_object_types DBMS_SQL.VARCHAR2_TABLE;

1311: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_COMPILABLE_OBJECTS';
1312:
1313: -- temp variables for bulk collecting objects
1314: l_object_ids DBMS_SQL.NUMBER_TABLE;
1315: l_object_types DBMS_SQL.VARCHAR2_TABLE;
1316: l_target_types DBMS_SQL.VARCHAR2_TABLE;
1317: l_target_ids DBMS_SQL.NUMBER_TABLE;
1318:
1319: TYPE long_varchar2_table_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;

Line 1316: l_target_types DBMS_SQL.VARCHAR2_TABLE;

1312:
1313: -- temp variables for bulk collecting objects
1314: l_object_ids DBMS_SQL.NUMBER_TABLE;
1315: l_object_types DBMS_SQL.VARCHAR2_TABLE;
1316: l_target_types DBMS_SQL.VARCHAR2_TABLE;
1317: l_target_ids DBMS_SQL.NUMBER_TABLE;
1318:
1319: TYPE long_varchar2_table_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
1320:

Line 1317: l_target_ids DBMS_SQL.NUMBER_TABLE;

1313: -- temp variables for bulk collecting objects
1314: l_object_ids DBMS_SQL.NUMBER_TABLE;
1315: l_object_types DBMS_SQL.VARCHAR2_TABLE;
1316: l_target_types DBMS_SQL.VARCHAR2_TABLE;
1317: l_target_ids DBMS_SQL.NUMBER_TABLE;
1318:
1319: TYPE long_varchar2_table_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
1320:
1321: -- temp variables for bulk collecting properties

Line 1322: l_prop_ids DBMS_SQL.NUMBER_TABLE;

1318:
1319: TYPE long_varchar2_table_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
1320:
1321: -- temp variables for bulk collecting properties
1322: l_prop_ids DBMS_SQL.NUMBER_TABLE;
1323: l_prop_object_ids DBMS_SQL.NUMBER_TABLE;
1324: l_prop_names DBMS_SQL.VARCHAR2_TABLE;
1325: l_datatypes DBMS_SQL.VARCHAR2_TABLE;
1326: l_canonical_values long_varchar2_table_type;

Line 1323: l_prop_object_ids DBMS_SQL.NUMBER_TABLE;

1319: TYPE long_varchar2_table_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
1320:
1321: -- temp variables for bulk collecting properties
1322: l_prop_ids DBMS_SQL.NUMBER_TABLE;
1323: l_prop_object_ids DBMS_SQL.NUMBER_TABLE;
1324: l_prop_names DBMS_SQL.VARCHAR2_TABLE;
1325: l_datatypes DBMS_SQL.VARCHAR2_TABLE;
1326: l_canonical_values long_varchar2_table_type;
1327:

Line 1324: l_prop_names DBMS_SQL.VARCHAR2_TABLE;

1320:
1321: -- temp variables for bulk collecting properties
1322: l_prop_ids DBMS_SQL.NUMBER_TABLE;
1323: l_prop_object_ids DBMS_SQL.NUMBER_TABLE;
1324: l_prop_names DBMS_SQL.VARCHAR2_TABLE;
1325: l_datatypes DBMS_SQL.VARCHAR2_TABLE;
1326: l_canonical_values long_varchar2_table_type;
1327:
1328: -- variables for traversal of the bulk collections

Line 1325: l_datatypes DBMS_SQL.VARCHAR2_TABLE;

1321: -- temp variables for bulk collecting properties
1322: l_prop_ids DBMS_SQL.NUMBER_TABLE;
1323: l_prop_object_ids DBMS_SQL.NUMBER_TABLE;
1324: l_prop_names DBMS_SQL.VARCHAR2_TABLE;
1325: l_datatypes DBMS_SQL.VARCHAR2_TABLE;
1326: l_canonical_values long_varchar2_table_type;
1327:
1328: -- variables for traversal of the bulk collections
1329: l_curr_object_id NUMBER;

Line 1805: l_host_names DBMS_SQL.VARCHAR2_TABLE;

1801:
1802: l_ctxt VARCHAR2(60) := PKG_NAME||'GENERATE_ENGINE_BUNDLES';
1803:
1804:
1805: l_host_names DBMS_SQL.VARCHAR2_TABLE;
1806: l_host_name VARCHAR2(256);
1807: l_bundle_object_id NUMBER;
1808: l_property_id NUMBER;
1809: