APPS.BSC_DATASETS_PVT dependencies on BSC_SYS_DATASET_CALC

Line 1647: from BSC_SYS_DATASET_CALC

1643: RAISE FND_API.G_EXC_ERROR;
1644: else -- Check that combination dataset id and calc id does not exist.
1645: select count(1)
1646: into l_count
1647: from BSC_SYS_DATASET_CALC
1648: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id
1649: and disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id;
1650: if l_count <> 0 then
1651: FND_MESSAGE.SET_NAME('BSC','BSC_DTSET_CALC_EXISTSD');

Line 1666: -- Insert pertaining values into table bsc_sys_dataset_calc.

1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: end if;
1665:
1666: -- Insert pertaining values into table bsc_sys_dataset_calc.
1667: insert into BSC_SYS_DATASET_CALC( dataset_id
1668: ,disabled_calc_id)
1669: values( p_Dataset_Rec.Bsc_Dataset_Id
1670: ,p_Dataset_Rec.Bsc_Disabled_Calc_Id);

Line 1667: insert into BSC_SYS_DATASET_CALC( dataset_id

1663: RAISE FND_API.G_EXC_ERROR;
1664: end if;
1665:
1666: -- Insert pertaining values into table bsc_sys_dataset_calc.
1667: insert into BSC_SYS_DATASET_CALC( dataset_id
1668: ,disabled_calc_id)
1669: values( p_Dataset_Rec.Bsc_Dataset_Id
1670: ,p_Dataset_Rec.Bsc_Disabled_Calc_Id);
1671:

Line 1716: from BSC_SYS_DATASET_CALC

1712: begin
1713:
1714: select distinct disabled_calc_id
1715: into x_Dataset_Rec.Bsc_Disabled_Calc_Id
1716: from BSC_SYS_DATASET_CALC
1717: where dataset_id = x_Dataset_Rec.Bsc_Dataset_Id;
1718:
1719: if (p_commit = FND_API.G_TRUE) then
1720: commit;

Line 1780: update BSC_SYS_DATASET_CALC

1776: FND_MSG_PUB.ADD;
1777: RAISE FND_API.G_EXC_ERROR;
1778: end if;
1779:
1780: update BSC_SYS_DATASET_CALC
1781: set disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id
1782: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1783:
1784: if (p_commit = FND_API.G_TRUE) then

Line 1847: delete from BSC_SYS_DATASET_CALC

1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: end if;
1846:
1847: delete from BSC_SYS_DATASET_CALC
1848: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1849:
1850: if (p_commit = FND_API.G_TRUE) then
1851: commit;