APPS.BSC_KPI_PVT dependencies on BSC_KPI_PERIODICITIES

Line 2170: from BSC_KPI_PERIODICITIES

2166:
2167: -- set value for display order.
2168: select count(display_order)
2169: into l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Display
2170: from BSC_KPI_PERIODICITIES
2171: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2172:
2173: l_db_object := 'BSC_KPI_PERIODICITIES';
2174:

Line 2173: l_db_object := 'BSC_KPI_PERIODICITIES';

2169: into l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Display
2170: from BSC_KPI_PERIODICITIES
2171: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2172:
2173: l_db_object := 'BSC_KPI_PERIODICITIES';
2174:
2175: insert into BSC_KPI_PERIODICITIES( indicator
2176: ,periodicity_id
2177: ,display_order

Line 2175: insert into BSC_KPI_PERIODICITIES( indicator

2171: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2172:
2173: l_db_object := 'BSC_KPI_PERIODICITIES';
2174:
2175: insert into BSC_KPI_PERIODICITIES( indicator
2176: ,periodicity_id
2177: ,display_order
2178: ,previous_years
2179: ,num_of_years

Line 2302: from BSC_KPI_PERIODICITIES

2298: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level2
2299: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level2_Default
2300: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Current_Period
2301: ,x_Bsc_Kpi_Entity_Rec.Last_Update_Date
2302: from BSC_KPI_PERIODICITIES
2303: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
2304: and periodicity_id = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id;
2305:
2306: if (p_commit = FND_API.G_TRUE) then

Line 2437: update BSC_KPI_PERIODICITIES

2433: if p_Bsc_Kpi_Entity_Rec.Last_Update_Date is not null then
2434: l_Bsc_Kpi_Entity_Rec.Last_Update_Date := p_Bsc_Kpi_Entity_Rec.Last_Update_Date;
2435: end if;
2436:
2437: update BSC_KPI_PERIODICITIES
2438: set display_order = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Display
2439: ,previous_years = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Previous_Years
2440: ,num_of_years = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Num_Years
2441: ,viewport_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Viewport_Flag

Line 2536: delete from BSC_KPI_PERIODICITIES

2532: FND_MSG_PUB.ADD;
2533: RAISE FND_API.G_EXC_ERROR;
2534: end if;
2535:
2536: delete from BSC_KPI_PERIODICITIES
2537: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2538:
2539: if (p_commit = FND_API.G_TRUE) then
2540: commit;