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_AO_ATWTR_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 34: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

30: l_view_by VARCHAR2(3000);
31:
32:
33:
34: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
35:
36: BEGIN
37: --
38: --Initialize p_custom_output

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

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

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

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

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

322: p_custom_output(p_custom_output.count) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':l_period_type_id';
325: l_custom_rec.attribute_value:= 1;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;

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

323:
324: l_custom_rec.attribute_name := ':l_period_type_id';
325: l_custom_rec.attribute_value:= 1;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;
331:

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

330: p_custom_output(p_custom_output.count) := l_custom_rec;
331:
332: /*l_custom_rec.attribute_name := ':l_period_start_time';
333: l_custom_rec.attribute_value:= '00:00';
334: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
335: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
336:
337: p_custom_output.Extend();
338: p_custom_output(p_custom_output.count) := l_custom_rec;

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

331:
332: /*l_custom_rec.attribute_name := ':l_period_start_time';
333: l_custom_rec.attribute_value:= '00:00';
334: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
335: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
336:
337: p_custom_output.Extend();
338: p_custom_output(p_custom_output.count) := l_custom_rec;
339: */

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

341: IF l_call_center IS NOT NULL
342: THEN
343: l_custom_rec.attribute_name := ':l_call_center';
344: l_custom_rec.attribute_value:= l_call_center;
345: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
346: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
347:
348: p_custom_output.Extend();
349: p_custom_output(p_custom_output.count) := l_custom_rec;

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

342: THEN
343: l_custom_rec.attribute_name := ':l_call_center';
344: l_custom_rec.attribute_value:= l_call_center;
345: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
346: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
347:
348: p_custom_output.Extend();
349: p_custom_output(p_custom_output.count) := l_custom_rec;
350: END IF;

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

352: IF l_campaign_id IS NOT NULL
353: THEN
354: l_custom_rec.attribute_name := ':l_campaign_id';
355: l_custom_rec.attribute_value:= l_campaign_id;
356: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
357: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
358:
359: p_custom_output.Extend();
360: p_custom_output(p_custom_output.count) := l_custom_rec;

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

353: THEN
354: l_custom_rec.attribute_name := ':l_campaign_id';
355: l_custom_rec.attribute_value:= l_campaign_id;
356: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
357: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
358:
359: p_custom_output.Extend();
360: p_custom_output(p_custom_output.count) := l_custom_rec;
361: END IF;

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

363: IF l_schedule_id IS NOT NULL
364: THEN
365: l_custom_rec.attribute_name := ':l_schedule_id';
366: l_custom_rec.attribute_value:= l_schedule_id;
367: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
369:
370: p_custom_output.Extend();
371: p_custom_output(p_custom_output.count) := l_custom_rec;

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

364: THEN
365: l_custom_rec.attribute_name := ':l_schedule_id';
366: l_custom_rec.attribute_value:= l_schedule_id;
367: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
369:
370: p_custom_output.Extend();
371: p_custom_output(p_custom_output.count) := l_custom_rec;
372: END IF;

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

373: IF l_source_code_id IS NOT NULL
374: THEN
375: l_custom_rec.attribute_name := ':l_source_code_id';
376: l_custom_rec.attribute_value:= l_source_code_id;
377: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
378: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
379:
380: p_custom_output.Extend();
381: p_custom_output(p_custom_output.count) := l_custom_rec;

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

374: THEN
375: l_custom_rec.attribute_name := ':l_source_code_id';
376: l_custom_rec.attribute_value:= l_source_code_id;
377: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
378: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
379:
380: p_custom_output.Extend();
381: p_custom_output(p_custom_output.count) := l_custom_rec;
382: END IF;

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

381: p_custom_output(p_custom_output.count) := l_custom_rec;
382: END IF;
383:
384:
385: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
387: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
388:
389: p_custom_output.EXTEND;

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

382: END IF;
383:
384:
385: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
387: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
388:
389: p_custom_output.EXTEND;
390: p_custom_output(p_custom_output.COUNT) := l_custom_rec;