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_KPI_CRUD_PUB dependencies on FND_API

Line 257: p_commit IN VARCHAR2 := FND_API.G_FALSE

253:
254:
255:
256: PROCEDURE Create_Kpi_End_To_End(
257: p_commit IN VARCHAR2 := FND_API.G_FALSE
258: ,p_responsibility_id IN number
259: ,p_create_new_kpi IN VARCHAR2 := FND_API.G_FALSE
260: ,p_kpi_id_to_add_measure IN VARCHAR2 := NULL
261: ,p_param_portlet_region_code IN VARCHAR2

Line 259: ,p_create_new_kpi IN VARCHAR2 := FND_API.G_FALSE

255:
256: PROCEDURE Create_Kpi_End_To_End(
257: p_commit IN VARCHAR2 := FND_API.G_FALSE
258: ,p_responsibility_id IN number
259: ,p_create_new_kpi IN VARCHAR2 := FND_API.G_FALSE
260: ,p_kpi_id_to_add_measure IN VARCHAR2 := NULL
261: ,p_param_portlet_region_code IN VARCHAR2
262: ,p_kpi_name IN VARCHAR2 := NULL
263: ,p_kpi_description IN VARCHAR2 := NULL

Line 277: ,p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE -- Create a region per analysis option.

273: ,p_measure_min_act_value IN number := NULL --min value for actual
274: ,p_measure_max_act_value IN number := NULL --max value for actual
275: ,p_page_function_name IN VARCHAR2
276: ,p_kpi_portlet_function_name IN VARCHAR2
277: ,p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE -- Create a region per analysis option.
278: ,p_Measure_App_Id IN NUMBER := NULL
279: ,p_Func_Area_Short_Name IN VARCHAR2 := NULL
280: ,x_measure_short_name OUT NOCOPY VARCHAR2
281: ,x_kpi_id OUT NOCOPY number

Line 303: p_commit VARCHAR2 := FND_API.G_FALSE

299: ,x_msg_data OUT NOCOPY VARCHAR2);
300:
301:
302: PROCEDURE Create_Dim_Level_Region_Item(
303: p_commit VARCHAR2 := FND_API.G_FALSE
304: ,p_non_time_counter NUMBER
305: ,p_non_time_dimension_objects bsc_varchar2_tbl_type
306: ,p_non_time_dimension_groups bsc_varchar2_tbl_type
307: ,p_time_counter NUMBER

Line 321: p_commit VARCHAR2 := FND_API.G_FALSE

317:
318:
319:
320: PROCEDURE Create_Measure(
321: p_commit VARCHAR2 := FND_API.G_FALSE
322: ,x_dataset_id OUT NOCOPY NUMBER
323: ,p_kpi_id NUMBER
324: ,p_dataset_source VARCHAR2
325: ,p_measure_name VARCHAR2

Line 332: ,p_measure_obsolete VARCHAR2 := FND_API.G_FALSE

328: ,p_dataset_format_id NUMBER
329: ,p_dataset_autoscale_flag NUMBER
330: ,p_measure_operation VARCHAR2
331: ,p_measure_increase_in_measure VARCHAR2
332: ,p_measure_obsolete VARCHAR2 := FND_API.G_FALSE
333: ,p_type VARCHAR2
334: ,p_measure_random_style NUMBER
335: ,p_measure_min_act_value NUMBER
336: ,p_measure_max_act_value NUMBER

Line 356: p_commit VARCHAR2 := FND_API.G_FALSE

352: );
353:
354:
355: PROCEDURE Associate_KPI_To_AO(
356: p_commit VARCHAR2 := FND_API.G_FALSE
357: ,p_indicator NUMBER
358: ,p_dataset_id NUMBER
359: ,p_measure_name VARCHAR2
360: ,p_measure_description VARCHAR2

Line 368: p_commit VARCHAR2 := FND_API.G_FALSE

364: ,x_msg_data OUT NOCOPY VARCHAR2);
365:
366:
367: PROCEDURE Create_Measure_Region_Item(
368: p_commit VARCHAR2 := FND_API.G_FALSE
369: ,p_measure_short_name VARCHAR2
370: ,p_sequence_number NUMBER
371: ,p_kpi_id NUMBER
372: ,p_Analysis_Option NUMBER := NULL

Line 401: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

397:
398: FUNCTION GET_GROUP_ID(p_kpi_portlet_function_name VARCHAR2) RETURN NUMBER;
399:
400: procedure Assign_Kpi_Periodicities(
401: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
402: ,p_kpi_id IN NUMBER
403: ,p_Time_Dim_obj_sns IN VARCHAR2 -- 'MONTH,QUATERLY'
404: ,p_Dft_Dim_obj_sn IN VARCHAR2 --:= NULL
405: ,p_Daily_Flag IN VARCHAR2 --:= FND_API.G_FALSE

Line 405: ,p_Daily_Flag IN VARCHAR2 --:= FND_API.G_FALSE

401: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
402: ,p_kpi_id IN NUMBER
403: ,p_Time_Dim_obj_sns IN VARCHAR2 -- 'MONTH,QUATERLY'
404: ,p_Dft_Dim_obj_sn IN VARCHAR2 --:= NULL
405: ,p_Daily_Flag IN VARCHAR2 --:= FND_API.G_FALSE
406: ,p_Is_XTD_Enabled IN VARCHAR2 -- := 'F' or 'T'
407: ,x_return_status OUT NOCOPY VARCHAR2
408: ,x_msg_count OUT NOCOPY NUMBER
409: ,x_msg_data OUT NOCOPY VARCHAR2

Line 424: , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_FALSE

420: PROCEDURE Update_Actual_Data_Source(
421: p_kpi_id IN NUMBER
422: , p_dataset_id IN NUMBER
423: , p_measure_short_name IN VARCHAR2
424: , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_FALSE
425:
426: );
427:
428:

Line 438: p_commit IN VARCHAR2 := FND_API.G_FALSE

434: x_msg_data OUT NOCOPY VARCHAR2);
435:
436:
437: PROCEDURE Update_Kpi_End_To_End(
438: p_commit IN VARCHAR2 := FND_API.G_FALSE
439: ,p_param_portlet_region_code IN VARCHAR2
440: ,p_page_function_name IN VARCHAR2
441: ,p_kpi_portlet_function_name IN VARCHAR2
442: ,p_measure_name IN VARCHAR2

Line 477: p_commit IN VARCHAR2 := FND_API.G_FALSE

473: );
474:
475:
476: PROCEDURE Delete_Kpi_End_To_End(
477: p_commit IN VARCHAR2 := FND_API.G_FALSE
478: ,p_param_portlet_region_code IN VARCHAR2
479: ,p_measure_short_name IN VARCHAR2 := NULL
480: ,p_page_function_name IN VARCHAR2
481: ,p_kpi_portlet_function_name IN VARCHAR2

Line 489: p_commit VARCHAR2 := FND_API.G_FALSE

485: ) ;
486:
487:
488: PROCEDURE Delete_Measure_Region_Item(
489: p_commit VARCHAR2 := FND_API.G_FALSE
490: ,p_Param_Portlet_Region_Code VARCHAR2
491: ,p_Measure_Short_Name VARCHAR2
492: ,p_Application_Id NUMBER
493: ,x_return_status OUT NOCOPY VARCHAR2

Line 499: p_Commit VARCHAR2 := FND_API.G_FALSE

495: ,x_msg_data OUT NOCOPY VARCHAR2
496: );
497:
498: PROCEDURE Unassign_Kpi_Analysis_Option (
499: p_Commit VARCHAR2 := FND_API.G_FALSE
500: ,p_Kpi_Id NUMBER
501: ,p_Dataset_Id NUMBER
502: ,x_return_status OUT NOCOPY VARCHAR2
503: ,x_msg_count OUT NOCOPY NUMBER

Line 513: p_commit VARCHAR2 := FND_API.G_FALSE

509:
510: FUNCTION Get_Kpi_Id(p_Page_Function_Name VARCHAR2) RETURN NUMBER;
511:
512: PROCEDURE Delete_Dim_Level_Region_Item(
513: p_commit VARCHAR2 := FND_API.G_FALSE
514: ,p_Application_Id NUMBER
515: ,p_Non_Time_Counter NUMBER
516: ,p_Non_Time_Dimension_Objects bsc_varchar2_tbl_type
517: ,p_Non_Time_Dimension_Groups bsc_varchar2_tbl_type

Line 531: p_Commit VARCHAR2 := FND_API.G_FALSE

527:
528: FUNCTION Get_Function_Id_By_Name(p_kpi_portlet_function_name VARCHAR2) RETURN NUMBER;
529:
530: PROCEDURE Update_Kpi_Analysis_Option (
531: p_Commit VARCHAR2 := FND_API.G_FALSE
532: ,p_Kpi_Id NUMBER
533: ,p_Dataset_Id NUMBER
534: ,p_Measure_Name VARCHAR2
535: ,p_Measure_Description VARCHAR2

Line 566: p_Commit VARCHAR2 := FND_API.G_FALSE

562: ) RETURN NUMBER ;
563:
564:
565: PROCEDURE Create_Region_By_AO (
566: p_Commit VARCHAR2 := FND_API.G_FALSE
567: , p_Kpi_Id IN NUMBER
568: , p_Analysis_Option_Id IN NUMBER := NULL
569: , p_Dim_Set_Id IN NUMBER
570: , p_Region_Name IN VARCHAR2

Line 580: p_Commit VARCHAR2 := FND_API.G_FALSE

576: , x_msg_data OUT NOCOPY VARCHAR2
577: );
578:
579: PROCEDURE Update_Region_By_AO (
580: p_Commit VARCHAR2 := FND_API.G_FALSE
581: , p_Kpi_Id IN NUMBER
582: , p_Analysis_Option_Id IN NUMBER
583: , p_Dim_Set_Id IN NUMBER
584: , p_Region_Name IN VARCHAR2

Line 638: p_commit VARCHAR2 := FND_API.G_FALSE,

634: , x_msg_data OUT NOCOPY VARCHAR2
635: );
636:
637: PROCEDURE Delete_Nested_Region_Item(
638: p_commit VARCHAR2 := FND_API.G_FALSE,
639: p_Root_AK_Region VARCHAR2,
640: p_Application_Id NUMBER,
641: p_Nested_Region_Code VARCHAR2,
642: x_return_status OUT NOCOPY VARCHAR2,

Line 687: p_commit IN VARCHAR2 := FND_API.G_FALSE

683: ) RETURN NUMBER;
684:
685:
686: PROCEDURE Create_Sim_Generic_Region_Item(
687: p_commit IN VARCHAR2 := FND_API.G_FALSE
688: , p_Region_Code IN VARCHAR2
689: , p_Region_Application_Id IN NUMBER
690: , p_Attribute_Code IN VARCHAR2
691: , p_Attribute_Application_Id IN NUMBER

Line 719: p_commit IN VARCHAR2 := FND_API.G_FALSE

715: , x_msg_data OUT NOCOPY VARCHAR2
716: );
717:
718: PROCEDURE Create_Addl_Ak_Region_Items(
719: p_commit IN VARCHAR2 := FND_API.G_FALSE
720: , p_Region_Code IN VARCHAR2
721: , p_Region_Application_Id IN NUMBER
722: , p_Display_Sequence IN NUMBER
723: , p_Display_Format IN VARCHAR2

Line 736: p_commit VARCHAR2 := FND_API.G_FALSE,

732: );
733:
734:
735: PROCEDURE Delete_Misc_Region_Items(
736: p_commit VARCHAR2 := FND_API.G_FALSE,
737: p_Region_Code VARCHAR2,
738: p_Application_Id NUMBER,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,

Line 745: p_commit IN VARCHAR2 := FND_API.G_FALSE

741: x_msg_data OUT NOCOPY VARCHAR2
742: );
743:
744: PROCEDURE Update_Sim_Generic_Region_Item(
745: p_commit IN VARCHAR2 := FND_API.G_FALSE
746: , p_Region_Code IN VARCHAR2
747: , p_Region_Application_Id IN NUMBER
748: , p_Attribute_Code IN VARCHAR2
749: , p_Attribute_Application_Id IN NUMBER

Line 777: p_commit IN VARCHAR2 := FND_API.G_FALSE

773: , x_msg_data OUT NOCOPY VARCHAR2
774: );
775:
776: PROCEDURE Update_Addl_Ak_Region_Items(
777: p_commit IN VARCHAR2 := FND_API.G_FALSE
778: , p_Region_Code IN VARCHAR2
779: , p_Region_Application_Id IN NUMBER
780: , p_Display_Format IN VARCHAR2
781: , p_Format_id IN NUMBER

Line 796: p_Commit IN VARCHAR2 := FND_API.G_FALSE

792: );
793:
794:
795: PROCEDURE Create_Dimension(
796: p_Commit IN VARCHAR2 := FND_API.G_FALSE
797: ,p_Dim_Short_Name IN VARCHAR2
798: ,p_Display_Name IN VARCHAR2
799: ,p_Description IN VARCHAR2
800: ,p_Dim_Objs_Record IN BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE

Line 804: ,p_hide IN VARCHAR2 := FND_API.G_FALSE

800: ,p_Dim_Objs_Record IN BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE
801: ,p_Dim_Obj_Short_Names IN VARCHAR2
802: ,p_Dim_Objects_Counter IN NUMBER
803: ,p_Application_Id IN NUMBER
804: ,p_hide IN VARCHAR2 := FND_API.G_FALSE
805: ,x_Return_Status OUT NOCOPY VARCHAR2
806: ,x_Msg_Count OUT NOCOPY NUMBER
807: ,x_Msg_Data OUT NOCOPY VARCHAR2
808: );

Line 811: p_Commit IN VARCHAR2 := FND_API.G_FALSE

807: ,x_Msg_Data OUT NOCOPY VARCHAR2
808: );
809:
810: PROCEDURE Create_Ak_Metadata(
811: p_Commit IN VARCHAR2 := FND_API.G_FALSE
812: , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE
813: , p_Kpi_Id IN NUMBER
814: , p_Analysis_Option_Id IN NUMBER
815: , p_Dim_Set_Id IN NUMBER

Line 812: , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE

808: );
809:
810: PROCEDURE Create_Ak_Metadata(
811: p_Commit IN VARCHAR2 := FND_API.G_FALSE
812: , p_Create_Region_Per_AO IN VARCHAR2 := FND_API.G_TRUE
813: , p_Kpi_Id IN NUMBER
814: , p_Analysis_Option_Id IN NUMBER
815: , p_Dim_Set_Id IN NUMBER
816: , p_Measure_Short_Name IN VARCHAR2

Line 857: ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE

853: , p_Dataset_Format_Id IN NUMBER
854: , p_Dataset_Autoscale_Flag IN NUMBER
855: , p_Measure_Operation IN VARCHAR2
856: , p_Measure_Increase_In_Measure IN VARCHAR2
857: ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE
858: ,p_Type IN VARCHAR2
859: , p_Measure_Random_Style IN NUMBER
860: , p_Measure_Min_Act_Value IN NUMBER
861: , p_Measure_Max_Act_Value IN NUMBER

Line 1048: p_commit IN VARCHAR2 := FND_API.G_FALSE

1044: ,x_msg_data OUT NOCOPY varchar2
1045: );
1046:
1047: procedure Delete_S2E_Metadata(
1048: p_commit IN VARCHAR2 := FND_API.G_FALSE
1049: ,p_tab_id IN number
1050: ,x_return_status OUT NOCOPY varchar2
1051: ,x_msg_count OUT NOCOPY number
1052: ,x_msg_data OUT NOCOPY varchar2

Line 1138: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1134: FUNCTION Get_Objective_By_AGKpi( p_Short_Name IN VARCHAR2) RETURN VARCHAR2;
1135:
1136: --IF AG Report is NOT in Production Mode
1137: PROCEDURE Convert_AutoGen_To_ViewBased (
1138: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1139: , p_Region_Code IN VARCHAR2
1140: , p_Region_Application_Id IN NUMBER
1141: , x_Return_Status OUT NOCOPY VARCHAR
1142: , x_Msg_Count OUT NOCOPY NUMBER

Line 1148: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1144: );
1145:
1146:
1147: PROCEDURE Delete_AG_Bsc_Metadata (
1148: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1149: , p_Region_Code IN VARCHAR2
1150: , p_Delete_Measures IN VARCHAR2
1151: , p_Delete_Dimensions IN VARCHAR2
1152: , x_Return_Status OUT NOCOPY VARCHAR

Line 1159: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1155: );
1156:
1157: -- added for Bug#4932280
1158: PROCEDURE Delete_AG_Bsc_Metadata (
1159: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1160: , p_Region_Code IN VARCHAR2
1161: , p_Delete_Measures IN VARCHAR2
1162: , x_Return_Status OUT NOCOPY VARCHAR
1163: , x_Msg_Count OUT NOCOPY NUMBER

Line 1169: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1165: );
1166:
1167:
1168: PROCEDURE Switch_Measure_Type (
1169: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1170: , p_Measure_Short_Name IN VARCHAR2
1171: , p_Target_Source IN VARCHAR2
1172: , p_Delete_Columns IN VARCHAR2
1173: , p_Clean_Measure_Date_Source IN VARCHAR2

Line 1220: p_commit IN VARCHAR2 := FND_API.G_FALSE

1216:
1217:
1218: PROCEDURE Delete_Tab_And_TabViews
1219: (
1220: p_commit IN VARCHAR2 := FND_API.G_FALSE
1221: , p_region_code IN AK_REGION_ITEMS.region_code%TYPE
1222: , x_Return_Status OUT NOCOPY VARCHAR2
1223: , x_Msg_Count OUT NOCOPY NUMBER
1224: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 1367: p_Commit IN VARCHAR := FND_API.G_FALSE

1363: ) RETURN VARCHAR2;
1364:
1365: -- Added the API Migrate_AGR_To_PLSQL() for Enhancement#4878676
1366: PROCEDURE Migrate_AGR_To_PLSQL (
1367: p_Commit IN VARCHAR := FND_API.G_FALSE
1368: , p_Region_Application_Id IN VARCHAR2
1369: , p_Region_Code IN VARCHAR2
1370: , p_Update_AK_Metadata IN VARCHAR2
1371: , p_Plsql_For_Report_Query IN VARCHAR2

Line 1383: p_Commit IN VARCHAR := FND_API.G_FALSE

1379: );
1380:
1381:
1382: PROCEDURE Migrate_AGR_To_PLSQL (
1383: p_Commit IN VARCHAR := FND_API.G_FALSE
1384: , p_Region_Application_Id IN VARCHAR2
1385: , p_Region_Code IN VARCHAR2
1386: , x_Return_Status OUT NOCOPY VARCHAR
1387: , x_Msg_Count OUT NOCOPY NUMBER

Line 1400: p_Commit IN VARCHAR := FND_API.G_FALSE

1396:
1397:
1398: -- needs to be moved into an utility file.
1399: PROCEDURE Cascade_Attr_Code_Into_Measure (
1400: p_Commit IN VARCHAR := FND_API.G_FALSE
1401: , p_Region_Code IN VARCHAR2
1402: , p_Region_Application_Id IN VARCHAR2
1403: , p_Old_Attribute_Codes IN VARCHAR2
1404: , p_Old_Attribute_Code_App_Ids IN VARCHAR2

Line 1413: p_Commit IN VARCHAR := FND_API.G_FALSE

1409: , x_Msg_Data OUT NOCOPY VARCHAR
1410: );
1411:
1412: PROCEDURE Cascade_Changes_Into_Forumla (
1413: p_Commit IN VARCHAR := FND_API.G_FALSE
1414: , p_Measure_Short_Name IN VARCHAR2
1415: , p_Old_Attribute_Codes IN VARCHAR2
1416: , p_Old_Attribute_Code_App_Ids IN VARCHAR2
1417: , p_New_Attribute_Codes IN VARCHAR2

Line 1433: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1429: ) RETURN VARCHAR2;
1430:
1431: -- added for bug#4741919
1432: PROCEDURE Delete_AG_Report (
1433: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1434: , p_Region_Code IN VARCHAR2
1435: , p_Delete_Measures IN VARCHAR2
1436: , x_Return_Status OUT NOCOPY VARCHAR
1437: , x_Msg_Count OUT NOCOPY NUMBER

Line 1443: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1439: );
1440:
1441: -- Added from Enhancement Number#4952167
1442: PROCEDURE Migrate_AGR_To_VBR (
1443: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1444: , p_Region_Application_Id IN VARCHAR2
1445: , p_Region_Code IN VARCHAR2
1446: , x_Return_Status OUT NOCOPY VARCHAR
1447: , x_Msg_Count OUT NOCOPY NUMBER

Line 1454: p_Commit IN VARCHAR2 := FND_API.G_FALSE

1450:
1451:
1452: -- Added from Enhancement Number#4952167
1453: PROCEDURE Migrate_To_Existing_Source (
1454: p_Commit IN VARCHAR2 := FND_API.G_FALSE
1455: , p_Existing_Report_Type IN VARCHAR2
1456: , p_Region_Application_Id IN VARCHAR2
1457: , p_Region_Code IN VARCHAR2
1458: , x_Return_Status OUT NOCOPY VARCHAR

Line 1523: ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE

1519: , p_Dataset_Format_Id IN NUMBER
1520: , p_Dataset_Autoscale_Flag IN NUMBER
1521: , p_Measure_Operation IN VARCHAR2
1522: , p_Measure_Increase_In_Measure IN VARCHAR2
1523: ,p_Measure_Obsolete IN VARCHAR2 := FND_API.G_FALSE
1524: ,p_Type IN VARCHAR2
1525: , p_Measure_Random_Style IN NUMBER
1526: , p_Measure_Min_Act_Value IN NUMBER
1527: , p_Measure_Max_Act_Value IN NUMBER