PACKAGE: APPS.OKI_DBI_NSCM_ACT_PVT

Source

1 PACKAGE OKI_DBI_NSCM_ACT_PVT AS
2 /* $Header: OKIPNACS.pls 120.1 2006/03/28 23:31:46 asparama noship $ */
3 
4     PROCEDURE get_activations_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   FUNCTION get_activations_sel_clause (
10     p_view_by_dim               IN       VARCHAR2
11   , p_view_by_col               IN       VARCHAR2)
12     RETURN VARCHAR2;
13 
14      PROCEDURE get_activations_trend_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 get_act_trend_sel_clause
20     RETURN VARCHAR2;
21 
22     PROCEDURE get_activations_detail_sql  (
23     p_param                     IN       bis_pmv_page_parameter_tbl
24   , x_custom_sql                OUT NOCOPY VARCHAR2
25   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
26 
27  FUNCTION get_act_dtl_sel_clause (
28     p_cur_suffix                IN       VARCHAR2
29    , p_period_type_code          IN       VARCHAR2
30    , p_status_id in VARCHAR2)
31     RETURN VARCHAR2;
32 
33  Function new_ren_detail( p_type                   IN VARCHAR2
34                          , p_new                   IN NUMBER
35                          , p_ren                   IN NUMBER ) RETURN NUMBER;
36 
37     END OKI_DBI_NSCM_ACT_PVT;