APPS.BIX_PMV_AO_ORR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixoorrr.plb 115.3 2004/06/01 09:06:05 pubalasu 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) ;

Line 20: l_custom_rec BIS_QUERY_ATTRIBUTES;

16: l_period_type varchar2(2000);
17: l_comp_type varchar2(2000);
18: l_sql_errm varchar2(32000);
19: l_agent_cost NUMBER;
20: l_custom_rec BIS_QUERY_ATTRIBUTES;
21: l_record_type_id NUMBER ;
22: l_start_date DATE;
23: l_end_date DATE;
24: l_period_from DATE;

Line 50: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

46: --
47: --Initialize p_custom_output
48: --
49:
50: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
51: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
52:
53: -- Get the parameters
54: BIX_PMV_DBI_UTL_PKG.get_ao_page_params( p_page_parameter_tbl,