[Home] [Help]
PACKAGE: APPS.PJI_PMV_COST
Source
1 PACKAGE PJI_PMV_COST AS
2 /* $Header: PJIRF06S.pls 120.1 2005/05/31 08:17:56 appldev $ */
3
4
5 PROCEDURE GET_SQL_PJI_REP_PC10 (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_PC11(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_PC13(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
17 PROCEDURE Get_SQL_PJI_REP_PC12(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
18 , x_PMV_Sql OUT NOCOPY VARCHAR2
19 , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20
21 -- -------------------------------------------------------------
22 -- PLSQL DRIVERS
23 -- -------------------------------------------------------------
24
25 FUNCTION PLSQLDriver_PJI_REP_PC10(
26 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
27 , p_Organization IN VARCHAR2
28 , p_Currency_Type IN VARCHAR2
29 , p_As_of_Date IN NUMBER
30 , p_Time_Comparison_Type IN VARCHAR2
31 , p_Period_Type IN VARCHAR2
32 , p_View_BY IN VARCHAR2
33 , p_Classifications IN VARCHAR2 DEFAULT NULL
34 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
35 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
36 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
37 , p_Work_Type IN VARCHAR2 DEFAULT NULL
38 ) RETURN PJI_REP_PC10_TBL;
39
40 FUNCTION PLSQLDriver_PJI_REP_PC11(
41 p_Operating_Unit IN VARCHAR2 DEFAULT NULL
42 , p_Organization IN VARCHAR2
43 , p_Currency_Type IN VARCHAR2
44 , p_As_Of_Date IN NUMBER
45 , p_Period_Type IN VARCHAR2
46 , p_View_BY IN VARCHAR2
47 , p_Classifications IN VARCHAR2 DEFAULT NULL
48 , p_Class_Codes IN VARCHAR2 DEFAULT NULL
49 , p_Report_Type IN VARCHAR2 DEFAULT NULL
50 , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
51 , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
52 , p_Work_Type IN VARCHAR2 DEFAULT NULL
53
54 )RETURN PJI_REP_PC11_TBL ;
55
56
57 FUNCTION PLSQLDriver_PJI_REP_PC13(
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_PC13_TBL;
72
73 END PJI_PMV_COST;