DBA Data[Home] [Help]

APPS.BIX_PMV_AI_TELDTL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 257: p_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

253:
254:
255: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
256: p_sql_text OUT NOCOPY VARCHAR2,
257: p_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
258: )
259: AS
260: l_sqltext VARCHAR2(32000) ;
261:

Line 269: l_custom_rec BIS_QUERY_ATTRIBUTES;

265: l_dnis VARCHAR2(3000);
266: l_view_by VARCHAR2 (120);
267: l_column_name VARCHAR2(1000);
268:
269: l_custom_rec BIS_QUERY_ATTRIBUTES;
270:
271: l_as_of_date DATE;
272: l_period_type varchar2(2000);
273: l_record_type_id NUMBER;

Line 301: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

297:
298: l_generate_viewby :='N';
299:
300: /* Initialize the variables */
301: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
302:
303: /* Trial for Util Package.. */
304:
305: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

Line 587: /*p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

583: -- l_sqltext:=NULL;
584: -- l_where_clause:=NULL;
585:
586: /* Initialize p_custom_output and l_custom_rec */
587: /*p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
588: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
589:
590: l_where_clause := NULL;
591: l_call_center := NULL;