The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name
, custom_setup_id
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_list_header_id;
SELECT name
, custom_setup_id
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_list_header_id;
SELECT name
, custom_setup_id
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_list_header_id;
SELECT name
, custom_setup_id
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_list_header_id;
SELECT name
, custom_setup_id
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_list_header_id;
SELECT name
, custom_setup_id
, 'PRIC'
, start_date_active
, end_date_active
, description
, owner_id
, currency_code
, user_status_name
, status_date
FROM ozf_price_lists_v
WHERE list_header_id = p_act_id;
PROCEDURE Update_PriceList_Status(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_PriceList_Status';
,aname => 'UPDATE_GEN_STATUS'
);
UPDATE ozf_price_list_attributes
SET user_status_id = l_next_status_id,
status_code = l_status_code,
status_date = SYSDATE,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id,
object_version_number = object_version_number + 1
WHERE qp_list_header_id = l_list_header_id;
UPDATE qp_list_headers_b
SET active_flag = 'Y',
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.conc_login_id
WHERE list_header_id = l_list_header_id;
'UPDATE_PRICELIST_STATUS',
itemtype, itemkey,to_char(actid),l_error_msg);
END Update_PriceList_Status;