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

Line 38: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

34: BEGIN
35:
36: /* Initialize the variables */
37: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
38: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
39: l_where_clause := NULL;
40: l_call_center := NULL;
41: l_agent_group := NULL;
42:

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

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

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

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

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

381:
382: IF l_call_center IS NOT NULL THEN
383: l_custom_rec.attribute_name := ':l_call_center' ;
384: l_custom_rec.attribute_value:= l_call_center;
385: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
386: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
387:
388: p_custom_output.Extend();
389: p_custom_output(p_custom_output.count) := l_custom_rec;

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

382: IF l_call_center IS NOT NULL THEN
383: l_custom_rec.attribute_name := ':l_call_center' ;
384: l_custom_rec.attribute_value:= l_call_center;
385: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
386: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
387:
388: p_custom_output.Extend();
389: p_custom_output(p_custom_output.count) := l_custom_rec;
390: END IF;

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

392: IF l_campaign_id IS NOT NULL
393: THEN
394: l_custom_rec.attribute_name := ':l_campaign_id';
395: l_custom_rec.attribute_value:= l_campaign_id;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398:
399: p_custom_output.Extend();
400: p_custom_output(p_custom_output.count) := l_custom_rec;

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

393: THEN
394: l_custom_rec.attribute_name := ':l_campaign_id';
395: l_custom_rec.attribute_value:= l_campaign_id;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398:
399: p_custom_output.Extend();
400: p_custom_output(p_custom_output.count) := l_custom_rec;
401: END IF;

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

403: IF l_schedule_id IS NOT NULL
404: THEN
405: l_custom_rec.attribute_name := ':l_schedule_id';
406: l_custom_rec.attribute_value:= l_schedule_id;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409:
410: p_custom_output.Extend();
411: p_custom_output(p_custom_output.count) := l_custom_rec;

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

404: THEN
405: l_custom_rec.attribute_name := ':l_schedule_id';
406: l_custom_rec.attribute_value:= l_schedule_id;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409:
410: p_custom_output.Extend();
411: p_custom_output(p_custom_output.count) := l_custom_rec;
412: END IF;

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

413: IF l_source_code_id IS NOT NULL
414: THEN
415: l_custom_rec.attribute_name := ':l_source_code_id';
416: l_custom_rec.attribute_value:= l_source_code_id;
417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
418: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
419:
420: p_custom_output.Extend();
421: p_custom_output(p_custom_output.count) := l_custom_rec;

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

414: THEN
415: l_custom_rec.attribute_name := ':l_source_code_id';
416: l_custom_rec.attribute_value:= l_source_code_id;
417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
418: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
419:
420: p_custom_output.Extend();
421: p_custom_output(p_custom_output.count) := l_custom_rec;
422: END IF;