[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lookup_code
INTO l_dummy_lookup
FROM fnd_lookup_values
WHERE lookup_type = p_vendor_buss_class_rec.lookup_type
AND lookup_code = p_vendor_buss_class_rec.lookup_code
AND enabled_flag = 'Y'
AND nvl(end_date_active, SYSDATE + 1) > SYSDATE
AND LANGUAGE = 'US';
SELECT lookup_code
INTO l_dummy_lookup
FROM fnd_lookup_values_vl
WHERE lookup_type = 'MINORITY GROUP'
AND lookup_code = p_vendor_buss_class_rec.ext_attr_1
AND enabled_flag = 'Y'
AND nvl(end_date_active, SYSDATE + 1) > SYSDATE;
SELECT pos_business_class_bo(classification_id,
party_id,
lookup_type,
lookup_code,
start_date_active,
end_date_active,
status,
ext_attr_1,
expiration_date,
certificate_number,
certifying_agency,
class_status,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
vendor_id) BULK COLLECT
INTO l_pos_bus_class_bo_tbl
FROM pos_bus_class_attr
WHERE party_id = p_party_id;
p_create_update_flag IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_count NUMBER;
SELECT 1
INTO v_row_exists
FROM pos_bus_class_attr
WHERE party_id = p_party_id
AND lookup_code = p_pos_bus_class_bo(I).lookup_code
AND lookup_type = p_pos_bus_class_bo(I).lookup_type
AND rownum < 2;
IF p_create_update_flag = 'C' THEN
validate_vendor_buss_class(p_vendor_buss_class_rec => p_vendor_buss_class_rec,
p_party_id => p_party_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_buss_valid => l_buss_valid);
ELSIF p_create_update_flag = 'U' THEN
---Update
BEGIN
SELECT classification_id
INTO l_classification_id
FROM pos_bus_class_attr
WHERE party_id = l_party_id
AND vendor_id = p_vendor_buss_class_rec.vendor_id
AND lookup_code =
p_vendor_buss_class_rec.lookup_code;
SELECT mapping_id
INTO l_mapping_id
FROM pos_supplier_mappings
WHERE party_id = l_party_id
AND vendor_id = p_vendor_buss_class_rec.vendor_id;
SELECT bus_class_request_id
INTO l_buss_class_req_id
FROM pos_bus_class_reqs
WHERE mapping_id = l_mapping_id
AND lookup_code =
p_vendor_buss_class_rec.lookup_code;
pos_supp_classification_pkg.update_bus_class_attr(p_party_id => l_party_id,
p_vendor_id => p_vendor_buss_class_rec.vendor_id,
p_selected => '',
p_classification_id => l_classification_id,
p_request_id => l_buss_class_req_id,
p_lookup_code => p_vendor_buss_class_rec.lookup_code,
p_exp_date => p_vendor_buss_class_rec.expiration_date,
p_cert_num => p_vendor_buss_class_rec.certificate_number,
p_cert_agency => p_vendor_buss_class_rec.certifying_agency,
p_ext_attr_1 => p_vendor_buss_class_rec.ext_attr_1,
p_class_status => p_vendor_buss_class_rec.class_status,
x_classification_id => l_out_classification_id,
x_request_id => l_out_buss_class_req_id,
x_status => l_return_status,
x_exception_msg => l_msg_data);