369:
370: PROCEDURE Bind_Variable (p_sqlstmt IN Varchar2,
371: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
372: p_sql_output OUT NOCOPY Varchar2,
373: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
374:
375: l_bind_rec BIS_QUERY_ATTRIBUTES;
376:
377: BEGIN
371: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
372: p_sql_output OUT NOCOPY Varchar2,
373: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
374:
375: l_bind_rec BIS_QUERY_ATTRIBUTES;
376:
377: BEGIN
378:
379: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
375: l_bind_rec BIS_QUERY_ATTRIBUTES;
376:
377: BEGIN
378:
379: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
380: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
381: p_sql_output := p_sqlstmt;
382:
383: p_bind_output_table.EXTEND;