APPS.EAM_METR_PROCESSOR dependencies on EAM_METER_READINGS

Line 20: from eam_meter_readings_interface

16: p_group_id in number,
17: p_commit in boolean default true) is
18: cursor allmeters is
19: select distinct meter_id
20: from eam_meter_readings_interface
21: where group_id = p_group_id
22: and process_phase = WIP_CONSTANTS.ML_VALIDATION
23: and process_status = WIP_CONSTANTS.RUNNING;
24:

Line 75: from eam_meter_readings_interface

71: procedure start_processing(p_group_id in number,
72: p_retcode out NOCOPY varchar2) is
73: cursor allrows is
74: select rowid, interface_id
75: from eam_meter_readings_interface
76: where group_id = p_group_id
77: and process_phase = WIP_CONSTANTS.ML_VALIDATION
78: and process_status = WIP_CONSTANTS.RUNNING;
79:

Line 88: update eam_meter_readings_interface

84: x_all_error boolean := true;
85: begin
86: p_retcode := '0';
87: -- generates the interface id and lock the rows
88: update eam_meter_readings_interface
89: set interface_id = wip_interface_s.nextval,
90: process_status = WIP_CONSTANTS.RUNNING
91: where group_id = p_group_id
92: and process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 130: from eam_meter_readings_interface

126: p_meter_id in number,
127: p_retcode out NOCOPY varchar2) is
128: cursor meter is
129: select rowid, interface_id, disable_flag, meter_id, reading_date
130: from eam_meter_readings_interface
131: where group_id = p_group_id
132: and meter_id = p_meter_id
133: and process_phase = WIP_CONSTANTS.ML_VALIDATION
134: and process_status = WIP_CONSTANTS.RUNNING

Line 162: update eam_meter_readings_interface

158: if ( eam_int_utils.has_errors ) then
159: -- rollback the default, etc.
160: rollback to savepoint eam_meter_reading_start;
161: -- set the error status for the current record
162: update eam_meter_readings_interface
163: set process_status = WIP_CONSTANTS.ERROR
164: where rowid = x_rowid;
165: -- set the return code
166: p_retcode := '2';

Line 170: update eam_meter_readings_interface

166: p_retcode := '2';
167: else
168: -- if the row passed validation, then we set the process phase
169: -- and then do the insertion
170: update eam_meter_readings_interface
171: set process_phase = WIP_CONSTANTS.ML_INSERTION
172: where rowid = x_rowid;
173:
174: if (l_disable_flag is not null and l_disable_flag='Y') then

Line 188: update eam_meter_readings_interface

184: if (l_return_status <> 'S') then
185: fnd_message.set_name('EAM', 'EAM_METINT_DISABLE_ERROR'); eam_int_utils.record_error(x_interface_id,
186: fnd_message.get,
187: FALSE);
188: update eam_meter_readings_interface
189: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
190: process_status = WIP_CONSTANTS.ERROR
191: where rowid = x_rowid;
192: else

Line 193: update eam_meter_readings_interface

189: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
190: process_status = WIP_CONSTANTS.ERROR
191: where rowid = x_rowid;
192: else
193: update eam_meter_readings_interface
194: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
195: process_status = WIP_CONSTANTS.COMPLETED
196: where rowid = x_rowid;
197: end if;

Line 201: update eam_meter_readings_interface

197: end if;
198: else
199: insert_one_row(x_rowid);
200:
201: update eam_meter_readings_interface
202: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
203: process_status = WIP_CONSTANTS.COMPLETED
204: where rowid = x_rowid;
205: end if;

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

204: where rowid = x_rowid;
205: end if;
206: end if;
207:
208: eam_int_utils.load_errors('eam_meter_readings_interface');
209: END LOOP;
210: close meter;
211:
212: end process_one_meter_data;

Line 217: insert into eam_meter_readings(

213:
214:
215: procedure insert_one_row(p_rowid rowid) is
216: begin
217: insert into eam_meter_readings(
218: meter_reading_id,
219: meter_id,
220: current_reading,
221: current_reading_date,

Line 251: select eam_meter_readings_s.nextval,

247: attribute14,
248: attribute15,
249: disable_flag
250: )
251: select eam_meter_readings_s.nextval,
252: meter_id,
253: reading_value,
254: reading_date,
255: reset_flag,

Line 283: from eam_meter_readings_interface

279: attribute13,
280: attribute14,
281: attribute15,
282: disable_flag
283: from eam_meter_readings_interface
284: where rowid = p_rowid;
285:
286: end insert_one_row;
287:

Line 295: from eam_meter_readings_interface

291: -- delete completed records
292: delete from wip_interface_errors
293: where interface_id in
294: (select interface_id
295: from eam_meter_readings_interface
296: where process_phase = WIP_CONSTANTS.ML_COMPLETE
297: and group_id = p_group_id
298: and process_status = WIP_CONSTANTS.COMPLETED);
299:

Line 300: delete from eam_meter_readings_interface

296: where process_phase = WIP_CONSTANTS.ML_COMPLETE
297: and group_id = p_group_id
298: and process_status = WIP_CONSTANTS.COMPLETED);
299:
300: delete from eam_meter_readings_interface
301: where process_phase = WIP_CONSTANTS.ML_COMPLETE
302: and group_id = p_group_id
303: and process_status = WIP_CONSTANTS.COMPLETED;
304: