The following lines contain the word 'select', 'insert', 'update' or 'delete':
BIS_USER_IND_SELECTIONS
*/
--===========================================================
-- 12-DEC-01 juwang modified for showing pre-seeded portlet
--===========================================================
--===========================================================
-- private function
--===========================================================
--============================================================
FUNCTION draw_portlet_header(
p_status_lbl IN VARCHAR2
,p_measure_lbl IN VARCHAR2
,p_value_lbl IN VARCHAR2
,p_change_lbl IN VARCHAR2
) RETURN VARCHAR2;
PROCEDURE delete_all_demo_rows(
p_plug_id IN NUMBER
);
p_ind_selection_id IN NUMBER
,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
,x_err OUT NOCOPY VARCHAR2
) ;
select PLUG_ID
into l_plug_id
from ICX_PORTLET_CUSTOMIZATIONS
where REFERENCE_PATH = p_reference_path;
delete_all_demo_rows(l_plug_id);
DELETE
FROM BIS_USER_IND_SELECTIONS
WHERE PLUG_ID = l_plug_id;
DELETE
FROM ICX_PORTLET_CUSTOMIZATIONS
WHERE REFERENCE_PATH = p_reference_path;
l_sqlcount := 'select count(distinct id) from ('||l_temp||')';
CURSOR c_selections IS
SELECT distinct a.ind_selection_id
,a.label
,a.target_level_id
-- mdamle 01/15/2001 - Use Dim6 and Dim7
-- ,a.org_level_value
,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 --1850860
,c.comparison_source --2157402
,c.indicator_id --2174470
FROM bis_user_ind_selections a
,bis_indicators c --1850860
,bisbv_target_levels d --1850860
WHERE a.plug_id = p_plug_id -- most selective first
AND a.user_id = l_user_id
AND d.target_level_id = a.target_level_id --1850860
AND d.measure_id = c.indicator_id --1850860
ORDER BY a.ind_selection_id;
csel c_selections%ROWTYPE;
OPEN c_selections;
<< c_selections_loop >>
FETCH c_selections INTO csel;
EXIT WHEN c_selections%NOTFOUND;
GOTO c_selections_loop;
p_ind_selection_id => csel.ind_selection_id
,x_target_rec => l_target_rec
,x_err => l_err
) ;
END LOOP; -- end of c_selections loop
CLOSE c_selections;
IF c_selections%ISOPEN THEN
CLOSE c_selections;
l_sql := 'select distinct id, value from ('||l_temp||')';
,p_selections_tbl IN Selected_Values_Tbl_Type
)
IS
BEGIN
setIndicators(
Z => Z
,p_back_url => p_back_url
,p_selections_tbl => p_selections_tbl
,p_reference_path => NULL
);
,p_selections_tbl IN Selected_Values_Tbl_Type
,p_reference_path IN VARCHAR2
)
is
l_initialize VARCHAR2(32000);
l_select_tarlevel VARCHAR2(32000);
l_displaylabels_tbl Selected_Values_Tbl_Type;
l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
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
);
IF (l_selections_tbl.COUNT <> 0) THEN
FOR i in 1 .. l_selections_tbl.COUNT LOOP
l_unique := TRUE;
if l_selections_tbl(i).target_level_id = l_temp_tbl(j).id then
l_unique := FALSE;
,p_target_level_id => l_selections_tbl(i).target_level_id) ) THEN
l_cnt := l_temp_tbl.COUNT + 1;
l_temp_tbl(l_cnt).id := l_selections_tbl(i).target_level_id;
l_temp_tbl(l_cnt).name := l_selections_tbl(i).target_level_name;
var temp=document.favorites.B.selectedIndex;
selectTo();
document.favorites.C.selectedIndex = end;
document.favorites.C.selectedIndex = end;
htp.p('function selectTo() {
alert("'||l_select_tarlevel||'")
}');
var temp = document.favorites.C.selectedIndex;
selectTo();
document.favorites.C.selectedIndex = temp-1;
var temp = document.favorites.C.selectedIndex;
selectTo();
document.favorites.C.selectedIndex = temp+1;
htp.p('function deleteTo() {
var temp=document.favorites.C.selectedIndex;
selectTo();
document.showDimensions.p_selections_tbl[i].value = document.favorites.C.options[i].value + "*" + document.favorites.C.options[i].text;
htp.formHidden('p_selections_tbl');
htp.p(bis_utilities_pvt.escape_html(BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES'))||': ');
htp.p('
htp.formSelectOption(l_initialize);
htp.formSelectOption(
cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indicators_tbl(i).target_level_id)),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_indicators_tbl(i).target_level_id));
htp.formSelectClose;
htp.p('
if (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
htp.formSelectOption(l_initialize);
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_temp_tbl(i).id)),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_temp_tbl(i).id));
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
l_loc := instr(p_selections_tbl(i),'*',1,1);
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
l_text := substr (p_selections_tbl(i),l_loc + 1);
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
exit when p_selections_tbl(i) is NULL;
htp.formSelectClose;
l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
l_button_tbl(1).href := 'Javascript:deleteTo()';
var dim0_index = document.'||p_formName||'.dim0.selectedIndex;
, p_displaylabels_tbl in Selected_Values_Tbl_Type
, p_selections_tbl in Selected_Values_Tbl_Type
, p_reference_path IN VARCHAR2
)
is
l_cnt PLS_INTEGER;
l_select_displabel VARCHAR2(32000);
SELECT plan_id,short_name,name
FROM BISBV_BUSINESS_PLANS
ORDER BY name;
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;
fnd_message.set_name('BIS','BIS_SELECT_DISPLAY_LABEL');
l_select_displabel := icx_util.replace_quotes(fnd_message.get);
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
);
htp.p('function selectTo() {
alert("'||l_select_displabel||'")
}');
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
var d0_tmp = document.dimensions.dim0.selectedIndex;
var d1_tmp = document.dimensions.dim1.selectedIndex;
var d2_tmp = document.dimensions.dim2.selectedIndex;
var d3_tmp = document.dimensions.dim3.selectedIndex;
var d4_tmp = document.dimensions.dim4.selectedIndex;
var d5_tmp = document.dimensions.dim5.selectedIndex;
var d6_tmp = document.dimensions.dim6.selectedIndex;
var d7_tmp = document.dimensions.dim7.selectedIndex;
var plan_tmp = document.dimensions.plan.selectedIndex;
document.dimensions.C.selectedIndex = end;
var temp = document.dimensions.C.selectedIndex;
selectTo();
document.dimensions.C.selectedIndex = temp-1;
var temp = document.dimensions.C.selectedIndex;
selectTo();
document.dimensions.C.selectedIndex = temp+1;
htp.p('function deleteTo() {
var temp=document.dimensions.C.selectedIndex;
selectTo();
if (confirm("'||BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')
||'" + " " + document.dimensions.C.options[temp].text + "?"))
document.dimensions.C.options[temp] = null;
var temp=document.dimensions.C.selectedIndex;
alert("'||l_select_displabel||'");
var tmp = document.indicators.p_indlevel.selectedIndex;
BIS_INDICATOR_REGION_UI_PVT.clearSelect
( p_formName => 'dimensions'
, p_elementTable => l_elements
, x_clearString => l_clear
);
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
l_loc := instr(p_selections_tbl(i),'*',1,1);
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
l_text := substr (p_selections_tbl(i),l_loc + 1);
var temp = document.dimensions.dim0.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim0.selectedIndex = 0;
var temp = document.dimensions.dim1.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim1.selectedIndex = 0;
var temp = document.dimensions.dim2.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim2.selectedIndex = 0;
var temp = document.dimensions.dim3.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim3.selectedIndex = 0;
var temp = document.dimensions.dim4.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim4.selectedIndex = 0;
var temp = document.dimensions.dim5.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim5.selectedIndex = 0;
var temp = document.dimensions.dim6.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim6.selectedIndex = 0;
var temp = document.dimensions.dim7.selectedIndex;
var ind_tmp = document.indicators.p_indlevel.selectedIndex;
document.dimensions.dim7.selectedIndex = 0;
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
htp.formHidden('p_selections_tbl',p_selections_tbl(i));
htp.formSelectOpen('p_indlevel'
,cattributes=>'onChange="setIndlevel()"');
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
if (p_selections_tbl(i) is NULL) then
EXIT;
l_loc := instr(p_selections_tbl(i),'*',1,1);
l_value := substr (p_selections_tbl(i),1,l_loc - 1);
l_text := substr (p_selections_tbl(i),l_loc + 1);
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),cselected=>'YES',
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
htp.formSelectClose;
htp.formSelectOpen('dim0');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name)),
cselected=>'YES',
cattributes=>'VALUE=-1');
htp.formSelectClose;
htp.formSelectOpen('dim0',cattributes=>'onchange="setdim0()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).id));
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim1',cattributes=>'onchange="setdim1()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim2',cattributes=>'onchange="setdim2()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim3',cattributes=>'onchange="setdim3()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim4',cattributes=>'onchange="setdim4()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim5',cattributes=>'onchange="setdim5()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim6',cattributes=>'onchange="setdim6()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim7',cattributes=>'onchange="setdim7()"');
htp.formSelectOption(l_blank,cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('plan');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
htp.formSelectClose;
htp.formSelectOpen(cname=>'C',cattributes=>'SIZE=20');
htp.formSelectOption(l_initialize);
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_labels_tbl(i).label),
cattributes=>' VALUE="'||bis_utilities_pvt.escape_html_input(REPLACE(REPLACE(l_link,'+1',c_minus),'+',c_at))||
bis_utilities_pvt.escape_html_input(l_access)||'"');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text)
,cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_value)||'"');
htp.formSelectClose;
htp.p('');
l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
l_button_tbl(1).href := 'Javascript:deleteTo()';
for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
htp.formHidden('p_selections_tbl',p_selections_tbl(i));
,p_displaylabels_tbl in Selected_Values_Tbl_Type
,p_reference_path IN VARCHAR2
)
is
l_plug_id pls_integer;
BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
p_api_version => 1.0,
p_user_id => l_user_id,
p_plug_id => l_plug_id,
x_return_status => l_return_status,
x_error_Tbl => l_error_tbl);
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);
UPDATE icx_portlet_customizations
SET caching_key = TO_CHAR(NVL(caching_key, 0) + 1)
WHERE reference_path = p_reference_path;
l_select_displabel varchar2(32000);
SELECT plan_id,short_name,name
FROM BISBV_BUSINESS_PLANS
ORDER BY name;
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;
fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
l_select_displabel := icx_util.replace_quotes(fnd_message.get);
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
);
SELECT level_id
INTO l_sob_level_id
FROM BIS_LEVELS
WHERE SHORT_NAME = 'SET OF BOOKS';
SELECT org_level_id
INTO l_org_level_id
FROM BIS_TARGET_LEVELS
WHERE target_level_id = l_indlevel_ID;
var temp = opener.document.dimensions.C.selectedIndex;
var d0_tmp = document.editDimensions.dim0.selectedIndex;
var d1_tmp = document.editDimensions.dim1.selectedIndex;
var d2_tmp = document.editDimensions.dim2.selectedIndex;
var d3_tmp = document.editDimensions.dim3.selectedIndex;
var d4_tmp = document.editDimensions.dim4.selectedIndex;
var d5_tmp = document.editDimensions.dim5.selectedIndex;
var d6_tmp = document.editDimensions.dim6.selectedIndex;
var d7_tmp = document.editDimensions.dim7.selectedIndex;
var plan_tmp = document.editDimensions.plan.selectedIndex;
var temp=opener.document.dimensions.C.selectedIndex;
BIS_INDICATOR_REGION_UI_PVT.clearSelect
( p_formName => 'editDimensions'
, p_elementTable => l_elements
, x_clearString => l_clear
);
var temp = document.editDimensions.dim0.selectedIndex;
document.editDimensions.dim0.selectedIndex = 0;
var temp = document.editDimensions.dim1.selectedIndex;
document.editDimensions.dim1.selectedIndex = 0;
var temp = document.editDimensions.dim2.selectedIndex;
document.editDimensions.dim2.selectedIndex = 0;
var temp = document.editDimensions.dim3.selectedIndex;
document.editDimensions.dim3.selectedIndex = 0;
var temp = document.editDimensions.dim4.selectedIndex;
document.editDimensions.dim4.selectedIndex = 0;
var temp = document.editDimensions.dim5.selectedIndex;
document.editDimensions.dim5.selectedIndex = 0;
var temp = document.editDimensions.dim6.selectedIndex;
document.editDimensions.dim6.selectedIndex = 0;
var temp = document.editDimensions.dim7.selectedIndex;
document.editDimensions.dim7.selectedIndex = 0;
htp.formSelectOpen('dim0');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name)),
cselected=>'YES',
cattributes=>'VALUE=-1');
htp.formSelectClose;
htp.formSelectOpen('dim0',cattributes=>'onchange="setdim0()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim0_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_dim0_level_value_rec.Dimension_level_Value_ID),
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).id));
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim1',cattributes=>'onchange="setdim1()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim2',cattributes=>'onchange="setdim2()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim3',cattributes=>'onchange="setdim3()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim4',cattributes=>'onchange="setdim4()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim5',cattributes=>'onchange="setdim5()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim6',cattributes=>'onchange="setdim6()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('dim7',cattributes=>'onchange="setdim7()"');
htp.formSelectOption(l_blank);
htp.formSelectOption
-- mdamle - 01/15/2001 - Add quotes around VALUE
(cvalue=>bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_Name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_ID)||'"',
cselected=>'YES');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name),
cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).id)||'"');
htp.formSelectOption(c_choose);
htp.formSelectClose;
htp.formSelectOpen('plan');
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),cselected=>'YES',
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),
cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
htp.formSelectClose;
SELECT parameters
FROM fnd_form_functions
WHERE function_name = l_function_name;
SELECT REFERENCE_PATH
FROM ICX_PORTLET_CUSTOMIZATIONS
WHERE PLUG_ID = p_plug_id;
SELECT function_id
FROM fnd_form_functions
WHERE function_name = cp_function_name;
SELECT plan_id
FROM BISBV_BUSINESS_PLANS
ORDER BY name;
BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
p_api_version => 1.0
,p_Indicator_Region_Rec => l_ind_rec
,x_return_status => x_return_status
,x_error_Tbl => x_error_tbl
);
SELECT ff.parameters, ff.USER_FUNCTION_NAME
FROM
fnd_menus fm,
fnd_menu_entries_vl fme,
fnd_form_functions_vl ff
WHERE
fm.menu_name = l_menu_name AND
fme.menu_id = fm.menu_id AND
fme.function_id = ff.function_id AND
ff.TYPE <> 'DBPORTLET';
SELECT bt.SHORT_NAME
, bu.DIMENSION1_LEVEL_VALUE
, bu.DIMENSION2_LEVEL_VALUE
, bu.DIMENSION3_LEVEL_VALUE
, bu.DIMENSION4_LEVEL_VALUE
, bu.DIMENSION5_LEVEL_VALUE
, bu.DIMENSION6_LEVEL_VALUE
, bu.DIMENSION7_LEVEL_VALUE
, bp.SHORT_NAME
, bu.LABEL
FROM
bis_user_ind_selections bu
, bis_target_levels bt
, BISBV_BUSINESS_PLANS bp
WHERE
bu.IND_SELECTION_ID = p_ind_sel
AND bu.TARGET_LEVEL_ID = bt.TARGET_LEVEL_ID
AND bu.PLAN_ID = bp.PLAN_ID;
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 NVL(acts.dimension1_level_value, 'NILL')
= NVL(p_target_rec.dim1_level_value_id, 'NILL')
AND NVL(acts.dimension2_level_value, 'NILL')
= NVL(p_target_rec.dim2_level_value_id, 'NILL')
AND NVL(acts.dimension3_level_value, 'NILL')
= NVL(p_target_rec.dim3_level_value_id, 'NILL')
AND NVL(acts.dimension4_level_value, 'NILL')
= NVL(p_target_rec.dim4_level_value_id, 'NILL')
AND NVL(acts.dimension5_level_value, 'NILL')
= NVL(p_target_rec.dim5_level_value_id, 'NILL')
AND NVL(acts.dimension6_level_value, 'NILL')
= NVL(p_target_rec.dim6_level_value_id, 'NILL')
AND NVL(acts.dimension7_level_value, 'NILL')
= NVL(p_target_rec.dim7_level_value_id, 'NILL')
ORDER BY acts.LAST_UPDATE_DATE DESC;
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;
SELECT LABEL, PARAM_DATA
FROM bis_pmf_populate_portlet bpp
WHERE bpp.PLUG_ID = p_plug_id
ORDER BY bpp.SEQ_ID;
PROCEDURE insert_row(
p_plug_id IN NUMBER
,p_seq_id IN NUMBER
,p_label IN VARCHAR2
,p_status IN NUMBER
,p_value IN VARCHAR2
,p_change IN VARCHAR2
,p_arrow IN NUMBER
,p_user_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
)
IS
l_param VARCHAR2(20000);
insert_row(p_plug_id => p_plug_id
,p_seq_id => p_seq_id
,p_label => p_label
,p_param_data => l_param
,p_user_id => p_user_id
,x_return_status => x_return_status
);
END insert_row;
PROCEDURE insert_row(
p_plug_id IN NUMBER
,p_seq_id IN NUMBER
,p_label IN VARCHAR2
,p_param_data IN VARCHAR2
,p_user_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
FND_MSG_PUB.INITIALIZE;
INSERT INTO bis_pmf_populate_portlet(
PLUG_ID,
SEQ_ID,
LABEL,
PARAM_DATA,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_plug_id
,p_seq_id
,p_label
,p_param_data
,sysdate
,p_user_id
,sysdate
,p_user_id
,p_user_id
);
END insert_row;
PROCEDURE delete_all_demo_rows(
p_plug_id IN NUMBER
)
IS
BEGIN
DELETE bis_pmf_populate_portlet
WHERE PLUG_ID = p_plug_id;
END delete_all_demo_rows;
SELECT computing_function_id
FROM bisbv_target_levels
WHERE target_level_id = p_target_level_id;
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');
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;
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;
SELECT short_name
INTO level_short_name
FROM bis_levels
WHERE level_id = l_time_dimension_level_id;
p_ind_selection_id
,x_target_rec.target_level_id
,l_time_dimension_level_id
,l_current_period_id
,l_current_period_name);
update bis_indicators
set comparison_source = 'POA_PMF_PO_DIST.PURCHASE_AMT'
,increase_in_measure = 'B'
where indicator_id = 24;
update bis_indicators
2 set comparison_source = 'WIP_BIS_PROD_VAL_EMP_AB1_IDC.FND_APPLY'
3 where indicator_id = 199;