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.7.12010000.2 2008/10/31 21:28:21 rsinn 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.7.12010000.2 2008/10/31 21:28:21 rsinn 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 977: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);

973: END LOOP;
974:
975: l_sqlstr := l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
976:
977: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
978:
979: l_cursor_handle := dbms_sql.open_cursor;
980: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
981: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);

Line 1180: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1235: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1302: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1402: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1509: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1568: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1635: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1691: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1754: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1814: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1880: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1934: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 1996: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2052: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2116: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2215: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2320: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2379: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2446: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2500: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2561: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2645: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2742: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2795: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2853: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2887: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2930: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2962: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 2999: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3053: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3114: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3197: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3285: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3337: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

Line 3398: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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