[Home] [Help]
PACKAGE BODY: APPS.BIX_PMV_EMC_TOPCUST_PRTLT_PKG
Source
1 PACKAGE BODY BIX_PMV_EMC_TOPCUST_PRTLT_PKG AS
2 /*$Header: bixetcvp.plb 115.20 2003/12/15 19:05:09 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_agent_cost NUMBER;
14 l_dummy_cust NUMBER;
15 l_comp_type varchar2(2000);
16 l_account varchar2(32000);
17 l_sql_errm varchar2(32000);
18 l_where varchar2(32000);
19 l_others_string VARCHAR2(100);
20 l_unident_string VARCHAR2(100);
21 l_subtotal_string VARCHAR2(100);
22 l_application_id NUMBER := 680;
23
24 l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
25
26 BEGIN
27 NULL;
28
29 EXCEPTION
30 WHEN OTHERS THEN
31 NULL;
32 END GET_SQL;
33 END BIX_PMV_EMC_TOPCUST_PRTLT_PKG;