DBA Data[Home] [Help]

APPS.EAM_METERREADING_UTILITY_PVT dependencies on EAM_PROCESS_WO_PUB

Line 25: p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_meter_reading_rec_type

21: ***************************************************************************/
22:
23: PROCEDURE Perform_Writes
24: (
25: p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_meter_reading_rec_type
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
28: ) IS
29: BEGIN

Line 35: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type

31: END Perform_Writes;
32:
33: PROCEDURE INSERT_ROW
34: (
35: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
39: , x_return_status OUT NOCOPY VARCHAR2

Line 36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type

32:
33: PROCEDURE INSERT_ROW
34: (
35: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
39: , x_return_status OUT NOCOPY VARCHAR2
40: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

Line 37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type

33: PROCEDURE INSERT_ROW
34: (
35: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
39: , x_return_status OUT NOCOPY VARCHAR2
40: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
41: ) IS

Line 38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type

34: (
35: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
39: , x_return_status OUT NOCOPY VARCHAR2
40: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
41: ) IS
42: l_meter_reading_rec EAM_MeterReading_PUB.Meter_Reading_Rec_Type;

Line 203: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type

199: END INSERT_ROW;
200:
201: PROCEDURE ENABLE_SOURCE_METER
202: (
203: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
204: , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
207: )IS

Line 204: , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type

200:
201: PROCEDURE ENABLE_SOURCE_METER
202: (
203: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
204: , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
207: )IS
208: l_return_status VARCHAR2(1);

Line 265: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

261: END ENABLE_SOURCE_METER;
262:
263: PROCEDURE DISABLE_COUNTER_HIERARCHY
264: (
265: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
266: , p_subinventory_id IN VARCHAR2
267: , p_wip_entity_id IN NUMBER := NULL
268: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
269: , x_return_status OUT NOCOPY VARCHAR2

Line 268: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

264: (
265: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
266: , p_subinventory_id IN VARCHAR2
267: , p_wip_entity_id IN NUMBER := NULL
268: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
269: , x_return_status OUT NOCOPY VARCHAR2
270: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
271: )IS
272: l_return_status VARCHAR2(1);

Line 278: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

274: l_msg_data VARCHAR2(2000);
275: TYPE counter_tbl IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
276: l_counter_tbl counter_tbl;
277: l_instance_id NUMBER;
278: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
279: l_count NUMBER := 0;
280:
281: /* Bug # 5255459 : Disable meter hiearchy for instances which are already removed */
282: CURSOR cur_replaced_instance IS

Line 400: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

396: END DISABLE_COUNTER_HIERARCHY;
397:
398: PROCEDURE UPDATE_ACTIVITY
399: (
400: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
401: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
402: , x_return_status OUT NOCOPY VARCHAR2
403: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
404: )IS

Line 401: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

397:
398: PROCEDURE UPDATE_ACTIVITY
399: (
400: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
401: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
402: , x_return_status OUT NOCOPY VARCHAR2
403: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
404: )IS
405:

Line 438: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');

434:
435: IF l_primary_item_id IS NULL THEN
436:
437: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
438: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');
439: END IF;
440:
441: EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY
442: (

Line 441: EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY

437: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
438: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');
439: END IF;
440:
441: EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY
442: (
443: p_organization_id => p_eam_wo_comp_rebuild_tbl(ii).organization_id
444: , p_asset_activity_id => p_eam_wo_comp_rebuild_tbl(ii).activity_id
445: , p_wip_entity_id => p_eam_wo_comp_rebuild_tbl(ii).rebuild_wip_entity_id

Line 453: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY() with return_status : ' || l_return_status);

449: , x_msg_count => l_msg_count
450: , x_msg_data => l_msg_data
451: );
452: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
453: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY() with return_status : ' || l_return_status);
454: END IF;
455:
456: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;
457:

Line 460: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY()..: ' || l_msg_data);

456: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;
457:
458: IF l_return_status <> 'S' THEN
459: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
460: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY()..: ' || l_msg_data);
461: END IF;
462: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
463: ( p_message_name => NULL
464: , p_message_text => l_msg_data

Line 501: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

497: END UPDATE_ACTIVITY;
498:
499: PROCEDURE UPDATE_GENEALOGY
500: (
501: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
502: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
505: )IS

Line 502: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

498:
499: PROCEDURE UPDATE_GENEALOGY
500: (
501: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
502: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
505: )IS
506: l_return_status VARCHAR2(1);

Line 576: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type

572:
573:
574: PROCEDURE UPDATE_LAST_SERVICE_READING
575: (
576: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
577: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
580: )IS

Line 577: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type

573:
574: PROCEDURE UPDATE_LAST_SERVICE_READING
575: (
576: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
577: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
580: )IS
581: l_return_status VARCHAR2(1);

Line 638: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

634: END UPDATE_LAST_SERVICE_READING;
635:
636: PROCEDURE UPDATE_REBUILD_WORK_ORDER
637: (
638: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
639: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
640: , x_return_status OUT NOCOPY VARCHAR2
641: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
642: )IS

Line 639: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type

635:
636: PROCEDURE UPDATE_REBUILD_WORK_ORDER
637: (
638: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
639: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
640: , x_return_status OUT NOCOPY VARCHAR2
641: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
642: )IS
643: BEGIN