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 AK_REGIONS

Line 1291: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1287: by Bug#4558279
1288: ********************************************/
1289:
1290: FUNCTION Is_Dim_Exist_In_Current_Region (
1291: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1292: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1293: ) RETURN VARCHAR2;
1294:
1295: FUNCTION Is_Dim_Exist_In_Nested_Region (

Line 1292: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1288: ********************************************/
1289:
1290: FUNCTION Is_Dim_Exist_In_Current_Region (
1291: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1292: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1293: ) RETURN VARCHAR2;
1294:
1295: FUNCTION Is_Dim_Exist_In_Nested_Region (
1296: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

Line 1296: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1292: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1293: ) RETURN VARCHAR2;
1294:
1295: FUNCTION Is_Dim_Exist_In_Nested_Region (
1296: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1297: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1298: ) RETURN VARCHAR2;
1299:
1300: FUNCTION Is_New_Param_Portlet_Required (

Line 1297: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1293: ) RETURN VARCHAR2;
1294:
1295: FUNCTION Is_Dim_Exist_In_Nested_Region (
1296: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1297: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1298: ) RETURN VARCHAR2;
1299:
1300: FUNCTION Is_New_Param_Portlet_Required (
1301: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

Line 1301: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1297: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1298: ) RETURN VARCHAR2;
1299:
1300: FUNCTION Is_New_Param_Portlet_Required (
1301: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1302: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1303: ) RETURN VARCHAR2;
1304:
1305: PROCEDURE Cascade_Parameter_Portlet (

Line 1302: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1298: ) RETURN VARCHAR2;
1299:
1300: FUNCTION Is_New_Param_Portlet_Required (
1301: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1302: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1303: ) RETURN VARCHAR2;
1304:
1305: PROCEDURE Cascade_Parameter_Portlet (
1306: p_Commit IN VARCHAR2

Line 1308: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1304:
1305: PROCEDURE Cascade_Parameter_Portlet (
1306: p_Commit IN VARCHAR2
1307: , p_Page_Function_Name IN VARCHAR2
1308: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1309: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1310: , p_Action_Type IN VARCHAR2
1311: , x_Region_Code OUT NOCOPY VARCHAR2
1312: , x_Region_Application_Id OUT NOCOPY NUMBER

Line 1309: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1305: PROCEDURE Cascade_Parameter_Portlet (
1306: p_Commit IN VARCHAR2
1307: , p_Page_Function_Name IN VARCHAR2
1308: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1309: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1310: , p_Action_Type IN VARCHAR2
1311: , x_Region_Code OUT NOCOPY VARCHAR2
1312: , x_Region_Application_Id OUT NOCOPY NUMBER
1313: , x_Return_Status OUT NOCOPY VARCHAR2

Line 1320: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1316: );
1317:
1318: PROCEDURE Create_Parameter_Portlet (
1319: p_Commit IN VARCHAR2
1320: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1321: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1322: , x_Region_Code OUT NOCOPY VARCHAR2
1323: , x_Region_Application_Id OUT NOCOPY NUMBER
1324: , x_Return_Status OUT NOCOPY VARCHAR2

Line 1321: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1317:
1318: PROCEDURE Create_Parameter_Portlet (
1319: p_Commit IN VARCHAR2
1320: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1321: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1322: , x_Region_Code OUT NOCOPY VARCHAR2
1323: , x_Region_Application_Id OUT NOCOPY NUMBER
1324: , x_Return_Status OUT NOCOPY VARCHAR2
1325: , x_Msg_Count OUT NOCOPY NUMBER

Line 1333: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1329:
1330: FUNCTION Get_New_Region_Code RETURN VARCHAR2;
1331:
1332: PROCEDURE Unroll_RegionItems_Into_Record (
1333: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1334: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1335: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1336: );
1337:

Line 1334: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1330: FUNCTION Get_New_Region_Code RETURN VARCHAR2;
1331:
1332: PROCEDURE Unroll_RegionItems_Into_Record (
1333: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1334: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1335: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1336: );
1337:
1338: PROCEDURE Get_Non_Nested_Into_Rec (

Line 1339: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

1335: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1336: );
1337:
1338: PROCEDURE Get_Non_Nested_Into_Rec (
1339: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1340: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1341: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1342: );
1343:

Line 1340: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

1336: );
1337:
1338: PROCEDURE Get_Non_Nested_Into_Rec (
1339: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
1340: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
1341: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
1342: );
1343:
1344: FUNCTION Get_Param_Portlet_By_Dashboard (

Line 1558: p_region_code IN AK_REGIONS.region_code%TYPE

1554: RETURN VARCHAR2;
1555:
1556: PROCEDURE Get_Non_Time_Dim_And_DimObjs
1557: (
1558: p_region_code IN AK_REGIONS.region_code%TYPE
1559: ,x_non_time_dim_dimObjs OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
1560: ,x_non_time_counter OUT NOCOPY NUMBER
1561: );
1562: