DBA Data[Home] [Help]

APPS.FII_AP_PAY_MGT dependencies on FII_PMV_UTIL

Line 31: FII_PMV_UTIL.Get_Parameters(

27: l_supplier_WHERE VARCHAR2(240);
28: l_period_type VARCHAR2(240);
29: BEGIN
30:
31: FII_PMV_UTIL.Get_Parameters(
32: p_page_parameter_tbl,
33: l_as_of_date,
34: l_organization,
35: l_supplier,

Line 82: FII_PMV_UTIL.bind_variable(

78: AND t.multiplier in (1,2,3,4,5)
79: GROUP by t.multiplier';
80:
81:
82: FII_PMV_UTIL.bind_variable(
83: p_sqlstmt=>sqlstmt,
84: p_page_parameter_tbl=>p_page_parameter_tbl,
85: p_sql_output=>inv_graph_sql,
86: p_bind_output_table=>inv_graph_output,

Line 124: FII_PMV_UTIL.Get_Parameters(

120: l_paid_on_time_count VARCHAR2(240);
121: l_paid_late_count VARCHAR2(240);
122: BEGIN
123:
124: FII_PMV_UTIL.Get_Parameters(
125: p_page_parameter_tbl,
126: l_as_of_date,
127: l_organization,
128: l_supplier,

Line 142: l_paid_late_count := 'paid_late_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);

138: l_supplier_WHERE
139: );
140:
141:
142: l_paid_late_count := 'paid_late_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);
143: l_paid_on_time_count := 'paid_on_time_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);
144:
145:
146: /*------------------------------------------------------+

Line 143: l_paid_on_time_count := 'paid_on_time_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);

139: );
140:
141:
142: l_paid_late_count := 'paid_late_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);
143: l_paid_on_time_count := 'paid_on_time_count'||FII_PMV_UTIL.get_period_type_suffix (l_period_type);
144:
145:
146: /*------------------------------------------------------+
147: | FII_MEASURE1 - Prior Paid Late |

Line 197: FII_PMV_UTIL.bind_variable(

193: GROUP BY viewby_dim.value, viewby_dim.id
194: &ORDER_BY_CLAUSE';
195:
196:
197: FII_PMV_UTIL.bind_variable(
198: p_sqlstmt=>sqlstmt,
199: p_page_parameter_tbl=>p_page_parameter_tbl,
200: p_sql_output=>inv_graph_sql,
201: p_bind_output_table=>inv_graph_output,

Line 250: FII_PMV_Util.Get_Parameters(

246: l_viewby_string VARCHAR2(240);
247: l_gid NUMBER;
248: l_start_date DATE;
249: BEGIN
250: FII_PMV_Util.Get_Parameters(
251: p_page_parameter_tbl,
252: l_as_of_date,
253: l_organization,
254: l_supplier,

Line 685: inv_graph_rec.attribute_value := fii_pmv_util.get_sec_profile;

681: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
682: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
683: inv_graph_output.EXTEND;
684: inv_graph_rec.attribute_name := ':SEC_ID';
685: inv_graph_rec.attribute_value := fii_pmv_util.get_sec_profile;
686: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
687: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
688: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
689: inv_graph_output.EXTEND;

Line 739: FII_PMV_Util.Get_Parameters(

735:
736: l_start_date DATE;
737:
738: BEGIN
739: FII_PMV_Util.Get_Parameters(
740: p_page_parameter_tbl,
741: l_as_of_date,
742: l_organization,
743: l_supplier,

Line 892: l_period_suffix:=FII_PMV_UTIL.get_period_type_suffix(l_page_period_type);

888: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
889: elec_late_payment_output.EXTEND;
890: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
891:
892: l_period_suffix:=FII_PMV_UTIL.get_period_type_suffix(l_page_period_type);
893:
894: /*-----------------------------------------------------+
895: | FII_MEASURE1 - Electronic |
896: | FII_MEASURE2 - Prior Electronic |

Line 1498: elec_late_payment_rec.attribute_value := fii_pmv_util.get_sec_profile;

1494: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1495: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1496: elec_late_payment_output.EXTEND;
1497: elec_late_payment_rec.attribute_name := ':SEC_ID';
1498: elec_late_payment_rec.attribute_value := fii_pmv_util.get_sec_profile;
1499: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1500: elec_late_payment_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1501: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1502: elec_late_payment_output.EXTEND;

Line 1540: FII_PMV_UTIL.get_parameters(

1536: l_payment_count VARCHAR2(50);
1537:
1538: BEGIN
1539: -- Read the parameters passed
1540: FII_PMV_UTIL.get_parameters(
1541: p_page_parameter_tbl=>p_page_parameter_tbl,
1542: p_as_of_date=>l_as_of_date,
1543: p_operating_unit=>l_organization,
1544: p_supplier=>l_supplier,

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

1552: p_gid=>l_gid,
1553: p_org_where=>l_org_where,
1554: p_supplier_where=>l_sup_where);
1555:
1556: l_per_type := FII_PMV_Util.get_period_type_suffix(l_period_type);
1557: l_paid_inv_count :=
1558: 'paid_inv_count'||l_per_type;
1559:
1560: l_paid_on_time_count :=

Line 1727: FII_PMV_Util.bind_variable(

1723: WHERE f.id = viewby_dim.id';
1724:
1725:
1726: /* Binding Section */
1727: FII_PMV_Util.bind_variable(
1728: p_sqlstmt=>sqlstmt,
1729: p_page_parameter_tbl=>p_page_parameter_tbl,
1730: p_sql_output=>kpi_sql,
1731: p_bind_output_table=>kpi_output,