The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_ind_selection_id IN NUMBER
,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
,x_err OUT NOCOPY VARCHAR2
) ;
p_ind_selection_id IN NUMBER,
p_target_level_id IN NUMBER,
p_time_dimension_level_id IN NUMBER,
x_current_period_id OUT NOCOPY VARCHAR2,
x_current_period_name OUT NOCOPY VARCHAR2
) IS
CURSOR c_source IS
SELECT source
FROM bis_target_levels
WHERE target_level_id = p_target_level_id;
SELECT x.sequence_no,
decode(x.sequence_no,
1, z.dimension1_level_id,
2, z.dimension2_level_id,
3, z.dimension3_level_id,
4, z.dimension4_level_id,
5, z.dimension5_level_id,
6, z.dimension6_level_id,
7, z.dimension7_level_id,
NULL) org_dimension_level_id
FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
WHERE x.dimension_id = y.dimension_id AND
y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
x.indicator_id = z.indicator_id AND
z.target_level_id = p_target_level_id;
SELECT decode(dimension_index,
1, dimension1_level_value,
2, dimension2_level_value,
3, dimension3_level_value,
4, dimension4_level_value,
5, dimension5_level_value,
6, dimension6_level_value,
7, dimension7_level_value,
NULL) dimension_level_value
FROM bis_user_ind_selections
WHERE ind_selection_id = p_ind_selection_id;
SELECT short_name
FROM bis_levels
WHERE level_id = org_level_id;
l_select_stmt VARCHAR2(2000);
x_select_String => l_select_stmt,
x_table_name => l_view_name,
x_value_name => l_value_name,
x_id_name => l_id_name,
x_level_name => l_name,
x_description => l_description,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', start_date, end_date'||
' FROM '||l_view_name;
l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', SYSDATE AS start_date, SYSDATE AS end_date'||
' FROM '||l_view_name;
p_ind_selection_id IN NUMBER,
p_target_level_id IN NUMBER,
p_time_dimension_level_id IN NUMBER,
p_current_period_id IN VARCHAR2,
p_current_period_name IN VARCHAR2,
x_next_period_id OUT NOCOPY VARCHAR2,
x_next_period_name OUT NOCOPY VARCHAR2
) IS
e_no_next_period EXCEPTION;
SELECT source
FROM bis_target_levels
WHERE target_level_id = p_target_level_id;
SELECT x.sequence_no,
decode(x.sequence_no,
1, z.dimension1_level_id,
2, z.dimension2_level_id,
3, z.dimension3_level_id,
4, z.dimension4_level_id,
5, z.dimension5_level_id,
6, z.dimension6_level_id,
7, z.dimension7_level_id,
NULL) org_dimension_level_id
FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
WHERE x.dimension_id = y.dimension_id AND
y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
x.indicator_id = z.indicator_id AND
z.target_level_id = p_target_level_id;
SELECT decode(dimension_index,
1, dimension1_level_value,
2, dimension2_level_value,
3, dimension3_level_value,
4, dimension4_level_value,
5, dimension5_level_value,
6, dimension6_level_value,
7, dimension7_level_value,
NULL) dimension_level_value
FROM bis_user_ind_selections
WHERE ind_selection_id = p_ind_selection_id;
SELECT short_name
FROM bis_levels
WHERE level_id = org_level_id;
l_select_stmt VARCHAR2(2000);
x_select_String => l_select_stmt,
x_table_name => l_view_name,
x_value_name => l_value_name,
x_id_name => l_id_name,
x_level_name => l_name,
x_description => l_description,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', start_date, end_date'||
' FROM '||l_view_name;
l_sql_aux := 'SELECT TO_CHAR(end_date + 1, ''MM-DD-YYYY'')'||
' FROM '||l_view_name||
' WHERE '||l_id_name||' = :1 '||
' AND ORGANIZATION_ID = :2 ' ||
' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :3 ';
l_sql_aux := 'SELECT TO_CHAR(end_date + 1, ''MM-DD-YYYY'')'||
' FROM '||l_view_name||
' WHERE '||l_id_name||' = : 1';
l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||' SYSDATE AS start_date, SYSDATE AS end_date'||
' FROM '||l_view_name;
p_ind_selection_id IN NUMBER,
p_target_level_id IN NUMBER,
p_time_dimension_index IN NUMBER,
p_time_dimension_level_id IN NUMBER,
p_current_period_id IN VARCHAR2,
p_current_period_name IN VARCHAR2,
p_plan_id IN NUMBER
) RETURN VARCHAR2 IS
CURSOR c_measure IS
SELECT i.short_name
FROM bis_indicators i, bis_target_levels t
WHERE i.indicator_id = t.indicator_id AND
t.target_level_id = p_target_level_id;
SELECT short_name
FROM bis_levels
WHERE level_id = (
SELECT decode(dimension_index,
1, dimension1_level_id,
2, dimension2_level_id,
3, dimension3_level_id,
4, dimension4_level_id,
5, dimension5_level_id,
6, dimension6_level_id,
7, dimension7_level_id,
NULL)
FROM bis_target_levels
WHERE target_level_id = p_target_level_id);
SELECT decode(dimension_index,
1, dimension1_level_value,
2, dimension2_level_value,
3, dimension3_level_value,
4, dimension4_level_value,
5, dimension5_level_value,
6, dimension6_level_value,
7, dimension7_level_value,
NULL) dimension_level_value
FROM bis_user_ind_selections
WHERE ind_selection_id = p_ind_selection_id;
getNextPeriodInfo(p_ind_selection_id,
p_target_level_id,
p_time_dimension_level_id,
p_current_period_id,
p_current_period_name,
l_next_period_id,
l_next_period_name);
, p_delete in varchar2 default 'N')
is
l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
CURSOR c_selections IS
SELECT distinct a.ind_selection_id
,a.label
,a.target_level_id
,a.dimension1_level_value
,a.dimension2_level_value
,a.dimension3_level_value
,a.dimension4_level_value
,a.dimension5_level_value
,a.dimension6_level_value
,a.dimension7_level_value
,a.plan_id
,c.increase_in_measure
,c.comparison_source
,c.indicator_id
FROM bis_user_ind_selections a
,fnd_user_resp_groups b
,bis_indicators c
,bisbv_target_levels d
WHERE a.user_id = g_user_id
AND a.plug_id = p_plug_id
AND a.user_id = b.user_id
AND b.start_date <= sysdate
AND (b.end_date is null or b.end_date >= sysdate)
AND d.target_level_id = a.target_level_id
AND d.measure_id = c.indicator_id
ORDER BY a.ind_selection_id;
IF p_delete = 'Y' THEN
BEGIN
delete from bis_user_ind_selections
where user_id = g_user_id
and plug_id = p_plug_id;
FOR csel in c_selections LOOP
htp.p(' ');
Line: 971
p_ind_selection_id => csel.ind_selection_id
,x_target_rec => l_target_rec
,x_err => l_err
) ;
Line: 1076
END LOOP; -- end of c_selections loop
Line: 1079
END IF; -- Main block: p_delete = 'Y'
Line: 1149
, p_selections_tbl Selected_Values_Tbl_Type
, p_back_url IN VARCHAR2
, p_reference_path IN VARCHAR2
, x_string out NOCOPY VARCHAR2
)
is
l_count number;
Line: 1162
l_select_tarlevel varchar2(32000);
Line: 1190
l_displaylabels_tbl Selected_Values_Tbl_Type;
Line: 1191
l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1224
fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
Line: 1225
l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
Line: 1256
BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
( p_api_version => 1.0
, p_user_id => l_user_id
, p_all_info => FND_API.G_TRUE
, p_plug_id => l_plug_id
, x_Indicator_Region_Tbl => l_selections_tbl
, x_return_status => l_return_status
, x_Error_Tbl => l_error_tbl
);
Line: 1279
IF (l_selections_tbl.COUNT <> 0) THEN
FOR i in 1 .. l_selections_tbl.COUNT LOOP
l_unique := TRUE;
Line: 1283
if l_selections_tbl(i).target_level_id = l_temp_tbl(j).id then
l_unique := FALSE;
Line: 1290
,p_target_level_id => l_selections_tbl(i).target_level_id) ) THEN
l_cnt := l_temp_tbl.COUNT + 1;
Line: 1292
l_temp_tbl(l_cnt).id := l_selections_tbl(i).target_level_id;
Line: 1293
l_temp_tbl(l_cnt).name := l_selections_tbl(i).target_level_name;
Line: 1325
l_string := l_string || ' var temp=document.DefaultFormName.B.selectedIndex;';
Line: 1327
l_string := l_string || ' selectTo();';
Line: 1345
l_string := l_string || ' document.DefaultFormName.C.selectedIndex = end;';
Line: 1350
l_string := l_string || ' document.DefaultFormName.C.selectedIndex = end;';
Line: 1356
l_string := l_string || 'function selectTo() {';
Line: 1357
l_string := l_string || ' alert("'||l_select_tarlevel||'")';
Line: 1364
l_string := l_string ||' var temp = document.DefaultFormName.C.selectedIndex;';
Line: 1366
l_string := l_string ||' selectTo();';
Line: 1377
l_string := l_string ||' document.DefaultFormName.C.selectedIndex = temp-1;';
Line: 1386
l_string := l_string ||' var temp = document.DefaultFormName.C.selectedIndex;';
Line: 1390
l_string := l_string ||' selectTo();';
Line: 1405
l_string := l_string ||' document.DefaultFormName.C.selectedIndex = temp+1;';
Line: 1413
l_string := l_string ||'function deleteTo() {';
Line: 1414
l_string := l_string ||' var temp=document.DefaultFormName.C.selectedIndex;';
Line: 1416
l_string := l_string ||' selectTo();';
Line: 1441
l_string := l_string ||' document.DefaultFormName.p_selections_tbl[i].value = e + "*" + document.DefaultFormName.C.options[i].text;';
Line: 1476
l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': ';
Line: 1481
l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': ';
Line: 1486
l_string := l_string ||'
Line: 1498
l_string := l_string ||'';
Line: 1518
l_string := l_string ||'
Line: 1522
if (TRIM(p_selections_tbl(1)) is NULL) then
-- If first time to this page, get the data from database
IF (l_temp_tbl.COUNT = 0) THEN
l_string := l_string ||'
Line: 1536
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
l_loc := instr(p_selections_tbl(i),'*',1,1);
Line: 1539
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
Line: 1540
l_text := substr (p_selections_tbl(i),l_loc + 1);
Line: 1542
exit when p_selections_tbl(i) is NULL;
Line: 1547
l_string := l_string ||'';
Line: 1590
l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
Line: 1591
l_button_tbl(1).href := 'Javascript:deleteTo()';
Line: 1673
, p_displaylabels_tbl in Selected_Values_Tbl_Type
, p_selections_tbl in Selected_Values_Tbl_Type
, p_back_url in VARCHAR2
, p_reference_path IN VARCHAR2
, x_str_object out nocopy CLOB
)
is
l_counter pls_integer := 150;
Line: 1689
l_select_displabel varchar2(32000);
Line: 1750
SELECT plan_id,short_name,name
FROM BISBV_BUSINESS_PLANS
ORDER BY name;
Line: 1757
SELECT TARGET_LEVEL_ID,
TARGET_LEVEL_NAME,
-- mdamle 01/15/2001 - Use Dim6 and Dim7
-- ORG_LEVEL_ID,
-- ORG_LEVEL_SHORT_NAME,
-- ORG_LEVEL_NAME,
DIMENSION1_LEVEL_ID,
DIMENSION1_LEVEL_SHORT_NAME,
DIMENSION1_LEVEL_NAME,
DIMENSION2_LEVEL_ID,
DIMENSION2_LEVEL_SHORT_NAME,
DIMENSION2_LEVEL_NAME,
DIMENSION3_LEVEL_ID,
DIMENSION3_LEVEL_SHORT_NAME,
DIMENSION3_LEVEL_NAME,
DIMENSION4_LEVEL_ID,
DIMENSION4_LEVEL_SHORT_NAME,
DIMENSION4_LEVEL_NAME,
DIMENSION5_LEVEL_ID,
DIMENSION5_LEVEL_SHORT_NAME,
DIMENSION5_LEVEL_NAME,
DIMENSION6_LEVEL_ID,
DIMENSION6_LEVEL_SHORT_NAME,
DIMENSION6_LEVEL_NAME,
DIMENSION7_LEVEL_ID,
DIMENSION7_LEVEL_SHORT_NAME,
DIMENSION7_LEVEL_NAME
FROM BISFV_TARGET_LEVELS
WHERE TARGET_LEVEL_ID = p_tarid;
Line: 1828
fnd_message.set_name('BIS','BIS_SELECT_DISPLAY_LABEL');
Line: 1829
l_select_displabel := icx_util.replace_quotes(fnd_message.get);
Line: 1860
BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
( p_api_version => 1.0
, p_user_id => l_user_id
, p_all_info => FND_API.G_TRUE
, p_plug_id => l_plug_id
, x_Indicator_Region_Tbl => l_labels_tbl
, x_return_status => l_return_status
, x_Error_Tbl => l_error_tbl
);
Line: 1883
l_string := l_string ||'function selectTo() {';
Line: 1884
l_string := l_string ||' alert("'||l_select_displabel||'")';
Line: 1895
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 1900
l_string := l_string ||' var d0_tmp = document.DefaultFormName.dim0.selectedIndex;';
Line: 1915
l_string := l_string ||' var d1_tmp = document.DefaultFormName.dim1.selectedIndex;';
Line: 1931
l_string := l_string ||' var d2_tmp = document.DefaultFormName.dim2.selectedIndex;';
Line: 1947
l_string := l_string ||' var d3_tmp = document.DefaultFormName.dim3.selectedIndex;';
Line: 1963
l_string := l_string ||' var d4_tmp = document.DefaultFormName.dim4.selectedIndex;';
Line: 1980
l_string := l_string ||' var d5_tmp = document.DefaultFormName.dim5.selectedIndex;';
Line: 1997
l_string := l_string ||' var d6_tmp = document.DefaultFormName.dim6.selectedIndex;';
Line: 2014
l_string := l_string ||' var d7_tmp = document.DefaultFormName.dim7.selectedIndex;';
Line: 2029
l_string := l_string ||' var plan_tmp = document.DefaultFormName.plan.selectedIndex;';
Line: 2079
l_string := l_string ||' document.DefaultFormName.C.selectedIndex = end;';
Line: 2092
l_string := l_string ||' var temp = document.DefaultFormName.C.selectedIndex;';
Line: 2094
l_string := l_string ||' selectTo();';
Line: 2106
l_string := l_string ||' document.DefaultFormName.C.selectedIndex = temp-1;';
Line: 2116
l_string := l_string ||' var temp = document.DefaultFormName.C.selectedIndex;';
Line: 2120
l_string := l_string ||' selectTo();';
Line: 2135
l_string := l_string ||' document.DefaultFormName.C.selectedIndex = temp+1;';
Line: 2142
l_string := l_string ||'function deleteTo() {';
Line: 2143
l_string := l_string ||' var temp=document.DefaultFormName.C.selectedIndex;';
Line: 2145
l_string := l_string ||' selectTo();';
Line: 2147
l_string := l_string ||' if (confirm("'||BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')||'" + " " + document.DefaultFormName.C.options[temp].text + "?"))';
Line: 2167
l_string := l_string ||' var temp=document.DefaultFormName.C.selectedIndex;';
Line: 2169
l_string := l_string ||' alert("'||l_select_displabel||'");';
Line: 2217
l_string := l_string ||' var tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2231
clearSelect
( p_formName => 'dimensions'
, p_elementTable => l_elements
, x_clearString => l_clear
);
Line: 2239
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
Line: 2243
l_loc := instr(p_selections_tbl(i),'*',1,1);
Line: 2244
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
Line: 2245
l_text := substr (p_selections_tbl(i),l_loc + 1);
Line: 2280
l_string := l_string ||' var temp = document.DefaultFormName.dim0.selectedIndex;';
Line: 2282
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2287
l_string := l_string ||' document.DefaultFormName.dim0.selectedIndex = 0;';
Line: 2303
l_string := l_string ||' var temp = document.DefaultFormName.dim1.selectedIndex;';
Line: 2305
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2313
l_string := l_string ||' document.DefaultFormName.dim1.selectedIndex = 0;';
Line: 2322
l_string := l_string ||' var temp = document.DefaultFormName.dim2.selectedIndex;';
Line: 2324
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2332
l_string := l_string ||' document.DefaultFormName.dim2.selectedIndex = 0;';
Line: 2342
l_string := l_string ||' var temp = document.DefaultFormName.dim3.selectedIndex;';
Line: 2344
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2352
l_string := l_string ||' document.DefaultFormName.dim3.selectedIndex = 0;';
Line: 2362
l_string := l_string ||' var temp = document.DefaultFormName.dim4.selectedIndex;';
Line: 2364
l_string := l_string ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2372
l_string := l_string ||' document.DefaultFormName.dim4.selectedIndex = 0;';
Line: 2384
l_string1 := l_string1 ||' var temp = document.DefaultFormName.dim5.selectedIndex;';
Line: 2386
l_string1 := l_string1 ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2394
l_string1 := l_string1 ||' document.DefaultFormName.dim5.selectedIndex = 0;';
Line: 2403
l_string1 := l_string1 ||' var temp = document.DefaultFormName.dim6.selectedIndex;';
Line: 2405
l_string1 := l_string1 ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2413
l_string1 := l_string1 ||' document.DefaultFormName.dim6.selectedIndex = 0;';
Line: 2421
l_string1 := l_string1 ||' var temp = document.DefaultFormName.dim7.selectedIndex;';
Line: 2423
l_string1 := l_string1 ||' var ind_tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2431
l_string1 := l_string1 ||' document.DefaultFormName.dim7.selectedIndex = 0;';
Line: 2506
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
Line: 2510
l_string1 := l_string1 ||'document.DefaultFormName.p_selections_tbl['||i||'-1].value='''||p_selections_tbl(i)||''';';
Line: 2517
l_string1 := l_string1 ||'
Line: 2519
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
Line: 2524
l_loc := instr(p_selections_tbl(i),'*',1,1);
Line: 2525
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
Line: 2526
l_text := substr (p_selections_tbl(i),l_loc + 1);
Line: 2532
l_string1 := l_string1 ||'
Line: 2537
l_string1 := l_string1 ||'';
Line: 2736
l_string1 := l_string1 ||'
Line: 2737
l_string1 := l_string1 ||'
Line: 2738
l_string1 := l_string1 ||'';
Line: 2755
l_string1 := l_string1 ||'
Line: 2756
l_string1 := l_string1 ||'
Line: 2768
l_string1 := l_string1 ||'';
Line: 2791
l_string1 := l_string1 ||'
Line: 2792
l_string1 := l_string1 ||'
Line: 2802
l_string1 := l_string1 ||'
Line: 2806
l_string1 := l_string1 ||'';
Line: 2827
l_string1 := l_string1 ||'
Line: 2828
l_string1 := l_string1 ||'
Line: 2837
l_string1 := l_string1 ||'
Line: 2841
l_string1 := l_string1 ||'';
Line: 2862
l_string1 := l_string1 ||'
Line: 2863
l_string1 := l_string1 ||'
Line: 2872
l_string1 := l_string1 ||'
Line: 2876
l_string1 := l_string1 ||'';
Line: 2897
l_string1 := l_string1 ||'
Line: 2898
l_string1 := l_string1 ||'
Line: 2906
l_string1 := l_string1 ||'
Line: 2910
l_string1 := l_string1 ||'';
Line: 2932
l_string1 := l_string1 ||'
Line: 2933
l_string1 := l_string1 ||'
Line: 2941
l_string1 := l_string1 ||'
Line: 2945
l_string1 := l_string1 ||'';
Line: 2967
l_string1 := l_string1 ||'
Line: 2968
l_string1 := l_string1 ||'
Line: 2976
l_string1 := l_string1 ||'
Line: 2980
l_string1 := l_string1 ||'';
Line: 3002
l_string1 := l_string1 ||'
Line: 3003
l_string1 := l_string1 ||'
Line: 3011
l_string1 := l_string1 ||'
Line: 3015
l_string1 := l_string1 ||'';
Line: 3027
l_string1 := l_string1 ||'
Line: 3029
l_string1 := l_string1 ||'
Line: 3031
l_string1 := l_string1 ||'';
Line: 3121
l_string1 := l_string1 ||'
Line: 3213
l_string1 := l_string1 ||'
Line: 3231
l_string1 := l_string1 ||'
Line: 3236
l_string1 := l_string1 ||'';
Line: 3262
l_string1 := l_string1 || '';
Line: 3291
l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
Line: 3292
l_button_tbl(1).href := 'Javascript:deleteTo()';
Line: 3402
l_select_displabel varchar2(32000);
Line: 3521
SELECT plan_id,short_name,name
FROM BISBV_BUSINESS_PLANS
ORDER BY name;
Line: 3527
SELECT TARGET_LEVEL_ID,
TARGET_LEVEL_NAME,
-- mdamle 01/15/2001 - Use Dim6 and Dim7
-- ORG_LEVEL_ID,
-- ORG_LEVEL_SHORT_NAME,
-- ORG_LEVEL_NAME,
DIMENSION1_LEVEL_ID,
DIMENSION1_LEVEL_SHORT_NAME,
DIMENSION1_LEVEL_NAME,
DIMENSION2_LEVEL_ID,
DIMENSION2_LEVEL_SHORT_NAME,
DIMENSION2_LEVEL_NAME,
DIMENSION3_LEVEL_ID,
DIMENSION3_LEVEL_SHORT_NAME,
DIMENSION3_LEVEL_NAME,
DIMENSION4_LEVEL_ID,
DIMENSION4_LEVEL_SHORT_NAME,
DIMENSION4_LEVEL_NAME,
DIMENSION5_LEVEL_ID,
DIMENSION5_LEVEL_SHORT_NAME,
DIMENSION5_LEVEL_NAME,
DIMENSION6_LEVEL_ID,
DIMENSION6_LEVEL_SHORT_NAME,
DIMENSION6_LEVEL_NAME,
DIMENSION7_LEVEL_ID,
DIMENSION7_LEVEL_SHORT_NAME,
DIMENSION7_LEVEL_NAME
FROM BISFV_TARGET_LEVELS
WHERE TARGET_LEVEL_ID = p_tarid;
Line: 3590
fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
Line: 3591
l_select_displabel := icx_util.replace_quotes(fnd_message.get);
Line: 3637
BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
( p_api_version => 1.0
, p_user_id => l_user_id
, p_all_info => FND_API.G_TRUE
, p_plug_id => l_plug_id
, x_Indicator_Region_Tbl => l_favorites_tbl
, x_return_status => l_return_status
, x_Error_Tbl => l_error_tbl
);
Line: 3658
SELECT level_id
INTO l_sob_level_id
FROM BIS_LEVELS
WHERE SHORT_NAME = 'SET OF BOOKS';
Line: 3765
l_string := l_string ||' var temp = opener.document.DefaultFormName.C.selectedIndex;';
Line: 3778
l_string := l_string ||' var d0_tmp = document.editDimensions.dim0.selectedIndex;';
Line: 3796
l_string := l_string ||' var d1_tmp = document.editDimensions.dim1.selectedIndex;';
Line: 3816
l_string := l_string ||' var d2_tmp = document.editDimensions.dim2.selectedIndex;';
Line: 3835
l_string := l_string ||' var d3_tmp = document.editDimensions.dim3.selectedIndex;';
Line: 3855
l_string := l_string ||' var d4_tmp = document.editDimensions.dim4.selectedIndex;';
Line: 3875
l_string := l_string ||' var d5_tmp = document.editDimensions.dim5.selectedIndex;';
Line: 3895
l_string := l_string ||' var d6_tmp = document.editDimensions.dim6.selectedIndex;';
Line: 3915
l_string := l_string ||' var d7_tmp = document.editDimensions.dim7.selectedIndex;';
Line: 3933
l_string := l_string ||' var plan_tmp = document.editDimensions.plan.selectedIndex;';
Line: 4005
l_string := l_string ||' var temp=opener.document.DefaultFormName.C.selectedIndex;';
Line: 4017
clearSelect
( p_formName => 'editDimensions'
, p_elementTable => l_elements
, x_clearString => l_clear
);
Line: 4028
l_string := l_string ||' var temp = document.editDimensions.dim0.selectedIndex;';
Line: 4034
l_string := l_string ||' document.editDimensions.dim0.selectedIndex = 0;';
Line: 4052
l_string := l_string ||' var temp = document.editDimensions.dim1.selectedIndex;';
Line: 4061
l_string := l_string ||' document.editDimensions.dim1.selectedIndex = 0;';
Line: 4070
l_string := l_string ||' var temp = document.editDimensions.dim2.selectedIndex;';
Line: 4079
l_string := l_string ||' document.editDimensions.dim2.selectedIndex = 0;';
Line: 4088
l_string := l_string ||' var temp = document.editDimensions.dim3.selectedIndex;';
Line: 4097
l_string := l_string ||' document.editDimensions.dim3.selectedIndex = 0;';
Line: 4106
l_string := l_string ||' var temp = document.editDimensions.dim4.selectedIndex;';
Line: 4115
l_string := l_string ||' document.editDimensions.dim4.selectedIndex = 0;';
Line: 4124
l_string := l_string ||' var temp = document.editDimensions.dim5.selectedIndex;';
Line: 4133
l_string := l_string ||' document.editDimensions.dim5.selectedIndex = 0;';
Line: 4143
l_string := l_string ||' var temp = document.editDimensions.dim6.selectedIndex;';
Line: 4152
l_string := l_string ||' document.editDimensions.dim6.selectedIndex = 0;';
Line: 4162
l_string := l_string ||' var temp = document.editDimensions.dim7.selectedIndex;';
Line: 4171
l_string := l_string ||' document.editDimensions.dim7.selectedIndex = 0;';
Line: 4311
l_string := l_string ||'
Line: 4312
l_string := l_string ||'
Line: 4313
l_string := l_string ||'';
Line: 4330
l_string := l_string ||'
Line: 4354
l_string := l_string ||'
Line: 4370
l_string := l_string ||'';
Line: 4392
l_string := l_string ||'
Line: 4412
l_string := l_string ||'
Line: 4426
l_string := l_string ||'';
Line: 4451
l_string := l_string ||'
Line: 4476
l_string := l_string ||'
Line: 4489
l_string := l_string ||'';
Line: 4510
l_string := l_string ||'
Line: 4530
l_string := l_string ||'
Line: 4544
l_string := l_string ||'';
Line: 4566
l_string := l_string ||'
Line: 4585
l_string := l_string ||'
Line: 4600
l_string := l_string ||'';
Line: 4624
l_string := l_string ||'
Line: 4643
l_string := l_string ||'
Line: 4656
l_string := l_string ||'';
Line: 4684
l_string := l_string ||'
Line: 4707
l_string := l_string ||'
Line: 4720
l_string := l_string ||'';
Line: 4748
l_string := l_string ||'
Line: 4770
l_string := l_string ||'
Line: 4783
l_string := l_string ||'';
Line: 4798
l_string := l_string ||'
Line: 4805
l_string := l_string ||'
Line: 4811
l_string := l_string ||'';
Line: 4928
,p_displaylabels_tbl in Selected_Values_Tbl_Type
,p_back_url in VARCHAR2
,p_reference_path in VARCHAR2)
is
l_plug_id pls_integer;
Line: 4979
BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
p_api_version => 1.0,
p_user_id => g_user_id,
p_plug_id => l_plug_id,
x_return_status => l_return_status,
x_error_Tbl => l_error_tbl);
Line: 5053
BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
p_api_version => 1.0,
p_Indicator_Region_Rec => l_indicator_region_values,
x_return_status => l_return_status,
x_error_Tbl => l_error_tbl);
Line: 5069
UPDATE icx_portlet_customizations
SET caching_key = TO_CHAR(NVL(caching_key, 0) + 1)
WHERE reference_path = p_reference_path;
Line: 5138
PROCEDURE clearSelect(
p_formName IN VARCHAR2
, p_elementTable IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
, x_clearString OUT NOCOPY VARCHAR2
)
IS
l_clear VARCHAR2(32000);
Line: 5165
var s = new String("select");
Line: 5187
END clearSelect;
Line: 5204
var dim0_index = document.'||p_formName||'.dim0.selectedIndex;
Line: 5241
select measure_name || ' (' || DIMENSION1_LEVEL_NAME || decode(DIMENSION2_LEVEL_NAME, '', '', ' - ' || DIMENSION2_LEVEL_NAME)
|| decode(DIMENSION3_LEVEL_NAME, '', '', ' - ' || DIMENSION3_LEVEL_NAME) || decode(DIMENSION4_LEVEL_NAME, '', '', ' - ' || DIMENSION4_LEVEL_NAME)
|| decode(DIMENSION5_LEVEL_NAME, '', '', ' - ' || DIMENSION5_LEVEL_NAME) || decode(DIMENSION6_LEVEL_NAME, '', '', ' - ' || DIMENSION6_LEVEL_NAME)
|| decode(DIMENSION7_LEVEL_NAME, '', '', ' - ' || DIMENSION7_LEVEL_NAME) || ')'
into l_perf_meas_name
from bisfv_target_levels tl
Where tl.target_level_id = p_target_level_id;
Line: 5264
SELECT x.sequence_no into l_OrgSeqNum
FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
WHERE x.dimension_id = y.dimension_id
AND y.short_name like BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL)
AND x.indicator_id = z.indicator_id
AND z.target_level_id = p_target_level_id;
Line: 5286
SELECT x.sequence_no into l_TimeSeqNum
FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
WHERE x.dimension_id = y.dimension_id
AND y.short_name like BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL)
AND x.indicator_id = z.indicator_id
AND z.target_level_id = p_target_level_id ;
Line: 5318
SELECT dimension1_level_id, dimension2_level_id, dimension3_level_id,
dimension1_level_id, dimension5_level_id, dimension6_level_id,
dimension7_level_id
INTO l_dimension1_level_id, l_dimension2_level_id, l_dimension3_level_id,
l_dimension4_level_id, l_dimension5_level_id, l_dimension6_level_id,
l_dimension7_level_id
FROM BIS_TARGET_LEVELS
WHERE target_level_id = p_target_level_id;
Line: 5392
SELECT tlv.target_level_id
FROM bisbv_target_levels tlv, bis_levels blv
WHERE tlv.target_level_id = p_tarid
AND (
tlv.dimension1_level_id = blv.level_id
OR tlv.dimension2_level_id = blv.level_id
OR tlv.dimension3_level_id = blv.level_id
OR tlv.dimension4_level_id = blv.level_id
OR tlv.dimension5_level_id = blv.level_id
OR tlv.dimension6_level_id = blv.level_id
OR tlv.dimension7_level_id = blv.level_id
)
AND blv.short_name = 'TOTAL_TIME';
Line: 5408
SELECT actual_id,
actual_value
FROM bisbv_actuals acts
WHERE acts.target_level_id = p_target_level_id
AND NVL (acts.dimension1_level_value, '1') =
NVL (p_dimension1_level_value, '1')
AND NVL (acts.dimension2_level_value, '1') =
NVL (p_dimension2_level_value, '1')
AND NVL (acts.dimension3_level_value, '1') =
NVL (p_dimension3_level_value, '1')
AND NVL (acts.dimension4_level_value, '1') =
NVL (p_dimension4_level_value, '1')
AND NVL (acts.dimension5_level_value, '1') =
NVL (p_dimension5_level_value, '1')
AND NVL (acts.dimension6_level_value, '1') =
NVL (p_dimension6_level_value, '1')
AND NVL (acts.dimension7_level_value, '1') =
NVL (p_dimension7_level_value, '1');
Line: 5431
SELECT target,
target_id,
NVL (range1_low, 0) range1_low,
NVL (range1_high, 0) range1_high,
range2_low,
range2_high,
range3_low,
range3_high,
notify_resp1_id,
notify_resp2_id,
notify_resp3_id
FROM bisbv_targets tars
WHERE tars.target_level_id = p_target_level_id
AND tars.plan_id = p_plan_id
AND NVL (tars.dim1_level_value_id, '1') =
NVL (p_dimension1_level_value, '1')
AND NVL (tars.dim2_level_value_id, '1') =
NVL (p_dimension2_level_value, '1')
AND NVL (tars.dim3_level_value_id, '1') =
NVL (p_dimension3_level_value, '1')
AND NVL (tars.dim4_level_value_id, '1') =
NVL (p_dimension4_level_value, '1')
AND NVL (tars.dim5_level_value_id, '1') =
NVL (p_dimension5_level_value, '1')
AND NVL (tars.dim6_level_value_id, '1') =
NVL (p_dimension6_level_value, '1')
AND NVL (tars.dim7_level_value_id, '1') =
NVL (p_dimension7_level_value, '1');
Line: 5464
SELECT computing_function_id
FROM bisbv_target_levels
WHERE target_level_id = p_target_level_id;
Line: 5939
SELECT meaning,
description
INTO Icon_Meaning,
Icon_Description
FROM FND_LOOKUPS
WHERE lookup_code = Icon_Code
AND lookup_type = 'HTML_NAVIGATION_ICONS';
Line: 5981
SELECT l.language_code
INTO NLS_LANGUAGE_CODE
FROM fnd_languages l,
nls_session_parameters p
WHERE p.parameter = 'NLS_LANGUAGE'
AND p.value = l.nls_language;
Line: 6313
SELECT attribute_label_long FROM ak_region_items_vl WHERE
region_code = cp_regn_code
AND attribute_code = cp_regn_item;
Line: 6369
SELECT
DIMENSION1_LEVEL_VALUE
,DIMENSION2_LEVEL_VALUE
,DIMENSION3_LEVEL_VALUE
,DIMENSION4_LEVEL_VALUE
,DIMENSION5_LEVEL_VALUE
,DIMENSION6_LEVEL_VALUE
,DIMENSION7_LEVEL_VALUE
FROM bisbv_actuals acts
WHERE acts.target_level_id = p_target_rec.target_level_id
AND DECODE(p_time_dimension_index,
1, 'NILL', NVL(acts.dimension1_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
1, 'NILL', NVL(p_target_rec.dim1_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
2, 'NILL', NVL(acts.dimension2_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
2, 'NILL', NVL(p_target_rec.dim2_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
3, 'NILL', NVL(acts.dimension3_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
3, 'NILL', NVL(p_target_rec.dim3_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
4, 'NILL', NVL(acts.dimension4_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
4, 'NILL', NVL(p_target_rec.dim4_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
5, 'NILL', NVL(acts.dimension5_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
5, 'NILL', NVL(p_target_rec.dim5_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
6, 'NILL', NVL(acts.dimension6_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
6, 'NILL', NVL(p_target_rec.dim6_level_value_id, 'NILL'))
AND DECODE(p_time_dimension_index,
7, 'NILL', NVL(acts.dimension7_level_value, 'NILL'))
= DECODE(p_time_dimension_index,
7, 'NILL', NVL(p_target_rec.dim7_level_value_id, 'NILL'))
ORDER BY acts.LAST_UPDATE_DATE DESC;
Line: 6605
SELECT attribute7, attribute14
FROM ak_region_items
WHERE
region_code = p_region_code
AND attribute_code = p_attribute_code;
Line: 7176
SELECT distinct DECODE(b.user_id, NULL, 0, 1)
FROM
fnd_user_resp_groups b
,bisbv_target_levels d
,bis_indicator_resps e
WHERE
b.user_id = p_cur_user_id
AND d.target_level_id = p_target_level_id
AND e.target_level_id = d.target_level_id
AND b.responsibility_id = e.responsibility_id
AND b.start_date <= sysdate
AND (b.end_date IS NULL or b.end_date >= sysdate);
Line: 7298
SELECT computing_function_id
FROM bisbv_target_levels
WHERE target_level_id = p_target_level_id;
Line: 7306
SELECT
target
,range1_low, range1_high
,range2_low, range2_high
,range3_low, range3_high
FROM bisbv_targets tars
WHERE tars.target_level_id = p_target_in.target_level_id
-- mdamle 01/15/2001
-- AND tars.org_level_value_id = p_target_in.org_level_value_id
-- AND NVL(tars.time_level_value_id,'NILL')
-- = NVL(p_target_in.time_level_value_id, 'NILL')
AND tars.plan_id = p_target_in.plan_id
AND NVL(tars.dim1_level_value_id, 'NILL')
= NVL(p_target_in.dim1_level_value_id, 'NILL')
AND NVL(tars.dim2_level_value_id, 'NILL')
= NVL(p_target_in.dim2_level_value_id, 'NILL')
AND NVL(tars.dim3_level_value_id, 'NILL')
= NVL(p_target_in.dim3_level_value_id, 'NILL')
AND NVL(tars.dim4_level_value_id, 'NILL')
= NVL(p_target_in.dim4_level_value_id, 'NILL')
AND NVL(tars.dim5_level_value_id, 'NILL')
= NVL(p_target_in.dim5_level_value_id, 'NILL')
AND NVL(tars.dim6_level_value_id, 'NILL')
= NVL(p_target_in.dim6_level_value_id, 'NILL')
AND NVL(tars.dim7_level_value_id, 'NILL')
= NVL(p_target_in.dim7_level_value_id, 'NILL');
Line: 7394
p_ind_selection_id IN NUMBER
,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
,x_err OUT NOCOPY VARCHAR2
)
IS
e_notimevalue EXCEPTION;
Line: 7415
SELECT
x.sequence_no,
decode(x.sequence_no,
1, z.dimension1_level_id,
2, z.dimension2_level_id,
3, z.dimension3_level_id,
4, z.dimension4_level_id,
5, z.dimension5_level_id,
6, z.dimension6_level_id,
7, z.dimension7_level_id,
NULL) time_dimension_level_id
FROM
bis_indicator_dimensions x
,bis_dimensions y
,bis_target_levels z
WHERE x.dimension_id = y.dimension_id
AND y.short_name=BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_tarid,NULL)
AND x.indicator_id = z.indicator_id
AND z.target_level_id = p_tarid;
Line: 7458
SELECT short_name
INTO level_short_name
FROM bis_levels
WHERE level_id = l_time_dimension_level_id;
Line: 7473
p_ind_selection_id
,x_target_rec.target_level_id
,l_time_dimension_level_id
,l_current_period_id
,l_current_period_name);