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 3017: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3013: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3014: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3015: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3016: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3017: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3018: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3019: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3020:
3021: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3035: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3031: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3032: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3033: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3034: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3035: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3036: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3037: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3038:
3039: l_output_dir VARCHAR2(512);

Line 3242: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3238: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3239: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3240: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3241: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3242: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3243: , p_eam_request_tbl => l_eam_request_tbl
3244: , x_eam_wo_rec => l_out_eam_wo_rec
3245: , x_eam_op_tbl => l_out_eam_op_tbl
3246: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3259: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3255: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3256: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3257: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3258: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3259: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3260: , x_eam_request_tbl => l_out_eam_request_tbl
3261: , x_return_status => x_return_status
3262: , x_msg_count => x_msg_count
3263: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3336: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3332: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3333: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3334: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3335: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3336: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3337: , p_eam_request_tbl => l_eam_request_tbl
3338: , x_eam_wo_rec => l_out_eam_wo_rec
3339: , x_eam_op_tbl => l_out_eam_op_tbl
3340: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3353: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3349: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3350: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3351: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3352: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3353: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3354: , x_eam_request_tbl => l_out_eam_request_tbl
3355: , x_return_status => x_return_status
3356: , x_msg_count => x_msg_count
3357: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3479: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3475: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3476: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3477: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3478: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3479: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3480: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3481: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3482:
3483: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3497: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3493: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3494: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3495: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3496: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3497: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3498: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3499: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3500:
3501: l_output_dir VARCHAR2(512);

Line 3632: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3628: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3629: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3630: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3631: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3632: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3633: , p_eam_request_tbl => l_eam_request_tbl
3634: , x_eam_wo_rec => l_out_eam_wo_rec
3635: , x_eam_op_tbl => l_out_eam_op_tbl
3636: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 3649: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3645: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3646: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3647: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3648: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
3649: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3650: , x_eam_request_tbl => l_out_eam_request_tbl
3651: , x_return_status => x_return_status
3652: , x_msg_count => x_msg_count
3653: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 3892: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3888: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3889: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3890: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3891: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3892: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3893: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3894: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3895:
3896: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3910: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3906: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3907: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3908: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3909: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3910: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3911: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3912: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3913:
3914: l_output_dir VARCHAR2(512);

Line 3983: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

3979: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
3980: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
3981: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
3982: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
3983: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
3984: , p_eam_request_tbl => l_eam_request_tbl
3985: , x_eam_wo_rec => l_out_eam_wo_rec
3986: , x_eam_op_tbl => l_out_eam_op_tbl
3987: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4000: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

3996: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
3997: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
3998: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
3999: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4000: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4001: , x_eam_request_tbl => l_out_eam_request_tbl
4002: , x_return_status => l_return_status
4003: , x_msg_count => x_msg_count
4004: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4077: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4073: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4074: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4075: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4076: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4077: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4078: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4079: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4080:
4081: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4095: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4091: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4092: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4093: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4094: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4095: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4096: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4097: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4098:
4099: l_output_dir VARCHAR2(512);

Line 4152: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

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

Line 4169: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

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

Line 4441: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4437: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4438: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4439: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4440: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4441: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4442: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4443: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4444:
4445: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4459: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4455: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4456: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4457: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4458: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4459: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4460: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4461: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4462:
4463: l_mssg_token_tbl_type EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 4536: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4532: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4533: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4534: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4535: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4536: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4537: , p_eam_request_tbl => l_eam_request_tbl
4538: , x_eam_wo_rec => l_out_eam_wo_rec
4539: , x_eam_op_tbl => l_out_eam_op_tbl
4540: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4553: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4549: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4550: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4551: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4552: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4553: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4554: , x_eam_request_tbl => l_out_eam_request_tbl
4555: , x_return_status => x_error_flag
4556: , x_msg_count => l_msg_count
4557: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 4595: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4591: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4592: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4593: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4594: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4595: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4596: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4597: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4598:
4599: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 4613: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

4609: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
4610: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
4611: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
4612: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
4613: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
4614: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
4615: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
4616:
4617: l_mssg_token_tbl_type EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 4663: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

4659: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
4660: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
4661: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
4662: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
4663: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
4664: , p_eam_request_tbl => l_eam_request_tbl
4665: , x_eam_wo_rec => l_out_eam_wo_rec
4666: , x_eam_op_tbl => l_out_eam_op_tbl
4667: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 4680: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

4676: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
4677: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
4678: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
4679: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
4680: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
4681: , x_eam_request_tbl => l_out_eam_request_tbl
4682: , x_return_status => x_error_flag
4683: , x_msg_count => l_msg_count
4684: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 5022: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5018: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5019: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5020: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5021: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5022: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5023: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5024: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5025:
5026: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 5040: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5036: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5037: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5038: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5039: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5040: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5041: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5042: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5043:
5044: l_output_dir VARCHAR2(512);

Line 5095: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

5091: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
5092: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
5093: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
5094: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
5095: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
5096: , p_eam_request_tbl => l_eam_request_tbl
5097: , x_eam_wo_rec => l_out_eam_wo_rec
5098: , x_eam_op_tbl => l_out_eam_op_tbl
5099: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 5112: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

5108: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
5109: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
5110: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
5111: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
5112: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
5113: , x_eam_request_tbl => l_out_eam_request_tbl
5114: , x_return_status => l_return_status
5115: , x_msg_count => l_msg_count
5116: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 5190: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5186: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5187: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5188: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5189: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5190: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5191: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5192: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5193:
5194: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 5208: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5204: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5205: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5206: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5207: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5208: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5209: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5210: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5211:
5212: l_output_dir VARCHAR2(512);

Line 5249: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

5245: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
5246: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
5247: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
5248: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
5249: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
5250: , p_eam_request_tbl => l_eam_request_tbl
5251: , x_eam_wo_rec => l_out_eam_wo_rec
5252: , x_eam_op_tbl => l_out_eam_op_tbl
5253: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 5266: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

5262: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
5263: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
5264: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
5265: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
5266: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
5267: , x_eam_request_tbl => l_out_eam_request_tbl
5268: , x_return_status => x_return_status
5269: , x_msg_count => x_msg_count
5270: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 5304: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

5300: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
5301: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
5302: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
5303: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
5304: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
5305: , p_eam_request_tbl => l_eam_request_tbl
5306: , x_eam_wo_rec => l_out_eam_wo_rec
5307: , x_eam_op_tbl => l_out_eam_op_tbl
5308: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 5321: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

5317: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
5318: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
5319: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
5320: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
5321: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
5322: , x_eam_request_tbl => l_out_eam_request_tbl
5323: , x_return_status => x_return_status
5324: , x_msg_count => x_msg_count
5325: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')

Line 5393: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5389: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5390: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5391: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5392: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5393: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5394: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5395: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5396:
5397: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 5411: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

5407: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
5408: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
5409: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
5410: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
5411: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
5412: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
5413: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
5414:
5415: l_output_dir VARCHAR2(512);

Line 5479: , p_eam_op_comp_tbl => l_eam_op_comp_tbl

5475: , p_eam_meter_reading_tbl => l_eam_meter_reading_tbl
5476: , p_eam_counter_prop_tbl => l_eam_counter_prop_tbl
5477: , p_eam_wo_comp_rebuild_tbl => l_eam_wo_comp_rebuild_tbl
5478: , p_eam_wo_comp_mr_read_tbl => l_eam_wo_comp_mr_read_tbl
5479: , p_eam_op_comp_tbl => l_eam_op_comp_tbl
5480: , p_eam_request_tbl => l_eam_request_tbl
5481: , x_eam_wo_rec => l_out_eam_wo_rec
5482: , x_eam_op_tbl => l_out_eam_op_tbl
5483: , x_eam_op_network_tbl => l_out_eam_op_network_tbl

Line 5496: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl

5492: , x_eam_meter_reading_tbl => l_out_eam_meter_reading_tbl
5493: , x_eam_counter_prop_tbl => l_out_eam_counter_prop_tbl
5494: , x_eam_wo_comp_rebuild_tbl => l_out_eam_wo_comp_rebuild_tbl
5495: , x_eam_wo_comp_mr_read_tbl => l_out_eam_wo_comp_mr_read_tbl
5496: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
5497: , x_eam_request_tbl => l_out_eam_request_tbl
5498: , x_return_status => x_return_status
5499: , x_msg_count => x_msg_count
5500: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')