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.CSI_CTR_GEN_UTILITY_PVT dependencies on CSI_CTR_GEN_UTILITY_PVT

Line 1: PACKAGE BODY CSI_CTR_GEN_UTILITY_PVT AS

1: PACKAGE BODY CSI_CTR_GEN_UTILITY_PVT AS
2: /* $Header: csivctub.pls 120.9.12020000.2 2012/10/16 05:00:12 dsingire ship $ */
3:
4: -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivctub.pls';

Line 4: -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';

1: PACKAGE BODY CSI_CTR_GEN_UTILITY_PVT AS
2: /* $Header: csivctub.pls 120.9.12020000.2 2012/10/16 05:00:12 dsingire ship $ */
3:
4: -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivctub.pls';
6:
7: FUNCTION G_MISS_NUM RETURN NUMBER IS
8: BEGIN

Line 860: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: -- Read the debug profiles values in to global variable 7197402
860: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863:
864: IF FND_API.to_Boolean( p_init_msg_list )

Line 981: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);

977: END LOOP;
978:
979: l_sqlstr := l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
980:
981: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
982:
983: l_cursor_handle := dbms_sql.open_cursor;
984: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);

Line 1184: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1180: BEGIN
1181: SAVEPOINT dump_ctr_grp_rec;
1182:
1183: -- Read the debug profiles values in to global variable 7197402
1184: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1185:
1186: PUT_LINE (' ');
1187: PUT_LINE ('Dumping the values for Counter Groups Record:');
1188: PUT_LINE (' ');

Line 1239: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1235: BEGIN
1236: SAVEPOINT dump_ctr_grp_tbl;
1237:
1238: -- Read the debug profiles values in to global variable 7197402
1239: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1240:
1241: IF p_counter_groups_tbl.COUNT > 0 THEN
1242: FOR tab_row IN p_counter_groups_tbl.FIRST .. p_counter_groups_tbl.LAST
1243: LOOP

Line 1306: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1302: BEGIN
1303: SAVEPOINT dump_ctr_template_rec;
1304:
1305: -- Read the debug profiles values in to global variable 7197402
1306: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1307:
1308: PUT_LINE (' ');
1309: PUT_LINE ('Dumping the values for Counter Template Record:');
1310: PUT_LINE (' ');

Line 1406: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1402: BEGIN
1403: SAVEPOINT dump_ctr_template_tbl;
1404:
1405: -- Read the debug profiles values in to global variable 7197402
1406: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1407:
1408: IF p_counter_template_tbl.COUNT > 0 THEN
1409: FOR tab_row IN p_counter_template_tbl.FIRST .. p_counter_template_tbl.LAST
1410: LOOP

Line 1513: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1509: BEGIN
1510: SAVEPOINT dump_ctr_item_assoc_rec;
1511:
1512: -- Read the debug profiles values in to global variable 7197402
1513: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1514:
1515: PUT_LINE (' ');
1516: PUT_LINE ('Dumping the values for Counter Item Association Record:');
1517: PUT_LINE (' ');

Line 1572: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1568: BEGIN
1569: SAVEPOINT dump_ctr_item_assoc_tbl;
1570:
1571: -- Read the debug profiles values in to global variable 7197402
1572: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1573:
1574: IF p_ctr_item_associations_tbl.COUNT > 0 THEN
1575: FOR tab_row IN p_ctr_item_associations_tbl.FIRST .. p_ctr_item_associations_tbl.LAST
1576: LOOP

Line 1639: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1635: BEGIN
1636: SAVEPOINT dump_ctr_relationship_rec;
1637:
1638: -- Read the debug profiles values in to global variable 7197402
1639: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1640:
1641: PUT_LINE (' ');
1642: PUT_LINE ('Dumping the values for Counter Relationships Record:');
1643: PUT_LINE (' ');

Line 1695: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1691: BEGIN
1692: SAVEPOINT dump_ctr_relationship_tbl;
1693:
1694: -- Read the debug profiles values in to global variable 7197402
1695: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1696:
1697: IF p_counter_relationships_tbl.COUNT > 0 THEN
1698: FOR tab_row IN p_counter_relationships_tbl.FIRST .. p_counter_relationships_tbl.LAST
1699: LOOP

Line 1758: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1754: BEGIN
1755: SAVEPOINT dump_ctr_property_template_rec;
1756:
1757: -- Read the debug profiles values in to global variable 7197402
1758: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1759:
1760: PUT_LINE (' ');
1761: PUT_LINE ('Dumping the values for Counter Property Template Record:');
1762: PUT_LINE (' ');

Line 1818: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1814: BEGIN
1815: SAVEPOINT dump_ctr_property_template_tbl;
1816:
1817: -- Read the debug profiles values in to global variable 7197402
1818: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1819:
1820: IF p_ctr_property_template_tbl.COUNT > 0 THEN
1821: FOR tab_row IN p_ctr_property_template_tbl.FIRST .. p_ctr_property_template_tbl.LAST
1822: LOOP

Line 1884: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1880: BEGIN
1881: SAVEPOINT dm_ctr_estimation_methods_rec;
1882:
1883: -- Read the debug profiles values in to global variable 7197402
1884: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1885:
1886: PUT_LINE (' ');
1887: PUT_LINE ('Dumping the values for Counter Estimation Methods Record:');
1888: PUT_LINE (' ');

Line 1938: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1934: BEGIN
1935: SAVEPOINT dm_ctr_estimation_methods_tbl;
1936:
1937: -- Read the debug profiles values in to global variable 7197402
1938: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1939:
1940: IF p_ctr_estimation_methods_tbl.COUNT > 0 THEN
1941: FOR tab_row IN p_ctr_estimation_methods_tbl.FIRST .. p_ctr_estimation_methods_tbl.LAST
1942: LOOP

Line 2000: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1996: BEGIN
1997: SAVEPOINT dump_ctr_derived_filters_rec;
1998:
1999: -- Read the debug profiles values in to global variable 7197402
2000: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2001:
2002: PUT_LINE (' ');
2003: PUT_LINE ('Dumping the values for Counter Derived Filters Record:');
2004: PUT_LINE (' ');

Line 2056: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2052: BEGIN
2053: SAVEPOINT dump_ctr_derived_filters_tbl;
2054:
2055: -- Read the debug profiles values in to global variable 7197402
2056: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2057:
2058: IF p_ctr_derived_filters_tbl.COUNT > 0 THEN
2059: FOR tab_row IN p_ctr_derived_filters_tbl.FIRST .. p_ctr_derived_filters_tbl.LAST
2060: LOOP

Line 2120: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2116: BEGIN
2117: SAVEPOINT dump_counter_instance_rec;
2118:
2119: -- Read the debug profiles values in to global variable 7197402
2120: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2121:
2122: PUT_LINE (' ');
2123: PUT_LINE ('Dumping the values for Counter Instance Record:');
2124: PUT_LINE (' ');

Line 2219: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2215: BEGIN
2216: SAVEPOINT dump_counter_instance_tbl;
2217:
2218: -- Read the debug profiles values in to global variable 7197402
2219: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2220:
2221: IF p_counter_instance_tbl.COUNT > 0 THEN
2222: FOR tab_row IN p_counter_instance_tbl.FIRST .. p_counter_instance_tbl.LAST
2223: LOOP

Line 2324: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2320: BEGIN
2321: SAVEPOINT dump_ctr_properties_rec;
2322:
2323: -- Read the debug profiles values in to global variable 7197402
2324: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2325:
2326: PUT_LINE (' ');
2327: PUT_LINE ('Dumping the values for Counter Properties Record:');
2328: PUT_LINE (' ');

Line 2383: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2379: BEGIN
2380: SAVEPOINT dump_ctr_properties_tbl;
2381:
2382: -- Read the debug profiles values in to global variable 7197402
2383: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2384:
2385: IF p_ctr_properties_tbl.COUNT > 0 THEN
2386: FOR tab_row IN p_ctr_properties_tbl.FIRST .. p_ctr_properties_tbl.LAST
2387: LOOP

Line 2450: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2446: BEGIN
2447: SAVEPOINT dump_counter_associations_rec;
2448:
2449: -- Read the debug profiles values in to global variable 7197402
2450: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2451:
2452: PUT_LINE (' ');
2453: PUT_LINE ('Dumping the values for Counter Instance Association Record:');
2454: PUT_LINE (' ');

Line 2504: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2500: BEGIN
2501: SAVEPOINT dump_counter_associations_tbl;
2502:
2503: -- Read the debug profiles values in to global variable 7197402
2504: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2505:
2506: IF p_counter_associations_tbl.COUNT > 0 THEN
2507: FOR tab_row IN p_counter_associations_tbl.FIRST .. p_counter_associations_tbl.LAST
2508: LOOP

Line 2565: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2561: BEGIN
2562: SAVEPOINT dump_counter_readings_rec;
2563:
2564: -- Read the debug profiles values in to global variable 7197402
2565: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2566:
2567: PUT_LINE (' ');
2568: PUT_LINE ('Dumping the values for Counter Readings Record:');
2569: PUT_LINE (' ');

Line 2649: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2645: BEGIN
2646: SAVEPOINT dump_counter_readings_tbl;
2647:
2648: -- Read the debug profiles values in to global variable 7197402
2649: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2650:
2651: IF p_counter_readings_tbl.COUNT > 0 THEN
2652: FOR tab_row IN p_counter_readings_tbl.FIRST .. p_counter_readings_tbl.LAST
2653: LOOP

Line 2746: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2742: BEGIN
2743: SAVEPOINT dump_ctr_property_readings_rec;
2744:
2745: -- Read the debug profiles values in to global variable 7197402
2746: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2747:
2748: PUT_LINE (' ');
2749: PUT_LINE ('Dumping the values for Counter Property Readings Record:');
2750: PUT_LINE (' ');

Line 2799: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2795: BEGIN
2796: SAVEPOINT dump_ctr_property_readings_tbl;
2797:
2798: -- Read the debug profiles values in to global variable 7197402
2799: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2800:
2801: IF p_ctr_property_readings_tbl.COUNT > 0 THEN
2802: FOR tab_row IN p_ctr_property_readings_tbl.FIRST .. p_ctr_property_readings_tbl.LAST
2803: LOOP

Line 2857: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2853: BEGIN
2854: SAVEPOINT dump_ctr_usage_forecast_rec;
2855:
2856: -- Read the debug profiles values in to global variable 7197402
2857: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2858:
2859: PUT_LINE (' ');
2860: PUT_LINE ('Dumping the values for Counter Usage Forecast Record:');
2861: PUT_LINE (' ');

Line 2891: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2887: BEGIN
2888: SAVEPOINT dump_ctr_usage_forecast_tbl;
2889:
2890: -- Read the debug profiles values in to global variable 7197402
2891: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2892:
2893: IF p_ctr_usage_forecast_tbl.COUNT > 0 THEN
2894: FOR tab_row IN p_ctr_usage_forecast_tbl.FIRST .. p_ctr_usage_forecast_tbl.LAST
2895: LOOP

Line 2934: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2930: BEGIN
2931: SAVEPOINT dump_ctr_reading_lock_rec;
2932:
2933: -- Read the debug profiles values in to global variable 7197402
2934: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2935:
2936: PUT_LINE (' ');
2937: PUT_LINE ('Dumping the values for Counter Reading Lock Record:');
2938: PUT_LINE (' ');

Line 2966: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2962: BEGIN
2963: SAVEPOINT dump_ctr_reading_lock_tbl;
2964:
2965: -- Read the debug profiles values in to global variable 7197402
2966: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2967:
2968: IF p_ctr_reading_lock_tbl.COUNT > 0 THEN
2969: FOR tab_row IN p_ctr_reading_lock_tbl.FIRST .. p_ctr_reading_lock_tbl.LAST
2970: LOOP

Line 3003: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2999: BEGIN
3000: SAVEPOINT dm_ctr_estimated_readings_rec;
3001:
3002: -- Read the debug profiles values in to global variable 7197402
3003: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3004:
3005: PUT_LINE (' ');
3006: PUT_LINE ('Dumping the values for Counter Estimated Readings Record:');
3007: PUT_LINE (' ');

Line 3057: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3053: BEGIN
3054: SAVEPOINT dm_ctr_estimated_readings_tbl;
3055:
3056: -- Read the debug profiles values in to global variable 7197402
3057: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3058:
3059: IF p_ctr_estimated_readings_tbl.COUNT > 0 THEN
3060: FOR tab_row IN p_ctr_estimated_readings_tbl.FIRST .. p_ctr_estimated_readings_tbl.LAST
3061: LOOP

Line 3118: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3114: BEGIN
3115: SAVEPOINT dm_ctr_readings_interface_rec;
3116:
3117: -- Read the debug profiles values in to global variable 7197402
3118: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3119:
3120: PUT_LINE (' ');
3121: PUT_LINE ('Dumping the values for Counter Readings Open Interface Record:');
3122: PUT_LINE (' ');

Line 3201: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3197: BEGIN
3198: SAVEPOINT dm_ctr_readings_interface_tbl;
3199:
3200: -- Read the debug profiles values in to global variable 7197402
3201: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3202:
3203: IF p_ctr_readings_interface_tbl.COUNT > 0 THEN
3204: FOR tab_row IN p_ctr_readings_interface_tbl.FIRST .. p_ctr_readings_interface_tbl.LAST
3205: LOOP

Line 3289: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3285: BEGIN
3286: SAVEPOINT dm_ctr_read_prop_interface_rec;
3287:
3288: -- Read the debug profiles values in to global variable 7197402
3289: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3290:
3291: PUT_LINE (' ');
3292: PUT_LINE ('Dumping the values for Counter Readings Properties Interface Record:');
3293: PUT_LINE (' ');

Line 3341: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3337: BEGIN
3338: SAVEPOINT dm_ctr_read_prop_interface_tbl;
3339:
3340: -- Read the debug profiles values in to global variable 7197402
3341: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3342:
3343: IF p_ctr_read_prop_interface_tbl.COUNT > 0 THEN
3344: FOR tab_row IN p_ctr_read_prop_interface_tbl.FIRST .. p_ctr_read_prop_interface_tbl.LAST
3345: LOOP

Line 3402: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3398: -- Standard Start of API savepoint
3399: -- SAVEPOINT dump_txn_rec;
3400:
3401: -- Read the debug profiles values in to global variable 7197402
3402: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3403:
3404: put_line(' ');
3405: put_line('Dumping the values for Transaction Record:');
3406: put_line(' ');