DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 2949: -- and should take the type BIS_PMV_PAGE_PARAMETER_TBL

2945: END Validate_Plsql_For_Report;
2946:
2947:
2948: -- This API returns the parameter being used for a PL/SQL API, which should have the one parameter
2949: -- and should take the type BIS_PMV_PAGE_PARAMETER_TBL
2950:
2951: PROCEDURE Get_Plsql_Parameters (
2952: p_Report_Function IN VARCHAR2
2953: , x_Parameter_1 OUT NOCOPY VARCHAR2

Line 3240: l_PMV_Query_Table BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();

3236: l_Attribute2_Count NUMBER;
3237: l_Attribute3_Count NUMBER;
3238: l_Default_Values_Count NUMBER;
3239:
3240: l_PMV_Query_Table BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3241: l_Table_Count NUMBER;
3242:
3243: l_Page_Parameter_Tbl BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3244: l_Page_Parameter_Rec BIS_PMV_PAGE_PARAMETER_REC := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

Line 3243: l_Page_Parameter_Tbl BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();

3239:
3240: l_PMV_Query_Table BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3241: l_Table_Count NUMBER;
3242:
3243: l_Page_Parameter_Tbl BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3244: l_Page_Parameter_Rec BIS_PMV_PAGE_PARAMETER_REC := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
3245:
3246: l_Sql VARCHAR2(8192);
3247: l_Comparison_Type VARCHAR2(30);

Line 3561: x_Param_Table IN OUT NOCOPY BIS_PMV_PAGE_PARAMETER_TBL

3557:
3558:
3559: -- Inserts into Parameter Query table.
3560: PROCEDURE Insert_Into_Query_Table (
3561: x_Param_Table IN OUT NOCOPY BIS_PMV_PAGE_PARAMETER_TBL
3562: , p_Parameter_Name IN VARCHAR2
3563: , p_Parameter_Id IN VARCHAR2
3564: , p_Parameter_Value IN VARCHAR2
3565: , p_Dimension IN VARCHAR2