[Home] [Help]
270: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
271: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
272:
273: x_Table_Number := x_Table_Number + 1;
274: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_REGION_EXTENSION';
275: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
276: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
277: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
278: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
774: )IS
775: l_count NUMBER;
776: l_region_code ak_regions.region_code%TYPE;
777: l_region_app_id ak_regions.region_application_id%TYPE;
778: l_YTD bis_ak_region_extension.attribute21%TYPE;
779:
780: l_attribute21 bis_ak_region_extension.attribute21%TYPE;
781:
782: CURSOR c_kpi IS
776: l_region_code ak_regions.region_code%TYPE;
777: l_region_app_id ak_regions.region_application_id%TYPE;
778: l_YTD bis_ak_region_extension.attribute21%TYPE;
779:
780: l_attribute21 bis_ak_region_extension.attribute21%TYPE;
781:
782: CURSOR c_kpi IS
783: SELECT A.region_code,A.region_application_id
784: FROM bsc_kpis_b B,
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: l_YTD :=p_YTD;
796:
797: --We need to check if the record exists in BIS_AK_REGION_EXTENSION table
798: -- if not then we need to create the record else update the record
799: FOR cd IN c_kpi LOOP
800:
801: IF(cd.region_code IS NOT NULL) THEN
800:
801: IF(cd.region_code IS NOT NULL) THEN
802: SELECT COUNT(0)
803: INTO l_count
804: FROM BIS_AK_REGION_EXTENSION
805: WHERE region_code =cd.region_code;
806:
807: IF(l_YTD IS NULL) THEN
808: l_YTD := BSC_SIMULATION_VIEW_PUB.c_YEAR_TO_DATE_DISABLED;