APPS.FII_AP_PAY_STATUS dependencies on FII_PMV_UTIL

Line 33: FII_PMV_UTIL.get_parameters(

29: -- l_asof_date_julien NUMBER;
30: BEGIN
31:
32: -- Read the parameters passed
33: FII_PMV_UTIL.get_parameters(
34: p_page_parameter_tbl=>p_page_parameter_tbl,
35: p_as_of_date=>l_as_of_date,
36: p_operating_unit=>l_organization,
37: p_supplier=>l_supplier,

Line 179: FII_PMV_UTIL.bind_variable(

175: GROUP BY viewby_dim.value, viewby_dim.id
176: &ORDER_BY_CLAUSE';
177:
178: -- Attach bind parameters
179: FII_PMV_UTIL.bind_variable(
180: p_sqlstmt=>sqlstmt,
181: p_page_parameter_tbl=>p_page_parameter_tbl,
182: p_sql_output=>open_pay_sum_sql,
183: p_bind_output_table=>open_pay_sum_output,

Line 222: FII_PMV_UTIL.get_parameters(

218: stmt5 VARCHAR2(500);
219: stmt6 VARCHAR2(500); /* Added for bug 3120355 */
220: BEGIN
221:
222: FII_PMV_UTIL.get_parameters(
223: p_page_parameter_tbl=>p_page_parameter_tbl,
224: p_as_of_date=>l_as_of_date,
225: p_operating_unit=>l_organization,
226: p_supplier=>l_supplier,

Line 286: FII_PMV_UTIL.bind_variable(

282: AND f.gid = :GID
283: Group by t1.multiplier order by t1.multiplier asc';
284:
285: -- Attach bind parameters
286: FII_PMV_UTIL.bind_variable(
287: p_sqlstmt=>sqlstmt,
288: p_page_parameter_tbl=>p_page_parameter_tbl,
289: p_sql_output=>inv_age_sql,
290: p_bind_output_table=>inv_age_output,

Line 330: FII_PMV_UTIL.get_parameters(

326:
327: BEGIN
328:
329: -- Read the parameters passed
330: FII_PMV_UTIL.get_parameters(
331: p_page_parameter_tbl=>p_page_parameter_tbl,
332: p_as_of_date=>l_as_of_date,
333: p_operating_unit=>l_organization,
334: p_supplier=>l_supplier,

Line 401: FII_PMV_UTIL.bind_variable(

397: GROUP BY viewby_dim.value, viewby_dim.id
398: &ORDER_BY_CLAUSE';
399:
400: -- Attach bind parameters
401: FII_PMV_UTIL.bind_variable(
402: p_sqlstmt=>l_sqlstmt,
403: p_page_parameter_tbl=>p_page_parameter_tbl,
404: p_sql_output=>open_pay_sum_pie_sql,
405: p_bind_output_table=>open_pay_sum_pie_output,

Line 440: FII_PMV_UTIL.get_parameters(

436:
437:
438: BEGIN
439:
440: FII_PMV_UTIL.get_parameters(
441: p_page_parameter_tbl=>p_page_parameter_tbl,
442: p_as_of_date=>l_as_of_date,
443: p_operating_unit=>l_organization,
444: p_supplier=>l_supplier,

Line 496: FII_PMV_UTIL.bind_variable(

492: AND bitand(cal.record_type_id, :RECORD_TYPE_ID) = :RECORD_TYPE_ID
493: AND cal.report_date in (&BIS_CURRENT_ASOF_DATE)';
494:
495: -- Attach bind parameters
496: FII_PMV_UTIL.bind_variable(
497: p_sqlstmt=>sqlstmt,
498: p_page_parameter_tbl=>p_page_parameter_tbl,
499: p_sql_output=>kpi_sql,
500: p_bind_output_table=>kpi_output,

Line 538: FII_PMV_Util.Get_Parameters(

534: BEGIN
535:
536: -- Retrieve parameter info
537:
538: FII_PMV_Util.Get_Parameters(
539: p_page_parameter_tbl,
540: l_as_of_date,
541: l_operating_unit,
542: l_supplier,

Line 641: FII_PMV_Util.bind_variable(

637: &ORDER_BY_CLAUSE ' ;
638:
639: -- Binding Section
640:
641: FII_PMV_Util.bind_variable(
642: p_sqlstmt=> sqlstmt,
643: p_page_parameter_tbl=>p_page_parameter_tbl,
644: p_sql_output=>get_hold_sum_sql,
645: p_bind_output_table=>get_hold_sum_output,