3:
4: PROCEDURE get_sg_prod_rev
5: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: get_sg_prod_rev_sql out NOCOPY VARCHAR2,
7: get_sg_prod_rev_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
8:
9: -- declaration section
10:
11: sqlstmt VARCHAR2(10000);
652:
653: -- Binding Section
654:
655: get_sg_prod_rev_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
656: get_sg_prod_rev_output := BIS_QUERY_ATTRIBUTES_TBL();
657: get_sg_prod_rev_sql := sqlstmt;
658:
659: get_sg_prod_rev_output.EXTEND;
660: get_sg_prod_rev_rec.attribute_name := ':RECORD_TYPE_ID';