eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PORTLET_PMREGION dependencies on BIS_PMF_PORTLET_UTIL

Line 1128: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(p_plug_id, p_user_id, x_owner_user_id) ) THEN

1124:
1125: -- if there is no rows customized for this login user,
1126: -- use whatever customized
1127: -- for the owner of the portlet.
1128: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(p_plug_id, p_user_id, x_owner_user_id) ) THEN
1129: l_user_id := p_user_id; -- current login user
1130: ELSE -- no rows have been customized for the login user
1131: l_user_id := x_owner_user_id;
1132: END IF;

Line 1158: l_row_style := BIS_PMF_PORTLET_UTIL.get_row_style(l_row_style);

1154: l_good_bad := csel.increase_in_measure; -- 1850860
1155:
1156:
1157: -- This is to display one row in white and the next in yellow
1158: l_row_style := BIS_PMF_PORTLET_UTIL.get_row_style(l_row_style);
1159:
1160: -- bug#2197758
1161:
1162: IF (NOT BIS_PMF_PORTLET_UTIL.is_authorized(

Line 1162: IF (NOT BIS_PMF_PORTLET_UTIL.is_authorized(

1158: l_row_style := BIS_PMF_PORTLET_UTIL.get_row_style(l_row_style);
1159:
1160: -- bug#2197758
1161:
1162: IF (NOT BIS_PMF_PORTLET_UTIL.is_authorized(
1163: p_cur_user_id => p_user_id
1164: ,p_target_level_id => csel.target_level_id) ) THEN
1165:
1166: l_html_row := l_html_row || draw_status(l_status_lbl, 0, l_row_style);

Line 1223: l_format_actual := BIS_PMF_PORTLET_UTIL.getAKFormatValue( p_measure_id =>csel.indicator_id ,p_val =>l_actual_value);

1219: l_html_row := l_html_row || draw_actual(l_value_lbl, l_none_lbl, l_row_style);
1220: l_html_row := l_html_row || draw_change(l_change_lbl,l_na_lbl,null,null,l_row_style);
1221:
1222: ELSE
1223: l_format_actual := BIS_PMF_PORTLET_UTIL.getAKFormatValue( p_measure_id =>csel.indicator_id ,p_val =>l_actual_value);
1224:
1225: get_change(
1226: p_actual_value => l_actual_value
1227: ,p_comp_actual_value => l_comparison_actual_value

Line 1633: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(l_plug_id, l_current_user_id, l_owner_user_id) ) THEN

1629: -- to the next proc because one of parameters is a plsql table
1630: -- which cannot be nullable
1631: l_displaylabels_tbl(1) := '';
1632:
1633: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(l_plug_id, l_current_user_id, l_owner_user_id) ) THEN
1634: l_user_id := l_current_user_id;
1635: ELSE
1636: l_user_id := l_owner_user_id;
1637: END IF;

Line 1678: BIS_PMF_PORTLET_UTIL.is_authorized(

1674: END LOOP;
1675: -- bug#2225110
1676:
1677: IF (l_unique AND
1678: BIS_PMF_PORTLET_UTIL.is_authorized(
1679: p_cur_user_id => l_current_user_id
1680: ,p_target_level_id => l_selections_tbl(i).target_level_id) ) THEN
1681: l_cnt := l_temp_tbl.COUNT + 1;
1682: l_temp_tbl(l_cnt).id := l_selections_tbl(i).target_level_id;

Line 2238: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(l_plug_id, l_current_user_id, l_owner_user_id) ) THEN

2234: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
2235:
2236: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
2237:
2238: IF (BIS_PMF_PORTLET_UTIL.has_customized_rows(l_plug_id, l_current_user_id, l_owner_user_id) ) THEN
2239: l_user_id := l_current_user_id;
2240: ELSE
2241: l_user_id := l_owner_user_id;
2242: END IF;

Line 3675: IF (BIS_PMF_PORTLET_UTIL.is_authorized(

3671: END IF;
3672:
3673: l_link := l_link||'*'||NVL(l_labels_tbl(i).PLAN_ID,'+1');
3674: -- bug#2225110
3675: IF (BIS_PMF_PORTLET_UTIL.is_authorized(
3676: p_cur_user_id => l_current_user_id
3677: ,p_target_level_id => l_labels_tbl(i).target_level_id) ) THEN
3678:
3679: l_access := '*Y';

Line 5668: l_function_name := BIS_PMF_PORTLET_UTIL.get_function_name(p_reference_path);

5664: FROM fnd_form_functions
5665: WHERE function_name = l_function_name;
5666: BEGIN
5667:
5668: l_function_name := BIS_PMF_PORTLET_UTIL.get_function_name(p_reference_path);
5669: IF ( l_function_name IS NULL ) THEN
5670: RETURN NULL;
5671: END IF;
5672:

Line 5758: l_function_name := BIS_PMF_PORTLET_UTIL.get_function_name(p_reference_path => p_reference_path);

5754: WHERE function_name = cp_function_name;
5755:
5756: BEGIN
5757:
5758: l_function_name := BIS_PMF_PORTLET_UTIL.get_function_name(p_reference_path => p_reference_path);
5759:
5760: IF ( l_function_name IS NULL ) THEN
5761: RETURN NULL;
5762: END IF;

Line 5810: l_level_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_target_level,p_parameters);

5806: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
5807: BEGIN
5808: x_return_status := FND_API.G_RET_STS_SUCCESS;
5809:
5810: l_level_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_target_level,p_parameters);
5811: IF (l_level_short_name IS NULL) THEN --bug#2210756
5812: RETURN NULL;
5813: END IF;
5814:

Line 5931: l_plan_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_plan,p_parameters);

5927:
5928: BEGIN
5929: x_return_status := FND_API.G_RET_STS_SUCCESS;
5930:
5931: l_plan_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_plan,p_parameters);
5932:
5933: -- plan short name is not specified
5934: IF ( l_plan_short_name IS NULL) THEN
5935: RETURN p_default_plan_id;

Line 6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);

6038:
6039:
6040: l_ind_rec.LABEL := p_user_fname;
6041: l_ind_rec.PLUG_ID := p_plug_id;
6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);
6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);

Line 6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);

6039:
6040: l_ind_rec.LABEL := p_user_fname;
6041: l_ind_rec.PLUG_ID := p_plug_id;
6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);
6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);

Line 6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);

6040: l_ind_rec.LABEL := p_user_fname;
6041: l_ind_rec.PLUG_ID := p_plug_id;
6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);
6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);
6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);

Line 6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);

6041: l_ind_rec.PLUG_ID := p_plug_id;
6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);
6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);
6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);
6049:

Line 6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);

6042: l_ind_rec.DIM1_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id1,p_parameters);
6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);
6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);
6049:
6050:

Line 6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);

6043: l_ind_rec.DIM2_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id2,p_parameters);
6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);
6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);
6049:
6050:
6051: -- save to database

Line 6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);

6044: l_ind_rec.DIM3_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id3,p_parameters);
6045: l_ind_rec.DIM4_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id4,p_parameters);
6046: l_ind_rec.DIM5_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id5,p_parameters);
6047: l_ind_rec.DIM6_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id6,p_parameters);
6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);
6049:
6050:
6051: -- save to database
6052: BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(

Line 6828: l_row_style := BIS_PMF_PORTLET_UTIL.get_row_style(l_row_style);

6824: );
6825:
6826: FOR demo_rec IN cDemo LOOP
6827: l_html_row := ' ';
6828: l_row_style := BIS_PMF_PORTLET_UTIL.get_row_style(l_row_style);
6829:
6830: BEGIN
6831:
6832: --getting info from table

Line 6833: l_status := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_status,demo_rec.PARAM_DATA,c_caret));

6829:
6830: BEGIN
6831:
6832: --getting info from table
6833: l_status := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_status,demo_rec.PARAM_DATA,c_caret));
6834: l_value := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_value, demo_rec.PARAM_DATA, c_caret), l_none_lbl);
6835: l_change := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_change, demo_rec.PARAM_DATA, c_caret), l_na_lbl);
6836: l_arrow := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_arrow, demo_rec.PARAM_DATA,c_caret));
6837: l_img := get_image(l_arrow, l_worse_msg, l_improve_msg,l_arrow_alt_text);

Line 6834: l_value := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_value, demo_rec.PARAM_DATA, c_caret), l_none_lbl);

6830: BEGIN
6831:
6832: --getting info from table
6833: l_status := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_status,demo_rec.PARAM_DATA,c_caret));
6834: l_value := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_value, demo_rec.PARAM_DATA, c_caret), l_none_lbl);
6835: l_change := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_change, demo_rec.PARAM_DATA, c_caret), l_na_lbl);
6836: l_arrow := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_arrow, demo_rec.PARAM_DATA,c_caret));
6837: l_img := get_image(l_arrow, l_worse_msg, l_improve_msg,l_arrow_alt_text);
6838: -- drawing now

Line 6835: l_change := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_change, demo_rec.PARAM_DATA, c_caret), l_na_lbl);

6831:
6832: --getting info from table
6833: l_status := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_status,demo_rec.PARAM_DATA,c_caret));
6834: l_value := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_value, demo_rec.PARAM_DATA, c_caret), l_none_lbl);
6835: l_change := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_change, demo_rec.PARAM_DATA, c_caret), l_na_lbl);
6836: l_arrow := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_arrow, demo_rec.PARAM_DATA,c_caret));
6837: l_img := get_image(l_arrow, l_worse_msg, l_improve_msg,l_arrow_alt_text);
6838: -- drawing now
6839: l_html_row := l_html_row || draw_status(l_status_lbl, l_status, l_row_style);

Line 6836: l_arrow := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_arrow, demo_rec.PARAM_DATA,c_caret));

6832: --getting info from table
6833: l_status := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_status,demo_rec.PARAM_DATA,c_caret));
6834: l_value := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_value, demo_rec.PARAM_DATA, c_caret), l_none_lbl);
6835: l_change := NVL(BIS_PMF_PORTLET_UTIL.getValue(c_key_change, demo_rec.PARAM_DATA, c_caret), l_na_lbl);
6836: l_arrow := TO_NUMBER(BIS_PMF_PORTLET_UTIL.getValue(c_key_arrow, demo_rec.PARAM_DATA,c_caret));
6837: l_img := get_image(l_arrow, l_worse_msg, l_improve_msg,l_arrow_alt_text);
6838: -- drawing now
6839: l_html_row := l_html_row || draw_status(l_status_lbl, l_status, l_row_style);
6840: l_html_row := l_html_row || draw_measure_name(l_actual_url, demo_rec.LABEL,

Line 7056: IF ( NOT BIS_PMF_PORTLET_UTIL.is_demo_on ) THEN -- demo not on

7052: l_url_lbl VARCHAR2(10000);
7053: l_servlet_agent VARCHAR2(5000) := NULL;
7054: BEGIN
7055:
7056: IF ( NOT BIS_PMF_PORTLET_UTIL.is_demo_on ) THEN -- demo not on
7057: RETURN;
7058: END IF;
7059:
7060: -- demo is on

Line 7563: IF ( BIS_PMF_PORTLET_UTIL.has_demo_rows(p_plug_id) ) THEN

7559: BEGIN
7560: l_session_id := icx_sec.g_session_id;
7561: l_login_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
7562:
7563: IF ( BIS_PMF_PORTLET_UTIL.has_demo_rows(p_plug_id) ) THEN
7564:
7565: display_demo_portlet(
7566: p_session_id => l_session_id
7567: ,p_plug_id => p_plug_id

Line 7575: BIS_PMF_PORTLET_UTIL.clean_user_ind_sel(p_plug_id);

7571: );
7572: ELSE -- no demo rows, use the production rows
7573: --bug#2210756, make sure the target level id specified exists
7574:
7575: BIS_PMF_PORTLET_UTIL.clean_user_ind_sel(p_plug_id);
7576:
7577: -- bug#2203485 render the portlet at runtime
7578: IF (NOT BIS_PMF_PORTLET_UTIL.has_rows(p_plug_id, l_owner_user_id) ) THEN
7579: copyMeasureDefs(

Line 7578: IF (NOT BIS_PMF_PORTLET_UTIL.has_rows(p_plug_id, l_owner_user_id) ) THEN

7574:
7575: BIS_PMF_PORTLET_UTIL.clean_user_ind_sel(p_plug_id);
7576:
7577: -- bug#2203485 render the portlet at runtime
7578: IF (NOT BIS_PMF_PORTLET_UTIL.has_rows(p_plug_id, l_owner_user_id) ) THEN
7579: copyMeasureDefs(
7580: p_reference_path => p_reference_path
7581: ,p_plug_id => p_plug_id
7582: ,p_user_id => l_owner_user_id