DBA Data[Home] [Help]

APPS.BIX_PMV_AI_KPI_PRTLT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixikpip.plb 115.10 2004/03/08 04:11:23 suray 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_as_of_date DATE;

Line 16: l_custom_rec BIS_QUERY_ATTRIBUTES;

12: l_comp_type varchar2(2000);
13: l_record_type_id NUMBER;
14: l_sql_errm varchar2(32000);
15: l_goal NUMBER;
16: l_custom_rec BIS_QUERY_ATTRIBUTES;
17: l_period_type_id NUMBER := 1;
18: l_period_from DATE;
19: l_period_to DATE;
20: l_call_center VARCHAR2(3000);

Line 28: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

24: l_session_where_clause VARCHAR2(3000);
25: l_view_by VARCHAR2(3000);
26:
27: BEGIN
28: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
30:
31: IF (FND_PROFILE.DEFINED('BIX_CALL_SLGOAL_PERCENT')) THEN
32: BEGIN