eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PJI_PMV_UTLZ

Source


1 PACKAGE PJI_PMV_UTLZ AS
2 -- $Header: PJIRR02S.pls 120.1 2005/06/16 05:15:05 appldev  $
3 
4 PROCEDURE Get_SQL_PJI_REP_UAP1 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5                              , x_PMV_Sql OUT NOCOPY VARCHAR2
6                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7 
8 PROCEDURE Get_SQL_PJI_REP_U1 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
9                              , x_PMV_Sql OUT NOCOPY VARCHAR2
10                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11 
12 PROCEDURE Get_SQL_PJI_REP_U2 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
13                              , x_PMV_Sql OUT NOCOPY VARCHAR2
14                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15 
16 PROCEDURE Get_SQL_PJI_REP_U3 (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 
20 PROCEDURE Get_SQL_PJI_REP_U4 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
21                              , x_PMV_Sql OUT NOCOPY VARCHAR2
22                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23 
24 PROCEDURE Get_SQL_PJI_REP_U5 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
25                              , x_PMV_Sql OUT NOCOPY VARCHAR2
26                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27 
28 PROCEDURE Get_SQL_PJI_REP_U6 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
29                              , x_PMV_Sql OUT NOCOPY VARCHAR2
30                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31 
32 PROCEDURE Get_SQL_PJI_REP_U7 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
33                              , x_PMV_Sql OUT NOCOPY VARCHAR2
34                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
35 
36 PROCEDURE Get_SQL_PJI_REP_U8 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
37                              , x_PMV_Sql OUT NOCOPY VARCHAR2
38                              , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39 
40 
41 FUNCTION PLSQLDriver_U1 (
42    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
43    p_organization          IN VARCHAR2,
44    p_as_of_date            IN NUMBER,
45    p_period_type           IN VARCHAR2,
46    p_comparator_type       IN VARCHAR2,
47    p_view_by               IN VARCHAR2,
48    p_utilization_category  IN VARCHAR2 DEFAULT NULL,
49    p_work_type             IN VARCHAR2 DEFAULT NULL,
50    p_job_level             IN VARCHAR2 DEFAULT NULL)
51 RETURN PJI_REP_U1_TBL;
52 
53 FUNCTION PLSQLDriver_U2 (
54    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
55    p_organization          IN VARCHAR2,
56    p_as_of_date            IN NUMBER,
57    p_period_type           IN VARCHAR2,
58    p_view_by               IN VARCHAR2
59 )  RETURN PJI_REP_U2_TBL;
60 
61 FUNCTION PLSQLDriver_U3 (
62    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
63    p_organization          IN VARCHAR2,
64    p_as_of_date            IN NUMBER,
65    p_period_type           IN VARCHAR2,
66    p_view_by               IN VARCHAR2,
67    p_utilization_category  IN VARCHAR2 DEFAULT NULL,
68    p_work_type             IN VARCHAR2 DEFAULT NULL,
69    p_job_level             IN VARCHAR2 DEFAULT NULL)
70 RETURN PJI_REP_U3_TBL;
71 
72 FUNCTION PLSQLDriver_U4 (
73    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
74    p_organization          IN VARCHAR2,
75    p_as_of_date            IN NUMBER,
76    p_period_type           IN VARCHAR2,
77    p_view_by               IN VARCHAR2,
78    p_utilization_category  IN VARCHAR2 DEFAULT NULL,
79    p_work_type             IN VARCHAR2 DEFAULT NULL,
80    p_job_level             IN VARCHAR2 DEFAULT NULL,
81    p_flag                  IN VARCHAR2 DEFAULT NULL)
82 RETURN PJI_REP_U4_TBL;
83 
84 
85 FUNCTION PLSQLDriver_PJI_REP_U6
86  (
87     p_operating_unit		IN VARCHAR2 DEFAULT NULL
88   , p_organization		IN VARCHAR2
89   , p_as_of_date		IN NUMBER
90   , p_Period_Type 		IN VARCHAR2
91   , p_util_categories 		IN VARCHAR2 DEFAULT NULL
92   , p_work_type                 IN VARCHAR2 DEFAULT NULL
93   , p_job_level 		IN VARCHAR2 DEFAULT NULL
94   , p_view_by                   IN VARCHAR2 DEFAULT NULL
95   )RETURN PJI_REP_U6_TBL ;
96 
97 
98 FUNCTION PLSQLDriver_PJI_REP_U7
99  (
100     p_operating_unit		IN VARCHAR2 DEFAULT NULL
101   , p_organization		IN VARCHAR2
102   , p_as_of_date		IN NUMBER
103   , p_Period_Type 		IN VARCHAR2
104   , p_util_categories 		IN VARCHAR2 DEFAULT NULL
105   , p_work_type                 IN VARCHAR2 DEFAULT NULL
106   , p_job_level 		IN VARCHAR2 DEFAULT NULL
107   , p_view_by                   IN VARCHAR2 DEFAULT NULL
108   )RETURN PJI_REP_U7_TBL ;
109 
110 
111 FUNCTION PLSQLDriver_PJI_REP_U8
112  (
113     p_operating_unit		IN VARCHAR2 DEFAULT NULL
114   , p_organization		IN VARCHAR2
115   , p_as_of_date		IN NUMBER
116   , p_Period_Type 		IN VARCHAR2
117   , p_util_categories 		IN VARCHAR2 DEFAULT NULL
118   , p_work_type                 IN VARCHAR2 DEFAULT NULL
119   , p_job_level 		IN VARCHAR2 DEFAULT NULL
120   , p_view_by                   IN VARCHAR2 DEFAULT NULL
121   )RETURN PJI_REP_U8_TBL ;
122 
123 
124 END PJI_PMV_UTLZ;