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 BSC_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 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 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 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 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 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;