eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_PLAN_RM_TREND_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

158: LOOP
159: l_rpt_end_date := FII_TIME_API.next_period_end_date(l_rpt_end_date, l_period_type);
160: END LOOP;
161:
162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
163: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
164:
165: IF (l_plan IS NULL OR l_plan2 IS NULL)
166: THEN l_stmt := '

Line 242: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

238: END IF;
239:
240: x_custom_sql := l_stmt;
241:
242: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
243: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
244: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
245: x_custom_output.extend;
246: x_custom_output(1) := l_custom_rec;

Line 244: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

240: x_custom_sql := l_stmt;
241:
242: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
243: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
244: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
245: x_custom_output.extend;
246: x_custom_output(1) := l_custom_rec;
247:
248: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';

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

246: x_custom_output(1) := l_custom_rec;
247:
248: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
249: l_custom_rec.attribute_value := to_char(l_period_type_id);
250: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
252: x_custom_output.extend;
253: x_custom_output(2) := l_custom_rec;
254:

Line 251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

247:
248: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
249: l_custom_rec.attribute_value := to_char(l_period_type_id);
250: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
252: x_custom_output.extend;
253: x_custom_output(2) := l_custom_rec;
254:
255: l_custom_rec.attribute_name := ':ISC_TIME_FROM';

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

253: x_custom_output(2) := l_custom_rec;
254:
255: l_custom_rec.attribute_name := ':ISC_TIME_FROM';
256: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
257: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
259: x_custom_output.extend;
260: x_custom_output(3) := l_custom_rec;
261:

Line 258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

254:
255: l_custom_rec.attribute_name := ':ISC_TIME_FROM';
256: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
257: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
259: x_custom_output.extend;
260: x_custom_output(3) := l_custom_rec;
261:
262: l_custom_rec.attribute_name := ':ISC_RPT_END_DATE';

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

260: x_custom_output(3) := l_custom_rec;
261:
262: l_custom_rec.attribute_name := ':ISC_RPT_END_DATE';
263: l_custom_rec.attribute_value := to_char(l_rpt_end_date,'DD/MM/YYYY');
264: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
266: x_custom_output.extend;
267: x_custom_output(4) := l_custom_rec;
268:

Line 265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

261:
262: l_custom_rec.attribute_name := ':ISC_RPT_END_DATE';
263: l_custom_rec.attribute_value := to_char(l_rpt_end_date,'DD/MM/YYYY');
264: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
266: x_custom_output.extend;
267: x_custom_output(4) := l_custom_rec;
268:
269: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

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

267: x_custom_output(4) := l_custom_rec;
268:
269: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
270: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
271: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
273: x_custom_output.extend;
274: x_custom_output(5) := l_custom_rec;
275:

Line 272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

268:
269: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
270: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
271: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
273: x_custom_output.extend;
274: x_custom_output(5) := l_custom_rec;
275:
276: l_custom_rec.attribute_name := ':ISC_UNION1_FLAG';

Line 278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;

274: x_custom_output(5) := l_custom_rec;
275:
276: l_custom_rec.attribute_name := ':ISC_UNION1_FLAG';
277: l_custom_rec.attribute_value := to_char(l_union1_flag);
278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
280: x_custom_output.extend;
281: x_custom_output(6) := l_custom_rec;
282:

Line 279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;

275:
276: l_custom_rec.attribute_name := ':ISC_UNION1_FLAG';
277: l_custom_rec.attribute_value := to_char(l_union1_flag);
278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
280: x_custom_output.extend;
281: x_custom_output(6) := l_custom_rec;
282:
283: END Get_Sql;