DBA Data[Home] [Help]

APPS.ENI_DBI_TOB_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 23: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

19: l_custom_rec BIS_QUERY_ATTRIBUTES;
20:
21: BEGIN
22:
23: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
24: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
25:
26: -- Ideally we should be calling ENI_DBI_UTIL_PKG.get_parameters(..) . But since we are concerned with only
27: -- the following three parameters, looping through the parameters table here, instead.

Line 67: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

63: AND edh.child_id = fact.item_category_id ';
64: l_from := ' , eni_denorm_hierarchies edh ';
65: l_custom_rec.attribute_name := ':CATEGORY';
66: l_custom_rec.attribute_value := l_category;
67: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
68: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
69: x_custom_output.extend;
70: x_custom_output(1) := l_custom_rec;
71: END IF;

Line 68: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

64: l_from := ' , eni_denorm_hierarchies edh ';
65: l_custom_rec.attribute_name := ':CATEGORY';
66: l_custom_rec.attribute_value := l_category;
67: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
68: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
69: x_custom_output.extend;
70: x_custom_output(1) := l_custom_rec;
71: END IF;
72: END IF;