1 PACKAGE poa_dbi_inv_pkg AUTHID CURRENT_USER
2 /* $Header: poadbiinvs.pls 115.0 2003/10/06 09:47:31 bthammin noship $ */
3 AS
4 --
5 -- -----------------------------------------------------------------------
6 -- |----------------------------< status_sql >---------------------------|
7 -- -----------------------------------------------------------------------
8 -- {Start of Comments}
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 -- Parameters:
15 -- Name Reqd Type Description
16 -- ------------------------------- ---- ----- -----------------------------
17 -- p_param Y TABLE The TABLE type in which all
18 -- the parameters are passed
19 -- x_custom_sql Y VARCHAR2 SQL Statement is build
20 -- with this variable based on
21 -- the options the user selects
22 -- on the Reports
23 -- x_custom_output Y TABLE
24 --
25 -- Post Success:
26 --
27 -- Out Parameters:
28 -- Name In/Out Type Description
29 -- ------------------------------- ------ -------- --------------------------
30 -- x_custom_sql OUT VARCHAR2 SQL Statement is built and
31 -- passed back with the
32 -- parameters passed from the
33 -- Reports page.
34 -- x_custom_outupt OUT TABLE
35 --
36 -- Post Failure:
37 --
38 -- {End of Comments}
39 --
40 PROCEDURE status_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
41 ,x_custom_sql OUT NOCOPY VARCHAR2
42 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43 --
44 -- -----------------------------------------------------------------------
45 -- |-----------------------------< trend_sql >---------------------------|
46 -- -----------------------------------------------------------------------
47 -- {Start of Comments}
48 -- Description:
49 --
50 --
51 -- Prerequisites:
52 --
53 -- Parameters:
54 -- Name Reqd Type Description
55 -- ------------------------------- ---- ---- -----------------------------
56 -- p_param Y TABLE The TABLE type in which all
57 -- the parameters are passed
58 -- x_custom_sql Y VARCHAR2 SQL Statement is build
59 -- with this variable based on
60 -- the options the user selects
61 -- on the Reports
62 -- x_custom_output Y TABLE
63 --
64 -- Post Success:
65 --
66 -- Out Parameters:
67 -- Name In/Out Type Description
68 -- ------------------------------- ------ -------- -------------------------
69 -- x_xustom_sql OUT VARCHAR2 SQL Statement is built and
70 -- passed back with the
71 -- parameters passed from the
72 -- Reports page.
73 -- x_custom_output OUT TABLE
74 -- Post Failure:
75 --
76 -- {End of Comments}
77 --
78 PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
79 ,x_custom_sql OUT NOCOPY VARCHAR2
80 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
81 --
82 END poa_dbi_inv_pkg;