eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_MEASURE_PUB dependencies on BIS_UTILITIES_PUB

Line 354: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

350: ,p_dimension5_id IN NUMBER
351: ,p_dimension6_id IN NUMBER
352: ,p_dimension7_id IN NUMBER
353: ,p_y_axis_title IN VARCHAR2 := NULL
354: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
355: ,p_ui_flag IN VARCHAR2
356: ,p_is_default_short_name IN VARCHAR2
357: ,p_func_area_short_name IN VARCHAR2 := NULL
358: ,x_return_status OUT NOCOPY VARCHAR2

Line 538: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

534: ,p_dimension5_id IN NUMBER
535: ,p_dimension6_id IN NUMBER
536: ,p_dimension7_id IN NUMBER
537: ,p_y_axis_title IN VARCHAR2 := NULL
538: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
539: ,p_ui_flag IN VARCHAR2
540: ,p_func_area_short_name IN VARCHAR2 := NULL
541: ,x_return_status OUT NOCOPY VARCHAR2
542: ,x_msg_count OUT NOCOPY NUMBER

Line 696: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

692: ,p_dimension5_id IN NUMBER
693: ,p_dimension6_id IN NUMBER
694: ,p_dimension7_id IN NUMBER
695: ,p_y_axis_title IN VARCHAR2 := NULL
696: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
697: ,p_ui_flag IN VARCHAR2 := c_UI_FLAG
698: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE
699: ,p_func_area_short_name IN VARCHAR2 := NULL
700: ,x_return_status OUT NOCOPY VARCHAR2

Line 707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

703: ) is
704:
705: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
706: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
708: l_Measure_Col_Help VARCHAR2(150);
709: l_count NUMBER;
710: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
711: begin

Line 742: l_Dataset_Rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

738:
739: --sawu: populate WHO column
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;

Line 743: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

739: --sawu: populate WHO column
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:

Line 748: l_Dataset_Rec.Bsc_Measure_Created_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);
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;

Line 749: l_Dataset_Rec.Bsc_Measure_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

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);
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:

Line 1011: l_Measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1007: l_Measure_rec.Dimension6_Id := p_Dimension6_id;
1008: l_Measure_rec.Dimension7_Id := p_Dimension7_id;
1009:
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;

Line 1013: l_Measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1009:
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

Line 1151: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1147: ,p_dimension5_id IN NUMBER
1148: ,p_dimension6_id IN NUMBER
1149: ,p_dimension7_id IN NUMBER
1150: ,p_y_axis_title IN VARCHAR2 := NULL
1151: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1152: ,p_ui_flag IN VARCHAR2
1153: ,p_func_area_short_name IN VARCHAR2 := NULL
1154: ,x_return_status OUT NOCOPY VARCHAR2
1155: ,x_msg_count OUT NOCOPY NUMBER

Line 1520: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1516: ,p_dimension5_id IN NUMBER
1517: ,p_dimension6_id IN NUMBER
1518: ,p_dimension7_id IN NUMBER
1519: ,p_y_axis_title IN VARCHAR2 := NULL
1520: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1521: ,p_ui_flag IN VARCHAR2
1522: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE
1523: ,p_func_area_short_name IN VARCHAR2 := NULL
1524: ,x_return_status OUT NOCOPY VARCHAR2

Line 1532: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1528:
1529: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1530: l_Dataset_Rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1531: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
1532: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1533: l_measure_col_help VARCHAR2(150);
1534: l_old_measure_id NUMBER;
1535: l_count NUMBER;
1536:

Line 1611: l_Dataset_Rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1607:
1608: --sawu: populate WHO column
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:

Line 1612: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1608: --sawu: populate WHO column
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);

Line 1616: l_Dataset_Rec.Bsc_Measure_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);
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:

Line 1617: l_Dataset_Rec.Bsc_Measure_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);
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

Line 1962: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1958: l_measure_rec.Source_Column_App_Id := p_source_column_app_id;
1959: l_measure_rec.Compare_Column_App_Id := p_compare_column_app_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:

Line 1963: l_measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1959: l_measure_rec.Compare_Column_App_Id := p_compare_column_app_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

Line 2163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2159: ) is
2160:
2161: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2162: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2164: l_count number;
2165: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
2166:
2167: begin

Line 2853: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

2849: Procedure Load_Measure
2850: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
2851: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2852: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
2853: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2854: , p_custom_mode IN VARCHAR2 := NULL
2855: , p_application_short_name IN VARCHAR2
2856: , p_Org_Dimension_Short_Name IN VARCHAR2
2857: , p_Time_Dimension_Short_Name IN VARCHAR2

Line 2880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2876: l_msg_count NUMBER;
2877: l_msg_data VARCHAR2(2000);
2878: l_org_dimension_id NUMBER;
2879: l_time_dimension_id NUMBER;
2880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2881: l_measure_rec_new BIS_MEASURE_PUB.Measure_Rec_Type;
2882: l_dataset_rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2883: l_dataset_rec_db1 BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2884: l_measure_rec_db BIS_MEASURE_PUB.Measure_Rec_Type;

Line 2963: IF (BIS_UTILITIES_PUB.Value_Missing

2959:
2960: -- Call to BIS_MEASURE_PVT.Measure_Value_ID_Conversion is used to check
2961: -- if the measure should be created/updated during the upload of measure
2962:
2963: IF (BIS_UTILITIES_PUB.Value_Missing
2964: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
2965: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
2966: = FND_API.G_TRUE) THEN
2967: BIS_MEASURE_PVT.Measure_Value_ID_Conversion

Line 2965: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

2961: -- if the measure should be created/updated during the upload of measure
2962:
2963: IF (BIS_UTILITIES_PUB.Value_Missing
2964: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
2965: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
2966: = FND_API.G_TRUE) THEN
2967: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
2968: ( p_api_version => 1.0
2969: , p_Measure_Rec => l_Measure_Rec_new

Line 2986: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)

2982: --bug#4045278: data versioning
2983: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(
2984: p_measure_short_name => p_Measure_Rec.Measure_Short_Name
2985: ,p_nls_mode => null
2986: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)
2987: ,p_file_lud => p_Measure_Rec.Last_Update_Date
2988: ,p_custom_mode => p_custom_mode
2989: );
2990:

Line 3166: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

3162: END IF;
3163:
3164: EXCEPTION
3165: WHEN NO_DATA_FOUND THEN
3166: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3167: x_return_status := FND_API.G_RET_STS_ERROR ;
3168: IF(x_msg_data IS NULL) THEN
3169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3170: ,p_count => x_msg_count

Line 3175: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

3171: ,p_data => x_msg_data);
3172: END IF;
3173: RAISE;
3174: WHEN FND_API.G_EXC_ERROR THEN
3175: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3176: x_return_status := FND_API.G_RET_STS_ERROR ;
3177: IF(x_msg_data IS NULL) THEN
3178: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3179: ,p_count => x_msg_count

Line 3184: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

3180: ,p_data => x_msg_data);
3181: END IF;
3182: RAISE;
3183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3184: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3186: IF(x_msg_data IS NULL) THEN
3187: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3188: ,p_count => x_msg_count

Line 3193: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

3189: ,p_data => x_msg_data);
3190: END IF;
3191: RAISE;
3192: WHEN others THEN
3193: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3195: IF(x_msg_data IS NULL) THEN
3196: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3197: ,p_count => x_msg_count

Line 3205: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

3201: END Load_Measure;
3202: --=============================================================================
3203: PROCEDURE Translate_Measure
3204: (p_commit IN VARCHAR2 := FND_API.G_FALSE
3205: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3206: , p_custom_mode IN VARCHAR2 := NULL
3207: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3208: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
3209: , x_return_status OUT NOCOPY VARCHAR2

Line 3217: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3213: IS
3214:
3215: l_dataset_rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
3216: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3217: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3218: l_Dataset_Id NUMBER;
3219: l_upload_test BOOLEAN := FALSE;
3220: BEGIN
3221:

Line 3230: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)

3226: --bug#4045278: data versioning
3227: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(
3228: p_measure_short_name => p_Measure_Rec.Measure_Short_Name
3229: ,p_nls_mode => 'NLS'
3230: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)
3231: ,p_file_lud => p_Measure_Rec.Last_Update_Date
3232: ,p_custom_mode => p_custom_mode
3233: );
3234:

Line 3254: l_dataset_rec.Bsc_Dataset_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

3250:
3251: l_dataset_rec.Bsc_Dataset_Id := l_Dataset_Id;
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);

Line 3255: l_dataset_rec.Bsc_Dataset_Last_Update_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

3251: l_dataset_rec.Bsc_Dataset_Id := l_Dataset_Id;
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);

Line 3258: l_dataset_rec.Bsc_Measure_Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

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;
3261:
3262: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

Line 3259: l_dataset_rec.Bsc_Measure_Last_Update_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;
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);

Line 3262: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

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;
3265:
3266: BSC_DATASETS_PUB.Translate_Measure(

Line 3263: l_measure_rec.Last_Updated_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;
3265:
3266: BSC_DATASETS_PUB.Translate_Measure(
3267: p_commit => FND_API.G_FALSE

Line 3324: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3320: ,x_msg_data OUT NOCOPY VARCHAR2
3321: ) IS
3322: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3323: l_measure_rec_new BIS_MEASURE_PUB.Measure_Rec_Type;
3324: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3325: l_org_dimension_id NUMBER;
3326: l_time_dimension_id NUMBER;
3327: l_flag VARCHAR2(10);
3328: BEGIN

Line 3342: IF (BIS_UTILITIES_PUB.Value_Not_Missing

3338: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3339: RAISE FND_API.G_EXC_ERROR;
3340: END IF;
3341:
3342: IF (BIS_UTILITIES_PUB.Value_Not_Missing
3343: (p_Org_Dimension_Short_Name) = FND_API.G_TRUE
3344: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
3345: = FND_API.G_TRUE) THEN
3346: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 3344: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)

3340: END IF;
3341:
3342: IF (BIS_UTILITIES_PUB.Value_Not_Missing
3343: (p_Org_Dimension_Short_Name) = FND_API.G_TRUE
3344: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
3345: = FND_API.G_TRUE) THEN
3346: BIS_DIMENSION_PVT.Value_ID_Conversion
3347: ( p_api_version => 1.0
3348: , p_Dimension_Short_Name => p_Org_Dimension_Short_Name

Line 3361: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE

3357: END IF;
3358:
3359: END IF;
3360:
3361: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
3362: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
3363: = FND_API.G_TRUE) THEN
3364: BIS_DIMENSION_PVT.Value_ID_Conversion
3365: ( p_api_version => 1.0

Line 3362: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)

3358:
3359: END IF;
3360:
3361: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
3362: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
3363: = FND_API.G_TRUE) THEN
3364: BIS_DIMENSION_PVT.Value_ID_Conversion
3365: ( p_api_version => 1.0
3366: , p_Dimension_Short_Name => p_Time_Dimension_Short_Name