APPS.BIX_PMV_EMC_AGTDET_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixead1r.plb 120.1 2005/09/14 16:24:03 anasubra 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 18: l_custom_rec BIS_QUERY_ATTRIBUTES;

14: l_period_type varchar2(2000);
15: l_comp_type varchar2(2000);
16: l_sql_errm varchar2(32000);
17: l_agent_cost NUMBER;
18: l_custom_rec BIS_QUERY_ATTRIBUTES;
19: l_period_type_id NUMBER := 1;
20: l_record_type_id NUMBER ;
21: l_account VARCHAR2(32000);
22: l_start_date DATE;

Line 39: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

35: --
36: --Initialize p_custom_output
37: --
38:
39: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
41:
42: -- Get the parameters
43: