PACKAGE BODY: APPS.BIX_PMV_EMC_CLASS_RPT_PKG

Source

1 PACKAGE BODY BIX_PMV_EMC_CLASS_RPT_PKG AS
2 /*$Header: bixeclar.plb 115.5 2003/12/15 19:05:07 djambula noship $ */
3 
4 PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5                   p_sql_text           OUT NOCOPY VARCHAR2,
6                   p_custom_output      OUT NOCOPY bis_query_attributes_TBL
7                   )
8 AS
9 l_sqltext	      VARCHAR2(32000) ;
10 l_where_clause        VARCHAR2(1000) ;
11 l_as_of_date   DATE;
12 l_period_type	varchar2(2000);
13 l_comp_type    varchar2(2000);
14 l_sql_errm      varchar2(32000);
15 l_agent_cost      NUMBER := 0;
16 l_cust_resp_time_goal NUMBER;
17 l_service_level_goal  NUMBER;
18 l_custom_rec       BIS_QUERY_ATTRIBUTES;
19 l_period_type_id   NUMBER := 1;
20 l_record_type_id   NUMBER;
21 l_account      VARCHAR2(32000);
22 l_start_date   DATE;
23 l_end_date     DATE;
24 l_period_from  DATE;
25 l_period_to    DATE;
26 l_max_collect_date   VARCHAR2(100);
27 l_period_start_date  DATE;
28 BEGIN
29 NULL;
30 EXCEPTION
31 WHEN OTHERS THEN
32 NULL;
33 END GET_SQL;
34 END  BIX_PMV_EMC_CLASS_RPT_PKG;