DBA Data[Home] [Help]

APPS.FII_AP_HOLD_SUM dependencies on FII_PMV_UTIL

Line 34: FII_PMV_Util.Get_Parameters(

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,

Line 247: FII_PMV_Util.bind_variable(

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,

Line 293: FII_PMV_Util.Get_Parameters(

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,

Line 444: FII_PMV_Util.bind_variable(

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,

Line 489: FII_PMV_Util.Get_Parameters(

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,

Line 653: FII_PMV_Util.bind_variable(

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,

Line 697: FII_PMV_Util.Get_Parameters(

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,

Line 767: FII_PMV_Util.bind_variable(

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,

Line 820: FII_PMV_Util.Get_Parameters(

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,

Line 841: FII_PMV_Util.get_format_mask(l_date_mask);

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;

Line 995: FII_PMV_UTIL.bind_variable(

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,