1: package poa_dbi_pr_pkg as
2: /* $Header: poadbiprs.pls 120.0 2005/06/01 13:09:17 appldev noship $ */
3: procedure status_sql(p_param in bis_pmv_page_parameter_tbl
4: ,x_custom_sql out nocopy varchar2
5: ,x_custom_output out nocopy bis_query_attributes_tbl);
6: procedure status_sum_sql(p_param in bis_pmv_page_parameter_tbl
7: ,x_custom_sql out nocopy varchar2
8: ,x_custom_output out nocopy bis_query_attributes_tbl);
9: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl
4: ,x_custom_sql out nocopy varchar2
5: ,x_custom_output out nocopy bis_query_attributes_tbl);
6: procedure status_sum_sql(p_param in bis_pmv_page_parameter_tbl
7: ,x_custom_sql out nocopy varchar2
8: ,x_custom_output out nocopy bis_query_attributes_tbl);
9: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl
10: ,x_custom_sql out nocopy varchar2
11: ,x_custom_output out nocopy bis_query_attributes_tbl);
12: procedure age_sql(p_param in bis_pmv_page_parameter_tbl
7: ,x_custom_sql out nocopy varchar2
8: ,x_custom_output out nocopy bis_query_attributes_tbl);
9: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl
10: ,x_custom_sql out nocopy varchar2
11: ,x_custom_output out nocopy bis_query_attributes_tbl);
12: procedure age_sql(p_param in bis_pmv_page_parameter_tbl
13: ,x_custom_sql out nocopy varchar2
14: ,x_custom_output out nocopy bis_query_attributes_tbl);
15: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl
10: ,x_custom_sql out nocopy varchar2
11: ,x_custom_output out nocopy bis_query_attributes_tbl);
12: procedure age_sql(p_param in bis_pmv_page_parameter_tbl
13: ,x_custom_sql out nocopy varchar2
14: ,x_custom_output out nocopy bis_query_attributes_tbl);
15: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl
16: ,x_custom_sql out nocopy varchar2
17: ,x_custom_output out nocopy bis_query_attributes_tbl);
18: procedure age_trend_sql(p_param in bis_pmv_page_parameter_tbl
13: ,x_custom_sql out nocopy varchar2
14: ,x_custom_output out nocopy bis_query_attributes_tbl);
15: procedure amt_trend_sql(p_param in bis_pmv_page_parameter_tbl
16: ,x_custom_sql out nocopy varchar2
17: ,x_custom_output out nocopy bis_query_attributes_tbl);
18: procedure age_trend_sql(p_param in bis_pmv_page_parameter_tbl
19: ,x_custom_sql out nocopy varchar2
20: ,x_custom_output out nocopy bis_query_attributes_tbl);
21: procedure au_trend_sql(p_param in bis_pmv_page_parameter_tbl
16: ,x_custom_sql out nocopy varchar2
17: ,x_custom_output out nocopy bis_query_attributes_tbl);
18: procedure age_trend_sql(p_param in bis_pmv_page_parameter_tbl
19: ,x_custom_sql out nocopy varchar2
20: ,x_custom_output out nocopy bis_query_attributes_tbl);
21: procedure au_trend_sql(p_param in bis_pmv_page_parameter_tbl
22: ,x_custom_sql out nocopy varchar2
23: ,x_custom_output out nocopy bis_query_attributes_tbl);
24: procedure dtl_sql(
19: ,x_custom_sql out nocopy varchar2
20: ,x_custom_output out nocopy bis_query_attributes_tbl);
21: procedure au_trend_sql(p_param in bis_pmv_page_parameter_tbl
22: ,x_custom_sql out nocopy varchar2
23: ,x_custom_output out nocopy bis_query_attributes_tbl);
24: procedure dtl_sql(
25: p_param in bis_pmv_page_parameter_tbl,
26: x_custom_sql out nocopy varchar2,
27: x_custom_output out nocopy bis_query_attributes_tbl
23: ,x_custom_output out nocopy bis_query_attributes_tbl);
24: procedure dtl_sql(
25: p_param in bis_pmv_page_parameter_tbl,
26: x_custom_sql out nocopy varchar2,
27: x_custom_output out nocopy bis_query_attributes_tbl
28: );
29: end poa_dbi_pr_pkg;