[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TARGET_LEVEL_ID,MEASURE_SHORT_NAME,MEASURE_NAME
INTO l_target_level,MEASURE_SHORT_NAME,MEASURE_NAME
FROM BISBV_TARGET_LEVELS L
, BISBV_PERFORMANCE_MEASURES M
WHERE M.MEASURE_ID = L.MEASURE_ID
AND M.MEASURE_SHORT_NAME = p_MEASURE_SHORT_NAME
--AND ((l_ORG_LEVEL_ID IS NOT NULL
--AND L.ORG_LEVEL_ID = l_ORG_LEVEL_ID)
--OR (l_ORG_LEVEL_ID IS NULL))
--AND ((l_TIME_LEVEL_ID IS NOT NULL
--AND L.TIME_LEVEL_ID = l_TIME_LEVEL_ID)
--OR (l_TIME_LEVEL_ID IS NULL))
AND ((l_DIMENSION1_LEVEL_ID IS NOT NULL
AND L.DIMENSION1_LEVEL_ID = l_DIMENSION1_LEVEL_ID)
OR (l_DIMENSION1_LEVEL_ID IS NULL))
AND ((l_DIMENSION2_LEVEL_ID IS NOT NULL
AND L.DIMENSION2_LEVEL_ID = l_DIMENSION2_LEVEL_ID)
OR (l_DIMENSION2_LEVEL_ID IS NULL))
AND ((l_DIMENSION3_LEVEL_ID IS NOT NULL
AND L.DIMENSION3_LEVEL_ID = l_DIMENSION3_LEVEL_ID)
OR (l_DIMENSION3_LEVEL_ID IS NULL))
AND ((l_DIMENSION4_LEVEL_ID IS NOT NULL
AND L.DIMENSION4_LEVEL_ID = l_DIMENSION4_LEVEL_ID)
OR (l_DIMENSION4_LEVEL_ID IS NULL))
AND ((l_DIMENSION5_LEVEL_ID IS NOT NULL
AND L.DIMENSION5_LEVEL_ID = l_DIMENSION5_LEVEL_ID)
OR (l_DIMENSION5_LEVEL_ID IS NULL))
AND ((l_DIMENSION6_LEVEL_ID IS NOT NULL
AND L.DIMENSION6_LEVEL_ID = l_DIMENSION6_LEVEL_ID)
OR (l_DIMENSION6_LEVEL_ID IS NULL))
AND ((l_DIMENSION7_LEVEL_ID IS NOT NULL
AND L.DIMENSION7_LEVEL_ID = l_DIMENSION7_LEVEL_ID)
OR (l_DIMENSION7_LEVEL_ID IS NULL));
SELECT TARGET, range1_low, range1_high
INTO l_target, v_range1_low, v_range1_high
FROM BISBV_TARGETS
WHERE TARGET_LEVEL_ID = P_TARGET_LEVEL_ID
--AND (( P_ORG_LEVEL_VALUE IS NOT NULL
--AND ORG_LEVEL_VALUE_ID = P_ORG_LEVEL_VALUE )
--OR (P_ORG_LEVEL_VALUE IS NULL))
--AND (( UPPER(TIME_LEVEL_VALUE_ID) IS NOT NULL
--AND UPPER(TIME_LEVEL_VALUE_ID) = UPPER(p_TIME_LEVEL_VALUE) )
--OR ( UPPER(TIME_LEVEL_VALUE_ID) IS NULL))
AND ((p_DIMENSION1_LEVEL_VALUE IS NOT NULL
AND DIM1_LEVEL_VALUE_ID = p_DIMENSION1_LEVEL_VALUE )
OR (p_DIMENSION1_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION2_LEVEL_VALUE IS NOT NULL
AND DIM2_LEVEL_VALUE_ID = p_DIMENSION2_LEVEL_VALUE )
OR (p_DIMENSION2_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION3_LEVEL_VALUE IS NOT NULL
AND DIM3_LEVEL_VALUE_ID = p_DIMENSION3_LEVEL_VALUE )
OR (p_DIMENSION3_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION4_LEVEL_VALUE IS NOT NULL
AND DIM4_LEVEL_VALUE_ID = p_DIMENSION4_LEVEL_VALUE )
OR (p_DIMENSION4_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION5_LEVEL_VALUE IS NOT NULL
AND DIM5_LEVEL_VALUE_ID = p_DIMENSION5_LEVEL_VALUE )
OR (p_DIMENSION5_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION6_LEVEL_VALUE IS NOT NULL
AND DIM6_LEVEL_VALUE_ID = p_DIMENSION6_LEVEL_VALUE )
OR (p_DIMENSION6_LEVEL_VALUE IS NULL))
AND ((p_DIMENSION7_LEVEL_VALUE IS NOT NULL
AND DIM7_LEVEL_VALUE_ID = p_DIMENSION7_LEVEL_VALUE )
OR (p_DIMENSION7_LEVEL_VALUE IS NULL))
AND PLAN_ID = p_plan;
Select LEVEL_ID
Into l_level_id
From BIS_LEVELS
Where short_name = p_Level_Short_Name ;
select bth.parent_territory_code
into vAreaCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'AREA'
and bth.child_territory_type = 'COUNTRY'
and bth.child_territory_code = vGeoLevelValue;
select bth.parent_territory_code
into vCountryCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'COUNTRY'
and bth.child_territory_type = 'REGION'
and bth.child_territory_code = vGeoLevelValue;
select bth.parent_territory_name
into vAreaCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'AREA'
and bth.child_territory_type = 'COUNTRY'
and bth.child_territory_code = vCountryCode;
SELECT distinct TARGET_LEVEL_ID, L.MEASURE_ID
INTO l_target_level_id, v_meas_id
FROM BISBV_TARGET_LEVELS L
, BISBV_PERFORMANCE_MEASURES M
WHERE M.MEASURE_ID = L.MEASURE_ID
AND M.MEASURE_SHORT_NAME = p_MEASURE_SHORT_NAME
AND L.ORG_LEVEL_ID = l_ORG_LEVEL_ID
AND L.TIME_LEVEL_ID = l_TIME_LEVEL_ID
AND ((l_DIMENSION1_LEVEL_ID IS NOT NULL
AND L.DIMENSION1_LEVEL_ID = l_DIMENSION1_LEVEL_ID)
OR (l_DIMENSION1_LEVEL_ID IS NULL))
AND ((l_DIMENSION2_LEVEL_ID IS NOT NULL
AND L.DIMENSION2_LEVEL_ID = l_DIMENSION2_LEVEL_ID)
OR (l_DIMENSION2_LEVEL_ID IS NULL))
AND ((l_DIMENSION3_LEVEL_ID IS NOT NULL
AND L.DIMENSION3_LEVEL_ID = l_DIMENSION3_LEVEL_ID)
OR (l_DIMENSION3_LEVEL_ID IS NULL))
AND ((l_DIMENSION4_LEVEL_ID IS NOT NULL
AND L.DIMENSION4_LEVEL_ID = l_DIMENSION4_LEVEL_ID)
OR (l_DIMENSION4_LEVEL_ID IS NULL))
AND ((l_DIMENSION5_LEVEL_ID IS NOT NULL
AND L.DIMENSION5_LEVEL_ID = l_DIMENSION5_LEVEL_ID)
OR (l_DIMENSION5_LEVEL_ID IS NULL));
select application_id
from fnd_responsibility
where responsibility_id=pRespId;
select application_id into l_application_id
from fnd_responsibility
where responsibility_id=l_fn_responsibility_id;
select function_id
into l_customize_id
from fnd_form_functions
where function_name = l_form_func_name;
select FND_FORM_FUNCTIONS_S.NEXTVAL into l_customize_id from dual;
fnd_form_functions_pkg.INSERT_ROW(
X_ROWID => l_rowid,
X_FUNCTION_ID => l_customize_id,
X_WEB_HOST_NAME => null,
X_WEB_AGENT_NAME => null,
X_WEB_HTML_CALL => l_form_func_call,
X_WEB_ENCRYPT_PARAMETERS => null,
X_WEB_SECURED => null,
X_WEB_ICON => null,
X_OBJECT_ID => null,
X_REGION_APPLICATION_ID => null,
X_REGION_CODE => null,
X_FUNCTION_NAME => l_form_func_name,
X_APPLICATION_ID => l_application_id,
X_FORM_ID => null,
X_PARAMETERS => null,
X_TYPE => 'JSP',
X_USER_FUNCTION_NAME => 'BIS SCHEDULE',
X_DESCRIPTION => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => l_user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => l_user_id,
X_LAST_UPDATE_LOGIN => l_user_id);
fnd_form_functions_pkg.insert_row (l_rowid,
l_customize_id, null,null,
l_form_func_call,
null,null,null,l_form_func_name,
l_application_id,null,null,'JSP','BIS SCHEDULE',
null,sysdate,l_user_id,sysdate,l_user_id,l_user_id);
select bth.parent_territory_code
into vAreaCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'AREA'
and bth.child_territory_type = 'COUNTRY'
and bth.child_territory_code = vGeoLevelValue;
select bth.parent_territory_code
into vCountryCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'COUNTRY'
and bth.child_territory_type = 'REGION'
and bth.child_territory_code = vGeoLevelValue;
select bth.parent_territory_name
into vAreaCode
from bis_territory_hierarchies_v bth
where bth.parent_territory_type = 'AREA'
and bth.child_territory_type = 'COUNTRY'
and bth.child_territory_code = vCountryCode;
BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
p_DimLevelShortName => vTotalLevel
,p_bis_source => pDimSource
,x_Select_String => v_sql_stmnt
,x_table_name=> v_table
,x_id_name=> v_id_name
,x_value_name=> v_value_name
,x_return_status=> v_return_status
,x_msg_count=> v_msg_count
,x_msg_data=> v_msg_data
);
vSql := 'select '||v_id_name||' from '||v_table;
SELECT dimension_id
FROM bis_dimensions
WHERE short_name = pDimShortName;
SELECT short_name
FROM bis_levels
where short_name like p_Search_string AND
dimension_id= p_dim_id;