APPS.BSC_DATASETS_PVT dependencies on BSC_SYS_DATASETS_TL

Line 1046: -- Insert the pertaining values into table bsc_sys_datasets_tl.

1042: ,l_Dataset_Rec.Bsc_Dataset_Last_Update_Date -- PMD
1043: ,l_Dataset_Rec.Bsc_Dataset_Last_Update_Login);-- PMD
1044:
1045:
1046: -- Insert the pertaining values into table bsc_sys_datasets_tl.
1047: insert into BSC_SYS_DATASETS_TL( dataset_id
1048: ,language
1049: ,source_lang
1050: ,name

Line 1047: insert into BSC_SYS_DATASETS_TL( dataset_id

1043: ,l_Dataset_Rec.Bsc_Dataset_Last_Update_Login);-- PMD
1044:
1045:
1046: -- Insert the pertaining values into table bsc_sys_datasets_tl.
1047: insert into BSC_SYS_DATASETS_TL( dataset_id
1048: ,language
1049: ,source_lang
1050: ,name
1051: ,help

Line 1063: from BSC_SYS_DATASETS_TL T

1059: from FND_LANGUAGES L
1060: where L.INSTALLED_FLAG in ('I', 'B')
1061: and not exists
1062: (select NULL
1063: from BSC_SYS_DATASETS_TL T
1064: where T.dataset_id = l_Dataset_Rec.Bsc_Dataset_Id
1065: and T.LANGUAGE = L.LANGUAGE_CODE);
1066:
1067: if (p_commit = FND_API.G_TRUE) then

Line 1396: update BSC_SYS_DATASETS_TL

1392: where dataset_id = l_Dataset_Rec.Bsc_Dataset_Id;
1393:
1394: ----Fix for the bug 2883880
1395:
1396: update BSC_SYS_DATASETS_TL
1397: set name = l_Dataset_Rec.Bsc_Dataset_Name
1398: ,help = l_Dataset_Rec.Bsc_Dataset_Help
1399: ,y_axis_title = l_Dataset_Rec.Bsc_y_axis_title
1400: ,source_lang = l_Dataset_Rec.Bsc_Source_Language

Line 1579: delete from BSC_SYS_DATASETS_TL

1575:
1576: delete from BSC_SYS_DATASETS_B
1577: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1578:
1579: delete from BSC_SYS_DATASETS_TL
1580: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1581:
1582: if (p_commit = FND_API.G_TRUE) then
1583: commit;

Line 1927: UPDATE bsc_sys_datasets_tl

1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: FND_MSG_PUB.Initialize;
1926:
1927: UPDATE bsc_sys_datasets_tl
1928: SET name = p_Dataset_Rec.Bsc_Dataset_Name
1929: ,help = p_Dataset_Rec.Bsc_Dataset_Help
1930: ,y_axis_title = p_Dataset_Rec.Bsc_y_axis_title
1931: ,source_lang = userenv('LANG')

Line 1983: UPDATE BSC_SYS_DATASETS_TL

1979: x_return_status := FND_API.G_RET_STS_SUCCESS;
1980:
1981: FND_MSG_PUB.Initialize;
1982:
1983: UPDATE BSC_SYS_DATASETS_TL
1984: SET name = p_Dataset_Rec.Bsc_Dataset_Name
1985: ,help = p_Dataset_Rec.Bsc_Dataset_Help
1986: ,y_axis_title = p_Dataset_Rec.Bsc_y_axis_title
1987: ,source_lang = p_source_lang