[Home] [Help]
PACKAGE: APPS.POA_DBI_REJ_PKG
Source
1 PACKAGE poa_dbi_rej_pkg AUTHID CURRENT_USER
2 /* $Header: poadbirejs.pls 115.0 2003/10/06 09:45:17 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 All the parameters are passed
18 -- using this table.
19 -- X_CUSTOM_SQL Y VARCHAR2 The SQL Statement is built and
20 -- passed back using this variable
21 -- X_CUSTOM_OUTPUT Y TABLE
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 -- Name In/Out Type Description
27 -- ------------------------------- ------ -------- -------------------------------
28 -- X_CUSTOM_SQL OUT VARCHAR2 The SQL Statement is built and
29 -- passed back using this variable
30 -- X_CUSTOM_OUTPUT OUT TABLE
31 --
32 -- Post Failure:
33 --
34 -- {End of Comments}
35 --
36 PROCEDURE status_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
37 ,x_custom_sql OUT NOCOPY VARCHAR2
38 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39 --
40 -- -----------------------------------------------------------------------
41 -- |----------------------------< rej_rsn_sql >--------------------------|
42 -- -----------------------------------------------------------------------
43 -- {Start of Comments}
44 -- Description:
45 --
46 --
47 -- Prerequisites:
48 --
49 -- Parameters:
50 -- Name Reqd Type Description
51 -- ------------------------------- ---- ---- -----------------------------
52 -- P_PARAM Y IN BIS_PMV_PAGE_PARAMETER_TBL
53 -- type
54 -- X_CUSTOM_SQL Y OUT
55 -- X_CUSTOM_OUTPUT Y OUT
56 --
57 -- Post Success:
58 --
59 -- Out Parameters:
60 -- Name In/Out Type Description
61 -- ------------------------------- ------ -------- -------------------------
62 -- X_CUSTOM_SQL OUT VARCHAR2 Returns the SQL Statement
63 -- X_CUSTOM_OUTPUT OUT TABLE Returns the
64 --
65 -- Post Failure:
66 --
67 -- {End of Comments}
68 --
69 PROCEDURE rej_rsn_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
70 ,x_custom_sql OUT NOCOPY VARCHAR2
71 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
72 --
73 END poa_dbi_rej_pkg;