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
1085: l_maintenance_object_type number;
1086: l_maintenance_object_source number;
1087:
1088: -- Fields added for new Work Order API
1089: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1086: l_maintenance_object_source number;
1087:
1088: -- Fields added for new Work Order API
1089: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1087:
1088: -- Fields added for new Work Order API
1089: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1088: -- Fields added for new Work Order API
1089: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1089: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1090: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1091: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1092: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1093: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1094: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1095: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1096: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1097: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1098: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1099: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1100: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1101: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1102: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1103: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1104: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1105: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1113: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1106: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1113: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1114: l_wip_entity_id NUMBER;
1107: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1113: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1114: l_wip_entity_id NUMBER;
1115: --Bug3592712: Max length of workorder name is 240 char.
1108: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1113: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1114: l_wip_entity_id NUMBER;
1115: --Bug3592712: Max length of workorder name is 240 char.
1116: l_wip_entity_name VARCHAR2(240);
1109: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1110: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1111: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1112: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1113: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1114: l_wip_entity_id NUMBER;
1115: --Bug3592712: Max length of workorder name is 240 char.
1116: l_wip_entity_name VARCHAR2(240);
1117:
1138: l_fail_dept_id NUMBER;
1139: l_eam_location_id NUMBER;
1140:
1141:
1142: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1139: l_eam_location_id NUMBER;
1140:
1141:
1142: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1140:
1141:
1142: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1141:
1142: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1142: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1143: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1144: l_eam_wo_relations_tbl2 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1145: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1152: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1146: l_eam_wo_relations_rec2 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1152: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1153: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1154:
1147: l_eam_wo_relations_rec3 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1152: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1153: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1154:
1155: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1148: l_eam_wo_relations_rec4 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1152: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1153: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1154:
1155: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1156: l_old_rebuild_source NUMBER;
1149:
1150: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1151: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1152: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1153: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1154:
1155: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1156: l_old_rebuild_source NUMBER;
1157: l_message_text varchar2(20);
1155: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
1156: l_old_rebuild_source NUMBER;
1157: l_message_text varchar2(20);
1158:
1159: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1160: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1161: wip_id NUMBER;
1162: manual_rebuild_flag varchar2(1);
1163: constraining_rel number;
1156: l_old_rebuild_source NUMBER;
1157: l_message_text varchar2(20);
1158:
1159: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1160: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1161: wip_id NUMBER;
1162: manual_rebuild_flag varchar2(1);
1163: constraining_rel number;
1164: followup_rel number;
1173: l_prev_project_id NUMBER;
1174: l_prev_task_id NUMBER;
1175: /* Added for bug#5284499 End */
1176:
1177: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1174: l_prev_task_id NUMBER;
1175: /* Added for bug#5284499 End */
1176:
1177: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1175: /* Added for bug#5284499 End */
1176:
1177: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1176:
1177: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1177: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1178: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1179: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1180: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1181: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1182: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1183: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1184: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1192: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1185: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1192: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1193:
1186: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1192: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1193:
1194: /* Added for FA */
1187: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1192: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1193:
1194: /* Added for FA */
1195: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
1188: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1189: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1190: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1191: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1192: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1193:
1194: /* Added for FA */
1195: l_eam_failure_entry_record eam_process_failure_entry_pub.eam_failure_entry_record_typ ;
1196: l_eam_failure_codes_tbl eam_process_failure_entry_pub.eam_failure_codes_tbl_typ ;
1842: l_eam_wo_relations_rec1.child_object_type_id := 1;
1843: l_eam_wo_relations_rec1.child_header_id :=l_wip_entity_updt;
1844: l_eam_wo_relations_rec1.child_object_id :=l_wip_entity_updt;
1845: l_eam_wo_relations_rec1.parent_relationship_type := 1;
1846: l_eam_wo_relations_rec1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
1847:
1848: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec1;
1849: record_count := record_count+1;
1850:
1870: l_eam_wo_relations_rec2.child_object_type_id := 1;
1871: l_eam_wo_relations_rec2.child_header_id :=l_wip_entity_updt;
1872: l_eam_wo_relations_rec2.child_object_id :=l_wip_entity_updt;
1873: l_eam_wo_relations_rec2.parent_relationship_type := 4;
1874: l_eam_wo_relations_rec2.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
1875:
1876: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec2;
1877: record_count := record_count+1;
1878:
1892: l_eam_wo_relations_rec3.child_header_id :=l_wip_entity_updt;
1893: l_eam_wo_relations_rec3.child_object_id :=l_wip_entity_updt;
1894: l_eam_wo_relations_rec3.parent_relationship_type := 1;
1895: l_eam_wo_relations_rec3.adjust_parent := FND_API.G_FALSE;
1896: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1897:
1898: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec3;
1899: record_count := record_count+1;
1900:
1909: l_eam_wo_relations_rec4.child_header_id :=l_wip_entity_updt;
1910: l_eam_wo_relations_rec4.child_object_id :=l_wip_entity_updt;
1911: l_eam_wo_relations_rec4.parent_relationship_type := 4;
1912: l_eam_wo_relations_rec4.adjust_parent := FND_API.G_FALSE;
1913: l_eam_wo_relations_rec4.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1914:
1915: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec4;
1916: record_count := record_count+1;
1917:
1917:
1918: end if; ---End of adding rel to new rebuild source
1919: end if;--End of delinking and attaching
1920: end if;
1921: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1922: ( p_bo_identifier => 'EAM'
1923: , p_init_msg_list => TRUE
1924: , p_api_version_number => 1.0
1925: , p_eam_wo_tbl => l_eam_wo_tbl
2131: l_eam_wo_relations_rec1.child_object_type_id := 1;
2132: l_eam_wo_relations_rec1.child_header_id :=1;
2133: l_eam_wo_relations_rec1.child_object_id :=1;
2134: l_eam_wo_relations_rec1.parent_relationship_type := 1;
2135: l_eam_wo_relations_rec1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2136:
2137: l_eam_wo_relations_rec2.batch_id := 1;
2138: l_eam_wo_relations_rec2.parent_object_id := l_parent_wip_entity_id;
2139: l_eam_wo_relations_rec2.parent_object_type_id := 1;
2141: l_eam_wo_relations_rec2.child_object_type_id := 1;
2142: l_eam_wo_relations_rec2.child_header_id :=1;
2143: l_eam_wo_relations_rec2.child_object_id :=1;
2144: l_eam_wo_relations_rec2.parent_relationship_type := 4;
2145: l_eam_wo_relations_rec2.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2146:
2147: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec1;
2148: l_eam_wo_relations_tbl(2) := l_eam_wo_relations_rec2;
2149: end if;
2238: /* End of change for bug #5453280 */
2239:
2240: l_eam_wo_tbl(1) := l_workorder_rec;
2241:
2242: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2243:
2244: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2245: ( p_bo_identifier => 'EAM'
2246: , p_init_msg_list => TRUE
2240: l_eam_wo_tbl(1) := l_workorder_rec;
2241:
2242: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2243:
2244: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2245: ( p_bo_identifier => 'EAM'
2246: , p_init_msg_list => TRUE
2247: , p_api_version_number => 1.0
2248: , p_eam_wo_tbl => l_eam_wo_tbl
2391: l_eam_wo_relations_rec3.child_object_type_id := 1;
2392: l_eam_wo_relations_rec3.child_header_id :=x_new_work_order_id;
2393: l_eam_wo_relations_rec3.child_object_id :=x_new_work_order_id;
2394: l_eam_wo_relations_rec3.parent_relationship_type := to_number(p_relationship_type);
2395: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2396:
2397: l_eam_wo_relations_tbl2(1) := l_eam_wo_relations_rec3;
2398:
2399:
2397: l_eam_wo_relations_tbl2(1) := l_eam_wo_relations_rec3;
2398:
2399:
2400:
2401: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
2402: ( p_bo_identifier => 'EAM'
2403: , p_init_msg_list => TRUE
2404: , p_api_version_number => 1.0
2405: , p_eam_wo_tbl => l_eam_wo_tbl2
2882: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2883: l_msg_count NUMBER;
2884: l_message_text VARCHAR2(1000);
2885:
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2883: l_msg_count NUMBER;
2884: l_message_text VARCHAR2(1000);
2885:
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2884: l_message_text VARCHAR2(1000);
2885:
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2885:
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2887: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2888: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2889: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2890: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2891: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2892: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2893: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2894: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2895: l_eam_wo_relations_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2896: l_eam_op_tbl_1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2897: l_eam_op_network_tbl_1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2898: l_eam_res_tbl_1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2899: l_eam_res_inst_tbl_1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2900: l_eam_sub_res_tbl_1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
2901: l_eam_mat_req_tbl_1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2902: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2903: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2904: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2905:
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2906: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2907: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2908: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2909: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2910: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2911: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2912: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2913: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2914: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2922: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2915: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2922: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2923:
2916: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2922: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2923:
2924: l_output_dir VARCHAR2(512);
2917: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2922: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2923:
2924: l_output_dir VARCHAR2(512);
2925:
2918: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2919: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2920: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2921: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2922: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2923:
2924: l_output_dir VARCHAR2(512);
2925:
2926:
2964: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_ID :=null;
2965: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_TYPE_ID :=1;
2966: l_eam_wo_relations_rec.TOP_LEVEL_HEADER_ID :=1;
2967: l_eam_wo_relations_rec.RETURN_STATUS :=null;
2968: l_eam_wo_relations_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2969:
2970: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
2971:
2972:
2971:
2972:
2973:
2974:
2975: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2976:
2977:
2978: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO
2979: ( p_bo_identifier => 'EAM'
2974:
2975: EAM_PROCESS_WO_PUB.l_eam_wo_list.delete; --Added for bug#4563210
2976:
2977:
2978: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO
2979: ( p_bo_identifier => 'EAM'
2980: , p_api_version_number=> 1.0
2981: , p_init_msg_list => TRUE
2982: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
3084: l_api_name constant varchar2(30) := 'Delete_WorkOrder_Dependency';
3085: l_api_version CONSTANT NUMBER := 1.0;
3086:
3087: -- All in parameters
3088: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3085: l_api_version CONSTANT NUMBER := 1.0;
3086:
3087: -- All in parameters
3088: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3086:
3087: -- All in parameters
3088: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3087: -- All in parameters
3088: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3088: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3089: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3090: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3098: -- All Out parateres
3091: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3092: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3093: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3094: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3095: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3096: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3097:
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3097:
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3098: -- All Out parateres
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3099: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3100: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3101: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3109: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3102: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3109: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3110:
3103: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3104: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3109: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3110:
3111: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3105: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3106: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3109: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3110:
3111: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3112: l_msg_count NUMBER;
3113: l_message_text VARCHAR2(1000);
3111: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3112: l_msg_count NUMBER;
3113: l_message_text VARCHAR2(1000);
3114: l_output_dir VARCHAR2(512);
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3112: l_msg_count NUMBER;
3113: l_message_text VARCHAR2(1000);
3114: l_output_dir VARCHAR2(512);
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3113: l_message_text VARCHAR2(1000);
3114: l_output_dir VARCHAR2(512);
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3114: l_output_dir VARCHAR2(512);
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3116: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3117: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3118: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3119: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3120: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3121: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3122: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3123: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3124: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3132:
3125: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3132:
3133: begin
3126: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3132:
3133: begin
3134:
3127: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3128: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3129: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3130: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3132:
3133: begin
3134:
3135: IF p_commit = FND_API.G_TRUE THEN
3164: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_ID :=null;
3165: l_eam_wo_relations_rec.TOP_LEVEL_OBJECT_TYPE_ID :=1;
3166: l_eam_wo_relations_rec.TOP_LEVEL_HEADER_ID :=1;
3167: l_eam_wo_relations_rec.RETURN_STATUS :=null;
3168: l_eam_wo_relations_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_DELETE;
3169:
3170:
3171: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3172:
3169:
3170:
3171: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3172:
3173: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
3174: ( p_bo_identifier => 'EAM'
3175: , p_init_msg_list => TRUE
3176: , p_api_version_number => 1.0
3177: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
3274: -- x_msg_count OUT NOCOPY NUMBER
3275: -- x_msg_data OUT NOCOPY VARCHAR2
3276: -- Notes : The procedure gets the entire work hierarchy for the required top_level_object_id.
3277: -- It then passes the child workorder and the parent Work order to the Process_Master_Child_WO
3278: -- in the EAM_PROCESS_WO_PUB, to generate the costing relationship between the 2 workorders
3279: --
3280: -- End of comments
3281: procedure create_cost_hierarchy_pvt(
3282: p_api_version IN NUMBER :=1.0 ,
3301: AND parent_relationship_type = 1
3302: CONNECT BY parent_object_id = PRIOR child_object_id
3303: AND parent_relationship_type = 1;
3304:
3305: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3302: CONNECT BY parent_object_id = PRIOR child_object_id
3303: AND parent_relationship_type = 1;
3304:
3305: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3303: AND parent_relationship_type = 1;
3304:
3305: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3304:
3305: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3305: l_workorder_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3306: l_workorder_rec1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3307: l_workorder_rec2 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3308: l_workorder_rec3 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3309: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3310: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3311: l_eam_op_tbl2 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3312: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3313: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3314: l_eam_op_network_tbl2 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3315: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3316: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3317: l_eam_res_tbl2 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3318: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3319: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3320: l_eam_res_inst_tbl2 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3321: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3329: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3322: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3329: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3330: l_wip_entity_id NUMBER;
3323: l_eam_sub_res_tbl2 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3329: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3330: l_wip_entity_id NUMBER;
3331: --Bug3592712: Max length of workorder name is 240 char.
3324: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3329: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3330: l_wip_entity_id NUMBER;
3331: --Bug3592712: Max length of workorder name is 240 char.
3332: l_wip_entity_name VARCHAR2(240);
3325: l_eam_res_usage_tbl1 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3326: l_eam_res_usage_tbl2 EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3327: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3328: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3329: l_eam_mat_req_tbl2 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3330: l_wip_entity_id NUMBER;
3331: --Bug3592712: Max length of workorder name is 240 char.
3332: l_wip_entity_name VARCHAR2(240);
3333:
3330: l_wip_entity_id NUMBER;
3331: --Bug3592712: Max length of workorder name is 240 char.
3332: l_wip_entity_name VARCHAR2(240);
3333:
3334: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3335: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3331: --Bug3592712: Max length of workorder name is 240 char.
3332: l_wip_entity_name VARCHAR2(240);
3333:
3334: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3335: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3332: l_wip_entity_name VARCHAR2(240);
3333:
3334: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3335: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3333:
3334: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3335: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3335: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3336: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3337: l_eam_wo_relations_rec1 EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3338:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3339: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3340: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3341: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3342: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3343: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3344: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3345: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3346:
3347: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3348: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3349: l_eam_wo_tbl2 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3350: l_eam_wo_tbl3 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3351:
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3352: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3360: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3353: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3360: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3361:
3354: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3360: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3361:
3362: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3355: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3360: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3361:
3362: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3363: l_old_rebuild_source NUMBER;
3356: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3357: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3358: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3359: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3360: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3361:
3362: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3363: l_old_rebuild_source NUMBER;
3364:
3361:
3362: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3363: l_old_rebuild_source NUMBER;
3364:
3365: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3366: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3367:
3368: l_parent_id NUMBER;
3369: l_child_wip_id NUMBER;
3362: l_eam_msg_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
3363: l_old_rebuild_source NUMBER;
3364:
3365: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3366: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3367:
3368: l_parent_id NUMBER;
3369: l_child_wip_id NUMBER;
3370:
3435: l_eam_wo_relations_rec.child_object_type_id := 1;
3436: l_eam_wo_relations_rec.child_header_id :=l_child_wip_id;
3437: l_eam_wo_relations_rec.child_object_id :=l_child_wip_id;
3438: l_eam_wo_relations_rec.parent_relationship_type := 3;
3439: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3440:
3441: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3442:
3443: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3439: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3440:
3441: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3442:
3443: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3444: p_bo_identifier => 'EAM'
3445: , p_init_msg_list => TRUE
3446: , p_api_version_number => 1.0
3447: , p_eam_wo_tbl => l_eam_wo_tbl2
3514: l_eam_wo_relations_rec.child_object_type_id := 1;
3515: l_eam_wo_relations_rec.child_header_id :=l_child_wip_id;
3516: l_eam_wo_relations_rec.child_object_id :=l_child_wip_id;
3517: l_eam_wo_relations_rec.parent_relationship_type := 3;
3518: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3519:
3520: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3521: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3522: p_bo_identifier => 'EAM'
3517: l_eam_wo_relations_rec.parent_relationship_type := 3;
3518: l_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3519:
3520: l_eam_wo_relations_tbl(1) := l_eam_wo_relations_rec;
3521: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
3522: p_bo_identifier => 'EAM'
3523: , p_init_msg_list => TRUE
3524: , p_api_version_number => 1.0
3525: , p_eam_wo_tbl => l_eam_wo_tbl2