35: l_err_stack VARCHAR2(250);
36: l_data VARCHAR2(250);
37: l_msg_index_out NUMBER;
38:
39: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
36: l_data VARCHAR2(250);
37: l_msg_index_out NUMBER;
38:
39: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
37: l_msg_index_out NUMBER;
38:
39: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
38:
39: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
39: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
40: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
41: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
42: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
43: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
44: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
45: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
46: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
47: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
48: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
49: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
50: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
51: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
52: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
53: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
54: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
55: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
63: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
56: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
63: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_wip_entity_id NUMBER;
57: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
63: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_wip_entity_id NUMBER;
65: --Bug3592712: Max length of workorder name is 240 char.
58: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
63: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_wip_entity_id NUMBER;
65: --Bug3592712: Max length of workorder name is 240 char.
66: l_wip_entity_name VARCHAR2(240);
59: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
60: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
62: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
63: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
64: l_wip_entity_id NUMBER;
65: --Bug3592712: Max length of workorder name is 240 char.
66: l_wip_entity_name VARCHAR2(240);
67:
80: l_parent_work_order_count number:=0;
81: l_adjust_parent varchar2(10);
82: l_row_count number :=0;
83:
84: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
85: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
81: l_adjust_parent varchar2(10);
82: l_row_count number :=0;
83:
84: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
85: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
82: l_row_count number :=0;
83:
84: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
85: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
83:
84: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
85: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
91: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
85: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
91: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
92: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
93:
86: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
91: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
92: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
93:
94: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
87: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
91: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
92: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
93:
94: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
95: l_old_rebuild_source NUMBER;
88:
89: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
90: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
91: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
92: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
93:
94: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
95: l_old_rebuild_source NUMBER;
96: l_message_text varchar2(20);
94: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
95: l_old_rebuild_source NUMBER;
96: l_message_text varchar2(20);
97:
98: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
99: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
100: l_output_dir VARCHAR2(512);
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
95: l_old_rebuild_source NUMBER;
96: l_message_text varchar2(20);
97:
98: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
99: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
100: l_output_dir VARCHAR2(512);
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
98: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
99: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
100: l_output_dir VARCHAR2(512);
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
99: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
100: l_output_dir VARCHAR2(512);
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
100: l_output_dir VARCHAR2(512);
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
101:
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
102: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
103: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
104: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
105: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
106: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
107: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
108: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
109: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
117: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
110: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
117: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
118:
111: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
117: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
118:
119: BEGIN
112: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
117: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
118:
119: BEGIN
120:
113: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
114: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
115: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
116: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
117: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
118:
119: BEGIN
120:
121: SAVEPOINT add_exist_work_order;
170: l_eam_wo_relations_rec.child_object_type_id := 1;
171: l_eam_wo_relations_rec.child_header_id :=p_wip_entity_id;
172: l_eam_wo_relations_rec.child_object_id :=p_wip_entity_id;
173: l_eam_wo_relations_rec.parent_relationship_type := p_relation_type ;
174: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
175:
176: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
177:
178: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
174: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
175:
176: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
177:
178: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
179:
180: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
181: ( p_bo_identifier => 'EAM'
182: , p_init_msg_list => TRUE
176: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
177:
178: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
179:
180: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
181: ( p_bo_identifier => 'EAM'
182: , p_init_msg_list => TRUE
183: , p_api_version_number => 1.0
184: , p_eam_wo_tbl => l_eam_wo_tbl
1107: l_maintenance_object_type number;
1108: l_maintenance_object_source number;
1109:
1110: -- Fields added for new Work Order API
1111: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1108: l_maintenance_object_source number;
1109:
1110: -- Fields added for new Work Order API
1111: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1109:
1110: -- Fields added for new Work Order API
1111: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1110: -- Fields added for new Work Order API
1111: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1111: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1112: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1113: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1114: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1115: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1116: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1117: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1118: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1119: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1120: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1121: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1122: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1123: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1124: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1125: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1126: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1127: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1128: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1136: l_wip_entity_id NUMBER;
1129: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1136: l_wip_entity_id NUMBER;
1137: --Bug3592712: Max length of workorder name is 240 char.
1130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1136: l_wip_entity_id NUMBER;
1137: --Bug3592712: Max length of workorder name is 240 char.
1138: l_wip_entity_name VARCHAR2(240);
1131: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1132: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1133: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1134: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1136: l_wip_entity_id NUMBER;
1137: --Bug3592712: Max length of workorder name is 240 char.
1138: l_wip_entity_name VARCHAR2(240);
1139:
1160: l_fail_dept_id NUMBER;
1161: l_eam_location_id NUMBER;
1162:
1163:
1164: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1161: l_eam_location_id NUMBER;
1162:
1163:
1164: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1162:
1163:
1164: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1163:
1164: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1164: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1165: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1166: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1167: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1174: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1168: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1174: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1175: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1176:
1169: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1174: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1175: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1176:
1177: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1170: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1174: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1175: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1176:
1177: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1178: l_old_rebuild_source NUMBER;
1171:
1172: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1173: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1174: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1175: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1176:
1177: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1178: l_old_rebuild_source NUMBER;
1179: l_message_text varchar2(20);
1177: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1178: l_old_rebuild_source NUMBER;
1179: l_message_text varchar2(20);
1180:
1181: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1182: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1183: wip_id NUMBER;
1184: manual_rebuild_flag varchar2(1);
1185: constraining_rel number;
1178: l_old_rebuild_source NUMBER;
1179: l_message_text varchar2(20);
1180:
1181: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1182: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1183: wip_id NUMBER;
1184: manual_rebuild_flag varchar2(1);
1185: constraining_rel number;
1186: followup_rel number;
1195: l_prev_project_id NUMBER;
1196: l_prev_task_id NUMBER;
1197: /* Added for bug#5284499 End */
1198:
1199: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1196: l_prev_task_id NUMBER;
1197: /* Added for bug#5284499 End */
1198:
1199: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1197: /* Added for bug#5284499 End */
1198:
1199: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1198:
1199: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1199: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1200: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1201: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1202: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1203: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1204: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1205: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1206: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1214: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1207: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1214: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1215:
1208: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1214: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1215:
1216: /* Added for FA */
1209: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1214: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1215:
1216: /* Added for FA */
1217: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
1210: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1211: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1212: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1213: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1214: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1215:
1216: /* Added for FA */
1217: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
1218: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ ;
1873: l_eam_wo_relations_rec1.child_object_type_id := 1;
1874: l_eam_wo_relations_rec1.child_header_id :=l_wip_entity_updt;
1875: l_eam_wo_relations_rec1.child_object_id :=l_wip_entity_updt;
1876: l_eam_wo_relations_rec1.parent_relationship_type := 1;
1877: l_eam_wo_relations_rec1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
1878:
1879: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec1;
1880: record_count := record_count+1;
1881:
1901: l_eam_wo_relations_rec2.child_object_type_id := 1;
1902: l_eam_wo_relations_rec2.child_header_id :=l_wip_entity_updt;
1903: l_eam_wo_relations_rec2.child_object_id :=l_wip_entity_updt;
1904: l_eam_wo_relations_rec2.parent_relationship_type := 4;
1905: l_eam_wo_relations_rec2.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
1906:
1907: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec2;
1908: record_count := record_count+1;
1909:
1923: l_eam_wo_relations_rec3.child_header_id :=l_wip_entity_updt;
1924: l_eam_wo_relations_rec3.child_object_id :=l_wip_entity_updt;
1925: l_eam_wo_relations_rec3.parent_relationship_type := 1;
1926: l_eam_wo_relations_rec3.adjust_parent := FND_API.G_FALSE;
1927: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1928:
1929: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec3;
1930: record_count := record_count+1;
1931:
1940: l_eam_wo_relations_rec4.child_header_id :=l_wip_entity_updt;
1941: l_eam_wo_relations_rec4.child_object_id :=l_wip_entity_updt;
1942: l_eam_wo_relations_rec4.parent_relationship_type := 4;
1943: l_eam_wo_relations_rec4.adjust_parent := FND_API.G_FALSE;
1944: l_eam_wo_relations_rec4.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1945:
1946: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec4;
1947: record_count := record_count+1;
1948:
1948:
1949: end if; ---End of adding rel to new rebuild source
1950: end if;--End of delinking and attaching
1951: end if;
1952: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1953: ( p_bo_identifier => 'EAM'
1954: , p_init_msg_list => TRUE
1955: , p_api_version_number => 1.0
1956: , p_eam_wo_tbl => l_eam_wo_tbl
2162: l_eam_wo_relations_rec1.child_object_type_id := 1;
2163: l_eam_wo_relations_rec1.child_header_id :=1;
2164: l_eam_wo_relations_rec1.child_object_id :=1;
2165: l_eam_wo_relations_rec1.parent_relationship_type := 1;
2166: l_eam_wo_relations_rec1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2167:
2168: l_eam_wo_relations_rec2.batch_id := 1;
2169: l_eam_wo_relations_rec2.parent_object_id := l_parent_wip_entity_id;
2170: l_eam_wo_relations_rec2.parent_object_type_id := 1;
2172: l_eam_wo_relations_rec2.child_object_type_id := 1;
2173: l_eam_wo_relations_rec2.child_header_id :=1;
2174: l_eam_wo_relations_rec2.child_object_id :=1;
2175: l_eam_wo_relations_rec2.parent_relationship_type := 4;
2176: l_eam_wo_relations_rec2.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2177:
2178: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec1;
2179: l_eam_wo_relations_tbl(2) := l_eam_wo_relations_rec2;
2180: end if;
2269: /* End of change for bug #5453280 */
2270:
2271: l_eam_wo_tbl(1) := l_workorder_rec;
2272:
2273: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2274:
2275: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2276: ( p_bo_identifier => 'EAM'
2277: , p_init_msg_list => TRUE
2271: l_eam_wo_tbl(1) := l_workorder_rec;
2272:
2273: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2274:
2275: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2276: ( p_bo_identifier => 'EAM'
2277: , p_init_msg_list => TRUE
2278: , p_api_version_number => 1.0
2279: , p_eam_wo_tbl => l_eam_wo_tbl
2422: l_eam_wo_relations_rec3.child_object_type_id := 1;
2423: l_eam_wo_relations_rec3.child_header_id :=x_new_work_order_id;
2424: l_eam_wo_relations_rec3.child_object_id :=x_new_work_order_id;
2425: l_eam_wo_relations_rec3.parent_relationship_type := to_number(p_relationship_type);
2426: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2427:
2428: l_eam_wo_relations_tbl2(1) := l_eam_wo_relations_rec3;
2429:
2430:
2428: l_eam_wo_relations_tbl2(1) := l_eam_wo_relations_rec3;
2429:
2430:
2431:
2432: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2433: ( p_bo_identifier => 'EAM'
2434: , p_init_msg_list => TRUE
2435: , p_api_version_number => 1.0
2436: , p_eam_wo_tbl => l_eam_wo_tbl2
2921: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2922: l_msg_count NUMBER;
2923: l_message_text VARCHAR2(1000);
2924:
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2922: l_msg_count NUMBER;
2923: l_message_text VARCHAR2(1000);
2924:
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2923: l_message_text VARCHAR2(1000);
2924:
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2924:
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2927: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2928: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2929: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2930: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2931: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2932: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2933: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2934: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2935: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2936: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2937: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2938: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2939: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2940: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2941: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2942: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2943: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2944:
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2945: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2946: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2947: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2948: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2949: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2950: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2951: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2952: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2953: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2961: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2954: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2961: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2962:
2955: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2961: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2962:
2963: l_output_dir VARCHAR2(512);
2956: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2961: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2962:
2963: l_output_dir VARCHAR2(512);
2964:
2957: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2958: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2959: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2960: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2961: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2962:
2963: l_output_dir VARCHAR2(512);
2964:
2965:
3003: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_ID :=null;
3004: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_TYPE_ID :=1;
3005: l_eam_wo_relations_rec.TOP_LEVEL_HEADER_ID :=1;
3006: l_eam_wo_relations_rec.RETURN_STATUS :=null;
3007: l_eam_wo_relations_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3008:
3009: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3010:
3011:
3010:
3011:
3012:
3013:
3014: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
3015:
3016:
3017: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO
3018: ( p_bo_identifier => 'EAM'
3013:
3014: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
3015:
3016:
3017: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO
3018: ( p_bo_identifier => 'EAM'
3019: , p_api_version_number=> 1.0
3020: , p_init_msg_list => TRUE
3021: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
3123: l_api_name constant varchar2(30) := 'Delete_WorkOrder_Dependency';
3124: l_api_version CONSTANT NUMBER := 1.0;
3125:
3126: -- All in parameters
3127: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3124: l_api_version CONSTANT NUMBER := 1.0;
3125:
3126: -- All in parameters
3127: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3125:
3126: -- All in parameters
3127: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3126: -- All in parameters
3127: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3127: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3128: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3129: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3137: -- All Out parateres
3130: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3131: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3132: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3133: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3134: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3135: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3136:
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3136:
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3137: -- All Out parateres
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3138: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3139: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3140: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3148: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3141: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3148: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3149:
3142: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3143: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3148: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3149:
3150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3144: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3145: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3148: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3149:
3150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3151: l_msg_count NUMBER;
3152: l_message_text VARCHAR2(1000);
3150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3151: l_msg_count NUMBER;
3152: l_message_text VARCHAR2(1000);
3153: l_output_dir VARCHAR2(512);
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3151: l_msg_count NUMBER;
3152: l_message_text VARCHAR2(1000);
3153: l_output_dir VARCHAR2(512);
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3152: l_message_text VARCHAR2(1000);
3153: l_output_dir VARCHAR2(512);
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3153: l_output_dir VARCHAR2(512);
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3155: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3156: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3157: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3158: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3159: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3160: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3171:
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3171:
3172: begin
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3171:
3172: begin
3173:
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3171:
3172: begin
3173:
3174: IF p_commit = FND_API.G_TRUE THEN
3203: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_ID :=null;
3204: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_TYPE_ID :=1;
3205: l_eam_wo_relations_rec.TOP_LEVEL_HEADER_ID :=1;
3206: l_eam_wo_relations_rec.RETURN_STATUS :=null;
3207: l_eam_wo_relations_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_DELETE;
3208:
3209:
3210: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3211:
3208:
3209:
3210: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3211:
3212: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
3213: ( p_bo_identifier => 'EAM'
3214: , p_init_msg_list => TRUE
3215: , p_api_version_number => 1.0
3216: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
3313: -- x_msg_count OUT NOCOPY NUMBER
3314: -- x_msg_data OUT NOCOPY VARCHAR2
3315: -- Notes : The procedure gets the entire work hierarchy for the required top_level_object_id.
3316: -- It then passes the child workorder and the parent Work order to the Process_Master_Child_WO
3317: -- in the EAM_PROCESS_WO_PUB, to generate the costing relationship between the 2 workorders
3318: --
3319: -- End of comments
3320: procedure create_cost_hierarchy_pvt(
3321: p_api_version IN NUMBER :=1.0 ,
3340: AND parent_relationship_type = 1
3341: CONNECT BY parent_object_id = PRIOR child_object_id
3342: AND parent_relationship_type = 1;
3343:
3344: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3341: CONNECT BY parent_object_id = PRIOR child_object_id
3342: AND parent_relationship_type = 1;
3343:
3344: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3342: AND parent_relationship_type = 1;
3343:
3344: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3343:
3344: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3344: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3345: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3346: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3347: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3348: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3349: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3350: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3351: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3352: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3353: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3354: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3355: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3356: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3357: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3358: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3359: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3360: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3368: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3361: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3368: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3369: l_wip_entity_id NUMBER;
3362: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3368: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3369: l_wip_entity_id NUMBER;
3370: --Bug3592712: Max length of workorder name is 240 char.
3363: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3368: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3369: l_wip_entity_id NUMBER;
3370: --Bug3592712: Max length of workorder name is 240 char.
3371: l_wip_entity_name VARCHAR2(240);
3364: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3365: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3366: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3367: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3368: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3369: l_wip_entity_id NUMBER;
3370: --Bug3592712: Max length of workorder name is 240 char.
3371: l_wip_entity_name VARCHAR2(240);
3372:
3369: l_wip_entity_id NUMBER;
3370: --Bug3592712: Max length of workorder name is 240 char.
3371: l_wip_entity_name VARCHAR2(240);
3372:
3373: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3374: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3370: --Bug3592712: Max length of workorder name is 240 char.
3371: l_wip_entity_name VARCHAR2(240);
3372:
3373: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3374: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3371: l_wip_entity_name VARCHAR2(240);
3372:
3373: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3374: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3372:
3373: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3374: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3374: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3375: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3376: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3377:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3378: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3379: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3380: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3381: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3382: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3383: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3384: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3385:
3386: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3387: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3388: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3389: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3390:
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3391: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3399: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3392: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3399: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3400:
3393: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3399: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3400:
3401: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3394: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3399: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3400:
3401: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3402: l_old_rebuild_source NUMBER;
3395: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3396: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3397: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3398: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3399: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3400:
3401: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3402: l_old_rebuild_source NUMBER;
3403:
3400:
3401: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3402: l_old_rebuild_source NUMBER;
3403:
3404: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3405: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3406:
3407: l_parent_id NUMBER;
3408: l_child_wip_id NUMBER;
3401: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3402: l_old_rebuild_source NUMBER;
3403:
3404: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3405: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3406:
3407: l_parent_id NUMBER;
3408: l_child_wip_id NUMBER;
3409:
3474: l_eam_wo_relations_rec.child_object_type_id := 1;
3475: l_eam_wo_relations_rec.child_header_id :=l_child_wip_id;
3476: l_eam_wo_relations_rec.child_object_id :=l_child_wip_id;
3477: l_eam_wo_relations_rec.parent_relationship_type := 3;
3478: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3479:
3480: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3481:
3482: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3478: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3479:
3480: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3481:
3482: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3483: p_bo_identifier => 'EAM'
3484: , p_init_msg_list => TRUE
3485: , p_api_version_number => 1.0
3486: , p_eam_wo_tbl => l_eam_wo_tbl2
3553: l_eam_wo_relations_rec.child_object_type_id := 1;
3554: l_eam_wo_relations_rec.child_header_id :=l_child_wip_id;
3555: l_eam_wo_relations_rec.child_object_id :=l_child_wip_id;
3556: l_eam_wo_relations_rec.parent_relationship_type := 3;
3557: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3558:
3559: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3560: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3561: p_bo_identifier => 'EAM'
3556: l_eam_wo_relations_rec.parent_relationship_type := 3;
3557: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3558:
3559: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3560: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3561: p_bo_identifier => 'EAM'
3562: , p_init_msg_list => TRUE
3563: , p_api_version_number => 1.0
3564: , p_eam_wo_tbl => l_eam_wo_tbl2