22:
23:
24: PROCEDURE EXPLODE_ACTIVITY
25: ( p_validation_level IN NUMBER
26: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
23:
24: PROCEDURE EXPLODE_ACTIVITY
25: ( p_validation_level IN NUMBER
26: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
24: PROCEDURE EXPLODE_ACTIVITY
25: ( p_validation_level IN NUMBER
26: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
25: ( p_validation_level IN NUMBER
26: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
26: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
27: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
28: , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
29: , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
30: , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
31: , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
32: , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
33: , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
34: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
42: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
35: , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
42: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
43: , x_return_status OUT NOCOPY VARCHAR2
36: , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
42: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
43: , x_return_status OUT NOCOPY VARCHAR2
44: )
37: , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
38: , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
39: , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
40: , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
41: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
42: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
43: , x_return_status OUT NOCOPY VARCHAR2
44: )
45: IS
48: l_routing_available CHAR := 'N';
49: l_wip_entity_id NUMBER;
50: l_organization_id NUMBER;
51:
52: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
49: l_wip_entity_id NUMBER;
50: l_organization_id NUMBER;
51:
52: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
50: l_organization_id NUMBER;
51:
52: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
51:
52: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
52: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
53: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
54: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
55: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
56: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
57: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
59: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
60: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
61:
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
62: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type := p_eam_wo_rec;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
70: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type := p_eam_op_tbl;
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
70: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
71:
64: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type := p_eam_op_network_tbl;
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
70: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
71:
72: /* Error Handling Variables */
65: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type := p_eam_res_tbl;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
70: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
71:
72: /* Error Handling Variables */
73: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type ;
66: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type := p_eam_res_inst_tbl;
67: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type := p_eam_sub_res_tbl;
68: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type := p_eam_res_usage_tbl;
69: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
70: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
71:
72: /* Error Handling Variables */
73: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type ;
74: l_mesg_token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;