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 1146: l_start := dbms_utility.get_time;

1142: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1143: -- --------------------------------------------------------------
1144: -- Recreate unique indexes and rebuild nonunique indexes.
1145: -- --------------------------------------------------------------
1146: l_start := dbms_utility.get_time;
1147: dbms_application_info.set_module(
1148: module_name => p_module_name,
1149: action_name => 'Post: Rebuild Indexes'
1150: );

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

1163: dbms_application_info.set_module(
1164: module_name => p_module_name,
1165: action_name => 'Post: Analyze Tables'
1166: );
1167: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1168: l_start := dbms_utility.get_time;
1169: Debug('Analyze the mirror table...');
1170:
1171: dbms_stats.gather_table_stats(

Line 1168: l_start := dbms_utility.get_time;

1164: module_name => p_module_name,
1165: action_name => 'Post: Analyze Tables'
1166: );
1167: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1168: l_start := dbms_utility.get_time;
1169: Debug('Analyze the mirror table...');
1170:
1171: dbms_stats.gather_table_stats(
1172: ownname => p_pv_schema_name,

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

1174: estimate_percent => 10,
1175: method_opt => 'FOR ALL INDEXES'
1176: );
1177:
1178: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1179: l_start := dbms_utility.get_time;
1180:
1181: -- --------------------------------------------------------------
1182: -- Rename synonyms.

Line 1179: l_start := dbms_utility.get_time;

1175: method_opt => 'FOR ALL INDEXES'
1176: );
1177:
1178: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1179: l_start := dbms_utility.get_time;
1180:
1181: -- --------------------------------------------------------------
1182: -- Rename synonyms.
1183: -- --------------------------------------------------------------

Line 1620: l_total_start := dbms_utility.get_time;

1616: -- *****************************************************************
1617: -- Currency Attributes Refresh
1618: -- *****************************************************************
1619: -- *****************************************************************
1620: l_total_start := dbms_utility.get_time;
1621:
1622: Debug('-- **********************************************************');
1623: Debug('-- Processing internal CURRENCY attributes...');
1624: Debug('-- **********************************************************');

Line 1639: l_start := dbms_utility.get_time;

1635: -- will be "rolled back".
1636: -- -----------------------------------------------------------------
1637: FOR x IN c_currency_attrs LOOP
1638: BEGIN
1639: l_start := dbms_utility.get_time;
1640:
1641: -- --------------------------------------------------------------
1642: -- Full Refresh
1643: -- --------------------------------------------------------------

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

1752:
1753: l_total_rows := l_total_rows + SQL%ROWCOUNT;
1754: END IF;
1755:
1756: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1757:
1758: EXCEPTION
1759: WHEN FND_API.G_EXC_ERROR THEN
1760: -- -------------------------------------------------------------------

Line 1836: l_start := dbms_utility.get_time;

1832: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1833: -- --------------------------------------------------------------------------
1834: -- Process NUMBER return_type.
1835: -- --------------------------------------------------------------------------
1836: l_start := dbms_utility.get_time;
1837: Debug('-- **********************************************************');
1838: Debug('-- Processing Internal Number attributes...');
1839: Debug('-- **********************************************************');
1840:

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

1940: END LOOP;
1941:
1942: COMMIT;
1943:
1944: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1945:
1946:
1947: -- --------------------------------------------------------------------------
1948: -- Process return_types other than NUMBER and CURRENCY.

Line 1950: l_start := dbms_utility.get_time;

1946:
1947: -- --------------------------------------------------------------------------
1948: -- Process return_types other than NUMBER and CURRENCY.
1949: -- --------------------------------------------------------------------------
1950: l_start := dbms_utility.get_time;
1951: Debug('-- **********************************************************');
1952: Debug('-- Processing internal OTHER attributes...');
1953: Debug('-- **********************************************************');
1954: dbms_application_info.set_module(

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

2061: END LOOP;
2062:
2063: COMMIT;
2064:
2065: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2066:
2067:
2068:
2069: -- *****************************************************************

Line 2078: l_start := dbms_utility.get_time;

2074: ELSE
2075: -- --------------------------------------------------------------------------
2076: -- Process Internal NUMBER return_type.
2077: -- --------------------------------------------------------------------------
2078: l_start := dbms_utility.get_time;
2079: Debug('-- **********************************************************');
2080: Debug('-- Processing internal NUMBER attributes...');
2081: Debug('-- **********************************************************');
2082: dbms_application_info.set_module(

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

2152:
2153: Debug(SQL%ROWCOUNT || ' rows processed.');
2154: l_total_rows := l_total_rows + SQL%ROWCOUNT;
2155:
2156: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2157:
2158:
2159: -- --------------------------------------------------------------------------
2160: -- Process return_types other than NUMBER and CURRENCY.

Line 2162: l_start := dbms_utility.get_time;

2158:
2159: -- --------------------------------------------------------------------------
2160: -- Process return_types other than NUMBER and CURRENCY.
2161: -- --------------------------------------------------------------------------
2162: l_start := dbms_utility.get_time;
2163: Debug('-- **********************************************************');
2164: Debug('-- Processing internal OTHER attributes...');
2165: Debug('-- **********************************************************');
2166: dbms_application_info.set_module(

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

2243:
2244: Debug(SQL%ROWCOUNT || ' rows processed.');
2245: l_total_rows := l_total_rows + SQL%ROWCOUNT;
2246:
2247: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2248: END IF;
2249:
2250:
2251: Debug('Total Elapsed Time (Internal: ' ||

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

2248: END IF;
2249:
2250:
2251: Debug('Total Elapsed Time (Internal: ' ||
2252: (DBMS_UTILITY.get_time - l_total_start) || ' hsec');
2253: Debug('Total Number of Rows Processed for This Operation: ' || l_total_rows);
2254: Debug('Throughput: ' ||
2255: ROUND((l_total_rows/(DBMS_UTILITY.get_time - l_total_start)) * 100, 2) ||
2256: ' rows/second');

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

2251: Debug('Total Elapsed Time (Internal: ' ||
2252: (DBMS_UTILITY.get_time - l_total_start) || ' hsec');
2253: Debug('Total Number of Rows Processed for This Operation: ' || l_total_rows);
2254: Debug('Throughput: ' ||
2255: ROUND((l_total_rows/(DBMS_UTILITY.get_time - l_total_start)) * 100, 2) ||
2256: ' rows/second');
2257:
2258: EXCEPTION
2259: WHEN others THEN

Line 2387: l_start := dbms_utility.get_time;

2383:
2384: -- --------------------------------------------------------------------------
2385: -- Process NUMBER and CURRENCY return_type.
2386: -- --------------------------------------------------------------------------
2387: l_start := dbms_utility.get_time;
2388: Debug('-- **********************************************************');
2389: Debug('-- Processing External NUMBER and CURRENCY attributes...');
2390: Debug('-- **********************************************************');
2391: dbms_application_info.set_module(

Line 2439: l_start2 := dbms_utility.get_time;

2435: -- ---------------------------------------------------------------
2436: null;
2437:
2438: ELSE
2439: l_start2 := dbms_utility.get_time;
2440:
2441: IF (x.batch_sql_text IS NULL) THEN
2442: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2443: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',

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

2565: COMMIT;
2566: END IF;
2567:
2568: Debug('Elapsed Time: ' ||
2569: (DBMS_UTILITY.get_time - l_start2) || ' hsec');
2570:
2571:
2572: EXCEPTION
2573: WHEN FND_API.G_EXC_ERROR THEN

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

2690: END IF;
2691: END LOOP;
2692:
2693:
2694: Debug('Elapsed Time (NUMBER/CURRENCY): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2695:
2696: -- --------------------------------------------------------------------------
2697: -- Process return_types other than NUMBER and CURRENCY.
2698: -- --------------------------------------------------------------------------

Line 2699: l_start := dbms_utility.get_time;

2695:
2696: -- --------------------------------------------------------------------------
2697: -- Process return_types other than NUMBER and CURRENCY.
2698: -- --------------------------------------------------------------------------
2699: l_start := dbms_utility.get_time;
2700: Debug('___________________________________________________________');
2701: Debug('-- **********************************************************');
2702: Debug('-- Processing External OTHER attributes...');
2703: Debug('-- **********************************************************');

Line 2752: l_start2 := dbms_utility.get_time;

2748: null;
2749:
2750: ELSE
2751:
2752: l_start2 := dbms_utility.get_time;
2753:
2754: IF (x.batch_sql_text IS NULL) THEN
2755: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2756: p_msg_name => 'PV_ABSENT_BATCH_SQL_TEXT',

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

2811: COMMIT;
2812: END IF;
2813:
2814: Debug('Elapsed Time: ' ||
2815: (DBMS_UTILITY.get_time - l_start2) || ' hsec');
2816:
2817: EXCEPTION
2818: WHEN others THEN
2819: Debug('Error executing insert statement for "' || x.name || '"');

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

2826: END IF;
2827: END LOOP;
2828:
2829:
2830: Debug('Elapsed Time (Other): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
2831:
2832: END Insert_External;
2833: -- ======================End of Insert_External==================================
2834:

Line 3833: l_start := dbms_utility.get_time;

3829: l_start NUMBER;
3830: l_start2 NUMBER;
3831:
3832: BEGIN
3833: l_start := dbms_utility.get_time;
3834:
3835: -- -----------------------------------------------------------------------
3836: -- Determine "APPS" schema.
3837: -- -----------------------------------------------------------------------

Line 3858: l_start2 := dbms_utility.get_time;

3854: object_name = x.name AND
3855: object_type = 'PACKAGE BODY' AND
3856: status = 'INVALID')
3857: LOOP
3858: l_start2 := dbms_utility.get_time;
3859: l_ddl_str := 'ALTER PACKAGE ' || y.owner || '.' || y.object_name ||
3860: ' COMPILE BODY';
3861: Debug(l_ddl_str);
3862:

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

3861: Debug(l_ddl_str);
3862:
3863: BEGIN
3864: EXECUTE IMMEDIATE l_ddl_str;
3865: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');
3866:
3867: EXCEPTION
3868: WHEN OTHERS THEN
3869: Debug(SQLCODE || ':::' || SQLERRM);

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

3866:
3867: EXCEPTION
3868: WHEN OTHERS THEN
3869: Debug(SQLCODE || ':::' || SQLERRM);
3870: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start2) || ' hsec');
3871: END;
3872: END LOOP;
3873: END IF;
3874: END LOOP;

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

3872: END LOOP;
3873: END IF;
3874: END LOOP;
3875:
3876: Debug('Elapsed Time (Recompile_Dependencies): ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
3877: END Recompile_Dependencies;
3878: -- ==========================End of Recompile_Dependencies=======================
3879:
3880: