[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE DELETE_RELATIONSHIP
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_parent_object_id IN NUMBER
, p_parent_object_type_id IN NUMBER
, p_child_object_id IN NUMBER
, p_child_object_type_id IN NUMBER
, p_new_parent_object_id IN NUMBER
, p_new_parent_object_type_id IN NUMBER
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
null;
END DELETE_RELATIONSHIP;
l_eam_wo_tbl.delete;
l_eam_wo_relations_tbl.delete;
l_eam_op_tbl.delete;
l_eam_op_network_tbl.delete;
l_eam_res_tbl.delete;
l_eam_res_inst_tbl.delete;
l_eam_sub_res_tbl.delete;
l_eam_mat_req_tbl.delete;
l_eam_di_tbl.delete;
l_eam_res_usage_tbl.delete;
l_eam_wo_comp_tbl.delete;
l_eam_wo_quality_tbl.delete;
l_eam_meter_reading_tbl.delete;
l_eam_counter_prop_tbl.delete;
l_eam_wo_comp_rebuild_tbl.delete;
l_eam_wo_comp_mr_read_tbl.delete;
l_eam_op_comp_tbl.delete;
l_eam_request_tbl.delete;
l_out_eam_wo_tbl.delete;
l_out_eam_wo_relations_tbl.delete;
l_out_eam_op_tbl.delete;
l_out_eam_op_network_tbl.delete;
l_out_eam_res_tbl.delete;
l_out_eam_res_inst_tbl.delete;
l_out_eam_sub_res_tbl.delete;
l_out_eam_mat_req_tbl.delete;
l_out_eam_di_tbl.delete;
l_out_eam_res_usage_tbl.delete;
l_out_eam_wo_comp_tbl.delete;
l_out_eam_wo_quality_tbl.delete;
l_out_eam_meter_reading_tbl.delete;
l_out_eam_counter_prop_tbl.delete;
l_out_eam_wo_comp_rebuild_tbl.delete;
l_out_eam_wo_comp_mr_read_tbl.delete;
l_out_eam_op_comp_tbl.delete;
l_out_eam_request_tbl.delete;
l_out_eam_wo_tbl_main.delete;
l_out_eam_wo_rel_tbl_main.delete;
l_out_eam_op_tbl_main.delete;
l_out_eam_op_network_tbl_main.delete;
l_out_eam_res_tbl_main.delete;
l_out_eam_res_inst_tbl_main.delete;
l_out_eam_sub_res_tbl_main.delete;
l_out_eam_mat_req_tbl_main.delete;
l_out_eam_di_tbl_main.delete;
l_out_eam_res_usage_tbl_main.delete;
l_out_eam_wo_comp_tbl_main.delete;
l_out_eam_wo_quality_tbl_main.delete;
l_ou_eam_meter_reading_tbl_m.delete;
l_out_eam_counter_prop_tbl_m.delete;
l_ou_eam_wo_comp_rebuild_tbl_m.delete;
l_ou_eam_wo_comp_mr_read_tbl_m.delete;
l_out_eam_op_comp_tbl_main.delete;
l_out_eam_request_tbl_main.delete;
l_out_eam_counter_prop_tbl_m.delete;
x_eam_wo_tbl.delete;
x_eam_wo_relations_tbl.delete;
x_eam_op_tbl.delete;
x_eam_op_network_tbl.delete;
x_eam_res_tbl.delete;
x_eam_res_inst_tbl.delete;
x_eam_sub_res_tbl.delete;
x_eam_mat_req_tbl.delete;
x_eam_direct_items_tbl.delete;
x_eam_res_usage_tbl.delete;
x_eam_wo_comp_tbl.delete;
x_eam_wo_quality_tbl.delete;
x_eam_meter_reading_tbl.delete;
x_eam_counter_prop_tbl.delete;
x_eam_wo_comp_rebuild_tbl.delete;
x_eam_wo_comp_mr_read_tbl.delete;
x_eam_op_comp_tbl.delete;
l_out_eam_wo_tbl.delete;
l_out_eam_wo_relations_tbl.delete;
l_out_eam_op_tbl.delete;
l_out_eam_op_network_tbl.delete;
l_out_eam_res_tbl.delete;
l_out_eam_res_inst_tbl.delete;
l_out_eam_sub_res_tbl.delete;
l_out_eam_res_usage_tbl.delete;
l_out_eam_mat_req_tbl.delete;
l_out_eam_di_tbl.delete;
l_out_eam_wo_comp_tbl.delete;
l_out_eam_wo_quality_tbl.delete;
l_out_eam_meter_reading_tbl.delete;
l_out_eam_counter_prop_tbl.delete;
l_out_eam_wo_comp_rebuild_tbl.delete;
l_out_eam_wo_comp_mr_read_tbl.delete;
l_out_eam_op_comp_tbl.delete;
l_out_eam_request_tbl.delete;
l_eam_op_tbl_head.delete;
l_eam_op_network_tbl_head.delete;
l_eam_res_tbl_head.delete;
l_eam_res_inst_tbl_head.delete;
l_eam_sub_res_tbl_head.delete;
l_eam_mat_req_tbl_head.delete;
l_eam_di_tbl_head.delete;
l_eam_res_usage_tbl_head.delete;
l_eam_wo_comp_tbl_head.delete;
l_eam_wo_quality_tbl_head.delete;
l_eam_meter_reading_tbl_head.delete;
l_eam_counter_prop_tbl_head.delete;
l_eam_wo_comp_rebuild_tbl_head.delete;
l_eam_wo_comp_mr_read_tbl_head.delete;
l_eam_op_comp_tbl_head.delete;
l_eam_request_tbl_head.delete;
l_mesg_token_tbl.delete;
l_token_tbl.delete;
EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
( p_mesg_token_tbl => l_mesg_token_tbl
, p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
, p_entity_index => l_eam_wo_rec_head.row_id
, p_application_id => 'EAM'
);
fnd_msg_pub.delete_msg(p_msg_index => fnd_msg_pub.Count_Msg);
EAM_ERROR_MESSAGE_PVT.Delete_Message;
--Before inserting the error message, insert the confirmation message of work order creation.
x_return_status := l_return_status;
l_eam_wo_list.delete;
--Insert the error message.
select wip_entity_name into l_wo_name
from wip_entities
where wip_entity_id = l_temp_wip_entity_id;
EAM_PROCESS_WO_PUB.G_OPR_DELETE then
if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
SAVEPOINT Delink_Relation_Start;
SAVEPOINT Delete_Dependency_Start;
IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delete_Dependency procedure ... ') ; END IF ;
EAM_WO_NETWORK_DEFAULT_PVT.Delete_Dependency
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_prior_object_id => l_eam_wo_relations_tbl(i).parent_object_id,
p_prior_object_type_id => l_eam_wo_relations_tbl(i).parent_object_type_id,
p_next_object_id => l_eam_wo_relations_tbl(i).child_object_id,
p_next_object_type_id => l_eam_wo_relations_tbl(i).child_object_type_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_mesg_token_tbl => l_mesg_token_tbl
);
rollback to Delete_Dependency_Start;
x_eam_wo_tbl.delete;
x_eam_wo_relations_tbl.delete;
x_eam_op_tbl.delete;
x_eam_op_network_tbl.delete;
x_eam_res_tbl.delete;
x_eam_res_inst_tbl.delete;
x_eam_sub_res_tbl.delete;
x_eam_mat_req_tbl.delete;
x_eam_direct_items_tbl.delete;
x_eam_res_usage_tbl.delete;
x_eam_res_usage_tbl.delete;
x_eam_wo_comp_tbl.delete;
x_eam_wo_quality_tbl.delete;
x_eam_meter_reading_tbl.delete;
x_eam_counter_prop_tbl.delete;
x_eam_wo_comp_rebuild_tbl.delete;
x_eam_wo_comp_mr_read_tbl.delete;
x_eam_op_comp_tbl.delete;
x_eam_request_tbl.delete;
select
wip_entity_id ,
organization_id ,
operation_seq_num ,
standard_operation_id ,
department_id ,
operation_sequence_id ,
description ,
minimum_transfer_quantity ,
count_point_type ,
backflush_flag ,
shutdown_type ,
first_unit_start_date ,
last_unit_completion_date ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
long_description
from wip_operations
where wip_entity_id = p_wip_entity_id;
select
wor.wip_entity_id ,
wor.organization_id ,
wor.operation_seq_num ,
wor.resource_seq_num ,
wor.resource_id ,
wor.uom_code ,
wor.basis_type ,
wor.usage_rate_or_amount ,
wor.activity_id ,
wor.scheduled_flag ,
wor.firm_flag ,
wor.assigned_units ,
wor.maximum_assigned_units ,
wor.autocharge_type ,
wor.standard_rate_flag ,
wor.applied_resource_units ,
wor.applied_resource_value ,
wor.start_date ,
wor.completion_date ,
wor.schedule_seq_num ,
wor.substitute_group_num ,
wor.replacement_group_num ,
wor.attribute_category ,
wor.attribute1 ,
wor.attribute2 ,
wor.attribute3 ,
wor.attribute4 ,
wor.attribute5 ,
wor.attribute6 ,
wor.attribute7 ,
wor.attribute8 ,
wor.attribute9 ,
wor.attribute10 ,
wor.attribute11 ,
wor.attribute12 ,
wor.attribute13 ,
wor.attribute14 ,
wor.attribute15 ,
wor.department_id
from wip_operations wo,
wip_operation_resources wor
where wo.wip_entity_id = p_wip_entity_id
and wor.wip_entity_id = p_wip_entity_id
and wo.operation_seq_num = wor.operation_seq_num;
select
wori.wip_entity_id ,
wori.organization_id ,
wori.operation_seq_num ,
wori.resource_seq_num ,
wori.instance_id ,
wori.serial_number ,
wori.start_date ,
wori.completion_date ,
wori.batch_id
from wip_op_resource_instances wori,
wip_operation_resources wor
where wor.wip_entity_id = p_wip_entity_id
and wori.wip_entity_id = p_wip_entity_id
and wori.operation_seq_num = wor.operation_seq_num
and wori.resource_seq_num = wor.resource_seq_num;
SELECT
wip_entity_id ,
organization_id ,
prior_operation ,
next_operation ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15
FROM
wip_operation_networks
WHERE wip_entity_id = p_wip_entity_id;
SELECT
wip_entity_id ,
organization_id ,
operation_seq_num ,
inventory_item_id ,
quantity_per_assembly ,
department_id ,
wip_supply_type ,
date_required ,
required_quantity ,
released_quantity ,
quantity_issued ,
supply_subinventory ,
supply_locator_id ,
mrp_net_flag ,
mps_required_quantity ,
mps_date_required ,
component_sequence_id ,
comments ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
auto_request_material ,
suggested_vendor_name ,
vendor_id ,
unit_price
FROM wip_requirement_operations wro
WHERE wro.wip_entity_id = p_wip_entity_id
AND wro.organization_id = p_organization_id;
SELECT
description ,
purchasing_category_id ,
direct_item_sequence_id ,
operation_seq_num ,
department_id ,
wip_entity_id ,
organization_id ,
suggested_vendor_name ,
suggested_vendor_id ,
suggested_vendor_site ,
suggested_vendor_site_id ,
suggested_vendor_contact ,
suggested_vendor_contact_id ,
suggested_vendor_phone ,
suggested_vendor_item_num ,
unit_price ,
auto_request_material ,
required_quantity ,
uom ,
need_by_date ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15
FROM wip_eam_direct_items wedi
WHERE wedi.wip_entity_id = p_wip_entity_id
AND wedi.organization_id = p_organization_id;
update wip_discrete_jobs
set primary_item_id = l_old_activity_id
where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;
update wip_operations wo
set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1
where wo.OPERATION_SEQ_NUM = wo1.OPERATION_SEQ_NUM
and wo1.wip_entity_id = p_wip_entity_id
)
where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;