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.EAM_METR_VALIDATOR dependencies on EAM_METER_READINGS_INTERFACE

Line 9: from eam_meter_readings_interface

5: p_interface_id in number) is
6: l_disable_flag varchar2(1);
7: begin
8: select disable_flag into l_disable_flag
9: from eam_meter_readings_interface
10: where rowid=p_current_rowid;
11:
12: if (l_disable_flag is null or l_disable_flag='N') then
13: populate_reading(p_current_rowid, p_interface_id);

Line 51: from eam_meter_readings_interface

47: end if;
48:
49: select reading_value, reading_change, meter_id, reading_date
50: into l_current_reading, l_reading_change, l_meter_id, l_reading_date
51: from eam_meter_readings_interface
52: where rowid=p_current_rowid;
53:
54: if (l_current_reading is null) then
55: if (l_reading_change is null) then

Line 77: update eam_meter_readings_interface

73: end if;
74:
75: l_current_reading:=l_last_reading+l_reading_change;
76:
77: update eam_meter_readings_interface
78: set reading_value=l_current_reading
79: where rowid=p_current_rowid;
80: end if;
81: end if;

Line 99: from eam_meter_readings_interface

95: begin
96: l_user_id:=fnd_global.user_id;
97: select created_by, last_updated_by, creation_date, last_update_date
98: into l_created_by, l_last_updated_by, l_creation_date, l_last_update_date
99: from eam_meter_readings_interface
100: where rowid=p_current_rowid;
101:
102: IF (l_created_by IS NOT NULL
103: AND l_last_updated_by IS NOT NULL

Line 126: update eam_meter_readings_interface

122: if (l_last_update_date is null) then
123: l_last_update_date:=sysdate;
124: end if;
125:
126: update eam_meter_readings_interface
127: set created_by=l_created_by,
128: last_updated_by=l_last_updated_by,
129: creation_date=l_creation_date,
130: last_update_date=l_last_update_date

Line 146: 'eam_meter_readings_interface mri',

142: begin
143: eam_int_utils.derive_id_from_code(
144: p_current_rowid,
145: p_interface_id,
146: 'eam_meter_readings_interface mri',
147: 'LAST_UPDATED_BY',
148: 'LAST_UPDATED_BY_NAME',
149: '(SELECT USER_ID
150: FROM FND_USER

Line 180: 'eam_meter_readings_interface mri',

176: begin
177: eam_int_utils.derive_id_from_code(
178: p_current_rowid,
179: p_interface_id,
180: 'eam_meter_readings_interface mri',
181: 'CREATED_BY',
182: 'CREATED_BY_NAME',
183: '(SELECT USER_ID
184: FROM FND_USER

Line 214: from eam_meter_readings_interface

210: x_org_code varchar2(3);
211: x_eam_enabled varchar2(1) := null;
212: begin
213: select organization_code into x_org_code
214: from eam_meter_readings_interface
215: where rowid = p_current_rowid;
216:
217: if ( x_org_code is null ) then
218: return;

Line 237: 'eam_meter_readings_interface mri',

233:
234: eam_int_utils.derive_id_from_code(
235: p_current_rowid,
236: p_interface_id,
237: 'eam_meter_readings_interface mri',
238: 'ORGANIZATION_ID',
239: 'ORGANIZATION_CODE',
240: '(SELECT ORGANIZATION_ID
241: FROM ORG_ORGANIZATION_DEFINITIONS

Line 260: from eam_meter_readings_interface

256: x_org_id number := null;
257: x_eam_enabled varchar2(1) := null;
258: begin
259: select organization_id into x_org_id
260: from eam_meter_readings_interface
261: where rowid = p_current_rowid;
262: if ( x_org_id is null ) then
263: return;
264: end if;

Line 313: from eam_meter_readings_interface

309: wip_entity_id
310: into x_org_id,
311: x_work_order_name,
312: x_wip_entity_id
313: from eam_meter_readings_interface
314: where rowid = p_current_rowid;
315:
316: if ( x_work_order_name is not null AND
317: x_wip_entity_id is null AND

Line 328: 'eam_meter_readings_interface mri',

324:
325: eam_int_utils.derive_id_from_code(
326: p_current_rowid,
327: p_interface_id,
328: 'eam_meter_readings_interface mri',
329: 'WIP_ENTITY_ID',
330: 'WORK_ORDER_NAME',
331: '(SELECT WIP_ENTITY_ID
332: FROM WIP_ENTITIES

Line 342: from eam_meter_readings_interface

338: -- now make sure that wip entity id is valid if not null
339: x_wip_entity_id := null;
340: select wip_entity_id
341: into x_wip_entity_id
342: from eam_meter_readings_interface
343: where rowid = p_current_rowid;
344: if ( x_wip_entity_id is null ) then
345: return;
346: end if;

Line 351: 'eam_meter_readings_interface mri',

347:
348: if ( NOT eam_int_utils.request_matches_condition(
349: p_current_rowid,
350: p_interface_id,
351: 'eam_meter_readings_interface mri',
352: 'exists (select 1
353: from wip_discrete_jobs wdj, eam_asset_meters eam, wip_entities we
354: where wdj.wip_entity_id = mri.wip_entity_id
355: and wdj.organization_id = mri.organization_id

Line 378: 'eam_meter_readings_interface mri',

374: p_retcode := '0';
375: eam_int_utils.derive_id_from_code(
376: p_current_rowid,
377: p_interface_id,
378: 'eam_meter_readings_interface mri',
379: 'METER_ID',
380: 'METER_NAME',
381: '(SELECT METER_ID
382: FROM EAM_METERS

Line 392: 'eam_meter_readings_interface mri',

388:
389: eam_int_utils.derive_code_from_id(
390: p_current_rowid,
391: p_interface_id,
392: 'eam_meter_readings_interface mri',
393: 'METER_ID',
394: 'METER_NAME',
395: '(SELECT METER_NAME
396: FROM EAM_METERS

Line 404: eam_int_utils.load_errors('eam_meter_readings_interface');

400: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'
401: );
402:
403: if ( eam_int_utils.has_errors ) then
404: eam_int_utils.load_errors('eam_meter_readings_interface');
405: update eam_meter_readings_interface
406: set process_status = WIP_CONSTANTS.ERROR,
407: process_phase = WIP_CONSTANTS.ML_VALIDATION
408: where rowid = p_current_rowid;

Line 405: update eam_meter_readings_interface

401: );
402:
403: if ( eam_int_utils.has_errors ) then
404: eam_int_utils.load_errors('eam_meter_readings_interface');
405: update eam_meter_readings_interface
406: set process_status = WIP_CONSTANTS.ERROR,
407: process_phase = WIP_CONSTANTS.ML_VALIDATION
408: where rowid = p_current_rowid;
409: p_retcode := '2';

Line 422: from eam_meter_readings_interface

418: begin
419: p_retcode := '0';
420:
421: select meter_name into x_meter_name
422: from eam_meter_readings_interface
423: where rowid = p_current_rowid;
424: -- if meter name is already specified, then we don't need to
425: -- validate it again.
426: if ( x_meter_name is not null ) then

Line 445: eam_int_utils.load_errors('eam_meter_readings_interface');

441: 'EAM',
442: 'EAM_MR_INVALID_METER');
443:
444: if ( eam_int_utils.has_errors ) then
445: eam_int_utils.load_errors('eam_meter_readings_interface');
446: update eam_meter_readings_interface
447: set process_status = WIP_CONSTANTS.ERROR,
448: process_phase = WIP_CONSTANTS.ML_VALIDATION
449: where rowid = p_current_rowid;

Line 446: update eam_meter_readings_interface

442: 'EAM_MR_INVALID_METER');
443:
444: if ( eam_int_utils.has_errors ) then
445: eam_int_utils.load_errors('eam_meter_readings_interface');
446: update eam_meter_readings_interface
447: set process_status = WIP_CONSTANTS.ERROR,
448: process_phase = WIP_CONSTANTS.ML_VALIDATION
449: where rowid = p_current_rowid;
450: p_retcode := '2';

Line 513: 'eam_meter_readings_interface mri',

509:
510: eam_int_utils.warn_irrelevant_column(
511: p_current_rowid,
512: p_interface_id,
513: 'eam_meter_readings_interface mri',
514: 'LIFE_TO_DATE_READING',
515: 'mri.reset_flag = ''Y''');
516:
517: -- now default the life to date reading to the previous entry

Line 525: from eam_meter_readings_interface

521: reset_flag
522: into x_meter_id,
523: x_reading_date,
524: x_reset_flag
525: from eam_meter_readings_interface
526: where rowid = p_current_rowid;
527:
528: if ( x_reset_flag is null OR x_reset_flag <> 'Y' ) then
529: return;

Line 553: update eam_meter_readings_interface

549: eam_int_utils.record_error(p_interface_id,
550: fnd_message.get,
551: FALSE);
552: else
553: update eam_meter_readings_interface
554: set life_to_date_reading = x_ltd
555: where rowid = p_current_rowid;
556: end if;
557: end reset_flag;

Line 587: 'eam_meter_readings_interface',

583: -- would rarely happen.
584: eam_int_utils.warn_redundant_column(
585: p_current_rowid,
586: p_interface_id,
587: 'eam_meter_readings_interface',
588: 'life_to_date_reading',
589: 'reading_value',
590: 'reset_flag <> ''Y''');
591:

Line 604: from eam_meter_readings_interface mri,

600: x_meter_id,
601: x_meter_type,
602: x_reading_date,
603: x_value_change_dir
604: from eam_meter_readings_interface mri,
605: eam_meters em
606: where mri.meter_id = em.meter_id
607: and mri.rowid = p_current_rowid;
608:

Line 687: update eam_meter_readings_interface

683: end if;
684: -- default the ltd reading
685:
686:
687: update eam_meter_readings_interface
688: -- set life_to_date_reading = x_pre_ltd + x_reading_value - x_pre_reading
689: set life_to_date_reading = l_ltd
690: where rowid = p_current_rowid;
691: x_ltd_defaulted := true;

Line 711: update eam_meter_readings_interface

707:
708: -- default the ltd reading
709: if ( NOT x_ltd_defaulted ) then
710:
711: update eam_meter_readings_interface
712: --set life_to_date_reading = x_next_ltd + x_reading_value - x_next_reading
713: set life_to_date_reading = l_ltd
714: where rowid = p_current_rowid;
715: x_ltd_defaulted := true;

Line 720: update eam_meter_readings_interface

716: end if;
717: end if;
718:
719: if ( NOT x_ltd_defaulted ) then
720: update eam_meter_readings_interface
721: -- set life_to_date_reading = x_reading_value
722: set life_to_date_reading = l_ltd
723: where rowid = p_current_rowid;
724: end if;

Line 775: from eam_meter_readings_interface mri,

771: x_reading_date,
772: x_reset_flag,
773: x_meter_id,
774: x_value_change_dir
775: from eam_meter_readings_interface mri,
776: eam_meters em
777: where mri.meter_id = em.meter_id
778: and mri.rowid = p_current_rowid;
779:

Line 835: update eam_meter_readings_interface

831: OR (x_value_change_dir = 2 AND x_pre_reading < x_ltd_reading) ) then
832: x_rule_broken := true;
833: end if;
834: if ( x_reset_flag <> 'Y' ) then
835: update eam_meter_readings_interface
836: set reading_value = x_pre_reading + x_ltd_reading - x_pre_ltd
837: where rowid = p_current_rowid;
838: x_defaulted := true;
839: end if;

Line 848: update eam_meter_readings_interface

844: OR (x_value_change_dir = 2 AND x_next_ltd > x_ltd_reading) ) then
845: x_rule_broken := true;
846: end if;
847: if ( x_reset_flag <> 'Y' AND (NOT x_defaulted) ) then
848: update eam_meter_readings_interface
849: set reading_value = x_next_reading + x_ltd_reading - x_next_ltd
850: where rowid = p_current_rowid;
851: end if;
852: end if;