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

Line 41: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

37:
38: l_unknown VARCHAR2(50);
39: l_view_by VARCHAR2(3000);
40:
41: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
42:
43: BEGIN
44: --
45: --Initialize p_custom_output

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

230: p_custom_sql := l_sqltext;
231:
232: l_custom_rec.attribute_name := ':l_row_type';
233: l_custom_rec.attribute_value:= 'C';
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
236:
237: p_custom_output.Extend();
238: p_custom_output(p_custom_output.count) := l_custom_rec;

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

231:
232: l_custom_rec.attribute_name := ':l_row_type';
233: l_custom_rec.attribute_value:= 'C';
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
236:
237: p_custom_output.Extend();
238: p_custom_output(p_custom_output.count) := l_custom_rec;
239:

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

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

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

239:
240: l_custom_rec.attribute_name := ':l_other_group' ;
241: l_custom_rec.attribute_value:= l_other_group;
242: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
243: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
244:
245: p_custom_output.Extend();
246: p_custom_output(p_custom_output.count) := l_custom_rec;
247:

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

248: IF l_call_center IS NOT NULL
249: THEN
250: l_custom_rec.attribute_name := ':l_call_center';
251: l_custom_rec.attribute_value:= l_call_center;
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254:
255: p_custom_output.Extend();
256: p_custom_output(p_custom_output.count) := l_custom_rec;

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

249: THEN
250: l_custom_rec.attribute_name := ':l_call_center';
251: l_custom_rec.attribute_value:= l_call_center;
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254:
255: p_custom_output.Extend();
256: p_custom_output(p_custom_output.count) := l_custom_rec;
257: END IF;

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

259: IF l_campaign_id IS NOT NULL
260: THEN
261: l_custom_rec.attribute_name := ':l_campaign_id';
262: l_custom_rec.attribute_value:= l_campaign_id;
263: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
264: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
265:
266: p_custom_output.Extend();
267: p_custom_output(p_custom_output.count) := l_custom_rec;

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

260: THEN
261: l_custom_rec.attribute_name := ':l_campaign_id';
262: l_custom_rec.attribute_value:= l_campaign_id;
263: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
264: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
265:
266: p_custom_output.Extend();
267: p_custom_output(p_custom_output.count) := l_custom_rec;
268: END IF;

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

270: IF l_schedule_id IS NOT NULL
271: THEN
272: l_custom_rec.attribute_name := ':l_schedule_id';
273: l_custom_rec.attribute_value:= l_schedule_id;
274: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
275: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
276:
277: p_custom_output.Extend();
278: p_custom_output(p_custom_output.count) := l_custom_rec;

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

271: THEN
272: l_custom_rec.attribute_name := ':l_schedule_id';
273: l_custom_rec.attribute_value:= l_schedule_id;
274: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
275: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
276:
277: p_custom_output.Extend();
278: p_custom_output(p_custom_output.count) := l_custom_rec;
279: END IF;

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

280: IF l_source_code_id IS NOT NULL
281: THEN
282: l_custom_rec.attribute_name := ':l_source_code_id';
283: l_custom_rec.attribute_value:= l_source_code_id;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
286:
287: p_custom_output.Extend();
288: p_custom_output(p_custom_output.count) := l_custom_rec;

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

281: THEN
282: l_custom_rec.attribute_name := ':l_source_code_id';
283: l_custom_rec.attribute_value:= l_source_code_id;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
286:
287: p_custom_output.Extend();
288: p_custom_output(p_custom_output.count) := l_custom_rec;
289: END IF;

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

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

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

289: END IF;
290: l_custom_rec.attribute_name := ':l_period_type_id';
291: l_custom_rec.attribute_value:= 1;
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;
297:

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

297:
298:
299: l_custom_rec.attribute_name := ':l_application_id';
300: l_custom_rec.attribute_value := 696;
301: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
302: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
303:
304: p_custom_output.EXTEND;
305: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

298:
299: l_custom_rec.attribute_name := ':l_application_id';
300: l_custom_rec.attribute_value := 696;
301: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
302: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
303:
304: p_custom_output.EXTEND;
305: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
306:

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

306:
307:
308: l_custom_rec.attribute_name := ':l_unknown';
309: l_custom_rec.attribute_value:= l_unknown;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312:
313: p_custom_output.EXTEND;
314: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

307:
308: l_custom_rec.attribute_name := ':l_unknown';
309: l_custom_rec.attribute_value:= l_unknown;
310: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
311: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
312:
313: p_custom_output.EXTEND;
314: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
315:

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

312:
313: p_custom_output.EXTEND;
314: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
315:
316: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
318: l_custom_rec.attribute_value := 'BIX_TELEPHONY+BIX_CALL_CENTER';
319:
320: p_custom_output.EXTEND;

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

313: p_custom_output.EXTEND;
314: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
315:
316: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
317: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
318: l_custom_rec.attribute_value := 'BIX_TELEPHONY+BIX_CALL_CENTER';
319:
320: p_custom_output.EXTEND;
321: p_custom_output(p_custom_output.COUNT) := l_custom_rec;