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_UPGRADES dependencies on BIS_MEASURE_PUB

Line 108: -- through UI/ldt. For this, BSC_BIS_MEASURE_PUB.get_Measure_Name is re-used.

104:
105: -- ankgoel: bug#3874911
106: -- Validate and re-generate dataset names untill unique
107: -- This validation is uses the same logic while creating/updating measures
108: -- through UI/ldt. For this, BSC_BIS_MEASURE_PUB.get_Measure_Name is re-used.
109: FUNCTION get_dataset_name(
110: p_dataset_name IN VARCHAR2
111: )
112: RETURN VARCHAR2

Line 125: BSC_BIS_MEASURE_PUB.get_Measure_Name( p_dataset_id => NULL

121:
122: WHILE (l_flag = 'F') LOOP
123: BEGIN
124: -- Validate Measure Name
125: BSC_BIS_MEASURE_PUB.get_Measure_Name( p_dataset_id => NULL
126: , p_ui_flag => 'N'
127: , p_dataset_source => 'PMF'
128: , p_dataset_name => l_dataset_name
129: , x_measure_name => l_return_name);

Line 180: l_bis_measure_rec bis_measure_pub.measure_rec_type;

176: l_max_ds_id_bis NUMBER;
177: l_max_ds_id_bsc NUMBER;
178: l_indicator_id NUMBER;
179: l_count NUMBER;
180: l_bis_measure_rec bis_measure_pub.measure_rec_type;
181: l_return_status VARCHAR2(1);
182: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
183: l_err VARCHAR2(2000);
184: BEGIN

Line 217: BIS_MEASURE_PUB.Delete_Measure(

213: FOR i IN 1..l_num_ids LOOP
214: BEGIN
215: l_bis_measure_rec.measure_id := l_arr_ids(i);
216:
217: BIS_MEASURE_PUB.Delete_Measure(
218: p_api_version => 1.0
219: ,p_commit => FND_API.G_FALSE
220: ,p_Measure_Rec => l_bis_measure_rec
221: ,x_return_status => l_return_status

Line 301: l_Dataset_Rec.Bsc_Source := BSC_BIS_MEASURE_PUB.c_PMF;

297: FOR icr IN bsc_indicators_cursor LOOP
298: BEGIN
299: SAVEPOINT SP_SYNC_MEASURE;
300: IF (icr.dataset_id is null) then
301: l_Dataset_Rec.Bsc_Source := BSC_BIS_MEASURE_PUB.c_PMF;
302: --l_Dataset_Rec.Bsc_Dataset_Name := icr.measure_name;
303: l_Dataset_Rec.Bsc_Dataset_Name := get_dataset_name(icr.measure_name);
304: l_Dataset_Rec.Bsc_Dataset_Help := icr.description;
305: l_Dataset_Rec.Bsc_Measure_Short_Name := icr.measure_short_name;

Line 307: l_Dataset_Rec.Bsc_Measure_Operation := BSC_BIS_MEASURE_PUB.c_SUM;

303: l_Dataset_Rec.Bsc_Dataset_Name := get_dataset_name(icr.measure_name);
304: l_Dataset_Rec.Bsc_Dataset_Help := icr.description;
305: l_Dataset_Rec.Bsc_Measure_Short_Name := icr.measure_short_name;
306: l_Dataset_Rec.Bsc_Measure_Long_Name := icr.measure_name;
307: l_Dataset_Rec.Bsc_Measure_Operation := BSC_BIS_MEASURE_PUB.c_SUM;
308: -- ankgoel: bug#3891748 - Creation_Date and Last_Update_Date will not be synced-up
309: -- They might be useful in debugging
310: l_Dataset_Rec.Bsc_Measure_Created_By := icr.created_by;
311: l_Dataset_Rec.Bsc_Measure_Last_Update_By := icr.last_updated_by;

Line 318: l_Measure_Col := BSC_BIS_MEASURE_PUB.Get_Measure_Col(

314: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := icr.last_updated_by;
315: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := icr.last_update_login;
316:
317: -- added for Enhancement#4239216
318: l_Measure_Col := BSC_BIS_MEASURE_PUB.Get_Measure_Col(
319: l_Dataset_Rec.Bsc_Dataset_Name,
320: l_Dataset_Rec.Bsc_Source,
321: NULL,
322: l_Dataset_Rec.Bsc_Measure_Short_Name

Line 431: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;

427: PROCEDURE sync_measures_bsc_to_pmf_51
428: IS
429: l_return_status varchar2(1);
430: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
431: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
432:
433: TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(2000)
434: INDEX BY BINARY_INTEGER;
435:

Line 456: l_measure_rec.Measure_Short_Name := BSC_BIS_MEASURE_PUB.c_PMD||cr.dataset_id;

452: l_num := 0;
453: FOR cr IN bsc_datasets_cursor_1 LOOP
454: BEGIN
455: SAVEPOINT SP_SYNC_MEASURE;
456: l_measure_rec.Measure_Short_Name := BSC_BIS_MEASURE_PUB.c_PMD||cr.dataset_id;
457:
458: /**************************************************************************
459: We need to validate that the Short Name we are going to create already exists
460: in PMF data model.If yes then we have to suffix the short_name with A or B

Line 482: BIS_MEASURE_PUB.Create_Measure(

478: l_measure_rec.Created_By := cr.created_by;
479: l_measure_rec.Last_Updated_By := cr.last_updated_by;
480: l_measure_rec.Last_Update_Login := cr.last_update_login;
481:
482: BIS_MEASURE_PUB.Create_Measure(
483: p_api_version => 1.0
484: ,p_commit => FND_API.G_FALSE
485: ,p_Measure_Rec => l_measure_rec
486: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)

Line 545: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;

541: PROCEDURE synch_measures_cds_to_pmf
542: IS
543: l_return_status varchar2(1);
544: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
545: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
546: l_count NUMBER;
547: l_Kpi_Id NUMBER;
548:
549: TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 622: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;

618: PROCEDURE sync_measures_bsc_to_pmf
619: IS
620: l_return_status varchar2(1);
621: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
622: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
623: l_count NUMBER;
624: l_Kpi_Id NUMBER;
625:
626: TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(2000)

Line 665: l_measure_rec.Measure_Short_Name := BSC_BIS_MEASURE_PUB.c_PMD||cr.dataset_id;

661: SET dataset_id = cr.dataset_id
662: WHERE short_name = cr.measure_short_name;
663: END IF;
664: ELSE
665: l_measure_rec.Measure_Short_Name := BSC_BIS_MEASURE_PUB.c_PMD||cr.dataset_id;
666: /****************************************************************************
667: One more thing we have to notive here is that short_names for BSC measures
668: will not be same in both the data models.
669: Its possible that the same measure can be attached to many datasets.

Line 710: BIS_MEASURE_PUB.Create_Measure(

706: x_mode => 'I');
707: END;
708: END IF;
709:
710: BIS_MEASURE_PUB.Create_Measure(
711: p_api_version => 1.0
712: ,p_commit => FND_API.G_FALSE
713: ,p_Measure_Rec => l_measure_rec
714: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)

Line 923: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

919: -- mdamle 09/25/2003 - Sync up measures for all installed languages
920: -- ashankar: bug#390429 - Used by bscup.sql in create_template process
921: Procedure lang_synch_BSC_To_PMF_measure(
922: p_dataset_id IN NUMBER := NULL
923: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
924: , x_return_status OUT NOCOPY VARCHAR2
925: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type)
926: is
927:

Line 938: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

934:
935: l_name bsc_sys_datasets_tl.name%type;
936: l_help bsc_sys_datasets_tl.help%type;
937: l_source_lang bsc_sys_datasets_tl.source_lang%type;
938: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
939: l_count number;
940:
941: BEGIN
942:

Line 956: BIS_MEASURE_PUB.Translate_Measure_By_lang

952:
953: -- mdamle 10/07/2003 - Bug#3170184 - For BSC type measure, always use short name in PMF display name
954: l_measure_rec.Measure_name := l_measure_rec.Measure_short_name;
955:
956: BIS_MEASURE_PUB.Translate_Measure_By_lang
957: ( p_api_version => 1.0
958: , p_commit => FND_API.G_FALSE
959: , p_Measure_Rec => l_Measure_Rec
960: , p_lang => cr.language_code

Line 1116: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

1112: and itl.language = dtl.language
1113: and itl.name <> dtl.name;
1114:
1115: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1116: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1117: l_measure_name BIS_INDICATORS_TL.Name%TYPE;
1118: l_count number;
1119: BEGIN
1120:

Line 1122: if scr.source = BSC_BIS_MEASURE_PUB.c_BSC then

1118: l_count number;
1119: BEGIN
1120:
1121: for scr in synch_lang_cursor loop
1122: if scr.source = BSC_BIS_MEASURE_PUB.c_BSC then
1123: -- ankgoel: Since name is same as short name and will not get
1124: -- re-generated unlike PMF to BSC sync-up, no conditions reqd. here
1125: l_measure_rec.measure_id := scr.indicator_id;
1126: l_measure_rec.description := scr.help;

Line 1131: BIS_MEASURE_PUB.Translate_Measure_By_lang

1127:
1128: -- mdamle 10/07/2003 - Bug#3170184 - For BSC type measure, always use short name in PMF display name
1129: l_measure_rec.Measure_name := scr.short_name;
1130:
1131: BIS_MEASURE_PUB.Translate_Measure_By_lang
1132: ( p_api_version => 1.0
1133: , p_commit => FND_API.G_FALSE
1134: , p_Measure_Rec => l_Measure_Rec
1135: , p_lang => scr.language

Line 2594: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND

2590: BIS_INDICATORS_VL I
2591: WHERE
2592: M.MEASURE_ID = D.MEASURE_ID1 AND
2593: D.DATASET_ID=I.DATASET_ID AND
2594: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2595: M.MEASURE_COL = I.SHORT_NAME ORDER BY I.DATASET_ID;
2596: /*SELECT
2597: M.MEASURE_ID,
2598: M.MEASURE_COL,

Line 2608: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND

2604: BSC_SYS_MEASURES M,
2605: BIS_INDICATORS_VL I
2606: WHERE
2607: M.SHORT_NAME = I.SHORT_NAME AND
2608: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2609: M.MEASURE_COL = I.SHORT_NAME ORDER BY I.DATASET_ID;*/
2610: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
2611: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2612: l_Return_Status VARCHAR2(1);

Line 2618: l_Measure_Col := BSC_BIS_MEASURE_PUB.Get_Measure_Col(

2614: l_Msg_Data VARCHAR2(2000);
2615: BEGIN
2616: SAVEPOINT SP_REFRESH_MEAS;
2617: FOR cPMFM IN cPMFMeasures LOOP
2618: l_Measure_Col := BSC_BIS_MEASURE_PUB.Get_Measure_Col(
2619: cPMFM.NAME,
2620: cPMFM.SOURCE,
2621: cPMFM.MEASURE_ID,
2622: cPMFM.SHORT_NAME

Line 2675: D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND

2671: FROM
2672: BSC_SYS_DATASETS_B D,
2673: BSC_SYS_MEASURES M
2674: WHERE
2675: D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2676: M.MEASURE_ID = D.MEASURE_ID1;
2677: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
2678: l_Return_Status VARCHAR2(1);
2679: l_Msg_Count NUMBER;