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_FORM_FUNCTIONS

Line 748: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW

744: l_Form_Parameters := 'pForceRun=Y' || '&' || 'pRegionCode=' || l_Region_Code
745: || '&' || 'pFunctionName=' || l_Region_Code
746: || '&' || 'pParameters=pParamIds@Y';
747:
748: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW
749: (
750: X_FUNCTION_ID => BSC_BIS_KPI_CRUD_PUB.Get_Function_Id_By_Name(l_Region_Code)
751: ,X_WEB_HOST_NAME => ''
752: ,X_WEB_AGENT_NAME => ''

Line 1023: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );

1019: /*
1020: At this point, Delete ALL the KPI Metadata and info related to the KPI.
1021: */
1022: --DBMS_OUTPUT.PUT_LINE('Outside BSC_PMF_UI_WRAPPER.Delete_Kpi' );
1023: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1024: BSC_PMF_UI_WRAPPER.Delete_Kpi(
1025: p_commit => p_commit
1026: ,p_Kpi_Id => l_Kpi_Id
1027: ,x_Return_Status => x_Return_Status

Line 1034: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );

1030: );
1031: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1035:
1036: -- Delete the Actual Measure from BSC and BIS Datamodel.
1037: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Delete_Measure ' );
1038: BSC_BIS_MEASURE_PUB.Delete_Measure(

Line 2741: FROM FND_FORM_FUNCTIONS F

2737: BEGIN
2738: -- when there is no matching, return -1000 to inform the caller
2739: SELECT F.Function_Id
2740: INTO l_Fun_Id
2741: FROM FND_FORM_FUNCTIONS F
2742: WHERE F.Function_Name = p_Kpi_Portlet_Function_Name;
2743:
2744: RETURN l_Fun_Id;
2745: EXCEPTION

Line 4761: SELECT FND_FORM_FUNCTIONS_S.nextval

4757: -- Create a new Form Function
4758: -- Need to modularize.
4759:
4760:
4761: SELECT FND_FORM_FUNCTIONS_S.nextval
4762: INTO l_fid
4763: FROM SYS.DUAL;
4764:
4765: l_Form_Parameters := 'pForceRun=Y' || '&' || 'pRegionCode=' || l_Region_Code

Line 4771: FND_FORM_FUNCTIONS_PKG.INSERT_ROW

4767: || '&' || 'pParameters=pParamIds@Y';
4768:
4769: --DBMS_OUTPUT.PUT_LINE('Creating Form Function ' );
4770:
4771: FND_FORM_FUNCTIONS_PKG.INSERT_ROW
4772: ( X_ROWID => l_Rowid
4773: ,X_FUNCTION_ID => l_Fid
4774: ,X_WEB_HOST_NAME => ''
4775: ,X_WEB_AGENT_NAME => ''

Line 4902: l_Form_Parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE;

4898: l_Kpi_Id NUMBER;
4899: l_Real_Kpi_Name BSC_SYS_DATASETS_TL.NAME%TYPE;
4900: l_Fid NUMBER;
4901: l_Rowid ROWID;
4902: l_Form_Parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE;
4903: l_Max_Seq_Number NUMBER;
4904: l_Sequence NUMBER;
4905: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;

Line 4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;

4902: l_Form_Parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE;
4903: l_Max_Seq_Number NUMBER;
4904: l_Sequence NUMBER;
4905: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

Line 4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;

4903: l_Max_Seq_Number NUMBER;
4904: l_Sequence NUMBER;
4905: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
4911: l_Count NUMBER;

Line 4912: l_Function_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;

4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
4911: l_Count NUMBER;
4912: l_Function_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4913: l_Measure_Group_Id NUMBER;
4914:
4915: l_Measure_Short_Name BSC_SYS_MEASURES.SHORT_NAME%TYPE;
4916:

Line 4923: l_Key_Short_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

4919: l_group_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
4920:
4921: -- added for AGRD
4922: l_Is_From_Report_Designer BOOLEAN;
4923: l_Key_Short_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
4924: l_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
4927: l_Is_XTD_Enabled VARCHAR2(1);

Line 5849: FND_FORM_FUNCTIONS_PKG.DELETE_ROW (

5845: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: END IF;
5848:
5849: FND_FORM_FUNCTIONS_PKG.DELETE_ROW (
5850: X_FUNCTION_ID => BSC_BIS_KPI_CRUD_PUB.Get_Function_Id_By_Name(p_Region_Code)
5851: );
5852:
5853: EXCEPTION

Line 7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL

7984:
7985: FND_MSG_PUB.Initialize;
7986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
7987:
7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL
7989: l_report_region_rec.Region_Code := p_Region_Code;
7990: l_report_region_rec.Region_Name := BIS_COMMON_UTILS.G_DEF_CHAR;
7991: l_report_region_rec.Region_Description := BIS_COMMON_UTILS.G_DEF_CHAR;
7992: l_report_region_rec.Region_Application_Id := p_Region_Application_Id;

Line 9068: FROM fnd_form_functions

9064: END IF;
9065:
9066: SELECT COUNT(1)
9067: INTO l_Count
9068: FROM fnd_form_functions
9069: WHERE function_name = l_Measure_Function_Name;
9070:
9071: -- For BSC Type of measure an invalid function name should be overwritten.
9072: --This happens only if the report with this function name is deleted

Line 9583: from report designer or not.If WEB_HTML_CALL of FND_FORM_FUNCTIONS is bisviewer.showreport or BISReportPG then it is created

9579:
9580: /*****************************************************
9581: Name : is_Scorecard_From_Reports
9582: Description : This API checks if the scoreacrd was created
9583: from report designer or not.If WEB_HTML_CALL of FND_FORM_FUNCTIONS is bisviewer.showreport or BISReportPG then it is created
9584: from report designer.If it is OA.jsp?akRegionCode=BIS_COMPONENT_PAGE?akRegionApplicationId=191 then it is created from page designer.
9585: Scorecard created from page designer can be deleted from Scorecard designers but not the scorecard created from
9586: report designer.
9587: INPUT : p_tab_sht_name

Line 9599: FROM FND_FORM_FUNCTIONS

9595: ) RETURN VARCHAR2 IS
9596:
9597: CURSOR c_form_function IS
9598: SELECT Web_html_call
9599: FROM FND_FORM_FUNCTIONS
9600: WHERE FUNCTION_NAME =p_tab_sht_name;
9601:
9602: l_web_html_call FND_FORM_FUNCTIONS.web_html_call%TYPE;
9603: BEGIN

Line 9602: l_web_html_call FND_FORM_FUNCTIONS.web_html_call%TYPE;

9598: SELECT Web_html_call
9599: FROM FND_FORM_FUNCTIONS
9600: WHERE FUNCTION_NAME =p_tab_sht_name;
9601:
9602: l_web_html_call FND_FORM_FUNCTIONS.web_html_call%TYPE;
9603: BEGIN
9604:
9605: IF(c_form_function%ISOPEN) THEN
9606: CLOSE c_form_function;