35: -- Required Will have value of 'TRUE' if this procedure is called because Validate_Structure
36: -- returned error.
37: -- Will have value of 'FALSE' if this procedure is called because l_relationship_errors= TRUE.
38: -- (Update for one of work order in hierarchy has failed.Hence fail entired hierarchy)
39: -- p_wo_relationship_exc_tbl IN EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type
40: -- Required Table containing list of exception messages
41: --
42: -- Initial version 1.0
43: --
45:
46: PROCEDURE log_network_error_messages(p_group_id NUMBER,
47: p_top_wip_entity_id NUMBER,
48: p_validate_fail BOOLEAN,
49: p_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type
50: )
51: IS
52: temp_err_mesg VARCHAR2(4000);
53:
156: -- l_group_id IN NUMBER Required
157: -- Group Id
158: -- p_wo_rec IN EAM_WORK_ORDER_IMPORT%ROWTYPE
159: -- Required Work Order Record fetched from cursor
160: -- p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type Required
161: -- Operation out table from work order api
162: -- p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type Required
163: -- Resource out table from work order api
164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type Required
158: -- p_wo_rec IN EAM_WORK_ORDER_IMPORT%ROWTYPE
159: -- Required Work Order Record fetched from cursor
160: -- p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type Required
161: -- Operation out table from work order api
162: -- p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type Required
163: -- Resource out table from work order api
164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type Required
165: -- Resource Instance out table from work order api
166: -- p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type Required
160: -- p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type Required
161: -- Operation out table from work order api
162: -- p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type Required
163: -- Resource out table from work order api
164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type Required
165: -- Resource Instance out table from work order api
166: -- p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type Required
167: -- Resource Usage out table from work order api
168: -- p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type Required
162: -- p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type Required
163: -- Resource out table from work order api
164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type Required
165: -- Resource Instance out table from work order api
166: -- p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type Required
167: -- Resource Usage out table from work order api
168: -- p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type Required
169: -- Material out table from work order api
170: --
164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type Required
165: -- Resource Instance out table from work order api
166: -- p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type Required
167: -- Resource Usage out table from work order api
168: -- p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type Required
169: -- Material out table from work order api
170: --
171: -- Initial version 1.0
172: --
174:
175: PROCEDURE log_error_messages(p_return_status VARCHAR2,
176: p_group_id NUMBER,
177: p_wo_rec EAM_WORK_ORDER_IMPORT%ROWTYPE,
178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,
179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type,
180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
175: PROCEDURE log_error_messages(p_return_status VARCHAR2,
176: p_group_id NUMBER,
177: p_wo_rec EAM_WORK_ORDER_IMPORT%ROWTYPE,
178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,
179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type,
180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
183: )
176: p_group_id NUMBER,
177: p_wo_rec EAM_WORK_ORDER_IMPORT%ROWTYPE,
178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,
179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type,
180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
183: )
184: IS
177: p_wo_rec EAM_WORK_ORDER_IMPORT%ROWTYPE,
178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,
179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type,
180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
183: )
184: IS
185: l_msg_count NUMBER;
178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,
179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type,
180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
183: )
184: IS
185: l_msg_count NUMBER;
186: msg_index NUMBER;
343: l_output_dir VARCHAR2(255);
344: l_return_status VARCHAR2(1);
345: l_msg_count NUMBER;
346:
347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
344: l_return_status VARCHAR2(1);
345: l_msg_count NUMBER;
346:
347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
345: l_msg_count NUMBER;
346:
347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
346:
347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
364:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;
380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;
388:
381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;
388:
389: l_operation_index NUMBER;
382:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;
388:
389: l_operation_index NUMBER;
390: l_material_index NUMBER;
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;
388:
389: l_operation_index NUMBER;
390: l_material_index NUMBER;
391: l_resource_index NUMBER;
397: TYPE l_import_wo_records IS REF CURSOR RETURN EAM_WORK_ORDER_IMPORT%ROWTYPE;
398: l_import_wo l_import_wo_records;
399: l_import_wo_record EAM_WORK_ORDER_IMPORT%ROWTYPE;
400:
401: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
402:
403: l_msg_data VARCHAR2(4000);
404:
405: CURSOR import_wo_oper_cur (l_group_id NUMBER,l_wip_entity_id NUMBER) IS
957: l_eam_res_inst_tbl(l_resource_instance_index) := l_eam_res_inst_rec;
958: l_resource_instance_index := l_resource_instance_index + 1;
959: END LOOP;
960:
961: EAM_PROCESS_WO_PUB.Process_WO
962: ( p_bo_identifier => 'EAM'
963: , p_init_msg_list => TRUE
964: , p_api_version_number => 1.0
965: , p_eam_wo_rec => l_eam_wo_rec