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

Line 30: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

26: l_dnis VARCHAR2(3000);
27: l_unknown VARCHAR2(50);
28: l_view_by VARCHAR2(3000);
29:
30: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
31:
32: BEGIN
33: --
34: --Initialize p_custom_output

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

236: p_custom_sql := l_sqltext;
237:
238: l_custom_rec.attribute_name := ':l_row_type';
239: l_custom_rec.attribute_value:= 'CDR';
240: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
241: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
242:
243: p_custom_output.Extend();
244: p_custom_output(p_custom_output.count) := l_custom_rec;

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

237:
238: l_custom_rec.attribute_name := ':l_row_type';
239: l_custom_rec.attribute_value:= 'CDR';
240: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
241: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
242:
243: p_custom_output.Extend();
244: p_custom_output(p_custom_output.count) := l_custom_rec;
245:

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

244: p_custom_output(p_custom_output.count) := l_custom_rec;
245:
246: l_custom_rec.attribute_name := ':l_other_group' ;
247: l_custom_rec.attribute_value:= l_other_group;
248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
250:
251: p_custom_output.Extend();
252: p_custom_output(p_custom_output.count) := l_custom_rec;

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

245:
246: l_custom_rec.attribute_name := ':l_other_group' ;
247: l_custom_rec.attribute_value:= l_other_group;
248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
250:
251: p_custom_output.Extend();
252: p_custom_output(p_custom_output.count) := l_custom_rec;
253:

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

254: IF l_call_center IS NOT NULL
255: THEN
256: l_custom_rec.attribute_name := ':l_call_center';
257: l_custom_rec.attribute_value:= l_call_center;
258: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
260:
261: p_custom_output.Extend();
262: p_custom_output(p_custom_output.count) := l_custom_rec;

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

255: THEN
256: l_custom_rec.attribute_name := ':l_call_center';
257: l_custom_rec.attribute_value:= l_call_center;
258: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
260:
261: p_custom_output.Extend();
262: p_custom_output(p_custom_output.count) := l_custom_rec;
263: END IF;

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

265: IF l_classification IS NOT NULL
266: THEN
267: l_custom_rec.attribute_name := ':l_classification';
268: l_custom_rec.attribute_value:= l_classification;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
271:
272: p_custom_output.EXTEND;
273: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

266: THEN
267: l_custom_rec.attribute_name := ':l_classification';
268: l_custom_rec.attribute_value:= l_classification;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
271:
272: p_custom_output.EXTEND;
273: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
274: END IF;

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

276: IF l_dnis IS NOT NULL AND l_dnis NOT IN ('INBOUND','OUTBOUND')
277: THEN
278: l_custom_rec.attribute_name := ':l_dnis';
279: l_custom_rec.attribute_value:= l_dnis;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;

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

277: THEN
278: l_custom_rec.attribute_name := ':l_dnis';
279: l_custom_rec.attribute_value:= l_dnis;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;
285: END IF;

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

285: END IF;
286:
287: l_custom_rec.attribute_name := ':l_period_type_id';
288: l_custom_rec.attribute_value:= 1;
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
291:
292: p_custom_output.Extend();
293: p_custom_output(p_custom_output.count) := l_custom_rec;

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

286:
287: l_custom_rec.attribute_name := ':l_period_type_id';
288: l_custom_rec.attribute_value:= 1;
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
291:
292: p_custom_output.Extend();
293: p_custom_output(p_custom_output.count) := l_custom_rec;
294:

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

293: p_custom_output(p_custom_output.count) := l_custom_rec;
294:
295: l_custom_rec.attribute_name := ':l_period_start_time';
296: l_custom_rec.attribute_value:= '00:00';
297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
299:
300: p_custom_output.EXTEND;
301: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

294:
295: l_custom_rec.attribute_name := ':l_period_start_time';
296: l_custom_rec.attribute_value:= '00:00';
297: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
298: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
299:
300: p_custom_output.EXTEND;
301: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
302:

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

301: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
302:
303: l_custom_rec.attribute_name := ':l_unknown';
304: l_custom_rec.attribute_value:= l_unknown;
305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
307:
308: p_custom_output.EXTEND;
309: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

302:
303: l_custom_rec.attribute_name := ':l_unknown';
304: l_custom_rec.attribute_value:= l_unknown;
305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
307:
308: p_custom_output.EXTEND;
309: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
310:

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

307:
308: p_custom_output.EXTEND;
309: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
310:
311: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
313: l_custom_rec.attribute_value := 'BIX_TELEPHONY+BIX_CALL_CENTER';
314:
315: p_custom_output.EXTEND;

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

308: p_custom_output.EXTEND;
309: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
310:
311: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
313: l_custom_rec.attribute_value := 'BIX_TELEPHONY+BIX_CALL_CENTER';
314:
315: p_custom_output.EXTEND;
316: p_custom_output(p_custom_output.COUNT) := l_custom_rec;