[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select file_data
into loc
from FND_LOBS
where file_id = pFileId;
select count(*)
into l_count
from fnd_lobs
where file_id = document_id;
select to_char(SYSDATE, 'HH24')
into x_current_hour
from dual;
select to_char(SYSDATE, 'MI')
into x_current_minute
from dual;
select name
into l_function
from ak_regions_vl
where region_code = pRegionCode;
l_function := 'select '||l_function||' from dual';
vHierSQL := ' select distinct ih.elementid, ih.longname'||
' from cmpwbdimension_v d, cmpitemhierarchy_v ih, '||
' cmplevelrelationship_v lr1'||
' , cmplevel_v l '||
' where ih.name = :1 and d.name = :2 '||
' and ih.elementid = lr1.HIERARCHY '||
' and lr1.CHILDLEVEL = l.ELEMENTID '||
' and d.elementid = ih.owndimension ';
vHierSQL := ' select distinct hier.hier_id, hier.hier_long_name' ||
' from edw_hierarchies_md_v hier, EDW_HIERARCHY_LEVEL_MD_V hierlvl' ||
' where hier.hier_id = hierlvl.hier_id' ||
' and hier.hier_name = :1 and hier.dim_name = :2';
SELECT attribute2 FROM
ak_region_items
WHERE region_code=rtrim(ltrim(pRegionCode)) and
(ltrim(rtrim(pAttributeCode)) in (attribute_code, attribute_code||'_FROM',
attribute_code||'_TO', attribute_code||'_HIERARCHY'));
SELECT attribute_code FROM
ak_region_items
WHERE region_code=rtrim(ltrim(pRegionCode)) and
attribute2=ltrim(rtrim(pDimension));
select web_html_call,parameters,type
from fnd_form_functions
where function_name = cpFunctionName;
select web_html_call
,parameters
,type
into l_web_html_call, l_parameters, l_type
from fnd_form_functions
where function_name = pFunctionName;
select web_html_call
,parameters
,type
into l_web_html_call, l_parameters, l_type
from fnd_form_functions
where function_name = l_ref_function_name;
SELECT 1
FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
WHERE MEV.MENU_ID = l_menu_id
AND RF.RESPONSIBILITY_ID (+) = l_resp_id
AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')
AND RF.ACTION_ID(+) <> DECODE(DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F'), 'F', MEV.FUNCTION_ID,
'M', MEV.SUB_MENU_ID, null)
AND RF.ACTION_ID IS NULL
AND MEV.FUNCTION_ID = FF.FUNCTION_ID
AND FF.function_name = l_function_name
AND RF.APPLICATION_ID(+) = l_appl_id
UNION
SELECT 1
FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
WHERE MEV.MENU_ID IN(
SELECT SUB_MENU_ID
FROM FND_MENU_ENTRIES
WHERE SUB_MENU_ID IS NOT NULL
CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID =l_menu_id)
AND RF.RESPONSIBILITY_ID (+) = l_resp_id
AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')
AND RF.ACTION_ID(+) <> DECODE(DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F'), 'F', MEV.FUNCTION_ID,
'M', MEV.SUB_MENU_ID, null)
AND RF.ACTION_ID IS NULL
AND MEV.FUNCTION_ID = FF.FUNCTION_ID
AND FF.function_name = l_function_name
AND RF.APPLICATION_ID(+) = l_appl_id;
select a.responsibility_id resp_id , a.menu_id menu_id, a.application_id appl_id
from fnd_responsibility a,
fnd_user_resp_groups b
where b.user_id = l_user_id
and a.version = 'W'
and b.responsibility_id = a.responsibility_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date >= sysdate)
and a.start_date <= sysdate
and (a.end_date is null or a.end_date >= sysdate)
and b.responsibility_application_id=a.application_id;
select user_name
from fnd_user
where user_id=puserid;
icx_portlet.updateCacheByUserFunc(l_user_name, pfunctionname);*/
update icx_portlet_customizations
set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
where user_id = puserid and
plug_id = pPlugId;
PROCEDURE update_portlets_bypage(p_page_id in varchar2) IS
l_append_title varchar2(2000);
l_function := 'update icx_portlet_customizations set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,''0''))+1) where reference_path in (select name from wwpob_portlet_instance$ where page_id=:1)';
SELECT attribute9
FROM ak_regions
WHERE region_code = p_region_code;
lSQL := 'select bis_portlet_trends.getPortalPageId(:1) from dual';
SELECT region_application_id FROM ak_regions
WHERE region_code = cp_region_code;
UPDATE icx_portlet_customizations
SET caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
WHERE reference_path = pReferencePath;
UPDATE icx_portlet_customizations
SET caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
WHERE plug_id = pPlugId;
SELECT web_html_call, parameters, type
FROM fnd_form_functions
WHERE function_name = pPageFunctionName;
SELECT FF.FUNCTION_NAME
FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF
WHERE MEV.MENU_ID IN (
SELECT SUB_MENU_ID
FROM FND_MENU_ENTRIES
WHERE SUB_MENU_ID IS NOT NULL
CONNECT BY MENU_ID = PRIOR SUB_MENU_ID START WITH MENU_ID = (SELECT MENU_ID FROM FND_MENUS
WHERE MENU_NAME=p_menu_name)
)
AND MEV.FUNCTION_ID = FF.FUNCTION_ID
AND BIS_PMV_UTIL.getParameterValue(FF.PARAMETERS, 'pRequestType') = 'P';
select att_value
from jdr_attributes a, (select att_comp_docid, att_comp_seq from jdr_attributes
where att_comp_docId in (select comp_docid from JDR_COMPONENTS
where comp_element like 'oa:pageLayout'
and comp_id = 'BisPage')
and att_name = 'user:akAttribute3'
and att_value = 'PARAMETER_PORTLET') b
where a.att_comp_docId = b.att_comp_docid
and a.att_comp_seq = b.att_comp_seq
and a.att_name = 'user:akAttribute1'
and a.att_value is not null
and a.att_comp_docId=p_doc_id;
SELECT path_docid --, path_type
INTO l_doc_id --, l_type
FROM jdr_paths
WHERE path_name = l_name AND path_owner_docid = l_owner_id;
l_sql := 'SELECT DISTINCT menu_id FROM fnd_menu_entries where function_id in (';
l_sql := 'SELECT distinct delegations.instance_pk1_value, parameter_view.value FROM fnd_grants delegations, fnd_objects parameter_object, '
|| pParameterView || ' parameter_view WHERE delegations.GRANTEE_KEY = :1 and parameter_object.obj_name = :2 '
|| 'and trunc(:3) between trunc(delegations.start_date) and trunc(delegations.end_date) and delegations.instance_pk1_value = to_char(parameter_view.id)'
|| 'and delegations.object_id = parameter_object.object_id and delegations.menu_id in ( ';
SELECT application_name FROM ak_regions R, fnd_application_vl A
WHERE R.region_code = cp_region_code AND R.region_application_id = A.application_id;
SELECT application_name
FROM fnd_application_vl app
WHERE app.application_short_name = l_code;
SELECT attribute10 FROM ak_regions
WHERE region_code = cp_region_code;
select file_content_type, file_data
into content_type, data
from fnd_lobs
where file_id = l_file_id;