30: BEGIN
31:
32: -- Retrieve parameter info
33:
34: FII_PMV_Util.Get_Parameters(
35: p_page_parameter_tbl,
36: l_as_of_date,
37: l_operating_unit,
38: l_supplier,
243: &ORDER_BY_CLAUSE' ;
244:
245: -- Binding Section
246:
247: FII_PMV_Util.bind_variable(
248: p_sqlstmt=> sqlstmt,
249: p_page_parameter_tbl=>p_page_parameter_tbl,
250: p_sql_output=>get_hold_sum_sql,
251: p_bind_output_table=>get_hold_sum_output,
289: BEGIN
290:
291: -- Retrieve parameter info
292:
293: FII_PMV_Util.Get_Parameters(
294: p_page_parameter_tbl,
295: l_as_of_date,
296: l_operating_unit,
297: l_supplier,
440:
441:
442: -- Binding Section
443:
444: FII_PMV_Util.bind_variable(
445: p_sqlstmt=> sqlstmt,
446: p_page_parameter_tbl=>p_page_parameter_tbl,
447: p_sql_output=>get_hold_discount_sum_sql,
448: p_bind_output_table=>get_hold_discount_sum_output,
485: BEGIN
486:
487: -- Retrieve parameter info
488:
489: FII_PMV_Util.Get_Parameters(
490: p_page_parameter_tbl,
491: l_as_of_date,
492: l_operating_unit,
493: l_supplier,
649: &ORDER_BY_CLAUSE' ;
650:
651: -- Binding Section
652:
653: FII_PMV_Util.bind_variable(
654: p_sqlstmt=> sqlstmt,
655: p_page_parameter_tbl=>p_page_parameter_tbl,
656: p_sql_output=>get_hold_cat_sum_sql,
657: p_bind_output_table=>get_hold_cat_sum_output,
693: BEGIN
694:
695: -- Retrieve parameter info
696:
697: FII_PMV_Util.Get_Parameters(
698: p_page_parameter_tbl,
699: l_as_of_date,
700: l_operating_unit,
701: l_supplier,
763: &ORDER_BY_CLAUSE' ;
764:
765: -- Binding Section
766:
767: FII_PMV_Util.bind_variable(
768: p_sqlstmt=> sqlstmt,
769: p_page_parameter_tbl=>p_page_parameter_tbl,
770: p_sql_output=>get_hold_type_sum_sql,
771: p_bind_output_table=>get_hold_type_sum_output,
816:
817:
818: BEGIN
819:
820: FII_PMV_Util.Get_Parameters(
821: p_page_parameter_tbl,
822: l_as_of_date,
823: l_operating_unit,
824: l_supplier,
837:
838:
839: l_record_type_id := 512;
840:
841: FII_PMV_Util.get_format_mask(l_date_mask);
842:
843:
844: -- IF l_supplier is not null and l_supplier <> 'All' then
845: -- l_gid := 0;
991:
992:
993:
994:
995: FII_PMV_UTIL.bind_variable(
996: p_sqlstmt=>sqlstmt,
997: p_page_parameter_tbl=>p_page_parameter_tbl,
998: p_sql_output=>get_hold_trend_sql,
999: p_bind_output_table=>get_hold_trend_output,