1: PACKAGE OKI_DBI_SRM_PDUE_PVT AS
2: /* $Header: OKIIPDUS.pls 120.1 2006/03/28 23:27:38 asparama noship $ */
3:
4: PROCEDURE get_table_sql (
5: p_param IN bis_pmv_page_parameter_tbl
6: , x_custom_sql OUT NOCOPY VARCHAR2
7: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
8:
9: PROCEDURE get_pastdue_percent_sql (
6: , x_custom_sql OUT NOCOPY VARCHAR2
7: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
8:
9: PROCEDURE get_pastdue_percent_sql (
10: p_param IN bis_pmv_page_parameter_tbl
11: , x_custom_sql OUT NOCOPY VARCHAR2
12: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
13:
14: PROCEDURE get_pduernwldetail_sql (
11: , x_custom_sql OUT NOCOPY VARCHAR2
12: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
13:
14: PROCEDURE get_pduernwldetail_sql (
15: 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:
19: PROCEDURE get_trend_sql(
16: , x_custom_sql OUT NOCOPY VARCHAR2
17: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
18:
19: PROCEDURE get_trend_sql(
20: p_param IN bis_pmv_page_parameter_tbl
21: , x_custom_sql OUT NOCOPY VARCHAR2
22: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
23:
24: PROCEDURE get_pdueval_cust_sql (
21: , x_custom_sql OUT NOCOPY VARCHAR2
22: , x_custom_output OUT NOCOPY bis_query_attributes_tbl);
23:
24: PROCEDURE get_pdueval_cust_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 OKI_DBI_SRM_PDUE_PVT ;