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

Line 36: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

310: p_custom_sql := l_sqltext;
311:
312: l_custom_rec.attribute_name := ':l_row_type';
313: l_custom_rec.attribute_value:= 'C';
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;

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

311:
312: l_custom_rec.attribute_name := ':l_row_type';
313: l_custom_rec.attribute_value:= 'C';
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;
319:

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

321: IF l_call_center IS NOT NULL
322: THEN
323: l_custom_rec.attribute_name := ':l_call_center';
324: l_custom_rec.attribute_value:= l_call_center;
325: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
326: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
327:
328: p_custom_output.Extend();
329: p_custom_output(p_custom_output.count) := l_custom_rec;

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

322: THEN
323: l_custom_rec.attribute_name := ':l_call_center';
324: l_custom_rec.attribute_value:= l_call_center;
325: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
326: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
327:
328: p_custom_output.Extend();
329: p_custom_output(p_custom_output.count) := l_custom_rec;
330: END IF;

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

332: IF l_campaign_id IS NOT NULL
333: THEN
334: l_custom_rec.attribute_name := ':l_campaign_id';
335: l_custom_rec.attribute_value:= l_campaign_id;
336: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
337: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
338:
339: p_custom_output.Extend();
340: p_custom_output(p_custom_output.count) := l_custom_rec;

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

333: THEN
334: l_custom_rec.attribute_name := ':l_campaign_id';
335: l_custom_rec.attribute_value:= l_campaign_id;
336: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
337: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
338:
339: p_custom_output.Extend();
340: p_custom_output(p_custom_output.count) := l_custom_rec;
341: END IF;

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

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

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

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

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

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

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

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

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

362: END IF;
363:
364: /*l_custom_rec.attribute_name := ':l_application_id';
365: l_custom_rec.attribute_value := 696;
366: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
368:
369: p_custom_output.EXTEND;
370: p_custom_output(p_custom_output.COUNT) := l_custom_rec;*/

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

363:
364: /*l_custom_rec.attribute_name := ':l_application_id';
365: l_custom_rec.attribute_value := 696;
366: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
368:
369: p_custom_output.EXTEND;
370: p_custom_output(p_custom_output.COUNT) := l_custom_rec;*/
371:

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

370: p_custom_output(p_custom_output.COUNT) := l_custom_rec;*/
371:
372: l_custom_rec.attribute_name := ':l_period_type_id';
373: l_custom_rec.attribute_value:= 1;
374: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
375: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
376:
377: p_custom_output.Extend();
378: p_custom_output(p_custom_output.count) := l_custom_rec;

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

371:
372: l_custom_rec.attribute_name := ':l_period_type_id';
373: l_custom_rec.attribute_value:= 1;
374: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
375: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
376:
377: p_custom_output.Extend();
378: p_custom_output(p_custom_output.count) := l_custom_rec;
379:

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

377: p_custom_output.Extend();
378: p_custom_output(p_custom_output.count) := l_custom_rec;
379:
380:
381: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
382: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
383: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
384:
385: p_custom_output.EXTEND;

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

378: p_custom_output(p_custom_output.count) := l_custom_rec;
379:
380:
381: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
382: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
383: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
384:
385: p_custom_output.EXTEND;
386: p_custom_output(p_custom_output.COUNT) := l_custom_rec;