The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl2(p_vendor_prodsrv_rec.segment1,
p_vendor_prodsrv_rec.segment1 || '.',
p_vendor_prodsrv_rec.segment1) ||
nvl2(p_vendor_prodsrv_rec.segment2,
p_vendor_prodsrv_rec.segment2 || '.',
p_vendor_prodsrv_rec.segment2) ||
nvl2(p_vendor_prodsrv_rec.segment3,
p_vendor_prodsrv_rec.segment3 || '.',
p_vendor_prodsrv_rec.segment3) ||
nvl2(p_vendor_prodsrv_rec.segment4,
p_vendor_prodsrv_rec.segment4 || '.',
p_vendor_prodsrv_rec.segment4) ||
nvl2(p_vendor_prodsrv_rec.segment5,
p_vendor_prodsrv_rec.segment5 || '.',
p_vendor_prodsrv_rec.segment5) ||
nvl2(p_vendor_prodsrv_rec.segment6,
p_vendor_prodsrv_rec.segment6 || '.',
p_vendor_prodsrv_rec.segment6) ||
nvl2(p_vendor_prodsrv_rec.segment7,
p_vendor_prodsrv_rec.segment7 || '.',
p_vendor_prodsrv_rec.segment7) ||
nvl2(p_vendor_prodsrv_rec.segment8,
p_vendor_prodsrv_rec.segment8 || '.',
p_vendor_prodsrv_rec.segment8) ||
nvl2(p_vendor_prodsrv_rec.segment9,
p_vendor_prodsrv_rec.segment9 || '.',
p_vendor_prodsrv_rec.segment9) ||
nvl2(p_vendor_prodsrv_rec.segment10,
p_vendor_prodsrv_rec.segment10 || '.',
p_vendor_prodsrv_rec.segment10) ||
nvl2(p_vendor_prodsrv_rec.segment11,
p_vendor_prodsrv_rec.segment11 || '.',
p_vendor_prodsrv_rec.segment11) ||
nvl2(p_vendor_prodsrv_rec.segment12,
p_vendor_prodsrv_rec.segment12 || '.',
p_vendor_prodsrv_rec.segment12) ||
nvl2(p_vendor_prodsrv_rec.segment13,
p_vendor_prodsrv_rec.segment13 || '.',
p_vendor_prodsrv_rec.segment13) ||
nvl2(p_vendor_prodsrv_rec.segment14,
p_vendor_prodsrv_rec.segment14 || '.',
p_vendor_prodsrv_rec.segment14) ||
nvl2(p_vendor_prodsrv_rec.segment15,
p_vendor_prodsrv_rec.segment15 || '.',
p_vendor_prodsrv_rec.segment15) ||
nvl2(p_vendor_prodsrv_rec.segment16,
p_vendor_prodsrv_rec.segment16 || '.',
p_vendor_prodsrv_rec.segment16) ||
nvl2(p_vendor_prodsrv_rec.segment17,
p_vendor_prodsrv_rec.segment17 || '.',
p_vendor_prodsrv_rec.segment17) ||
nvl2(p_vendor_prodsrv_rec.segment18,
p_vendor_prodsrv_rec.segment18 || '.',
p_vendor_prodsrv_rec.segment18) ||
nvl2(p_vendor_prodsrv_rec.segment19,
p_vendor_prodsrv_rec.segment19 || '.',
p_vendor_prodsrv_rec.segment19) ||
nvl2(p_vendor_prodsrv_rec.segment20,
p_vendor_prodsrv_rec.segment20 || '.',
p_vendor_prodsrv_rec.segment20)
INTO l_segment_concat
FROM dual;
SELECT pos_product_service_bo(ps.classification_id,
ps.vendor_id,
ps.segment1,
ps.segment2,
ps.segment3,
ps.segment4,
ps.segment5,
ps.segment6,
ps.segment7,
ps.segment8,
ps.segment9,
ps.segment10,
ps.segment11,
ps.segment12,
ps.segment13,
ps.segment14,
ps.segment15,
ps.segment16,
ps.segment17,
ps.segment18,
ps.segment19,
ps.segment20,
ps.status,
ps.segment_definition,
ps.created_by,
ps.creation_date,
ps.last_updated_by,
ps.last_update_date,
ps.last_update_login) BULK COLLECT
INTO l_pos_product_service_bo_tbl
FROM pos_sup_products_services ps,
ap_suppliers ap
WHERE ap.party_id = l_party_id
AND ps.vendor_id = ap.vendor_id;
SELECT mapping_id
INTO l_mapping_id
FROM pos_supplier_mappings
WHERE vendor_id = p_vendor_prodsrv_rec(i).vendor_id
AND party_id = l_party_id;
* Use this routine to update status field of product service table
* @param p_api_version The version of API
* @param p_init_msg_list The Initialization message list
* @param p_req_id The classification id
* @param p_status The status to be updated with
* @param x_return_status The return status
* @param x_msg_count The message count
* @param x_msg_data The message data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Create Supplier Contact
* @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
*/
/* PROCEDURE update_pos_prod_service_status(p_req_id IN NUMBER,
p_status IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
BEGIN
UPDATE pos_sup_products_services
SET status = p_status,
last_updated_by = fnd_global.user_id,
last_update_date = SYSDATE,
last_update_login = fnd_global.login_id
WHERE classification_id = p_req_id;
END update_pos_prod_service_status;