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_COPRHR_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 294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

290: p_custom_sql := l_sqltext;
291:
292: l_custom_rec.attribute_name := ':l_row_type';
293: l_custom_rec.attribute_value:= 'C';
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
295: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
296:
297: p_custom_output.Extend();
298: p_custom_output(p_custom_output.count) := l_custom_rec;

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

291:
292: l_custom_rec.attribute_name := ':l_row_type';
293: l_custom_rec.attribute_value:= 'C';
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
295: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
296:
297: p_custom_output.Extend();
298: p_custom_output(p_custom_output.count) := l_custom_rec;
299:

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

301: IF l_call_center IS NOT NULL
302: THEN
303: l_custom_rec.attribute_name := ':l_call_center';
304: l_custom_rec.attribute_value:= l_call_center;
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: THEN
303: l_custom_rec.attribute_name := ':l_call_center';
304: l_custom_rec.attribute_value:= l_call_center;
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: END IF;

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

312: IF l_campaign_id IS NOT NULL
313: THEN
314: l_custom_rec.attribute_name := ':l_campaign_id';
315: l_custom_rec.attribute_value:= l_campaign_id;
316: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
317: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
318:
319: p_custom_output.Extend();
320: p_custom_output(p_custom_output.count) := l_custom_rec;

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

313: THEN
314: l_custom_rec.attribute_name := ':l_campaign_id';
315: l_custom_rec.attribute_value:= l_campaign_id;
316: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
317: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
318:
319: p_custom_output.Extend();
320: p_custom_output(p_custom_output.count) := l_custom_rec;
321: END IF;

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

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

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

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

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

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

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

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

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

342: END IF;
343:
344: l_custom_rec.attribute_name := ':l_application_id';
345: l_custom_rec.attribute_value := 696;
346: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
348:
349: p_custom_output.EXTEND;
350: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

343:
344: l_custom_rec.attribute_name := ':l_application_id';
345: l_custom_rec.attribute_value := 696;
346: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
348:
349: p_custom_output.EXTEND;
350: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
351:

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

350: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
351:
352: l_custom_rec.attribute_name := ':l_period_type_id';
353: l_custom_rec.attribute_value:= 1;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
356:
357: p_custom_output.Extend();
358: p_custom_output(p_custom_output.count) := l_custom_rec;

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

351:
352: l_custom_rec.attribute_name := ':l_period_type_id';
353: l_custom_rec.attribute_value:= 1;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
356:
357: p_custom_output.Extend();
358: p_custom_output(p_custom_output.count) := l_custom_rec;
359:

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

357: p_custom_output.Extend();
358: p_custom_output(p_custom_output.count) := l_custom_rec;
359:
360:
361: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
362: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
363: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
364:
365: p_custom_output.EXTEND;

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

358: p_custom_output(p_custom_output.count) := l_custom_rec;
359:
360:
361: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
362: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
363: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
364:
365: p_custom_output.EXTEND;
366: p_custom_output(p_custom_output.COUNT) := l_custom_rec;