APPS.EAM_IMPORT_WORKORDERS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

    Wrapper procedure on top of WO API.This is used to update valid imported workorders and its related entities
    ************************************************/
PROCEDURE import_workorders
(
      p_commit                      IN    VARCHAR2      := FND_API.G_FALSE,
      p_eam_wo_tbl		IN			EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
      p_eam_wo_relations_tbl     IN            EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
      p_eam_op_tbl               IN                    EAM_PROCESS_WO_PUB.eam_op_tbl_type,
      p_eam_res_tbl              IN                   EAM_PROCESS_WO_PUB.eam_res_tbl_type,
      p_eam_res_inst_tbl     IN			EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type,
      p_eam_res_usage_tbl      IN              EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
      p_eam_mat_req_tbl         IN                EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type,
      p_eam_direct_items_tbl    IN             EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type,
      p_eam_request_tbl           IN              EAM_PROCESS_WO_PUB.eam_request_tbl_type,
      p_eam_wo_comp_tbl		 IN		EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type,
      p_eam_meter_reading_tbl   IN		EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
      p_eam_counter_prop_tbl    IN	 EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
      p_eam_wo_comp_rebuild_tbl	 IN	EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
      p_eam_wo_comp_mr_read_tbl	 IN	EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
      x_wip_entity_id              OUT NOCOPY       NUMBER,
      x_return_status		OUT NOCOPY	VARCHAR2,
      x_msg_count			OUT NOCOPY	NUMBER
)
IS
      l_eam_wo_tbl					EAM_PROCESS_WO_PUB.eam_wo_tbl_type;

Line: 115

        l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

Line: 123

         SELECT asset_number INTO l_asset_serial_number FROM wip_discrete_jobs
         WHERE wip_entity_id= l_wip_entity_id AND organization_id=l_eam_wo_rec.organization_id;

Line: 137

           l_eam_op_tbl_p.delete(l_eam_op_tbl_p.FIRST,l_eam_op_tbl_p.last); -- remove all prev job's elements

Line: 142

          l_eam_op_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

Line: 151

          l_eam_res_tbl_p.delete(l_eam_res_tbl_p.first,l_eam_res_tbl_p.last); -- remove all prev job's elements

Line: 156

         l_eam_res_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

Line: 165

          l_eam_res_inst_tbl_p.delete(l_eam_res_inst_tbl_p.first,l_eam_res_inst_tbl_p.last); -- remove all prev job's elements

Line: 223

		, p_debug_filename		=> 'createupdatewo.log'
		, p_debug_file_mode		=> 'W'
		);