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

Line 35: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

272: p_custom_sql := l_sqltext;
273:
274: l_custom_rec.attribute_name := ':l_row_type';
275: l_custom_rec.attribute_value:= 'C';
276: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
278:
279: p_custom_output.Extend();
280: p_custom_output(p_custom_output.count) := l_custom_rec;

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

273:
274: l_custom_rec.attribute_name := ':l_row_type';
275: l_custom_rec.attribute_value:= 'C';
276: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
278:
279: p_custom_output.Extend();
280: p_custom_output(p_custom_output.count) := l_custom_rec;
281:

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

280: p_custom_output(p_custom_output.count) := l_custom_rec;
281:
282: l_custom_rec.attribute_name := ':l_period_type_id';
283: l_custom_rec.attribute_value:= 1;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_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.NUMERIC_BIND;

281:
282: l_custom_rec.attribute_name := ':l_period_type_id';
283: l_custom_rec.attribute_value:= 1;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
286:
287: p_custom_output.Extend();
288: p_custom_output(p_custom_output.count) := l_custom_rec;
289:

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:
290: /*l_custom_rec.attribute_name := ':l_period_start_time';
291: l_custom_rec.attribute_value:= '00:00';
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_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.VARCHAR2_BIND;

289:
290: /*l_custom_rec.attribute_name := ':l_period_start_time';
291: l_custom_rec.attribute_value:= '00:00';
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;
297: */

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

299: IF l_call_center IS NOT NULL
300: THEN
301: l_custom_rec.attribute_name := ':l_call_center';
302: l_custom_rec.attribute_value:= l_call_center;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;

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

300: THEN
301: l_custom_rec.attribute_name := ':l_call_center';
302: l_custom_rec.attribute_value:= l_call_center;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
308: END IF;

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

310: IF l_campaign_id IS NOT NULL
311: THEN
312: l_custom_rec.attribute_name := ':l_campaign_id';
313: l_custom_rec.attribute_value:= l_campaign_id;
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: THEN
312: l_custom_rec.attribute_name := ':l_campaign_id';
313: l_custom_rec.attribute_value:= l_campaign_id;
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: END IF;

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

321: IF l_schedule_id IS NOT NULL
322: THEN
323: l_custom_rec.attribute_name := ':l_schedule_id';
324: l_custom_rec.attribute_value:= l_schedule_id;
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_schedule_id';
324: l_custom_rec.attribute_value:= l_schedule_id;
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 335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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

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

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

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

339: p_custom_output(p_custom_output.count) := l_custom_rec;
340: END IF;
341:
342:
343: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
344: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
345: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
346:
347: p_custom_output.EXTEND;

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

340: END IF;
341:
342:
343: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
344: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
345: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
346:
347: p_custom_output.EXTEND;
348: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

349:
350:
351: l_custom_rec.attribute_name := ':l_application_id';
352: l_custom_rec.attribute_value := 696;
353: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
355:
356: p_custom_output.EXTEND;
357: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

350:
351: l_custom_rec.attribute_name := ':l_application_id';
352: l_custom_rec.attribute_value := 696;
353: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
355:
356: p_custom_output.EXTEND;
357: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
358: