1 PACKAGE PJI_PMV_DFLT_PARAMS AUTHID CURRENT_USER AS
2 /* $Header: PJIRX02S.pls 115.8 2004/06/04 12:35:32 aljain noship $ */
3
4
5 --(function 1: common for all )
6 FUNCTION PJI_REP_DIM_2 return varchar2;
7
8 --(function 2: common for all )
9 FUNCTION AS_OF_DATE return varchar2;
10
11 --Profitability Reports
12 --(function 3: common for all except PP5 and PP6 -else condition)
13 FUNCTION Profitability_PP_Time_Year return varchar2;
14
15 --(function 4: common for all except PP5 and PP6 -else condition)
16 FUNCTION Profitability_PP_Time_Qtr return varchar2;
17
18 --(function 5: common for all except PP5 and PP6 -else condition)
19 FUNCTION Profitability_PP_Time_Period return varchar2;
20
21 --(function 6: common for all except PP5 and PP6 -else condition)
22 FUNCTION Profitability_PP_Time_Week return varchar2;
23
24 --(function 7: for PP5 and PP6 under profitability)
25 FUNCTION Profitability_PP56_Time return varchar2;
26
27 --(function 8: For PP1 and PP2 under profitability)
28 FUNCTION Profitability_PP12_Yearly return varchar2;
29
30 --(function 9: common for all under profitability)
31 FUNCTION Profitability_PP_PjiRepDim27 return varchar2;
32
33 --Availablity Reports
34 --(function 10: common for RA1,RA3,RA5)
35 FUNCTION Availability_RA_Time_Year return varchar2;
36
37 --(function 11: common for RA1,RA3,RA5)
38 FUNCTION Availability_RA_Time_Qtr return varchar2;
39
40 --(function 12: common for RA1,RA3,RA5)
41 FUNCTION Availability_RA_Time_Period return varchar2;
42
43 --(function 13:common for RA1,RA3,RA5)
44 FUNCTION Availability_RA_Time_Week return varchar2;
45
46 --(function 14: common for all under availability)
47 FUNCTION Availability_RA_PjiRepDim28 return varchar2;
48
49 --(function 15: RA3 for availability)
50 FUNCTION Availability_RA_PjiRepDim29 return varchar2;
51
52 --(function 16: RA4 for availability)
53 FUNCTION Availability_RA_FiiTimeWeek return varchar2;
54
55 --Cost Reports
56 --(function 17: for PP7 and PP8 under Cost -if condition )
57 FUNCTION Cost_PP78_Time return varchar2;
58
59 --(function 18: common for all except PP7 and PP8 -else)
60 FUNCTION Cost_PP_Time_Year return varchar2;
61
62 --(function 19: common for all except PP7 and PP8 -else)
63 FUNCTION Cost_PP_Time_Qtr return varchar2;
64
65 --(function 20: common for all except PP7 and PP8 -else)
66 FUNCTION Cost_PP_Time_Period return varchar2;
67
68 --(function 21: common for all except PP7 and PP8 -else)
69 FUNCTION Cost_PP_Time_Week return varchar2;
70
71 --(function 22: For PP4,PC6 and PC10 under Cost)
72 FUNCTION Cost_P4610_Yearly return varchar2;
73
74 --(function 23: common for all under Cost)
75 FUNCTION Cost_PP_PjiRepDim27 return varchar2;
76
77 --Bookings_Backlog reports
78 --(function 24: for PB2,PB02 and PB03 under Bookings_Backlog -if condition )
79 FUNCTION Bookings_Backlog20203_Time return varchar2;
80
81 --(function 25: common for all except PB2,PB02 and PB03 -else)
82 FUNCTION Bookings_Backlog_Time_Year return varchar2;
83
84 --(function 26: common for all except PB2,PB02 and PB03 -else)
85 FUNCTION Bookings_Backlog_Time_Qtr return varchar2;
86
87 --(function 27: common for all except PB2,PB02 and PB03 -else)
88 FUNCTION Bookings_Backlog_Time_Period return varchar2;
89
90 --(function 28: common for all except PB2,PB02 and PB03 -else)
91 FUNCTION Bookings_Backlog_Time_Week return varchar2;
92
93 --(function 29: common for all under Bookings Backlog)
94 FUNCTION Bookings_Backlog_PjiRepDim27 return varchar2;
95
96 --(function 30: for PBB2 under Bookings Backlog)
97 FUNCTION Bookings_BacklogBB2_Dim33 return varchar2;
98
99 --(function 31: PBB1 under Bookings Backlog)
100 FUNCTION Bookings_BacklogBB1_Yearly return varchar2;
101
102 --Utilization Reports
103 --(function 32: for UAP1 and U1 under Utilization)
104 FUNCTION Utilization_UAP1U1_Yearly return varchar2;
105
106 --(function 33: for U2 under Utilization -if condition )
107 FUNCTION Utilization_U2_Time return varchar2;
108
109 --(function 34: common for all except U2 -else)
110 FUNCTION Utilization_Time_Year return varchar2;
111
112 --(function 35: common for all except U2 -else)
113 FUNCTION Utilization_Time_Qtr return varchar2;
114
115 --(function 36: common for all except U2 -else)
116 FUNCTION Utilization_Time_Period return varchar2;
117
118 --(function 37: common for all except u2 -else)
119 FUNCTION Utilization_Time_Week return varchar2;
120
121 --(function 38: common for all under Utilization)
122 FUNCTION Utilization_PjiRepDim27 return varchar2;
123
124
125 END PJI_PMV_DFLT_PARAMS;
126
127
[Home] [Help]