740: l_last_update_date := nvl(p_last_update_date, sysdate);
741:
742: l_Dataset_Rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
743: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
744: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
745: l_Dataset_Rec.Bsc_Dataset_Creation_Date := l_last_update_date;
746: l_Dataset_Rec.Bsc_Dataset_Last_Update_Date := l_last_update_date;
747:
748: l_Dataset_Rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
746: l_Dataset_Rec.Bsc_Dataset_Last_Update_Date := l_last_update_date;
747:
748: l_Dataset_Rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
749: l_Dataset_Rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
750: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
751: l_Dataset_Rec.Bsc_Measure_Creation_Date := l_last_update_date;
752: l_Dataset_Rec.Bsc_Measure_Last_Update_Date := l_last_update_date;
753:
754: -- We dont need to lock here, since the data_source has
1010: --sawu: populate WHO column
1011: l_Measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1012: l_Measure_rec.Creation_Date := l_last_update_date;
1013: l_Measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1014: l_Measure_rec.Last_Update_Login := fnd_global.LOGIN_ID;
1015: l_Measure_rec.Last_Update_Date := l_last_update_date;
1016:
1017: -- rpenneru 12/20/2004 - Add Functional Area short name
1018: l_Measure_rec.Func_Area_Short_Name := p_func_area_short_name;
1384: l_Dataset_Rec.Bsc_Measure_Created_By := p_Dataset_Rec_db.Bsc_Measure_Created_By;
1385: end if;
1386:
1387: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
1388: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
1389: end if;
1390:
1391: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
1392: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
1388: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
1389: end if;
1390:
1391: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
1392: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
1393: end if;
1394:
1395:
1396: BSC_DATASETS_PVT.Create_Measures(
1609: l_last_update_date := nvl(p_last_update_date, sysdate);
1610:
1611: l_Dataset_Rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1612: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1613: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
1614: l_Dataset_Rec.Bsc_Dataset_Last_Update_Date := l_last_update_date;
1615:
1616: l_Dataset_Rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1617: l_Dataset_Rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1614: l_Dataset_Rec.Bsc_Dataset_Last_Update_Date := l_last_update_date;
1615:
1616: l_Dataset_Rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1617: l_Dataset_Rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1618: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
1619: l_Dataset_Rec.Bsc_Measure_Last_Update_Date := l_last_update_date;
1620:
1621: if p_measure_short_name is null then
1622: l_Dataset_Rec.Bsc_Measure_Short_Name := c_PMD || p_Dataset_id;
1960:
1961: --sawu: populate WHO column
1962: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1963: l_measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1964: l_measure_rec.Last_Update_Login := fnd_global.LOGIN_ID;
1965: l_measure_rec.Last_Update_Date := l_last_update_date;
1966:
1967: --rpenneru: 12/22/04 Populate Functional Area Short name
1968: l_measure_rec.Func_Area_Short_Name := p_func_area_short_name;
3252:
3253: --sawu: populate WHO column
3254: l_dataset_rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3255: l_dataset_rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3256: l_dataset_rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
3257:
3258: l_dataset_rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3259: l_dataset_rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3260: l_dataset_rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
3256: l_dataset_rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
3257:
3258: l_dataset_rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3259: l_dataset_rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3260: l_dataset_rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
3261:
3262: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3263: l_measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3264: l_measure_rec.Last_Update_Login := fnd_global.LOGIN_ID;
3260: l_dataset_rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
3261:
3262: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3263: l_measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3264: l_measure_rec.Last_Update_Login := fnd_global.LOGIN_ID;
3265:
3266: BSC_DATASETS_PUB.Translate_Measure(
3267: p_commit => FND_API.G_FALSE
3268: ,p_measure_rec => l_measure_rec