DBA Data[Home] [Help]

APPS.BIX_PMV_AO_COPRHR_PRTLT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: p_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /*$Header: bixocphp.plb 120.1 2005/06/10 04:21:03 appldev $ */
3:
4: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5: p_custom_sql 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 36: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

32: l_session_where_clause VARCHAR2(3000);
33: l_call_center VARCHAR2(3000);
34: l_view_by VARCHAR2(3000);
35:
36: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: BEGIN
39: --
40: --Initialize p_custom_output

Line 42: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

38: BEGIN
39: --
40: --Initialize p_custom_output
41: --
42: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
43:
44: -- Get the parameters
45:
46: BIX_PMV_DBI_UTL_PKG.get_ao_page_params( p_page_parameter_tbl,