APPS.EAM_ASSET_LOG_PUB SQL Statements

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

Line: 53

			SELECT instance_id, instance_number
			  FROM csi_item_instances
			 WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;

Line: 58

		        SELECT mp.maint_organization_id
			  FROM csi_item_instances cii, mtl_parameters mp
			 WHERE cii.equipment_gen_object_id = nvl(p_equipment_gen_object_id, cii.equipment_gen_object_id)  AND
			       p_event_date BETWEEN active_start_date AND
			       NVL(active_end_date, SYSDATE) AND
			       cii.last_vld_organization_id = mp.organization_id;

Line: 125

		SELECT 1 INTO l_count
		  FROM csi_item_instances
		 WHERE equipment_gen_object_id = p_equipment_gen_object_id;

Line: 138

		eam_asset_log_pvt.insert_row(
			p_event_date		=>	p_event_date,
			p_event_type		=>	p_event_type,
			p_event_id		=>	p_event_id,
			p_organization_id	=>	l_organization_id,
			p_instance_id		=>	p_instance_id,
			p_comments		=>	p_comments,
			p_reference		=>	p_reference,
			p_ref_id		=>	p_ref_id,
			p_operable_flag		=>	p_operable_flag,
			p_reason_code		=>	p_reason_code,
			p_resource_id		=>	p_resource_id,
			p_equipment_gen_object_id =>	p_equipment_gen_object_id,
			p_instance_number	=>	p_instance_number,
			p_downcode		=>	p_downcode,
			p_expected_up_date	=>	p_expected_up_date,
			p_employee_id		=>	p_employee_id,
			p_department_id		=>	p_department_id,
			x_return_status		=>	x_return_status,
			x_msg_count		=>	x_msg_count,
			x_msg_data		=>	x_msg_data
			);

Line: 163

	-- insert into log table with out asset id context and store the log id generated;

Line: 165

          SELECT eam_asset_log_s.NEXTVAL INTO l_log_id FROM DUAL;

Line: 167

          eam_asset_log_pvt.insert_row
          (p_log_id		=>	l_log_id,
          p_event_type		=>	p_event_type,
          p_event_id		=>	p_event_id,
          p_organization_id	=>	l_organization_id,
          p_instance_id		=>	p_instance_id,
          p_comments		=>	p_comments,
          p_reference		=>	p_reference,
          p_ref_id		=>	p_ref_id,
          p_operable_flag		=>	p_operable_flag,
          p_reason_code		=>	p_reason_code,
          p_resource_id		=>	p_resource_id,
          p_equipment_gen_object_id =>	p_equipment_gen_object_id,
          p_source_log_id		=>	null,
          p_expected_up_date	=>	p_expected_up_date,
          p_employee_id		=>	p_employee_id,
          p_department_id		=>	p_department_id,
          x_return_status		=>	x_return_status,
          x_msg_count		=>	x_msg_count,
          x_msg_data		=>	x_msg_data
          );

Line: 214

        eam_asset_log_pvt.insert_row
        ( p_event_date		=>	p_event_date,
          p_event_type		=>	p_event_type,
          p_event_id		=>	p_event_id,
          p_organization_id	=>	l_organization_id,
          p_instance_id		=>	l_instance_id,
          p_comments		=>	p_comments,
          p_reference		=>	p_reference,
          p_ref_id		=>	p_ref_id,
          p_operable_flag		=>	p_operable_flag,
          p_reason_code		=>	p_reason_code,
          p_resource_id		=>	p_resource_id,
          p_equipment_gen_object_id =>	l_equipment_gen_object_id,
          p_source_log_id		=>	l_log_id,
          p_instance_number	=>	l_instance_number,
          p_downcode		=>	p_downcode,
          p_expected_up_date	=>	p_expected_up_date,
          p_employee_id		=>	p_employee_id,
          p_department_id		=>	p_department_id,
          x_return_status		=>	x_return_status,
          x_msg_count		=>	x_msg_count,
          x_msg_data		=>	x_msg_data
        );