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.BSC_KPI_PVT dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 1513: l_db_object := 'BSC_KPI_ANALYSIS_GROUPS';

1509: FND_MSG_PUB.ADD;
1510: RAISE FND_API.G_EXC_ERROR;
1511: end if;
1512:
1513: l_db_object := 'BSC_KPI_ANALYSIS_GROUPS';
1514:
1515: insert into BSC_KPI_ANALYSIS_GROUPS( INDICATOR
1516: ,ANALYSIS_GROUP_ID
1517: ,NUM_OF_OPTIONS

Line 1515: insert into BSC_KPI_ANALYSIS_GROUPS( INDICATOR

1511: end if;
1512:
1513: l_db_object := 'BSC_KPI_ANALYSIS_GROUPS';
1514:
1515: insert into BSC_KPI_ANALYSIS_GROUPS( INDICATOR
1516: ,ANALYSIS_GROUP_ID
1517: ,NUM_OF_OPTIONS
1518: ,DEPENDENCY_FLAG
1519: ,PARENT_ANALYSIS_ID

Line 1668: from BSC_KPI_ANALYSIS_GROUPS

1664: ,x_Bsc_Kpi_Entity_Rec.Bsc_Parent_Anal_Id
1665: ,x_Bsc_Kpi_Entity_Rec.Bsc_Change_Dim_Set
1666: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value
1667: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Ana_Group_Short_Name
1668: from BSC_KPI_ANALYSIS_GROUPS
1669: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
1670: and analysis_group_id = p_Bsc_Kpi_Entity_Rec.Bsc_Anal_Group_Id;
1671: ELSE
1672: select distinct analysis_group_id

Line 1686: from BSC_KPI_ANALYSIS_GROUPS

1682: ,x_Bsc_Kpi_Entity_Rec.Bsc_Parent_Anal_Id
1683: ,x_Bsc_Kpi_Entity_Rec.Bsc_Change_Dim_Set
1684: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value
1685: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Ana_Group_Short_Name
1686: from BSC_KPI_ANALYSIS_GROUPS
1687: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1688: END IF;
1689: if (p_commit = FND_API.G_TRUE) then
1690: commit;

Line 1817: update BSC_KPI_ANALYSIS_GROUPS

1813: , p_grand_parent_option_Id => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Analysis_Option0
1814: , p_option_Id => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value
1815: );
1816: END IF;
1817: update BSC_KPI_ANALYSIS_GROUPS
1818: set analysis_group_id = l_Bsc_Kpi_Entity_Rec.Bsc_Anal_Group_Id
1819: ,num_of_options = l_Bsc_Kpi_Entity_Rec.Bsc_Num_Options
1820: ,dependency_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Dependency_Flag
1821: ,parent_analysis_id = l_Bsc_Kpi_Entity_Rec.Bsc_Parent_Anal_Id

Line 1828: update BSC_KPI_ANALYSIS_GROUPS

1824: ,short_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Ana_Group_Short_Name
1825: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
1826: AND analysis_group_id = l_Bsc_Kpi_Entity_Rec.Bsc_Anal_Group_Id;
1827: ELSE
1828: update BSC_KPI_ANALYSIS_GROUPS
1829: set analysis_group_id = l_Bsc_Kpi_Entity_Rec.Bsc_Anal_Group_Id
1830: ,num_of_options = l_Bsc_Kpi_Entity_Rec.Bsc_Num_Options
1831: ,dependency_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Dependency_Flag
1832: ,parent_analysis_id = l_Bsc_Kpi_Entity_Rec.Bsc_Parent_Anal_Id

Line 1923: FROM bsc_kpi_analysis_groups

1919: RAISE FND_API.G_EXC_ERROR;
1920: END IF;
1921:
1922: DELETE
1923: FROM bsc_kpi_analysis_groups
1924: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1925:
1926: DELETE
1927: FROM bsc_kpi_analysis_options_b

Line 5829: update BSC_KPI_ANALYSIS_GROUPS

5825: and analysis_group_id = 0
5826: and user_level1 = 1;
5827:
5828: -- update the Default option in KPI ANALYSIS GROUPS
5829: update BSC_KPI_ANALYSIS_GROUPS
5830: set default_value = l_def_option
5831: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
5832:
5833:

Line 5853: UPDATE BSC_KPI_ANALYSIS_GROUPS

5849: AND ANALYSIS_GROUP_ID = 0
5850: AND OPTION_ID = L_DEF_OPTION;
5851:
5852: -- update the Default option in KPI ANALYSIS GROUPS
5853: UPDATE BSC_KPI_ANALYSIS_GROUPS
5854: SET DEFAULT_VALUE = l_def_option
5855: WHERE INDICATOR = l_shared_kpi;
5856:
5857: END LOOP;

Line 5870: from BSC_KPI_ANALYSIS_GROUPS

5866:
5867: -- Get the default analysis option id.
5868: select default_value
5869: into l_def_option
5870: from BSC_KPI_ANALYSIS_GROUPS
5871: where indicator = l_shared_kpi
5872: and analysis_group_id = 0;
5873:
5874: update BSC_KPI_ANALYSIS_OPTIONS_B

Line 5962: FROM BSC_KPI_ANALYSIS_GROUPS

5958: BEGIN
5959: SAVEPOINT BSCSeefaulValPVT;
5960: SELECT Dependency_Flag, Default_Value
5961: INTO l_Dependency_Flag, l_Default_Value
5962: FROM BSC_KPI_ANALYSIS_GROUPS
5963: WHERE Indicator = p_Kpi_Id
5964: AND Analysis_Group_Id = p_group_Id;
5965:
5966: -- find current default options

Line 5987: UPDATE BSC_KPI_ANALYSIS_GROUPS

5983: WHERE Indicator = p_Kpi_Id
5984: AND Analysis_Group_Id = p_group_Id
5985: AND Option_Id = p_option_Id;
5986:
5987: UPDATE BSC_KPI_ANALYSIS_GROUPS
5988: SET Default_Value = p_option_Id
5989: WHERE Indicator = p_Kpi_Id
5990: AND Analysis_Group_Id = p_group_Id;
5991:

Line 6014: UPDATE BSC_KPI_ANALYSIS_GROUPS

6010: WHERE Indicator = p_Kpi_Id
6011: AND Analysis_Group_Id = p_group_Id
6012: AND Option_Id = p_option_Id;
6013:
6014: UPDATE BSC_KPI_ANALYSIS_GROUPS
6015: SET Default_Value = p_option_Id
6016: WHERE Indicator = p_Kpi_Id
6017: AND Analysis_Group_Id = p_group_Id;
6018:

Line 6040: UPDATE BSC_KPI_ANALYSIS_GROUPS

6036: AND Analysis_Group_Id = p_group_Id
6037: AND Option_Id = p_option_Id
6038: AND Parent_Option_Id = p_Parent_Option_Id;
6039:
6040: UPDATE BSC_KPI_ANALYSIS_GROUPS
6041: SET Default_Value = p_option_Id
6042: WHERE Indicator = p_Kpi_Id
6043: AND Analysis_Group_Id = p_group_Id;
6044:

Line 6069: UPDATE BSC_KPI_ANALYSIS_GROUPS

6065: AND Option_Id = p_option_Id
6066: AND Parent_Option_Id = p_Parent_Option_Id
6067: AND Grandparent_Option_Id = p_Grand_Parent_Option_Id;
6068:
6069: UPDATE BSC_KPI_ANALYSIS_GROUPS
6070: SET Default_Value = p_option_Id
6071: WHERE Indicator = p_Kpi_Id
6072: AND Analysis_Group_Id = p_group_Id;
6073:

Line 6132: from BSC_KPI_ANALYSIS_GROUPS

6128: IF (l_proto_flag <> BSC_KPI_PUB.Delete_Kpi_Flag) THEN
6129: -- Get the number of analysis groups in this or in source kpi.
6130: select max(analysis_group_id)
6131: into l_group_count
6132: from BSC_KPI_ANALYSIS_GROUPS
6133: where indicator = l_source_kpi;
6134:
6135: -- Get the default option id for the first analysis groups.
6136: select default_value

Line 6138: from BSC_KPI_ANALYSIS_GROUPS

6134:
6135: -- Get the default option id for the first analysis groups.
6136: select default_value
6137: into l_default_option
6138: from BSC_KPI_ANALYSIS_GROUPS
6139: where indicator = l_source_kpi
6140: and analysis_group_id = 0;
6141:
6142: -- Set this default option for the display flag

Line 6156: from BSC_KPI_ANALYSIS_GROUPS

6152: -- Determine if there is a dependency between groups 1 and 0, and get the
6153: -- default option id.
6154: select dependency_flag, default_value
6155: into l_dependency1_flag, l_default_option
6156: from BSC_KPI_ANALYSIS_GROUPS
6157: where indicator = l_source_kpi
6158: and analysis_group_id = 1;
6159:
6160: -- If there is no dependency apply This flag without filtering on parent id.

Line 6173: from BSC_KPI_ANALYSIS_GROUPS

6169: else
6170:
6171: select default_value
6172: into l_default_parent_option
6173: from BSC_KPI_ANALYSIS_GROUPS
6174: where indicator = l_source_kpi
6175: and analysis_group_id = 0;
6176:
6177: update BSC_KPI_ANALYSIS_OPTIONS_B

Line 6193: from BSC_KPI_ANALYSIS_GROUPS

6189:
6190: -- Determine if there is a dependency between groups 2 and 1.
6191: select dependency_flag, default_value
6192: into l_dependency2_flag, l_default_option
6193: from BSC_KPI_ANALYSIS_GROUPS
6194: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6195: and analysis_group_id = 2;
6196:
6197: -- if there is no dependency between groups 1 and 0, and 2 and 1 apply flag

Line 6210: from BSC_KPI_ANALYSIS_GROUPS

6206: elsif l_dependency1_flag <> 1 then
6207:
6208: select default_value
6209: into l_default_parent_option
6210: from BSC_KPI_ANALYSIS_GROUPS
6211: where indicator = l_source_kpi
6212: and analysis_group_id = 1;
6213:
6214: update BSC_KPI_ANALYSIS_OPTIONS_B

Line 6236: from BSC_KPI_ANALYSIS_GROUPS

6232: else
6233:
6234: select default_value
6235: into l_default_parent_option
6236: from BSC_KPI_ANALYSIS_GROUPS
6237: where indicator = l_source_kpi
6238: and analysis_group_id = 1;
6239:
6240: select default_value

Line 6242: from BSC_KPI_ANALYSIS_GROUPS

6238: and analysis_group_id = 1;
6239:
6240: select default_value
6241: into l_default_grandparent_option
6242: from BSC_KPI_ANALYSIS_GROUPS
6243: where indicator = l_source_kpi
6244: and analysis_group_id = 0;
6245:
6246: update BSC_KPI_ANALYSIS_OPTIONS_B

Line 6739: from BSC_KPI_ANALYSIS_GROUPS

6735: else
6736: -- See if there is some Analysis Group that depend of the current one
6737: select count(ANALYSIS_GROUP_ID)
6738: into l_count
6739: from BSC_KPI_ANALYSIS_GROUPS
6740: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6741: and PARENT_ANALYSIS_ID = p_Bsc_kpi_Entity_Rec.Bsc_kpi_Group_Id;
6742:
6743: if l_count = 0 then