DBA Data[Home] [Help]

APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_PROCESS_WO_PUB

Line 39: -- p_wo_relationship_exc_tbl IN EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type

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: --

Line 49: p_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type

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:

Line 160: -- p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type Required

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

Line 162: -- p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_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

Line 164: -- p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_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

Line 166: -- p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_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: --

Line 168: -- p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type Required

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: --

Line 178: p_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type,

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

Line 179: p_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_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: )

Line 180: p_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,

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

Line 181: p_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,

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;

Line 182: p_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

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;

Line 347: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

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;

Line 348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_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;

Line 349: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_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;

Line 350: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_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;

Line 351: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_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;

Line 352: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_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;

Line 353: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_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;
357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 354: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_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;

Line 355: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_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;

Line 356: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_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;

Line 357: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_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;

Line 358: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_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;

Line 359: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_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;

Line 360: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_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:

Line 361: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_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:
365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 362: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_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;
366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 363: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_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;

Line 365: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_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;

Line 366: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_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;

Line 367: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_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;

Line 368: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_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;

Line 369: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_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;

Line 370: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_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;

Line 371: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_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;
375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 372: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_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;

Line 373: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_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;

Line 374: l_out_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_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;

Line 375: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_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;

Line 376: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_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;

Line 377: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_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;

Line 378: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_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:

Line 379: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_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:
383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;

Line 380: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_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;
384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;

Line 381: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_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;
385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;

Line 383: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_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 ;

Line 384: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_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:

Line 385: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_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:
389: l_operation_index NUMBER;

Line 386: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_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;
390: l_material_index NUMBER;

Line 387: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type ;

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;

Line 401: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;

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

Line 961: EAM_PROCESS_WO_PUB.Process_WO

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