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.BIX_PMV_EMC_BKLG_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 32: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

28: l_view_by varchar2(1000);
29: l_row_type varchar2(10) := 'AC';
30: l_period_start_date date;
31:
32: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
33:
34: BEGIN
35: --
36: --Initialize p_custom_output

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

272:
273: p_custom_sql := l_sqltext;
274:
275: p_custom_output.EXTEND;
276: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
278: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
279: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
280:

Line 277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

273: p_custom_sql := l_sqltext;
274:
275: p_custom_output.EXTEND;
276: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
277: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
278: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
279: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
280:
281: p_custom_output.EXTEND();

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

280:
281: p_custom_output.EXTEND();
282: l_custom_rec.attribute_name := ':l_period_to_bind' ;
283: l_custom_rec.attribute_value:= l_period_to_bind;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
286: p_custom_output(p_custom_output.count) := l_custom_rec;
287:
288: p_custom_output.EXTEND();

Line 285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

281: p_custom_output.EXTEND();
282: l_custom_rec.attribute_name := ':l_period_to_bind' ;
283: l_custom_rec.attribute_value:= l_period_to_bind;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
286: p_custom_output(p_custom_output.count) := l_custom_rec;
287:
288: p_custom_output.EXTEND();
289: l_custom_rec.attribute_name := ':l_period_type_id' ;

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

287:
288: p_custom_output.EXTEND();
289: l_custom_rec.attribute_name := ':l_period_type_id' ;
290: l_custom_rec.attribute_value:= 1;
291: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
292: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
293: p_custom_output(p_custom_output.count) := l_custom_rec;
294:
295: IF ( l_account IS NOT NULL) THEN

Line 292: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

288: p_custom_output.EXTEND();
289: l_custom_rec.attribute_name := ':l_period_type_id' ;
290: l_custom_rec.attribute_value:= 1;
291: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
292: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
293: p_custom_output(p_custom_output.count) := l_custom_rec;
294:
295: IF ( l_account IS NOT NULL) THEN
296: l_custom_rec.attribute_name := ':l_account' ;

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

294:
295: IF ( l_account IS NOT NULL) THEN
296: l_custom_rec.attribute_name := ':l_account' ;
297: l_custom_rec.attribute_value:= l_account;
298: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
299: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
300:
301: p_custom_output.Extend();
302: p_custom_output(p_custom_output.count) := l_custom_rec;

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

295: IF ( l_account IS NOT NULL) THEN
296: l_custom_rec.attribute_name := ':l_account' ;
297: l_custom_rec.attribute_value:= l_account;
298: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
299: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
300:
301: p_custom_output.Extend();
302: p_custom_output(p_custom_output.count) := l_custom_rec;
303: END IF;

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

304:
305: IF ( l_classification IS NOT NULL) THEN
306: l_custom_rec.attribute_name := ':l_classification' ;
307: l_custom_rec.attribute_value:= l_classification;
308: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
309: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
310:
311: p_custom_output.Extend();
312: p_custom_output(p_custom_output.count) := l_custom_rec;

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

305: IF ( l_classification IS NOT NULL) THEN
306: l_custom_rec.attribute_name := ':l_classification' ;
307: l_custom_rec.attribute_value:= l_classification;
308: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
309: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
310:
311: p_custom_output.Extend();
312: p_custom_output(p_custom_output.count) := l_custom_rec;
313: END IF;

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

313: END IF;
314:
315: l_custom_rec.attribute_name := ':l_row_type' ;
316: l_custom_rec.attribute_value:= l_row_type;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
318: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
319:
320: p_custom_output.Extend();
321: p_custom_output(p_custom_output.count) := l_custom_rec;

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

314:
315: l_custom_rec.attribute_name := ':l_row_type' ;
316: l_custom_rec.attribute_value:= l_row_type;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
318: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
319:
320: p_custom_output.Extend();
321: p_custom_output(p_custom_output.count) := l_custom_rec;
322: