DBA Data[Home] [Help]

PACKAGE: APPS.PJI_PMV_PROFITABILITY

Source


1 PACKAGE PJI_PMV_PROFITABILITY AUTHID CURRENT_USER AS
2 /* $Header: PJIRF04S.pls 115.5 2003/06/23 09:31:08 aljain noship $*/
3 
4 
5 PROCEDURE GET_SQL_PJI_REP_PP1 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6 		, x_PMV_Sql OUT NOCOPY VARCHAR2
7                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8 
9 PROCEDURE GET_SQL_PJI_REP_PP2 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
10  		, x_PMV_Sql OUT NOCOPY VARCHAR2
11                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12 
13 PROCEDURE GET_SQL_PJI_REP_PP3 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
14 		, x_PMV_Sql OUT NOCOPY VARCHAR2
15                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16 PROCEDURE GET_SQL_PJI_REP_PP4 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
17 		, x_PMV_Sql OUT NOCOPY VARCHAR2
18                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19 PROCEDURE GET_SQL_PJI_REP_PP9 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
20 		, x_PMV_Sql OUT NOCOPY VARCHAR2
21                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
22 PROCEDURE GET_SQL_PJI_REP_PP10 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
23 		, x_PMV_Sql OUT NOCOPY VARCHAR2
24                 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
25 
26 -- -------------------------------------------------------------
27 -- PLSQL DRIVERS
28 -- -------------------------------------------------------------
29 
30 FUNCTION PLSQLDriver_PJI_REP_PP3(
31                         p_Operating_Unit		IN VARCHAR2 DEFAULT NULL
32                         , p_Organization		IN VARCHAR2
33                         , p_Currency_Type		IN VARCHAR2
34                         , p_As_Of_Date                  IN NUMBER
35                         , p_Period_Type 		IN VARCHAR2
36                         , p_View_BY 			IN VARCHAR2
37                         , p_Classifications		IN VARCHAR2 DEFAULT NULL
38                         , p_Class_Codes			IN VARCHAR2 DEFAULT NULL
39 			, p_Expenditure_Category        IN VARCHAR2 DEFAULT NULL
40 			, p_Expenditure_Type            IN VARCHAR2 DEFAULT NULL
41 			, p_Revenue_Category            IN VARCHAR2 DEFAULT NULL
42 			, p_Revenue_Type                IN VARCHAR2 DEFAULT NULL
43 			, p_Work_Type                   IN VARCHAR2 DEFAULT NULL
44 
45 		)  RETURN PJI_REP_PP3_TBL;
46 
47 
48 FUNCTION PLSQLDriver_PJI_REP_PPDTL(
49                         p_Operating_Unit		IN VARCHAR2 DEFAULT NULL
50                         , p_Organization		IN VARCHAR2
51                         , p_Currency_Type		IN VARCHAR2
52                         , p_As_Of_Date                  IN NUMBER
53                         , p_Period_Type 		IN VARCHAR2
54                         , p_View_BY 			IN VARCHAR2
55                         , p_Classifications		IN VARCHAR2 DEFAULT NULL
56                         , p_Class_Codes			IN VARCHAR2 DEFAULT NULL
57                         , p_Project_IDs			IN VARCHAR2 DEFAULT NULL
58 			, p_Expenditure_Category        IN VARCHAR2 DEFAULT NULL
59 			, p_Expenditure_Type            IN VARCHAR2 DEFAULT NULL
60 			, p_Revenue_Category            IN VARCHAR2 DEFAULT NULL
61 			, p_Revenue_Type                IN VARCHAR2 DEFAULT NULL
62 			, p_Work_Type                   IN VARCHAR2 DEFAULT NULL
63 		)  RETURN PJI_REP_PPDTL_TBL;
64 
65 
66 FUNCTION PLSQLDriver_PJI_REP_PPSUM(
67                         p_Operating_Unit		IN VARCHAR2 DEFAULT NULL
68                         , p_Organization		IN VARCHAR2
69                         , p_Currency_Type		IN VARCHAR2
70                         , p_As_Of_Date                  IN NUMBER
71                         , p_Time_Comparison_Type        IN VARCHAR2
72                         , p_Period_Type 		IN VARCHAR2
73                         , p_View_BY 			IN VARCHAR2
74                         , p_Classifications		IN VARCHAR2 DEFAULT NULL
75                         , p_Class_Codes			IN VARCHAR2 DEFAULT NULL
76                         , p_Expenditure_Category        IN VARCHAR2 DEFAULT NULL
77                         , p_Expenditure_Type            IN VARCHAR2 DEFAULT NULL
78                         , p_Revenue_Category            IN VARCHAR2 DEFAULT NULL
79                         , p_Revenue_Type                IN VARCHAR2 DEFAULT NULL
80                         , p_Work_Type                   IN VARCHAR2 DEFAULT NULL
81 
82 		)  RETURN PJI_REP_PPSUM_TBL;
83 
84 
85 END PJI_PMV_PROFITABILITY;