DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_EVAG_PRTLT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixevagp.plb 120.0 2005/05/25 17:17:44 appldev 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;

Line 21: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
22: l_classification VARCHAR2(32000);
23: l_where_clause VARCHAR2(32000);
24: l_view_by varchar2(1000);
25: l_row_type varchar2(10) := 'AC';

Line 31: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

27: BEGIN
28: --
29: --Initialize p_custom_output
30: --
31: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
32:
33: bix_pmv_dbi_utl_pkg.get_emc_page_params (p_page_parameter_tbl,
34: l_as_of_date,
35: l_period_type,