APPS.BSC_KPI_PVT dependencies on BSC_KPI_PROPERTIES

Line 1138: l_db_object := 'BSC_KPI_PROPERTIES';

1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: end if;
1137:
1138: l_db_object := 'BSC_KPI_PROPERTIES';
1139:
1140: insert into BSC_KPI_PROPERTIES( indicator
1141: ,property_code
1142: ,property_value

Line 1140: insert into BSC_KPI_PROPERTIES( indicator

1136: end if;
1137:
1138: l_db_object := 'BSC_KPI_PROPERTIES';
1139:
1140: insert into BSC_KPI_PROPERTIES( indicator
1141: ,property_code
1142: ,property_value
1143: ,secondary_value)
1144: values( p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 1228: from BSC_KPI_PROPERTIES

1224: select distinct property_value
1225: ,secondary_value
1226: into x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value
1227: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value
1228: from BSC_KPI_PROPERTIES
1229: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
1230: and property_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code;
1231:
1232: if (p_commit = FND_API.G_TRUE) then

Line 1333: update BSC_KPI_PROPERTIES

1329: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value is not null then
1330: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value;
1331: end if;
1332:
1333: update BSC_KPI_PROPERTIES
1334: set property_value = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value
1335: ,secondary_value = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value
1336: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
1337: and property_code = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code;

Line 1422: delete from BSC_KPI_PROPERTIES

1418: RAISE FND_API.G_EXC_ERROR;
1419: end if;
1420:
1421:
1422: delete from BSC_KPI_PROPERTIES
1423: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1424:
1425: if (p_commit = FND_API.G_TRUE) then
1426: commit;