[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT config_type
INTO l_config_type
FROM bsc_kpis_b
WHERE short_name =p_region_code;
l_select_stmt VARCHAR2(32000);
SELECT lt.short_name
, lo.short_name
, lt.LEVEL_VALUES_VIEW_NAME
INTO l_time_level
, l_org_level
, l_view_name
FROM BIS_LEVELS lt
, BIS_LEVELS lo
, BIS_TARGET_LEVELS tl
WHERE tl.Target_level_id = p_Target_Level_id
AND lt.Level_ID = tl.Time_Level_id
AND lo.Level_ID = tl.org_Level_id;
l_select_stmt := ' SELECT PERIOD_SET_NAME, PERIOD_NAME, ID '||' '
||'FROM '||l_view_name||' '
||'WHERE ORGANIZATION_ID = :p_Organization_ID '
||'AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :l_org_level '
||' AND '
||' TO_DATE(TO_CHAR(:p_Date,'||''''||'DD-MM-RR'||''''
||'), '||''''||'DD-MM-RR'||''''||')'
||' BETWEEN '
||' TO_DATE(TO_CHAR(START_DATE,'||''''||'DD-MM-RR'||''''
||'), '||''''||'DD-MM-RR'||''''||') and '
||' TO_DATE(TO_CHAR(END_DATE,'||''''||'DD-MM-RR'||''''
||'), '||''''||'DD-MM-RR'||''''||')';
l_select_stmt := ' SELECT PERIOD_SET_NAME, PERIOD_NAME, ID '||' '
||'FROM '||l_view_name||' '
||'WHERE :p_Date BETWEEN NVL(START_DATE,:p_Date) '
||'AND NVL(END_DATE,:p_Date) ';
, statement => l_select_stmt
, language_flag => DBMS_SQL.NATIVE
);
select name from wf_role_lov_vl
where name = p_notify_resp_name;
SELECT bis_excpt_wf_s.nextval
INTO l_wf_item_key
FROM dual;
select created_by into l_created_by
from fnd_application
where application_id = p_application_id;
SELECT application_id
FROM FND_APPLICATION_VL
WHERE created_by NOT IN (1,2)
AND (created_by < 120 OR created_by > 129)
ORDER BY creation_date desc;
SELECT APPLICATION_ID
INTO l_Apps_Id
FROM FND_APPLICATION
WHERE UPPER(APPLICATION_SHORT_NAME) = UPPER(p_Application_Short_Name);
PROCEDURE Get_Update_Date_For_Owner (
p_owner IN VARCHAR2
,p_last_update_date IN VARCHAR2
,x_file_last_update_date OUT NOCOPY DATE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF ( (p_owner = 'ORACLE') AND (p_last_update_date IS NULL) ) THEN
RAISE FND_API.G_EXC_ERROR;
x_file_last_update_date := NVL(to_date(p_last_update_date, 'YYYY/MM/DD'), SYSDATE);
x_msg_data := x_msg_data ||' Upload failed: OWNER=''ORACLE'' and Last_Update_Date is missing.';
x_msg_data := 'Upload failed: OWNER=''ORACLE'' and Last_Update_Date is missing.';
x_msg_data := x_msg_data ||' -> BIS_UTIL.Get_Update_Date_For_Owner ';
x_msg_data := SQLERRM ||' at BIS_UTIL.Get_Update_Date_For_Owner ';
END Get_Update_Date_For_Owner;
PROCEDURE Validate_For_Update
(
p_last_update_date IN DATE
,p_owner IN VARCHAR2
,p_force_mode IN BOOLEAN
,p_table_name IN VARCHAR2
,p_key_value IN VARCHAR2
,x_ret_code OUT NOCOPY BOOLEAN
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_file_last_updated_by NUMBER;
l_db_last_updated_by NUMBER;
l_db_last_update_date DATE;
l_file_last_updated_by := fnd_load_util.OWNER_ID(p_owner);
SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bis_dimensions
WHERE short_name = p_key_value;
SELECT dim_tl.last_update_date, dim_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bis_dimensions_tl dim_tl, bis_dimensions dim
WHERE dim.short_name = p_key_value
AND dim_tl.dimension_id = dim.dimension_id
AND dim_tl.language = USERENV('LANG');
SELECT lev_tl.last_update_date, lev_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bis_levels_tl lev_tl, bis_levels lev
WHERE lev.short_name = p_key_value
AND lev.level_id = lev_tl.level_id
AND USERENV('LANG') = lev_tl.language;
SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bis_levels
WHERE short_name = p_key_value;
SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bsc_sys_dim_groups_vl
WHERE short_name = p_key_value;
SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
FROM bsc_sys_dim_levels_b
WHERE short_name = p_key_value;
x_ret_code := fnd_load_util.UPLOAD_TEST( p_file_id => l_file_last_updated_by
,p_file_lud => p_last_update_date
,p_db_id => l_db_last_updated_by
,p_db_lud => l_db_last_update_date
,p_custom_mode => l_custom_mode);
x_msg_data := x_msg_data ||' -> BIS_UTIL.Validate_For_Update ';
x_msg_data := SQLERRM ||' at BIS_UTIL.Validate_For_Update ';
END Validate_For_Update;
'SELECT bis_lvl.short_name, bis_lvl.name
FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp
WHERE bis_dim.dim_grp_id = bsc_dim.dim_group_id
AND bis_lvl.short_name = bsc_lvl.short_name
AND bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
AND bis_dim.short_name = :1';
SELECT level_table_name INTO l_dim_bsc_table
FROM bsc_sys_dim_levels_b
WHERE short_name = p_dim_object;
l_sql_stmt := ' DELETE FROM ' || l_dim_bsc_table;
l_sql_stmt := ' INSERT INTO '||l_dim_bsc_table||
' (CODE, USER_CODE, NAME, LANGUAGE, SOURCE_LANG) '||
' SELECT '||id||' AS CODE, '||
' '''||TO_CHAR(id)||''' AS USER_CODE, '||
' '''||value||''' AS NAME, L.LANGUAGE_CODE, '||
' USERENV(''LANG'') '||
' FROM FND_LANGUAGES L '||
' WHERE L.INSTALLED_FLAG IN (''I'', ''B'') '||
' AND NOT EXISTS '||
' ( SELECT NULL FROM '||l_dim_bsc_table||
' T WHERE T.CODE = '||id||' '||
' AND T.LANGUAGE = L.LANGUAGE_CODE) ';
SELECT function_name
FROM fnd_form_functions_vl
WHERE parameters LIKE 'pRegionCode=' || p_Region_Code || '&pRequestType=P%';
l_sql_stmt := ' SELECT value FROM ' || p_view_name || ' WHERE id = ''' || p_id || ''' AND rownum < 2';
SELECT level_values_view_name
FROM bis_levels
WHERE short_name = p_dim_object;
SELECT total_flag
FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp
WHERE bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
AND bis_dim.dim_grp_id = lvl_by_grp.dim_group_id
AND bsc_lvl.short_name = p_dim_object
AND bis_dim.short_name = p_dimension;
l_sql_stmt := ' SELECT id, value FROM ' || l_view_name_rec.level_values_view_name || ' WHERE rownum < 2 ';
SELECT att_value
FROM jdr_attributes
WHERE att_name = 'windowTitle' AND att_comp_docid IN
(SELECT UNIQUE a.att_comp_docid
FROM jdr_attributes a, jdr_attributes b
WHERE a.att_comp_docid = b.att_comp_docid AND a.att_comp_seq = b.att_comp_seq
AND a.att_name = 'user:akAttribute3' AND a.att_value = p_portlet_type
AND b.att_name = 'user:akAttribute1' AND b.att_value = p_portlet_func_name);
SELECT function_name, user_function_name
FROM fnd_form_functions_vl
WHERE parameters like p_param_search_string;
SELECT menu_id
FROM fnd_menu_entries fnd_mnu_ent, fnd_form_functions fnd_ff
WHERE fnd_mnu_ent.function_id = fnd_ff.function_id
AND fnd_ff.function_name = p_function_name;
SELECT fnd_resp.responsibility_id
FROM fnd_responsibility fnd_resp, fnd_menu_entries fnd_mnu_ent, fnd_user_resp_groups fnd_usr_resp
WHERE fnd_resp.menu_id = fnd_mnu_ent.menu_id
AND fnd_usr_resp.responsibility_id = fnd_resp.responsibility_id
AND fnd_mnu_ent.menu_id = l_menu_id
AND fnd_usr_resp.user_id = l_user_id
AND fnd_usr_resp.start_date <= sysdate
AND (fnd_usr_resp.end_date is null or fnd_usr_resp.end_date >= sysdate)
AND fnd_resp.start_date <= sysdate
AND (fnd_resp.end_date is null or fnd_resp.end_date >= sysdate)
AND rownum < 2;
SELECT menu_id
FROM fnd_menu_entries
WHERE sub_menu_id = l_sub_menu_id;
SELECT function_name
FROM fnd_form_functions
WHERE ((type = 'JSP' AND (web_html_call LIKE 'bisviewm.jsp%' OR web_html_call like 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%'))
OR (type = 'WWW' AND LOWER(web_html_call) LIKE 'bisviewer.showreport%'))
AND UPPER(parameters) LIKE UPPER('%pRegionCode=' || p_region_code || '%')
AND rownum < 2;
SELECT fnd_resp.responsibility_id
FROM fnd_responsibility fnd_resp, wf_role_lov_vl wf
WHERE fnd_resp.responsibility_id = wf.orig_system_id
AND wf.name = p_owner
AND wf.orig_system like 'FND_RESP%'
AND rownum < 2; -- Just to avoid any failure here.
SELECT fnd_usr.user_id
FROM fnd_user fnd_usr, wf_role_lov_vl wf
WHERE wf.name = p_owner
AND ((wf.orig_system = 'FND_USR' AND fnd_usr.user_id = wf.orig_system_id) OR
(wf.orig_system = 'PER' AND fnd_usr.employee_id = wf.orig_system_id)
);
SELECT security_group_id
FROM fnd_user_resp_groups_direct
WHERE user_id = p_user_id
AND responsibility_id = p_resp_id
AND rownum < 2;
SELECT security_group_id
FROM fnd_security_groups
WHERE security_group_key = l_sec_grp_key;
SELECT 1
FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim
WHERE sys_dim_group.dim_group_id = sys_dim_level_group.dim_group_id
AND sys_dim_levels.dim_level_id = sys_dim_level_group.dim_level_id
AND sys_dim_group.dim_group_id = bis_dim.dim_grp_id
AND sys_dim_levels.short_name = bis_level.short_name
AND sys_dim_group.short_name = l_dim
AND sys_dim_levels.short_name = l_dim_level;
SELECT
bis_measures.name INTO l_measure_name
FROM
bis_indicators_vl bis_measures
WHERE
bis_measures.short_name = p_attribute2;
SELECT
bis_measures.name INTO l_measure_name
FROM
bis_indicators_vl bis_measures,
ak_region_items_vl akRegionItems
WHERE
akRegionItems.region_code = p_region_code AND
akRegionItems.attribute_code = p_attribute2 AND
akRegionItems.attribute2 = bis_measures.short_name;
SELECT region_code, region_application_id, attribute_code, attribute_application_id
FROM ak_region_items
WHERE attribute2 = p_measure_short_name
AND attribute1 IN ('MEASURE_NOTARGET', 'MEASURE')
AND NOT(region_code = p_current_region_code AND region_application_id = p_current_region_appid)
AND NVL(BIS_REPORT_PUB.getRegionDataSourceType(p_current_region_code),' ') <> 'MULTIPLE_DATA_SOURCE'
AND BIS_UTIL.Is_Simulation_Report(region_code) <> FND_API.G_TRUE
AND rownum < 2 ;
SELECT attribute_code, attribute_application_id
FROM ak_region_items
WHERE region_code = p_region_code
AND region_application_id = p_region_appid
AND attribute1 IN ('COMPARE_TO_MEASURE', 'COMPARE_TO_MEASURE_NO_TARGET')
AND attribute2 = p_measure_attrcode ;
SELECT dim_group.name
FROM
bsc_sys_dim_levels_by_group dim_lev_by_group,
bsc_sys_dim_levels_vl dim_lev,
bsc_sys_dim_groups_vl dim_group
WHERE
dim_lev.short_name=p_dim_lev_short_name
AND dim_lev_by_group.dim_level_id = dim_lev.dim_level_id
AND dim_lev_by_group.dim_group_id = dim_group.dim_group_id
AND bis_util.is_seeded(dim_group.created_by,'Y','N') = 'Y';