DBA Data[Home] [Help]

APPS.FII_AP_PAID_INV_ACTIVITY dependencies on FII_PMV_UTIL

Line 35: FII_PMV_Util.Get_Parameters(

31: l_url_4 VARCHAR2(10000);
32: l_url_2 VARCHAR2(10000);
33: l_url_3 VARCHAR2(10000);
34: BEGIN
35: FII_PMV_Util.Get_Parameters(
36: p_page_parameter_tbl,
37: l_as_of_date,
38: l_operating_unit,
39: l_supplier,

Line 51: l_period_type_str := FII_PMV_Util.get_period_type_suffix(l_period_type);

47: l_gid,
48: l_org_where,
49: l_supplier_where
50: );
51: l_period_type_str := FII_PMV_Util.get_period_type_suffix(l_period_type);
52: l_paid_inv_count := 'paid_inv_count'||l_period_type_str;
53: l_paid_on_time := 'paid_on_time_count'||l_period_type_str;
54: l_paid_late := 'paid_late_count'||l_period_type_str;
55: l_payment_count := 'payment_count'||l_period_type_str;

Line 346: FII_PMV_Util.bind_variable(

342: group by VIEWBY, VIEWBYID
343: &ORDER_BY_CLAUSE';
344:
345: /* Binding Section */
346: FII_PMV_Util.bind_variable(
347: p_sqlstmt=>sqlstmt,
348: p_page_parameter_tbl=>p_page_parameter_tbl,
349: p_sql_output=>paid_invoice_sql,
350: p_bind_output_table=>paid_invoice_output,

Line 384: FII_PMV_Util.Get_Parameters(

380:
381: l_url_1 VARCHAR2(1000);
382: l_url_4 VARCHAR2(1000);
383: BEGIN
384: FII_PMV_Util.Get_Parameters(
385: p_page_parameter_tbl,
386: l_as_of_date,
387: l_operating_unit,
388: l_supplier,

Line 401: l_per_type := FII_PMV_Util.get_period_type_suffix(l_period_type);

397: l_org_where,
398: l_supplier_where
399: );
400:
401: l_per_type := FII_PMV_Util.get_period_type_suffix(l_period_type);
402:
403: /**************Description of Measures, Attributes returned to PMV *****
404: FII_MEASURE1 - Paid Amount,(Payments)
405: FII_MEASURE2 - Prior Paid amount,(Payments)

Line 616: FII_PMV_Util.bind_variable(

612: group by viewby_dim.value, viewby_dim.id
613: &ORDER_BY_CLAUSE';
614:
615: /* Binding Section */
616: FII_PMV_Util.bind_variable(
617: p_sqlstmt=>sqlstmt,
618: p_page_parameter_tbl=>p_page_parameter_tbl,
619: p_sql_output=>paid_invoice_sql,
620: p_bind_output_table=>paid_invoice_output,