DBA Data[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;