40: ************************************************/
41: PROCEDURE CREATE_UPDATE_WO
42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
41: PROCEDURE CREATE_UPDATE_WO
42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
42: (
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
43: p_commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
44: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
45: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
46: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
47: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
48: p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
49: p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
50: p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
51: p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,
52: p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,
60: p_failure_date IN DATE := null,
53: p_eam_wo_comp_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
54: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
55: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
56: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
57: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
58: p_prev_activity_id IN NUMBER,
59: p_failure_id IN NUMBER := null,
60: p_failure_date IN DATE := null,
61: p_failure_entry_id IN NUMBER := null,