[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT object_id
INTO l_object_id
FROM csi_ii_relationships
WHERE LEVEL = ( SELECT MAX(LEVEL)
FROM csi_ii_relationships
START WITH subject_id = p_instance_id
CONNECT BY subject_id = PRIOR object_id
)
AND relationship_type_code = p_relationship_type_code
START WITH subject_id = p_instance_id
CONNECT BY subject_id = PRIOR object_id;
FUNCTION R_COUNT ( L_SELECT IN VARCHAR2)
RETURN Number IS
l_count Number := 0;
EXECUTE IMMEDIATE l_select
Into l_count;
SELECT attribute_id
INTO x_attribute_id
FROM csi_i_extended_attribs
WHERE attribute_level=p_ext_attrib_rec.attribute_level
AND (l_master_org_id IS NULL
OR
( l_master_org_id IS NOT NULL
AND master_organization_id =l_master_org_id) )
AND (l_inv_item_id IS NULL
OR
( l_inv_item_id IS NOT NULL
AND inventory_item_id =l_inv_item_id) )
AND (l_item_category_id IS NULL
OR
( l_item_category_id IS NOT NULL
AND item_category_id =l_item_category_id) )
AND (l_instance_id IS NULL
OR
( l_instance_id IS NOT NULL
AND instance_id =l_instance_id) )
AND attribute_code =p_ext_attrib_rec.attribute_code;
csi_i_ext_attrib_pkg.insert_row(
px_attribute_id => x_attribute_id ,
p_attribute_level => p_ext_attrib_rec.attribute_level,
p_master_organization_id => p_ext_attrib_rec.master_organization_id,
p_inventory_item_id => p_ext_attrib_rec.inventory_item_id,
p_item_category_id => p_ext_attrib_rec.item_category_id,
p_instance_id => p_ext_attrib_rec.instance_id,
p_attribute_code => p_ext_attrib_rec.attribute_code,
p_attribute_name => p_ext_attrib_rec.attribute_name,
p_attribute_category => p_ext_attrib_rec.attribute_category,
p_description => p_ext_attrib_rec.description,
p_active_start_date => p_ext_attrib_rec.active_start_date,
p_active_end_date => p_ext_attrib_rec.active_end_date,
p_context => p_ext_attrib_rec.context,
p_attribute1 => p_ext_attrib_rec.attribute1,
p_attribute2 => p_ext_attrib_rec.attribute2,
p_attribute3 => p_ext_attrib_rec.attribute3,
p_attribute4 => p_ext_attrib_rec.attribute4,
p_attribute5 => p_ext_attrib_rec.attribute5,
p_attribute6 => p_ext_attrib_rec.attribute6,
p_attribute7 => p_ext_attrib_rec.attribute7,
p_attribute8 => p_ext_attrib_rec.attribute8,
p_attribute9 => p_ext_attrib_rec.attribute9,
p_attribute10 => p_ext_attrib_rec.attribute10,
p_attribute11 => p_ext_attrib_rec.attribute11,
p_attribute12 => p_ext_attrib_rec.attribute12,
p_attribute13 => p_ext_attrib_rec.attribute13,
p_attribute14 => p_ext_attrib_rec.attribute14,
p_attribute15 => p_ext_attrib_rec.attribute15,
p_created_by => fnd_global.user_id,
p_creation_date => SYSDATE,
p_last_updated_by => fnd_global.user_id,
p_last_update_date => SYSDATE,
p_last_update_login => fnd_global.conc_login_id,
p_object_version_number => 1
);
SELECT 'x'
INTO l_dummy
FROM csi_lookups
WHERE lookup_type = l_ext_lookup_type
AND lookup_code = p_ext_attrib_rec.attribute_level;
SELECT 'x'
INTO l_dummy
FROM mtl_category_set_valid_cats
WHERE category_id = p_ext_attrib_rec.item_category_id
AND category_set_id = ( SELECT category_set_id
FROM csi_install_parameters );
SELECT 'x'
INTO l_dummy
FROM mtl_system_items
WHERE organization_id = p_ext_attrib_rec.master_organization_id
AND inventory_item_id = p_ext_attrib_rec.inventory_item_id;
SELECT 'x'
INTO l_dummy
FROM csi_item_instances
WHERE instance_id = p_ext_attrib_rec.instance_id;
SELECT 'x'
INTO l_dummy
FROM csi_lookups
WHERE lookup_type=l_attrib_lookup_type
AND lookup_code=p_attribute_code;
SELECT 'x'
INTO l_dummy
FROM csi_lookups
WHERE lookup_type= l_cat_lookup_type
AND lookup_code=p_attribute_category;
SELECT cii.instance_id,
cii.instance_number,
cii.active_end_date,
cii.object_version_number
FROM csi_item_instances cii
WHERE nvl(cii.active_end_date , sysdate) < sysdate
AND cii.instance_status_id <> p_expired_status_id
AND not exists ( SELECT 'X' from csi_instance_statuses cis
WHERE cis.instance_status_id = cii.instance_status_id
AND cis.terminated_flag = 'Y');
SELECT 'Y'
INTO l_parent_found
FROM csi_ii_relationships
WHERE subject_id = exp_inst_rec.instance_id
AND relationship_type_code = 'COMPONENT_OF'
AND sysdate between nvl(active_start_date, sysdate -1)
and nvl(active_end_date, sysdate + 1);