PACKAGE: APPS.OKI_DBI_NSCM_EXP_PVT

Source

1 PACKAGE OKI_DBI_NSCM_EXP_PVT AS
2 /* $Header: OKIPNEXS.pls 120.1 2006/03/28 23:32:04 asparama noship $ */
3 
4     PROCEDURE get_expirations_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_period_expiring_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_expirations_detail_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     FUNCTION exptype_detail(
20     p_type                      IN VARCHAR2
21   , p_renewed                   IN NUMBER
22   , p_open                      IN NUMBER
23   , p_cancelled                 IN NUMBER
24   , p_norenewal                 IN NUMBER ) RETURN NUMBER;
25 
26    PROCEDURE get_exp_dist_sql  (
27     p_param                     IN  bis_pmv_page_parameter_tbl
28   , x_custom_sql                OUT NOCOPY VARCHAR2
29   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
30 
31   FUNCTION get_expdist_sel_clause RETURN VARCHAR2 ;
32 
33     PROCEDURE get_prd_exp_cont_dtl_sql (
34     p_param                     IN       bis_pmv_page_parameter_tbl
35   , x_custom_sql                OUT NOCOPY VARCHAR2
36   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
37 
38 
39 END OKI_DBI_NSCM_EXP_PVT ;