[Home] [Help]
PACKAGE BODY: APPS.BIX_PMV_EMC_BACK_CLA_RPT_PKG
Source
1 PACKAGE BODY BIX_PMV_EMC_BACK_CLA_RPT_PKG AS
2 /*$Header: bixebclr.plb 115.6 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;
16 l_custom_rec BIS_QUERY_ATTRIBUTES;
17 l_period_type_id NUMBER := 1;
18 l_record_type_id NUMBER ;
19 l_account VARCHAR2(32000);
20 l_start_date DATE;
21 l_end_date DATE;
22 l_period_from DATE;
23 l_period_to DATE;
24 l_max_collect_date VARCHAR2(100);
25 l_period_start_date DATE;
26 l_application_id NUMBER := 680;
27
28 BEGIN
29 NULL;
30 EXCEPTION
31 WHEN OTHERS THEN
32 NULL;
33 END GET_SQL;
34 END BIX_PMV_EMC_BACK_CLA_RPT_PKG;