PACKAGE BODY: APPS.BIX_PMV_EMC_AHW_PRTLT_PKG

Source

1 PACKAGE BODY BIX_PMV_EMC_AHW_PRTLT_PKG AS
2 /*$Header: bixeahwp.plb 115.11 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_custom_sql         OUT NOCOPY VARCHAR2,
6                   p_custom_output      OUT NOCOPY bis_query_attributes_TBL
7                   )
8 AS
9 l_sqltext	      VARCHAR2(32000) ;
10 l_as_of_date   DATE;
11 l_period_type	varchar2(2000);
12 l_record_type_id NUMBER;
13 l_comp_type    varchar2(2000);
14 l_account      varchar2(32000);
15 l_sql_errm      varchar2(32000);
16 l_previous_report_start_date DATE;
17 l_current_report_start_date DATE;
18 l_previous_as_of_date DATE;
19 l_period_type_id NUMBER;
20 l_time_id_column  VARCHAR2(1000);
21 l_application_id NUMBER := 680;
22 l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
23 
24 BEGIN
25 NULL;
26 EXCEPTION
27 WHEN OTHERS THEN
28 NULL;
29 END GET_SQL;
30 END  BIX_PMV_EMC_AHW_PRTLT_PKG;