DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on EAM_OP_COMP

Line 267: from eam_op_completion_txns

263:
264: IF p_transaction_type = 2 THEN
265: select actual_start_date ,actual_end_date ,actual_duration
266: into l_act_st_date ,l_act_end_date,l_act_duration
267: from eam_op_completion_txns
268: where
269: wip_entity_id = p_wip_entity_id and
270: operation_seq_num = p_operation_seq_num and
271: transaction_type = 1 and

Line 273: from eam_op_completion_txns

269: wip_entity_id = p_wip_entity_id and
270: operation_seq_num = p_operation_seq_num and
271: transaction_type = 1 and
272: last_update_date = (select max(last_update_date)
273: from eam_op_completion_txns
274: where wip_entity_id = p_wip_entity_id and
275: operation_seq_num = p_operation_seq_num and
276: transaction_type = 1);
277:

Line 383: eam_op_comp.op_comp(

379: -- how to compute date by interval, how many hours a day???
380: l_actual_end_date := l_act_st_date + (l_act_duration/24);
381:
382: begin
383: eam_op_comp.op_comp(
384: -- p_api_version => p_api_version,
385: -- p_init_msg_list => p_init_msg_list,
386: -- p_commit => p_commit,
387: -- p_validation_level => p_validation_level,

Line 556: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

552: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
553: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
554: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
555: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
556: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
557: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
558: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
559:
560: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 574: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

570: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
571: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
572: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
573: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
574: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
575: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
576: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
577:
578: l_output_dir VARCHAR2(512);

Line 753: from eam_op_completion_txns

749: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
750:
751:
752: select max(transaction_id) into l_transaction_id
753: from eam_op_completion_txns
754: where wip_entity_id = p_wip_entity_id
755: and operation_seq_num = p_old_op_seq_num;
756:
757: update eam_op_completion_txns

Line 757: update eam_op_completion_txns

753: from eam_op_completion_txns
754: where wip_entity_id = p_wip_entity_id
755: and operation_seq_num = p_old_op_seq_num;
756:
757: update eam_op_completion_txns
758: set handover_operation_seq_num = p_new_op_seq_num
759: where wip_entity_id = p_wip_entity_id
760: and operation_seq_num = p_old_op_seq_num
761: and transaction_id = l_transaction_id;

Line 844: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

840: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
841: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
842: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
843: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
844: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
845: , p_eam_request_tbl => l_eam_request_tbl
846: , x_eam_wo_rec => l_out_eam_wo_rec
847: , x_eam_op_tbl => l_out_eam_op_tbl
848: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 861: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

857: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
858: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
859: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
860: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
861: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
862: , x_eam_request_tbl => l_out_eam_request_tbl
863: , x_return_status => x_return_status
864: , x_msg_count => x_msg_count
865: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 1307: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1303: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1304: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1305: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1306: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1307: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1308: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1309: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1310:
1311: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1325: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1321: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1322: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1323: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1324: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1325: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1326: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1327: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1328:
1329: l_output_dir VARCHAR2(512);

Line 1622: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

1618: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
1619: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
1620: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
1621: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
1622: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
1623: , p_eam_request_tbl => l_eam_request_tbl
1624: , x_eam_wo_rec => l_out_eam_wo_rec
1625: , x_eam_op_tbl => l_out_eam_op_tbl
1626: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 1639: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

1635: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
1636: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
1637: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
1638: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
1639: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
1640: , x_eam_request_tbl => l_out_eam_request_tbl
1641: , x_return_status => x_return_status
1642: , x_msg_count => x_msg_count
1643: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 1930: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1926: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1927: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1928: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1929: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1930: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1931: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1932: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1933:
1934: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 1948: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

1944: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1945: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1946: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1947: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1948: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1949: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1950: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1951:
1952:

Line 2092: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

2088: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
2089: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
2090: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
2091: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
2092: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
2093: , p_eam_request_tbl => l_eam_request_tbl
2094: , x_eam_wo_rec => l_out_eam_wo_rec
2095: , x_eam_op_tbl => l_out_eam_op_tbl
2096: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 2109: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

2105: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
2106: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
2107: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
2108: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
2109: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2110: , x_eam_request_tbl => l_out_eam_request_tbl
2111: , x_return_status => x_return_status
2112: , x_msg_count => x_msg_count
2113: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 2174: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

2170: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
2171: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
2172: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
2173: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
2174: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
2175: , p_eam_request_tbl => l_eam_request_tbl
2176: , x_eam_wo_rec => l_out_eam_wo_rec
2177: , x_eam_op_tbl => l_out_eam_op_tbl
2178: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 2191: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

2187: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
2188: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
2189: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
2190: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
2191: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2192: , x_eam_request_tbl => l_out_eam_request_tbl
2193: , x_return_status => x_return_status
2194: , x_msg_count => x_msg_count
2195: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 2550: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2546: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2547: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2548: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2549: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2550: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2551: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2552: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2553:
2554: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 2568: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2564: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2565: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2566: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2567: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2568: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2569: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2570: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2571:
2572: l_output_dir VARCHAR2(512);

Line 2752: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

2748: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
2749: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
2750: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
2751: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
2752: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
2753: , p_eam_request_tbl => l_eam_request_tbl
2754: , x_eam_wo_rec => l_out_eam_wo_rec
2755: , x_eam_op_tbl => l_out_eam_op_tbl
2756: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 2769: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

2765: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
2766: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
2767: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
2768: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
2769: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2770: , x_eam_request_tbl => l_out_eam_request_tbl
2771: , x_return_status => x_return_status
2772: , x_msg_count => x_msg_count
2773: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 2827: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

2823: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
2824: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
2825: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
2826: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
2827: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
2828: , p_eam_request_tbl => l_eam_request_tbl
2829: , x_eam_wo_rec => l_out_eam_wo_rec
2830: , x_eam_op_tbl => l_out_eam_op_tbl
2831: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 2844: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

2840: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
2841: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
2842: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
2843: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
2844: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2845: , x_eam_request_tbl => l_out_eam_request_tbl
2846: , x_return_status => x_return_status
2847: , x_msg_count => x_msg_count
2848: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 2969: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2965: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2966: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2967: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2968: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2969: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2970: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2971: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2972:
2973: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 2987: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2983: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2984: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2985: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2986: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2987: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2988: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2989: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2990:
2991: l_output_dir VARCHAR2(512);

Line 3122: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3118: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3119: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3120: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3121: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3122: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3123: , p_eam_request_tbl => l_eam_request_tbl
3124: , x_eam_wo_rec => l_out_eam_wo_rec
3125: , x_eam_op_tbl => l_out_eam_op_tbl
3126: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3139: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3135: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3136: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3137: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3138: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3139: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3140: , x_eam_request_tbl => l_out_eam_request_tbl
3141: , x_return_status => x_return_status
3142: , x_msg_count => x_msg_count
3143: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3382: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3378: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3379: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3380: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3381: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3382: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3383: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3384: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3385:
3386: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3400: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3396: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3397: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3398: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3399: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3400: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3401: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3402: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3403:
3404: l_output_dir VARCHAR2(512);

Line 3473: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3469: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3470: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3471: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3472: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3473: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3474: , p_eam_request_tbl => l_eam_request_tbl
3475: , x_eam_wo_rec => l_out_eam_wo_rec
3476: , x_eam_op_tbl => l_out_eam_op_tbl
3477: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3490: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3486: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3487: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3488: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3489: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3490: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3491: , x_eam_request_tbl => l_out_eam_request_tbl
3492: , x_return_status => l_return_status
3493: , x_msg_count => x_msg_count
3494: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3567: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3563: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3564: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3565: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3566: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3567: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3568: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3569: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3570:
3571: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3585: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3581: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3582: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3583: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3584: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3585: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3586: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3587: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3588:
3589: l_output_dir VARCHAR2(512);

Line 3642: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3638: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3639: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3640: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3641: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3642: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3643: , p_eam_request_tbl => l_eam_request_tbl
3644: , x_eam_wo_rec => l_out_eam_wo_rec
3645: , x_eam_op_tbl => l_out_eam_op_tbl
3646: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3659: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3655: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3656: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3657: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3658: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3659: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3660: , x_eam_request_tbl => l_out_eam_request_tbl
3661: , x_return_status => l_return_status
3662: , x_msg_count => x_msg_count
3663: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3931: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3927: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3928: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3929: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3930: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3931: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3932: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3933: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3934:
3935: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3949: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3945: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3946: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3947: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3948: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3949: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3950: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3951: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3952:
3953: l_mssg_token_tbl_type EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 4026: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4022: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4023: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4024: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4025: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4026: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4027: , p_eam_request_tbl => l_eam_request_tbl
4028: , x_eam_wo_rec => l_out_eam_wo_rec
4029: , x_eam_op_tbl => l_out_eam_op_tbl
4030: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4043: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4039: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4040: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4041: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4042: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4043: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4044: , x_eam_request_tbl => l_out_eam_request_tbl
4045: , x_return_status => x_error_flag
4046: , x_msg_count => l_msg_count
4047: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4085: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4081: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4082: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4083: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4084: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4085: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4086: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4087: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4088:
4089: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4103: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4099: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4100: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4101: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4102: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4103: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4104: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4105: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4106:
4107: l_mssg_token_tbl_type EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 4153: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4149: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4150: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4151: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4152: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4153: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4154: , p_eam_request_tbl => l_eam_request_tbl
4155: , x_eam_wo_rec => l_out_eam_wo_rec
4156: , x_eam_op_tbl => l_out_eam_op_tbl
4157: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4170: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4166: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4167: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4168: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4169: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4170: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4171: , x_eam_request_tbl => l_out_eam_request_tbl
4172: , x_return_status => x_error_flag
4173: , x_msg_count => l_msg_count
4174: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4512: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4508: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4509: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4510: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4511: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4512: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4513: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4514: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4515:
4516: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4530: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4526: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4527: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4528: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4529: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4530: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4531: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4532: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4533:
4534: l_output_dir VARCHAR2(512);

Line 4585: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4581: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4582: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4583: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4584: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4585: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4586: , p_eam_request_tbl => l_eam_request_tbl
4587: , x_eam_wo_rec => l_out_eam_wo_rec
4588: , x_eam_op_tbl => l_out_eam_op_tbl
4589: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4602: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4598: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4599: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4600: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4601: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4602: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4603: , x_eam_request_tbl => l_out_eam_request_tbl
4604: , x_return_status => l_return_status
4605: , x_msg_count => l_msg_count
4606: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4680: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4676: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4677: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4678: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4679: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4680: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4681: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4682: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4683:
4684: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4698: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4694: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4695: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4696: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4697: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4698: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4699: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4700: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4701:
4702: l_output_dir VARCHAR2(512);

Line 4739: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4735: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4736: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4737: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4738: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4739: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4740: , p_eam_request_tbl => l_eam_request_tbl
4741: , x_eam_wo_rec => l_out_eam_wo_rec
4742: , x_eam_op_tbl => l_out_eam_op_tbl
4743: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4756: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4752: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4753: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4754: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4755: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4756: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4757: , x_eam_request_tbl => l_out_eam_request_tbl
4758: , x_return_status => x_return_status
4759: , x_msg_count => x_msg_count
4760: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4794: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4790: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4791: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4792: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4793: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4794: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4795: , p_eam_request_tbl => l_eam_request_tbl
4796: , x_eam_wo_rec => l_out_eam_wo_rec
4797: , x_eam_op_tbl => l_out_eam_op_tbl
4798: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4811: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4807: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4808: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4809: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4810: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4811: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4812: , x_eam_request_tbl => l_out_eam_request_tbl
4813: , x_return_status => x_return_status
4814: , x_msg_count => x_msg_count
4815: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4883: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4879: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4880: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4881: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4882: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4883: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4884: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4885: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4886:
4887: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4901: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4897: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4898: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4899: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4900: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4901: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4902: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4903: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4904:
4905: l_output_dir VARCHAR2(512);

Line 4969: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4965: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4966: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4967: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4968: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4969: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4970: , p_eam_request_tbl => l_eam_request_tbl
4971: , x_eam_wo_rec => l_out_eam_wo_rec
4972: , x_eam_op_tbl => l_out_eam_op_tbl
4973: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4986: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4982: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4983: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4984: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4985: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4986: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4987: , x_eam_request_tbl => l_out_eam_request_tbl
4988: , x_return_status => x_return_status
4989: , x_msg_count => x_msg_count
4990: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')