[Home] [Help]
PACKAGE: APPS.PJI_PMV_ENGINE
Source
1 PACKAGE PJI_PMV_ENGINE AS
2 /* $Header: PJIRX01S.pls 120.3 2005/10/11 17:37:48 appldev noship $ */
3
4 G_dimension_codes_tab PA_PLSQL_DATATYPES.Char150TabTyp;
5 G_dimension_level_tab PA_PLSQL_DATATYPES.Char150TabTyp;
6 G_dim_base_column_tab PA_PLSQL_DATATYPES.Char150TabTyp;
7 G_view_by_table_tab PA_PLSQL_DATATYPES.Char150TabTyp;
8
9 G_attribute_code_tab PA_PLSQL_DATATYPES.Char150TabTyp;
10 G_msr_base_column_tab PA_PLSQL_DATATYPES.Char150TabTyp;
11 G_attribute4_tab PA_PLSQL_DATATYPES.Char150TabTyp;
12 G_aggregation_tab PA_PLSQL_DATATYPES.Char150TabTyp;
13
14 G_GL_Calendar_ID FII_TIME_CAL_NAME.CALENDAR_ID%TYPE;
15 G_PA_Calendar_ID FII_TIME_CAL_NAME.CALENDAR_ID%TYPE;
16
17
18 G_Org_Dimension_Level VARCHAR2(50):='ORGANIZATION+PJI_ORGANIZATIONS';
19 G_Org_Base_Column_Name VARCHAR2(50);
20 G_ViewBY VARCHAR2(150);
21 G_ViewBY_Column_Name VARCHAR2(150);
22 G_ViewBY_Table_Name VARCHAR2(150);
23
24 /*
25 ** All Conversion Functions are defined here.
26 */
27
28 Procedure Write2FWKLog( p_Message VARCHAR2
29 , p_Module VARCHAR2 DEFAULT NULL
30 , p_Level NUMBER DEFAULT 1);
31
32 Procedure Convert_Project(p_Project_IDS VARCHAR2 DEFAULT NULL
33 , p_View_BY VARCHAR2);
34
35 Procedure Convert_Operating_Unit(p_Operating_Unit_IDS VARCHAR2 DEFAULT NULL
36 , p_View_BY VARCHAR2);
37
38 Procedure Convert_Organization(p_Top_Organization_ID NUMBER DEFAULT NULL);
39
40 Procedure Convert_Organization(p_Top_Organization_ID NUMBER
41 , p_View_BY VARCHAR2);
42
43 Procedure Convert_Organization(p_Top_Organization_ID NUMBER
44 , p_View_BY VARCHAR2
45 , p_Top_Organization_Name OUT NOCOPY VARCHAR2);
46
47 Function Convert_Classification(p_Classification_ID VARCHAR2 DEFAULT NULL
48 , p_Class_Code_IDS VARCHAR2 DEFAULT NULL
49 , p_View_BY VARCHAR2) RETURN VARCHAR2;
50
51 Function Convert_Expenditure_Type(p_Expenditure_Category VARCHAR2 DEFAULT NULL
52 , p_Expenditure_Type_IDS VARCHAR2 DEFAULT NULL
53 , p_View_BY VARCHAR2) RETURN VARCHAR2;
54
55 Function Convert_Event_Revenue_Type(p_Revenue_Category VARCHAR2 DEFAULT NULL
56 , p_Revenue_Type_IDS VARCHAR2 DEFAULT NULL
57 , p_View_BY VARCHAR2) RETURN VARCHAR2;
58
59 Function Convert_Work_Type(p_Work_Type_IDS VARCHAR2 DEFAULT NULL
60 ,p_View_BY VARCHAR2) RETURN VARCHAR2;
61
62 Function Convert_Util_Category(p_Work_Type_IDS VARCHAR2 DEFAULT NULL
63 , p_Util_Category_IDS VARCHAR2 DEFAULT NULL
64 , p_View_BY VARCHAR2) RETURN VARCHAR2;
65
66 Function Convert_Job_Level(p_Job_IDS VARCHAR2 DEFAULT NULL
67 , p_Job_Level_IDS VARCHAR2 DEFAULT NULL
68 , p_View_BY VARCHAR2) RETURN VARCHAR2;
69
70
71 Procedure Convert_Time(p_From_Time_ID NUMBER
72 , p_To_Time_ID NUMBER
73 , p_Period_Type VARCHAR2
74 , p_View_BY VARCHAR2
75 , p_Parse_Prior VARCHAR2 DEFAULT NULL);
76
77 Procedure Convert_Time(p_As_Of_Date NUMBER
78 , p_Period_Type VARCHAR2
79 , p_View_BY VARCHAR2
80 , p_Parse_Prior VARCHAR2 DEFAULT NULL
81 , p_Report_Type VARCHAR2 DEFAULT NULL
82 , p_Comparator VARCHAR2 DEFAULT NULL
83 , p_Parse_ITD VARCHAR2 DEFAULT NULL
84 , p_Full_Period_Flag VARCHAR2 DEFAULT NULL
85 );
86
87 Procedure Convert_Time_AVL_Trend(p_AS_OF_DATE NUMBER);
88
89
90 Function Convert_AS_OF_DATE(p_As_Of_Date NUMBER
91 , p_Period_Type VARCHAR2
92 , p_Comparator VARCHAR2) RETURN NUMBER;
93
94 Procedure Convert_ITD_NViewBY_AS_OF_DATE(p_As_Of_Date NUMBER
95 , p_Period_Type VARCHAR2
96 , p_Parse_Prior VARCHAR2 DEFAULT NULL
97 , p_Comparator VARCHAR2 DEFAULT 'I'
98 , p_Calendar_ID NUMBER DEFAULT NULL);
99
100 Procedure Convert_NViewBY_AS_OF_DATE(p_As_Of_Date NUMBER
101 , p_Period_Type VARCHAR2
102 , p_Parse_Prior VARCHAR2 DEFAULT NULL
103 , p_Full_Period_Flag VARCHAR2 DEFAULT NULL
104 , p_Calendar_ID NUMBER DEFAULT NULL
105 , p_Default_Period_Name VARCHAR2 DEFAULT NULL
106 , p_Default_Period_ID NUMBER DEFAULT NULL);
107
108 Procedure Convert_NFViewBY_AS_OF_DATE(p_As_Of_Date NUMBER
109 , p_Period_Type VARCHAR2
110 , p_Parse_Prior VARCHAR2 DEFAULT NULL
111 , p_Full_Period_Flag VARCHAR2 DEFAULT NULL
112 , p_Calendar_ID NUMBER DEFAULT NULL
113 , p_Default_Period_Name VARCHAR2 DEFAULT NULL
114 , p_Default_Period_ID NUMBER DEFAULT NULL);
115
116 Procedure Convert_Expected_Time(p_As_Of_Date NUMBER
117 , p_Period_Type VARCHAR2
118 , p_Parse_Prior VARCHAR2 DEFAULT NULL);
119
120 Function Convert_Currency_Code(p_Currency_Code VARCHAR2) RETURN VARCHAR2;
121
122 Function Convert_Currency_Record_Type(p_Currency_Type VARCHAR2) RETURN NUMBER;
123
124
125 Function Convert_ViewBY(p_View_BY VARCHAR2) RETURN VARCHAR2;
126
127 /*
128 ** Interface API for generating SQL.
129 */
130
131 Procedure Generate_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
132 , p_SQL_Statement IN OUT NOCOPY VARCHAR2
133 , p_PMV_Output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
134 , p_Region_Code IN VARCHAR2
135 , p_PLSQL_Driver IN VARCHAR2
136 , p_PLSQL_Driver_Params IN VARCHAR2
137 );
138
139 Procedure Generate_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
140 , p_Select_List IN VARCHAR2
141 , p_SQL_Statement IN OUT NOCOPY VARCHAR2
142 , p_PMV_Output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
143 , p_Region_Code IN VARCHAR2
144 , p_PLSQL_Driver IN VARCHAR2
145 , p_PLSQL_Driver_Params IN VARCHAR2
146 );
147
148 END PJI_PMV_ENGINE;