APPS.BIX_PMV_AO_TELDTL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 7: p_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

3:
4:
5: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: p_sql_text OUT NOCOPY VARCHAR2,
7: p_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
8: )
9: AS
10: l_sqltext VARCHAR2(32000) ;
11: l_where_clause VARCHAR2(1000) ;

Line 18: l_custom_rec BIS_QUERY_ATTRIBUTES;

14: l_view_by VARCHAR2(3000);
15: l_unknown VARCHAR2(3000);
16: l_column_name VARCHAR2(1000);
17:
18: l_custom_rec BIS_QUERY_ATTRIBUTES;
19: --added for campaign, schedule and source code
20: l_campaign_id varchar2(3000);
21: l_schedule_id varchar2(3000);
22: l_source_code_id varchar2(3000);

Line 36: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

32: l_record_type_id NUMBER;
33:
34: BEGIN
35: /* Initialize p_custom_output and l_custom_rec */
36: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
38:
39: l_where_clause := NULL;
40: l_call_center := NULL;