The following lines contain the word 'select', 'insert', 'update' or 'delete':
select responsibility_id
from fnd_responsibility_vl
where application_id = l_application_id
and responsibility_name = l_resp_name;
select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;
SELECT APPLICATION_ID
INTO l_application_id
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME = 'MSC'
and rownum = 1;
SELECT responsibility_id
INTO l_resp_id
FROM FND_responsibility_vl
where application_Id = l_application_id
and rownum =1 ;
SELECT APPLICATION_ID
INTO l_application_id
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME = 'MRP'
and rownum = 1;
SELECT responsibility_id
INTO l_resp_id
FROM FND_responsibility_vl
where application_Id = l_application_id
and rownum =1 ;
PROCEDURE validate_pjm_selectAll(p_server_dblink IN varchar2,
p_user_name IN varchar2,
p_plan_id IN number,
p_query_id IN number) IS
sql_stmt varchar2(500);
' SELECT number1, -- trx_id
number2, -- organization_id,
date1, -- new_schedule_date,
number3, -- project_id,
number4 -- task_id
FROM mrp_form_query '||p_server_dblink||
' WHERE query_id = :p_query_id ';
select user_id
INTO l_user_id
FROM fnd_user
where user_name= p_user_name; -- here I can pass any userid
SELECT APPLICATION_ID
INTO l_application_id
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME ='PJM'
and rownum = 1;
SELECT responsibility_id
INTO l_resp_id
FROM FND_responsibility_vl
where application_Id = l_application_id
and rownum = 1;
select operating_unit
INTO l_operating_unit_id
FROM org_organization_definitions
WHERE organization_id=p_org ; --3983540
sql_stmt:= 'update msc_supplies ' ||p_server_dblink ||
' SET implement_as = NULL,
implement_quantity = NULL,
implement_date = NULL,
release_status = 2,
release_errors = :p_error
where transaction_id = :p_transaction_id
and plan_id = :plan_id';
END validate_pjm_selectAll;
select user_id
INTO l_user_id
FROM fnd_user
where user_name= p_user_name; -- here I can pass any userid
SELECT APPLICATION_ID
INTO l_application_id
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME ='PJM'
and rownum = 1;
SELECT responsibility_id
INTO l_resp_id
FROM FND_responsibility_vl
where application_Id = l_application_id
and rownum = 1;
select operating_unit
INTO l_operating_unit_id
FROM org_organization_definitions
WHERE organization_id=p_org ; --3983540
select user_id
into l_user_id
from fnd_user
where user_name = p_user_name;
select application_id
into l_appl_id
from fnd_application_vl
where application_short_name = p_appl_name;
select responsibility_id
into l_resp_id
from fnd_responsibility_vl
where responsibility_name = p_resp_name
and application_Id = l_appl_id;
select fnd_profile.value_specific ( p_prof_name
, l_user_id
, l_resp_id
, l_appl_id
)
into rc from dual;