[Home] [Help]
PACKAGE: APPS.PJI_PMV_PROFITABILITY_TREND
Source
1 PACKAGE PJI_PMV_PROFITABILITY_TREND AUTHID CURRENT_USER AS
2 /* $Header: PJIRF05S.pls 115.4 2003/06/23 09:41:02 aljain noship $ */
3
4 FUNCTION PLSQLDriver_PJI_REP_PP5(
5 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
6 , p_Organization IN VARCHAR2
7 , p_Currency_Type IN VARCHAR2
8 , p_As_Of_Date IN NUMBER
9 , p_Period_Type IN VARCHAR2
10 , p_View_BY IN VARCHAR2
11 , p_Classifications IN VARCHAR2 DEFAULT NULL
12 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
13 , p_Report_Type IN VARCHAR2 DEFAULT NULL
14 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
15 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
16 , p_Revenue_Category IN VARCHAR2 DEFAULT NULL
17 , p_Revenue_Type IN VARCHAR2 DEFAULT NULL
18 , p_Work_Type IN VARCHAR2 DEFAULT NULL
19 )RETURN PJI_REP_PP5_TBL ;
20
21 PROCEDURE Get_SQL_PJI_REP_PP5(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
22 , x_PMV_Sql OUT NOCOPY VARCHAR2
23 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24
25 PROCEDURE Get_SQL_PJI_REP_PP6(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
26 , x_PMV_Sql OUT NOCOPY VARCHAR2
27 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
28
29 PROCEDURE Get_SQL_PJI_REP_PP7(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
30 , x_PMV_Sql OUT NOCOPY VARCHAR2
31 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
32
33 PROCEDURE Get_SQL_PJI_REP_PP8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
34 , x_PMV_Sql OUT NOCOPY VARCHAR2
35 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36
37 END PJI_PMV_PROFITABILITY_TREND;