[Home] [Help]
PACKAGE: APPS.PJI_PMV_CAPITAL_COST
Source
1 PACKAGE PJI_PMV_CAPITAL_COST AS
2 /* $Header: PJIRF07S.pls 120.1 2005/05/31 08:18:08 appldev $ */
3
4
5
6 PROCEDURE GET_SQL_PJI_REP_PC6 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
7 , x_PMV_Sql OUT NOCOPY VARCHAR2
8 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9
10 PROCEDURE GET_SQL_PJI_REP_PC7 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
11 , x_PMV_Sql OUT NOCOPY VARCHAR2
12 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
13
14 PROCEDURE GET_SQL_PJI_REP_PC9 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
15 , x_PMV_Sql OUT NOCOPY VARCHAR2
16 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
17
18 PROCEDURE Get_SQL_PJI_REP_PC8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
19 , x_PMV_Sql OUT NOCOPY VARCHAR2
20 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21
22 -- -------------------------------------------------------------
23 -- PLSQL DRIVERS
24 -- -------------------------------------------------------------
25
26 FUNCTION PLSQLDriver_PJI_REP_PC6(
27 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
28 , p_Organization IN VARCHAR2
29 , p_Currency_Type IN VARCHAR2
30 , p_As_of_Date IN NUMBER
31 , p_Time_Comparison_Type IN VARCHAR2
32 , p_Period_Type IN VARCHAR2
33 , p_View_BY IN VARCHAR2
34 , p_Classifications IN VARCHAR2 DEFAULT NULL
35 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
36 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
37 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
38 , p_Work_Type IN VARCHAR2 DEFAULT NULL
39 ) RETURN PJI_REP_PC6_TBL;
40
41 FUNCTION PLSQLDriver_PJI_REP_PC7(
42 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
43 , p_Organization IN VARCHAR2
44 , p_Currency_Type IN VARCHAR2
45 , p_As_Of_Date IN NUMBER
46 , p_Period_Type IN VARCHAR2
47 , p_View_BY IN VARCHAR2
48 , p_Classifications IN VARCHAR2 DEFAULT NULL
49 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
50 , p_Report_Type IN VARCHAR2 DEFAULT NULL
51 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
52 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
53 , p_Work_Type IN VARCHAR2 DEFAULT NULL
54
55 )RETURN PJI_REP_PC7_TBL;
56
57 FUNCTION PLSQLDriver_PJI_REP_PC9(
58 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
59 , p_Organization IN VARCHAR2
60 , p_Currency_Type IN VARCHAR2
61 , p_As_Of_Date IN NUMBER
62 , p_Period_Type IN VARCHAR2
63 , p_View_BY IN VARCHAR2
64 , p_Classifications IN VARCHAR2 DEFAULT NULL
65 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
66 , p_Project_IDs IN VARCHAR2 DEFAULT NULL
67 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
68 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
69 , p_Work_Type IN VARCHAR2 DEFAULT NULL
70
71 ) RETURN PJI_REP_PC9_TBL;
72 END PJI_PMV_CAPITAL_COST;