APPS.EAM_METER_READINGS_JSP dependencies on EAM_METER_READINGS

Line 1: package body EAM_METER_READINGS_JSP AS

1: package body EAM_METER_READINGS_JSP AS
2: /* $Header: EAMMRRJB.pls 115.8 2002/11/19 23:53:49 aan ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_METER_READINGS_JSP';
4:
5: -------------------------------------------------------------------------------

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_METER_READINGS_JSP';

1: package body EAM_METER_READINGS_JSP AS
2: /* $Header: EAMMRRJB.pls 115.8 2002/11/19 23:53:49 aan ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_METER_READINGS_JSP';
4:
5: -------------------------------------------------------------------------------
6: -- check if work order has mandatory meter reading
7: FUNCTION has_mandatory_meter_reading( p_wip_entity_id in number) RETURN VARCHAR2

Line 48: from eam_meter_readings mr4

44: l_meter_reading_id := null;
45:
46: -- fix for bug 2112310. Adding following two select statements for better performance
47: select max(mr4.current_reading_date) into l_last_reading_date
48: from eam_meter_readings mr4
49: where mr4.meter_id = p_meter_id;
50:
51: select max(meter_reading_id) as meter_reading_id into l_meter_reading_id
52: from eam_meter_readings

Line 52: from eam_meter_readings

48: from eam_meter_readings mr4
49: where mr4.meter_id = p_meter_id;
50:
51: select max(meter_reading_id) as meter_reading_id into l_meter_reading_id
52: from eam_meter_readings
53: where meter_id = p_meter_id and
54: current_reading_date = l_last_reading_date;
55:
56: /* COMMENTING DUE TO BUG 2112310

Line 61: eam_meter_readings mr5,

57: -- first get the greatest reading date
58: SELECT max(mr5.meter_reading_id) as meter_reading_id
59: into l_meter_reading_id
60: FROM
61: eam_meter_readings mr5,
62: (select max(mr4.current_reading_date) as last_reading_date
63: from eam_meter_readings mr4
64: where mr4.meter_id = p_meter_id
65: group by mr4.meter_id

Line 63: from eam_meter_readings mr4

59: into l_meter_reading_id
60: FROM
61: eam_meter_readings mr5,
62: (select max(mr4.current_reading_date) as last_reading_date
63: from eam_meter_readings mr4
64: where mr4.meter_id = p_meter_id
65: group by mr4.meter_id
66: ) mr3
67: WHERE mr5.meter_id = p_meter_id

Line 78: --- insert a meter reading row into eam_meter_readings table

74: END get_latest_meter_reading_id;
75:
76:
77: -------------------------------------------------------------------------
78: --- insert a meter reading row into eam_meter_readings table
79: -------------------------------------------------------------------------
80: procedure insert_row
81: (
82: p_meter_id IN NUMBER

Line 95: select eam_meter_readings_s.nextval

91: l_reading_id NUMBER;
92:
93: BEGIN
94:
95: select eam_meter_readings_s.nextval
96: into l_reading_id
97: from dual;
98:
99: insert into eam_meter_readings

Line 99: insert into eam_meter_readings

95: select eam_meter_readings_s.nextval
96: into l_reading_id
97: from dual;
98:
99: insert into eam_meter_readings
100: (
101: meter_reading_id,
102: meter_id,
103: current_reading,

Line 366: from eam_meter_readings

362:
363: if( FND_API.TO_BOOLEAN(p_before)) then
364: select max(current_reading_date)
365: into l_reading_date
366: from eam_meter_readings
367: where meter_id = p_meter_id and
368: current_reading_date <= p_reading_date -- use <= here
369: group by meter_id;
370: else

Line 373: from eam_meter_readings

369: group by meter_id;
370: else
371: select min(current_reading_date)
372: into l_reading_date
373: from eam_meter_readings
374: where meter_id = p_meter_id and
375: current_reading_date > p_reading_date -- interesting, use >
376: group by meter_id;
377: end if;

Line 383: from eam_meter_readings

379: if(l_reading_date is not null) then
380: -- should always success, just in case that two reading have the same date
381: select max(meter_reading_id)
382: into l_reading_id
383: from eam_meter_readings
384: where meter_id = p_meter_id and current_reading_date = l_reading_date
385: group by meter_id;
386:
387: select life_to_date_reading, current_reading

Line 389: from eam_meter_readings

385: group by meter_id;
386:
387: select life_to_date_reading, current_reading
388: into l_ltd_reading, l_reading
389: from eam_meter_readings
390: where meter_reading_id = l_reading_id;
391: end if;
392:
393: x_reading_id := l_reading_id;

Line 546: eam_meter_readings_jsp.get_current_reading_data(

542: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_MRR_DATE_EXIST'
543: ,p_token1 => 'METER_NAME', p_value1 => l_meter_name);
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: else
546: eam_meter_readings_jsp.get_current_reading_data(
547: p_reading => p_reading,
548: p_reading_change => p_reading_change,
549: p_reset_flag => p_reset_flag,
550: p_meter_direction => l_meter_direction,

Line 633: end EAM_METER_READINGS_JSP;

629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630:
631: END add_meter_reading;
632:
633: end EAM_METER_READINGS_JSP;