DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_ACCOUNT_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixeactr.plb 120.0 2005/05/25 17:28:49 appldev 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_sql_errm varchar2(32000);
15: l_agent_cost NUMBER := 0;
16: l_cust_resp_time_goal NUMBER;
17: l_service_level_goal 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 38: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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