APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_USER_IND_SELECTIONS

Line 293: FROM bis_user_ind_selections

289: 5, dimension5_level_value,
290: 6, dimension6_level_value,
291: 7, dimension7_level_value,
292: NULL) dimension_level_value
293: FROM bis_user_ind_selections
294: WHERE ind_selection_id = p_ind_selection_id;
295:
296: CURSOR c_org_level_name (org_level_id NUMBER) IS
297: SELECT short_name

Line 484: FROM bis_user_ind_selections

480: 5, dimension5_level_value,
481: 6, dimension6_level_value,
482: 7, dimension7_level_value,
483: NULL) dimension_level_value
484: FROM bis_user_ind_selections
485: WHERE ind_selection_id = p_ind_selection_id;
486:
487: CURSOR c_org_level_name (org_level_id NUMBER) IS
488: SELECT short_name

Line 705: FROM bis_user_ind_selections

701: 5, dimension5_level_value,
702: 6, dimension6_level_value,
703: 7, dimension7_level_value,
704: NULL) dimension_level_value
705: FROM bis_user_ind_selections
706: WHERE ind_selection_id = p_ind_selection_id;
707:
708: l_measure VARCHAR2(50);
709: l_targeturl VARCHAR2(2000);

Line 867: FROM bis_user_ind_selections a

863: ,a.plan_id
864: ,c.increase_in_measure
865: ,c.comparison_source
866: ,c.indicator_id
867: FROM bis_user_ind_selections a
868: ,fnd_user_resp_groups b
869: ,bis_indicators c
870: ,bisbv_target_levels d
871: WHERE a.user_id = g_user_id

Line 889: delete from bis_user_ind_selections

885:
886: IF p_delete = 'Y' THEN
887:
888: BEGIN
889: delete from bis_user_ind_selections
890: where user_id = g_user_id
891: and plug_id = p_plug_id;
892: EXCEPTION
893: WHEN OTHERS THEN

Line 944: -- Begin fetching rows from the table BIS_USER_IND_SELECTIONS

940:
941:
942: --Performance measures
943:
944: -- Begin fetching rows from the table BIS_USER_IND_SELECTIONS
945: --
946: l_row_style := 'Band';
947:
948: FOR csel in c_selections LOOP

Line 1255: -- bis_user_ind_selections table.

1251: , x_Error_Tbl => l_error_tbl
1252: );
1253:
1254: -- Get all the previously selected Indicator levels from
1255: -- bis_user_ind_selections table.
1256: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
1257: ( p_api_version => 1.0
1258: , p_user_id => l_user_id
1259: , p_all_info => FND_API.G_TRUE

Line 2444: -- display labels and dimlvl valss into the BIS_USER_IND_SELECTIONS table

2440:
2441: -- ***************
2442: l_string1 := l_string1 ||'';
2443: -- Dummy form to send selected labels to a procedure that inserts the
2444: -- display labels and dimlvl valss into the BIS_USER_IND_SELECTIONS table
2445:
2446: l_string1 := l_string1 ||'';
2447:
2448: l_string1 := l_string1 ||'