PACKAGE: APPS.PJI_PMV_AVL

Source

1 PACKAGE PJI_PMV_AVL AS
2 -- $Header: PJIRR01S.pls 120.1 2005/05/31 08:18:27 appldev  $
3 
4 PROCEDURE Get_SQL_PJI_REP_RA1 (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 PROCEDURE Get_SQL_PJI_REP_RA2 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
8                              , x_PMV_Sql OUT NOCOPY  VARCHAR2
9                              , x_PMV_Output OUT NOCOPY  BIS_QUERY_ATTRIBUTES_TBL);
10 PROCEDURE Get_SQL_PJI_REP_RA3 (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 PROCEDURE Get_SQL_PJI_REP_RA4 (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 PROCEDURE Get_SQL_PJI_REP_RA5 (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 
21 FUNCTION PLSQLDriver_RA1 (
22    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
23    p_organization          IN VARCHAR2,
24    p_threshold             IN NUMBER,
25    p_As_Of_Date            IN NUMBER,
26    p_period_type           IN VARCHAR2,
27    p_view_by               IN VARCHAR2
28 )  RETURN PJI_REP_RA1_TBL;
29 
30 FUNCTION PLSQLDriver_RA2 (
31    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
32    p_organization          IN VARCHAR2,
33    p_threshold             IN NUMBER,
34    p_as_of_date            IN NUMBER,
35    p_view_by               IN VARCHAR2
36 )  RETURN PJI_REP_RA2_TBL;
37 
38 FUNCTION PLSQLDriver_RA3 (
39    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
40    p_organization          IN VARCHAR2,
41    p_threshold             IN NUMBER,
42    p_avl_type              IN VARCHAR2,
43    p_as_of_date            IN NUMBER,
44    p_period_type           IN VARCHAR2,
45    p_view_by               IN VARCHAR2
46 )  RETURN PJI_REP_RA3_TBL;
47 
48 FUNCTION PLSQLDriver_RA4 (
49    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
50    p_organization          IN VARCHAR2,
51    p_threshold             IN NUMBER,
52    p_as_of_date            IN NUMBER,
53    p_period_type           IN VARCHAR2,
54    p_view_by               IN VARCHAR2
55 )  RETURN PJI_REP_RA4_TBL;
56 
57 FUNCTION PLSQLDriver_RA5 (
58    p_operating_unit        IN VARCHAR2 DEFAULT NULL,
59    p_organization          IN VARCHAR2,
60    p_threshold             IN NUMBER,
61    p_avl_days              IN NUMBER,
62    p_as_of_date            IN NUMBER,
63    p_period_type           IN VARCHAR2,
64    p_view_by               IN VARCHAR2
65 )  RETURN PJI_REP_RA5_TBL;
66 
67 END PJI_PMV_AVL;
68