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.PV_CONTEXT_VALUES dependencies on DBMS_UTILITY

Line 266: l_total_start := dbms_utility.get_time;

262: BEGIN
263: -- -----------------------------------------------------------------------
264: -- Set variables.
265: -- -----------------------------------------------------------------------
266: l_total_start := dbms_utility.get_time;
267:
268: IF (p_log_to_file <> 'Y') THEN
269: g_log_to_file := 'N';
270: ELSE

Line 420: l_start := dbms_utility.get_time;

416: -- Pre-processing steps including synonym recovery, retrieving PV schema,
417: -- retrieving underlying tables for the search and the mirror table,
418: -- alter/drop indexes, etc.
419: -- -----------------------------------------------------------------------
420: l_start := dbms_utility.get_time;
421: Debug('~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
422: Debug('Pre-Processing....................................................');
423: dbms_application_info.set_module(
424: module_name => g_module_name,

Line 469: Debug('Elapsed Time (Pre-Processing): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

465: RETURN;
466: END IF;
467:
468:
469: Debug('Elapsed Time (Pre-Processing): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
470: l_start := dbms_utility.get_time;
471:
472:
473: -- *****************************************************************

Line 470: l_start := dbms_utility.get_time;

466: END IF;
467:
468:
469: Debug('Elapsed Time (Pre-Processing): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
470: l_start := dbms_utility.get_time;
471:
472:
473: -- *****************************************************************
474: -- *****************************************************************

Line 542: Debug('Elapsed Time (Non-Refreshables): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

538:
539: COMMIT;
540: END IF;
541:
542: Debug('Elapsed Time (Non-Refreshables): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
543: l_start := dbms_utility.get_time;
544:
545:
546: -- *****************************************************************

Line 543: l_start := dbms_utility.get_time;

539: COMMIT;
540: END IF;
541:
542: Debug('Elapsed Time (Non-Refreshables): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
543: l_start := dbms_utility.get_time;
544:
545:
546: -- *****************************************************************
547: -- *****************************************************************

Line 566: Debug('Elapsed Time (Functional Expertise): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

562: IF (l_num_temp > 0) THEN
563: Insert_Functional_Expertise(l_refresh_type, l_user_id);
564: END IF;
565:
566: Debug('Elapsed Time (Functional Expertise): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
567: l_start := dbms_utility.get_time;
568:
569:
570: -- *****************************************************************

Line 567: l_start := dbms_utility.get_time;

563: Insert_Functional_Expertise(l_refresh_type, l_user_id);
564: END IF;
565:
566: Debug('Elapsed Time (Functional Expertise): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
567: l_start := dbms_utility.get_time;
568:
569:
570: -- *****************************************************************
571: -- *****************************************************************

Line 584: Debug('Elapsed Time (Internal Attributes): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

580: );
581:
582: Insert_Internal(l_refresh_type, l_user_id);
583:
584: Debug('Elapsed Time (Internal Attributes): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
585: l_start := dbms_utility.get_time;
586:
587:
588: -- *****************************************************************

Line 585: l_start := dbms_utility.get_time;

581:
582: Insert_Internal(l_refresh_type, l_user_id);
583:
584: Debug('Elapsed Time (Internal Attributes): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
585: l_start := dbms_utility.get_time;
586:
587:
588: -- *****************************************************************
589: -- *****************************************************************

Line 722: Debug('Elapsed Time (Derived/Perf Incr): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

718:
719:
720:
721: Debug('Total Number of Rows Inserted for this operation: ' || g_non_batch_insert_count);
722: Debug('Elapsed Time (Derived/Perf Incr): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
723:
724: l_start := dbms_utility.get_time;
725:
726:

Line 724: l_start := dbms_utility.get_time;

720:
721: Debug('Total Number of Rows Inserted for this operation: ' || g_non_batch_insert_count);
722: Debug('Elapsed Time (Derived/Perf Incr): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
723:
724: l_start := dbms_utility.get_time;
725:
726:
727: -- *****************************************************************
728: -- *****************************************************************

Line 741: Debug('Elapsed Time (External Attributes): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

737: );
738:
739: Insert_External(l_refresh_type, l_user_id);
740:
741: Debug('Elapsed Time (External Attributes): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
742:
743:
744: -- *****************************************************************
745: -- *****************************************************************

Line 749: l_start := dbms_utility.get_time;

745: -- *****************************************************************
746: -- Post Loading Processing
747: -- *****************************************************************
748: -- *****************************************************************
749: l_start := dbms_utility.get_time;
750: Debug('~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
751: Debug('Post loading processing...............................................');
752: dbms_application_info.set_module(
753: module_name => g_module_name,

Line 784: Debug('Elapsed Time (Total Post-Processing): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

780: Debug('The next incremental refresh will start from ' || l_incr_timestamp);
781:
782: COMMIT;
783:
784: Debug('Elapsed Time (Total Post-Processing): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
785:
786:
787:
788: -- -------------------------------------------------------------------------

Line 808: l_elapsed_time := DBMS_UTILITY.get_time - l_total_start;

804: END IF;
805:
806:
807:
808: l_elapsed_time := DBMS_UTILITY.get_time - l_total_start;
809: Debug('=====================================================================');
810: Debug('Total Elapsed Time: ' || l_elapsed_time || ' hsec' || ' = ' ||
811: ROUND((l_elapsed_time/6000), 2) || ' minutes');
812: Debug('=====================================================================');

Line 1168: l_start := dbms_utility.get_time;

1164: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1165: -- --------------------------------------------------------------
1166: -- Recreate unique indexes and rebuild nonunique indexes.
1167: -- --------------------------------------------------------------
1168: l_start := dbms_utility.get_time;
1169: dbms_application_info.set_module(
1170: module_name => p_module_name,
1171: action_name => 'Post: Rebuild Indexes'
1172: );

Line 1189: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1185: dbms_application_info.set_module(
1186: module_name => p_module_name,
1187: action_name => 'Post: Analyze Tables'
1188: );
1189: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1190: l_start := dbms_utility.get_time;
1191: Debug('Analyze the mirror table...');
1192:
1193: dbms_stats.gather_table_stats(

Line 1190: l_start := dbms_utility.get_time;

1186: module_name => p_module_name,
1187: action_name => 'Post: Analyze Tables'
1188: );
1189: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1190: l_start := dbms_utility.get_time;
1191: Debug('Analyze the mirror table...');
1192:
1193: dbms_stats.gather_table_stats(
1194: ownname => p_pv_schema_name,

Line 1200: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1196: estimate_percent => 10,
1197: method_opt => 'FOR ALL INDEXES'
1198: );
1199:
1200: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1201: l_start := dbms_utility.get_time;
1202:
1203: -- --------------------------------------------------------------
1204: -- Rename synonyms.

Line 1201: l_start := dbms_utility.get_time;

1197: method_opt => 'FOR ALL INDEXES'
1198: );
1199:
1200: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1201: l_start := dbms_utility.get_time;
1202:
1203: -- --------------------------------------------------------------
1204: -- Rename synonyms.
1205: -- --------------------------------------------------------------

Line 1642: l_total_start := dbms_utility.get_time;

1638: -- *****************************************************************
1639: -- Currency Attributes Refresh
1640: -- *****************************************************************
1641: -- *****************************************************************
1642: l_total_start := dbms_utility.get_time;
1643:
1644: Debug('-- **********************************************************');
1645: Debug('-- Processing internal CURRENCY attributes...');
1646: Debug('-- **********************************************************');

Line 1661: l_start := dbms_utility.get_time;

1657: -- will be "rolled back".
1658: -- -----------------------------------------------------------------
1659: FOR x IN c_currency_attrs LOOP
1660: BEGIN
1661: l_start := dbms_utility.get_time;
1662:
1663: -- --------------------------------------------------------------
1664: -- Full Refresh
1665: -- --------------------------------------------------------------

Line 1778: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1774:
1775: l_total_rows := l_total_rows + SQL%ROWCOUNT;
1776: END IF;
1777:
1778: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1779:
1780: EXCEPTION
1781: WHEN FND_API.G_EXC_ERROR THEN
1782: -- -------------------------------------------------------------------

Line 1858: l_start := dbms_utility.get_time;

1854: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1855: -- --------------------------------------------------------------------------
1856: -- Process NUMBER return_type.
1857: -- --------------------------------------------------------------------------
1858: l_start := dbms_utility.get_time;
1859: Debug('-- **********************************************************');
1860: Debug('-- Processing Internal Number attributes...');
1861: Debug('-- **********************************************************');
1862:

Line 1966: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

1962: END LOOP;
1963:
1964: COMMIT;
1965:
1966: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1967:
1968:
1969: -- --------------------------------------------------------------------------
1970: -- Process return_types other than NUMBER and CURRENCY.

Line 1972: l_start := dbms_utility.get_time;

1968:
1969: -- --------------------------------------------------------------------------
1970: -- Process return_types other than NUMBER and CURRENCY.
1971: -- --------------------------------------------------------------------------
1972: l_start := dbms_utility.get_time;
1973: Debug('-- **********************************************************');
1974: Debug('-- Processing internal OTHER attributes...');
1975: Debug('-- **********************************************************');
1976: dbms_application_info.set_module(

Line 2087: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2083: END LOOP;
2084:
2085: COMMIT;
2086:
2087: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2088:
2089:
2090:
2091: -- *****************************************************************

Line 2100: l_start := dbms_utility.get_time;

2096: ELSE
2097: -- --------------------------------------------------------------------------
2098: -- Process Internal NUMBER return_type.
2099: -- --------------------------------------------------------------------------
2100: l_start := dbms_utility.get_time;
2101: Debug('-- **********************************************************');
2102: Debug('-- Processing internal NUMBER attributes...');
2103: Debug('-- **********************************************************');
2104: dbms_application_info.set_module(

Line 2178: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2174:
2175: Debug(SQL%ROWCOUNT || ' rows processed.');
2176: l_total_rows := l_total_rows + SQL%ROWCOUNT;
2177:
2178: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2179:
2180:
2181: -- --------------------------------------------------------------------------
2182: -- Process return_types other than NUMBER and CURRENCY.

Line 2184: l_start := dbms_utility.get_time;

2180:
2181: -- --------------------------------------------------------------------------
2182: -- Process return_types other than NUMBER and CURRENCY.
2183: -- --------------------------------------------------------------------------
2184: l_start := dbms_utility.get_time;
2185: Debug('-- **********************************************************');
2186: Debug('-- Processing internal OTHER attributes...');
2187: Debug('-- **********************************************************');
2188: dbms_application_info.set_module(

Line 2269: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2265:
2266: Debug(SQL%ROWCOUNT || ' rows processed.');
2267: l_total_rows := l_total_rows + SQL%ROWCOUNT;
2268:
2269: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2270: END IF;
2271:
2272:
2273: Debug('Total Elapsed Time (Internal: ' ||

Line 2274: (DBMS_UTILITY.get_time - l_total_start) || ' hsec');

2270: END IF;
2271:
2272:
2273: Debug('Total Elapsed Time (Internal: ' ||
2274: (DBMS_UTILITY.get_time - l_total_start) || ' hsec');
2275: Debug('Total Number of Rows Processed for This Operation: ' || l_total_rows);
2276: Debug('Throughput: ' ||
2277: ROUND((l_total_rows/(DBMS_UTILITY.get_time - l_total_start)) * 100, 2) ||
2278: ' rows/second');

Line 2277: ROUND((l_total_rows/(DBMS_UTILITY.get_time - l_total_start)) * 100, 2) ||

2273: Debug('Total Elapsed Time (Internal: ' ||
2274: (DBMS_UTILITY.get_time - l_total_start) || ' hsec');
2275: Debug('Total Number of Rows Processed for This Operation: ' || l_total_rows);
2276: Debug('Throughput: ' ||
2277: ROUND((l_total_rows/(DBMS_UTILITY.get_time - l_total_start)) * 100, 2) ||
2278: ' rows/second');
2279:
2280: EXCEPTION
2281: WHEN others THEN

Line 2409: l_start := dbms_utility.get_time;

2405:
2406: -- --------------------------------------------------------------------------
2407: -- Process NUMBER and CURRENCY return_type.
2408: -- --------------------------------------------------------------------------
2409: l_start := dbms_utility.get_time;
2410: Debug('-- **********************************************************');
2411: Debug('-- Processing External NUMBER and CURRENCY attributes...');
2412: Debug('-- **********************************************************');
2413: dbms_application_info.set_module(

Line 2461: l_start2 := dbms_utility.get_time;

2457: -- ---------------------------------------------------------------
2458: null;
2459:
2460: ELSE
2461: l_start2 := dbms_utility.get_time;
2462:
2463: IF (x.batch_sql_text IS NULL) THEN
2464: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2465: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',

Line 2591: (DBMS_UTILITY.get_time - l_start2) || ' hsec');

2587: COMMIT;
2588: END IF;
2589:
2590: Debug('Elapsed Time: ' ||
2591: (DBMS_UTILITY.get_time - l_start2) || ' hsec');
2592:
2593:
2594: EXCEPTION
2595: WHEN FND_API.G_EXC_ERROR THEN

Line 2716: Debug('Elapsed Time (NUMBER/CURRENCY): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2712: END IF;
2713: END LOOP;
2714:
2715:
2716: Debug('Elapsed Time (NUMBER/CURRENCY): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2717:
2718: -- --------------------------------------------------------------------------
2719: -- Process return_types other than NUMBER and CURRENCY.
2720: -- --------------------------------------------------------------------------

Line 2721: l_start := dbms_utility.get_time;

2717:
2718: -- --------------------------------------------------------------------------
2719: -- Process return_types other than NUMBER and CURRENCY.
2720: -- --------------------------------------------------------------------------
2721: l_start := dbms_utility.get_time;
2722: Debug('___________________________________________________________');
2723: Debug('-- **********************************************************');
2724: Debug('-- Processing External OTHER attributes...');
2725: Debug('-- **********************************************************');

Line 2774: l_start2 := dbms_utility.get_time;

2770: null;
2771:
2772: ELSE
2773:
2774: l_start2 := dbms_utility.get_time;
2775:
2776: IF (x.batch_sql_text IS NULL) THEN
2777: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2778: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',

Line 2837: (DBMS_UTILITY.get_time - l_start2) || ' hsec');

2833: COMMIT;
2834: END IF;
2835:
2836: Debug('Elapsed Time: ' ||
2837: (DBMS_UTILITY.get_time - l_start2) || ' hsec');
2838:
2839: EXCEPTION
2840: WHEN others THEN
2841: Debug('Error executing insert statement for "' || x.name || '"');

Line 2852: Debug('Elapsed Time (Other): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

2848: END IF;
2849: END LOOP;
2850:
2851:
2852: Debug('Elapsed Time (Other): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2853:
2854: END Insert_External;
2855: -- ======================End of Insert_External==================================
2856:

Line 3855: l_start := dbms_utility.get_time;

3851: l_start NUMBER;
3852: l_start2 NUMBER;
3853:
3854: BEGIN
3855: l_start := dbms_utility.get_time;
3856:
3857: -- -----------------------------------------------------------------------
3858: -- Determine "APPS" schema.
3859: -- -----------------------------------------------------------------------

Line 3880: l_start2 := dbms_utility.get_time;

3876: object_name = x.name AND
3877: object_type = 'PACKAGE BODY' AND
3878: status = 'INVALID')
3879: LOOP
3880: l_start2 := dbms_utility.get_time;
3881: l_ddl_str := 'ALTER PACKAGE ' || y.owner || '.' || y.object_name ||
3882: ' COMPILE BODY';
3883: Debug(l_ddl_str);
3884:

Line 3887: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');

3883: Debug(l_ddl_str);
3884:
3885: BEGIN
3886: EXECUTE IMMEDIATE l_ddl_str;
3887: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');
3888:
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: Debug(SQLCODE || ':::' || SQLERRM);

Line 3892: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');

3888:
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: Debug(SQLCODE || ':::' || SQLERRM);
3892: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');
3893: END;
3894: END LOOP;
3895: END IF;
3896: END LOOP;

Line 3898: Debug('Elapsed Time (Recompile_Dependencies): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

3894: END LOOP;
3895: END IF;
3896: END LOOP;
3897:
3898: Debug('Elapsed Time (Recompile_Dependencies): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
3899: END Recompile_Dependencies;
3900: -- ==========================End of Recompile_Dependencies=======================
3901:
3902: