DBA Data[Home] [Help]

APPS.ENI_DBI_RVT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 215: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

211: AND t.start_date BETWEEN &BIS_CURRENT_REPORT_START_DATE
212: AND &BIS_CURRENT_ASOF_DATE
213: ' || l_order_by;
214:
215: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
216: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
217: x_custom_sql := l_stmt;
218:
219: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';

Line 221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

217: x_custom_sql := l_stmt;
218:
219: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
220: l_custom_rec.attribute_value := to_char( l_item_cat_flag );
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
223: x_custom_output.EXTEND;
224: x_custom_output(1) := l_custom_rec;
225:

Line 222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

218:
219: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
220: l_custom_rec.attribute_value := to_char( l_item_cat_flag );
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
223: x_custom_output.EXTEND;
224: x_custom_output(1) := l_custom_rec;
225:
226: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';

Line 228: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

224: x_custom_output(1) := l_custom_rec;
225:
226: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
227: l_custom_rec.attribute_value := to_char( l_cust_flag );
228: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
229: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
230: x_custom_output.EXTEND;
231: x_custom_output(2) := l_custom_rec;
232:

Line 229: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

225:
226: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
227: l_custom_rec.attribute_value := to_char( l_cust_flag );
228: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
229: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
230: x_custom_output.EXTEND;
231: x_custom_output(2) := l_custom_rec;
232:
233: l_custom_rec.attribute_name := ':ENI_REASON_FLAG';

Line 235: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

231: x_custom_output(2) := l_custom_rec;
232:
233: l_custom_rec.attribute_name := ':ENI_REASON_FLAG';
234: l_custom_rec.attribute_value := to_char( l_reason_flag );
235: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
236: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
237: x_custom_output.EXTEND;
238: x_custom_output(3) := l_custom_rec;
239:

Line 236: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

232:
233: l_custom_rec.attribute_name := ':ENI_REASON_FLAG';
234: l_custom_rec.attribute_value := to_char( l_reason_flag );
235: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
236: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
237: x_custom_output.EXTEND;
238: x_custom_output(3) := l_custom_rec;
239:
240: END get_sql;