DBA Data[Home] [Help]

APPS.IBE_BI_PROD_CATG_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 72: BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

68: l_OrdBy VARCHAR2(2000);
69: l_var VARCHAR2(2000);
70: l_view_by VARCHAR2(3200);
71: l_custom_rec BIS_QUERY_ATTRIBUTES :=
72: BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
73: dbg_msg VARCHAR2(3200);
74:
75: l_gl_p VARCHAR2(15) := '''FII_GLOBAL1''';
76: l_gl_s VARCHAR2(15) := '''FII_GLOBAL2''';

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

322: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
323:
324: l_custom_rec.attribute_name := ':l_ccy' ;
325: l_custom_rec.attribute_value:= l_currency_code ;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328: x_custom_output.EXTEND;
329: x_custom_output(1) := l_custom_rec;
330:

Line 327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

323:
324: l_custom_rec.attribute_name := ':l_ccy' ;
325: l_custom_rec.attribute_value:= l_currency_code ;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328: x_custom_output.EXTEND;
329: x_custom_output(1) := l_custom_rec;
330:
331: l_custom_rec.attribute_name :=':l_gl_p' ;

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

329: x_custom_output(1) := l_custom_rec;
330:
331: l_custom_rec.attribute_name :=':l_gl_p' ;
332: l_custom_rec.attribute_value:= l_gl_p;
333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
335: x_custom_output.EXTEND;
336: x_custom_output(2) := l_custom_rec;
337:

Line 334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

330:
331: l_custom_rec.attribute_name :=':l_gl_p' ;
332: l_custom_rec.attribute_value:= l_gl_p;
333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
335: x_custom_output.EXTEND;
336: x_custom_output(2) := l_custom_rec;
337:
338: l_custom_rec.attribute_name := ':l_gl_s' ;

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

336: x_custom_output(2) := l_custom_rec;
337:
338: l_custom_rec.attribute_name := ':l_gl_s' ;
339: l_custom_rec.attribute_value:= l_gl_s;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output.EXTEND;
343: x_custom_output(3) := l_custom_rec;
344:

Line 341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

337:
338: l_custom_rec.attribute_name := ':l_gl_s' ;
339: l_custom_rec.attribute_value:= l_gl_s;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output.EXTEND;
343: x_custom_output(3) := l_custom_rec;
344:
345: