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