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

Line 270: p_meter_keys_arr IN DBMS_SQL.NUMBER_TABLE)

266: p_reading_time IN DATE,
267: p_incr_tag_value IN NUMBER,
268: p_prev_reading_time IN DATE,
269: p_frequency IN NUMBER,
270: p_meter_keys_arr IN DBMS_SQL.NUMBER_TABLE)
271: IS
272: v_from_time DATE;
273: v_processed_flag VARCHAR2(1) := 'N';
274: v_system_id NUMBER := -99999;

Line 353: -- TYPE DBMS_SQL.NUMBER_TABLE IS TABLE OF NUMBER;

349: **************************************************************************** */
350:
351: PROCEDURE LOAD_ACT_METER_RAW_TO_READINGS(p_curr_partition IN NUMBER)
352: IS
353: -- TYPE DBMS_SQL.NUMBER_TABLE IS TABLE OF NUMBER;
354:
355:
356: -- Fetch raw data for active tags from the patition
357: -- ordered by TAG_CODE, READING_TIME

Line 396: v_meter_fk_key_array DBMS_SQL.NUMBER_TABLE;

392: v_raw_tab_name VARCHAR2(30) := 'MTH_TAG_METER_READINGS_RAW';
393: v_curr_partition NUMBER := p_curr_partition;
394: v_prev_tag_code VARCHAR2(255) := NULL;
395: v_curr_tag_code VARCHAR2(255) := NULL;
396: v_meter_fk_key_array DBMS_SQL.NUMBER_TABLE;
397: v_err_code VARCHAR2(255);
398: v_lookup_entry_exist boolean;
399: v_prev_reading_time DATE := NULL;
400: v_prev_tag_value NUMBER := NULL;

Line 731: p_to_time IN DATE) RETURN DBMS_SQL.NUMBER_TABLE

727: FUNCTION getCompValuesForSFT(p_entity_fk_key IN NUMBER,
728: p_entity_type IN VARCHAR2,
729: p_component_value IN VARCHAR2,
730: p_from_time IN DATE,
731: p_to_time IN DATE) RETURN DBMS_SQL.NUMBER_TABLE
732: IS
733: CURSOR c_getShifts(p_entity_type IN VARCHAR2, p_entity_fk_key IN VARCHAR2,
734: p_from_time IN DATE, p_to_time IN DATE) IS
735: SELECT from_date, To_Date, availability_flag

Line 744: v_comp_values DBMS_SQL.NUMBER_TABLE;

740: from_date <= p_to_time
741: ORDER BY from_date;
742:
743: v_shifts shift_array_type;
744: v_comp_values DBMS_SQL.NUMBER_TABLE;
745:
746: v_num_elements NUMBER;
747: v_from_time DATE := p_from_time;
748: v_to_time DATE;

Line 959: RETURN DBMS_SQL.NUMBER_TABLE

955: p_entity_type IN VARCHAR2,
956: p_component_value IN VARCHAR2,
957: p_from_time IN DATE,
958: p_to_time IN DATE)
959: RETURN DBMS_SQL.NUMBER_TABLE
960: IS
961: CURSOR c_getEquipStatusTime(p_equip_fk_key IN VARCHAR2,
962: p_from_time IN DATE,
963: p_to_time IN DATE) IS

Line 974: v_comp_values DBMS_SQL.NUMBER_TABLE;

970: actual_to_date IS NOT NULL
971: ORDER BY actual_from_date;
972:
973: v_status status_array_type;
974: v_comp_values DBMS_SQL.NUMBER_TABLE;
975:
976: --v_num_elements NUMBER;
977: v_from_time DATE := p_from_time;
978: v_to_time DATE;

Line 1182: RETURN DBMS_SQL.NUMBER_TABLE

1178:
1179: FUNCTION getCompValuesForMeter(p_meter_fk_key IN NUMBER,
1180: p_from_time IN DATE,
1181: p_to_time IN DATE)
1182: RETURN DBMS_SQL.NUMBER_TABLE
1183: IS
1184: CURSOR c_getMeterReadings(p_meter_fk_key IN NUMBER,
1185: p_from_time IN DATE,
1186: p_to_time IN DATE) IS

Line 1196: v_comp_values DBMS_SQL.NUMBER_TABLE;

1192: from_time <= p_to_time
1193: ORDER BY from_time;
1194:
1195: v_meter_readings readings_array_type;
1196: v_comp_values DBMS_SQL.NUMBER_TABLE;
1197:
1198: v_num_elements NUMBER;
1199: v_from_time DATE := p_from_time;
1200: v_to_time DATE;

Line 1281: RETURN DBMS_SQL.NUMBER_TABLE

1277: p_entity_type IN VARCHAR2,
1278: p_component_value IN VARCHAR2,
1279: p_from_time IN DATE,
1280: p_to_time IN DATE)
1281: RETURN DBMS_SQL.NUMBER_TABLE
1282: IS
1283: CURSOR c_get_custom_api IS
1284:
1285: SELECT DESCRIPTION

Line 1292: v_comp_values DBMS_SQL.NUMBER_TABLE;

1288: LOOKUP_TYPE ='MTH_CUSTOM_PLSQL_API';
1289:
1290: v_api_name VARCHAR2(200) := NULL;
1291: v_stmt VARCHAR2(4000);
1292: v_comp_values DBMS_SQL.NUMBER_TABLE;
1293:
1294: v_num_elements NUMBER;
1295: v_from_time DATE := p_from_time;
1296: v_to_time DATE;

Line 1405: * return value is DBMS_SQL.NUMBER_TABLE *

1401: * p_to_time - the ending point of time to *
1402: * calculate the virtual meter *
1403: * Return Value :List of values of the components for each hour *
1404: * within the from time and to time. The type of the *
1405: * return value is DBMS_SQL.NUMBER_TABLE *
1406: **************************************************************************** */
1407:
1408: FUNCTION calculate_virtual_component(p_component_type IN VARCHAR2,
1409: p_component_value IN VARCHAR2,

Line 1414: RETURN DBMS_SQL.NUMBER_TABLE

1410: p_entity_type IN VARCHAR2,
1411: p_entity_fk_key IN VARCHAR2,
1412: p_from_time IN DATE,
1413: p_to_time IN DATE)
1414: RETURN DBMS_SQL.NUMBER_TABLE
1415:
1416: IS
1417: v_comp_values DBMS_SQL.NUMBER_TABLE;
1418: v_num_elements NUMBER;

Line 1417: v_comp_values DBMS_SQL.NUMBER_TABLE;

1413: p_to_time IN DATE)
1414: RETURN DBMS_SQL.NUMBER_TABLE
1415:
1416: IS
1417: v_comp_values DBMS_SQL.NUMBER_TABLE;
1418: v_num_elements NUMBER;
1419: v_from_time DATE := p_from_time;
1420: v_end_from_time DATE := p_to_time - 1/24;
1421: v_one_hour NUMBER := 1/24;

Line 1426: -- v_comp_values := DBMS_SQL.NUMBER_TABLE(v_num_elements);

1422: i NUMBER := 1;
1423: v_value NUMBER;
1424: BEGIN
1425: v_num_elements := Trunc((p_to_time - p_from_time) * 24) + 1;
1426: -- v_comp_values := DBMS_SQL.NUMBER_TABLE(v_num_elements);
1427: IF (p_component_type = 'CONST') THEN
1428: -- 1. Support CONST type component
1429: v_value := To_Number(p_component_value);
1430: WHILE (v_from_time <= v_end_from_time) LOOP

Line 1570: DBMS_SQL.DEFINE_COLUMN(p_cursor, 1, v_usageValue);

1566: BEGIN
1567:
1568:
1569: -- 1. Construct the dynamic sql statement to calculate virtual meter formula
1570: DBMS_SQL.DEFINE_COLUMN(p_cursor, 1, v_usageValue);
1571:
1572: FOR i IN 1..p_components.Count LOOP
1573: DBMS_SQL.BIND_VARIABLE(p_cursor, ':' || i,
1574: p_components(i).comp_time_series_values(p_idx));

Line 1573: DBMS_SQL.BIND_VARIABLE(p_cursor, ':' || i,

1569: -- 1. Construct the dynamic sql statement to calculate virtual meter formula
1570: DBMS_SQL.DEFINE_COLUMN(p_cursor, 1, v_usageValue);
1571:
1572: FOR i IN 1..p_components.Count LOOP
1573: DBMS_SQL.BIND_VARIABLE(p_cursor, ':' || i,
1574: p_components(i).comp_time_series_values(p_idx));
1575: END LOOP;
1576:
1577: dummy := DBMS_SQL.EXECUTE(p_cursor);

Line 1577: dummy := DBMS_SQL.EXECUTE(p_cursor);

1573: DBMS_SQL.BIND_VARIABLE(p_cursor, ':' || i,
1574: p_components(i).comp_time_series_values(p_idx));
1575: END LOOP;
1576:
1577: dummy := DBMS_SQL.EXECUTE(p_cursor);
1578: IF DBMS_SQL.FETCH_ROWS(p_cursor)>0 THEN
1579: -- get column values of the row
1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );
1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);

Line 1578: IF DBMS_SQL.FETCH_ROWS(p_cursor)>0 THEN

1574: p_components(i).comp_time_series_values(p_idx));
1575: END LOOP;
1576:
1577: dummy := DBMS_SQL.EXECUTE(p_cursor);
1578: IF DBMS_SQL.FETCH_ROWS(p_cursor)>0 THEN
1579: -- get column values of the row
1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );
1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);
1582: END IF;

Line 1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );

1576:
1577: dummy := DBMS_SQL.EXECUTE(p_cursor);
1578: IF DBMS_SQL.FETCH_ROWS(p_cursor)>0 THEN
1579: -- get column values of the row
1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );
1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);
1582: END IF;
1583:
1584: --DBMS_SQL.CLOSE_CURSOR(c);

Line 1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);

1577: dummy := DBMS_SQL.EXECUTE(p_cursor);
1578: IF DBMS_SQL.FETCH_ROWS(p_cursor)>0 THEN
1579: -- get column values of the row
1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );
1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);
1582: END IF;
1583:
1584: --DBMS_SQL.CLOSE_CURSOR(c);
1585: RETURN v_usageValue;

Line 1584: --DBMS_SQL.CLOSE_CURSOR(c);

1580: -- Dbms_Output.put_line( ' DBMS_SQL.FETCH_ROWS(c)>0 : ' );
1581: DBMS_SQL.COLUMN_VALUE(p_cursor, 1, v_usageValue);
1582: END IF;
1583:
1584: --DBMS_SQL.CLOSE_CURSOR(c);
1585: RETURN v_usageValue;
1586: /*
1587: EXCEPTION WHEN OTHERS THEN
1588: IF DBMS_SQL.IS_OPEN(c) THEN

Line 1588: IF DBMS_SQL.IS_OPEN(c) THEN

1584: --DBMS_SQL.CLOSE_CURSOR(c);
1585: RETURN v_usageValue;
1586: /*
1587: EXCEPTION WHEN OTHERS THEN
1588: IF DBMS_SQL.IS_OPEN(c) THEN
1589: DBMS_SQL.CLOSE_CURSOR(c);
1590: END IF;
1591:
1592: RETURN v_usageValue;

Line 1589: DBMS_SQL.CLOSE_CURSOR(c);

1585: RETURN v_usageValue;
1586: /*
1587: EXCEPTION WHEN OTHERS THEN
1588: IF DBMS_SQL.IS_OPEN(c) THEN
1589: DBMS_SQL.CLOSE_CURSOR(c);
1590: END IF;
1591:
1592: RETURN v_usageValue;
1593: */

Line 1661: c := DBMS_SQL.OPEN_CURSOR;

1657: p_components(i).component_pk_key;
1658: END LOOP;
1659: v_stmt := v_stmt || ' FROM DUAL)';
1660:
1661: c := DBMS_SQL.OPEN_CURSOR;
1662: DBMS_SQL.PARSE(c, v_stmt, DBMS_SQL.NATIVE);
1663:
1664: -- 2. Calculate the virtual meter for each hour available
1665: FOR i IN 1..v_numElements LOOP

Line 1662: DBMS_SQL.PARSE(c, v_stmt, DBMS_SQL.NATIVE);

1658: END LOOP;
1659: v_stmt := v_stmt || ' FROM DUAL)';
1660:
1661: c := DBMS_SQL.OPEN_CURSOR;
1662: DBMS_SQL.PARSE(c, v_stmt, DBMS_SQL.NATIVE);
1663:
1664: -- 2. Calculate the virtual meter for each hour available
1665: FOR i IN 1..v_numElements LOOP
1666: v_usage_value := calVirtualMeter(c, p_components, i);

Line 1680: DBMS_SQL.CLOSE_CURSOR(c);

1676: v_hour_start_time := v_hour_start_time + 1/24;
1677:
1678:
1679: END LOOP;
1680: DBMS_SQL.CLOSE_CURSOR(c);
1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: -- v_err_code := 'Failed to calculate the virtual meter between ' ||

Line 1696: DBMS_SQL.CLOSE_CURSOR(c);

1692: ( MODULE, error_code, error_msg, timestamp) VALUES
1693: ('MTH_SUSTAIN_ASPECT_PKG.cal_save_virtual_meter',
1694: v_err_code, v_err_msg, SYSDATE);
1695:
1696: DBMS_SQL.CLOSE_CURSOR(c);
1697:
1698:
1699: END cal_save_virtual_meter;
1700: