401: if p_custom_output is null then
402: p_custom_output := bis_query_attributes_tbl();
403: end if;
404:
405: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
406:
407: l_custom_rec.attribute_name := '&BIV_AGE_LAG';
408: l_custom_rec.attribute_value := l_lag;
409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
405: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
406:
407: l_custom_rec.attribute_name := '&BIV_AGE_LAG';
408: l_custom_rec.attribute_value := l_lag;
409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
411: p_custom_output.extend;
412: p_custom_output(p_custom_output.count) := l_custom_rec;
413:
406:
407: l_custom_rec.attribute_name := '&BIV_AGE_LAG';
408: l_custom_rec.attribute_value := l_lag;
409: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
411: p_custom_output.extend;
412: p_custom_output(p_custom_output.count) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := '&BIV_CURR_PATTERN';
412: p_custom_output(p_custom_output.count) := l_custom_rec;
413:
414: l_custom_rec.attribute_name := '&BIV_CURR_PATTERN';
415: l_custom_rec.attribute_value := l_curr_pattern;
416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
418: p_custom_output.extend;
419: p_custom_output(p_custom_output.count) := l_custom_rec;
420:
413:
414: l_custom_rec.attribute_name := '&BIV_CURR_PATTERN';
415: l_custom_rec.attribute_value := l_curr_pattern;
416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
418: p_custom_output.extend;
419: p_custom_output(p_custom_output.count) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := '&BIV_PREV_PATTERN';
419: p_custom_output(p_custom_output.count) := l_custom_rec;
420:
421: l_custom_rec.attribute_name := '&BIV_PREV_PATTERN';
422: l_custom_rec.attribute_value := l_prev_pattern;
423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
425: p_custom_output.extend;
426: p_custom_output(p_custom_output.count) := l_custom_rec;
427:
420:
421: l_custom_rec.attribute_name := '&BIV_PREV_PATTERN';
422: l_custom_rec.attribute_value := l_prev_pattern;
423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
425: p_custom_output.extend;
426: p_custom_output(p_custom_output.count) := l_custom_rec;
427:
428: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_START_DATE';
426: p_custom_output(p_custom_output.count) := l_custom_rec;
427:
428: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_START_DATE';
429: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_start_date),'dd/mm/yyyy');
430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
432: p_custom_output.extend;
433: p_custom_output(p_custom_output.count) := l_custom_rec;
434:
427:
428: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_START_DATE';
429: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_start_date),'dd/mm/yyyy');
430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
432: p_custom_output.extend;
433: p_custom_output(p_custom_output.count) := l_custom_rec;
434:
435: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_END_DATE';
433: p_custom_output(p_custom_output.count) := l_custom_rec;
434:
435: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_END_DATE';
436: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_date),'dd/mm/yyyy');
437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
439: p_custom_output.extend;
440: p_custom_output(p_custom_output.count) := l_custom_rec;
441:
434:
435: l_custom_rec.attribute_name := '&BIV_CURR_EFFEC_END_DATE';
436: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_date),'dd/mm/yyyy');
437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
439: p_custom_output.extend;
440: p_custom_output(p_custom_output.count) := l_custom_rec;
441:
442: l_custom_rec.attribute_name := '&BIV_PREV_EFFEC_END_DATE';
440: p_custom_output(p_custom_output.count) := l_custom_rec;
441:
442: l_custom_rec.attribute_name := '&BIV_PREV_EFFEC_END_DATE';
443: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_prior_date),'dd/mm/yyyy');
444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
446: p_custom_output.extend;
447: p_custom_output(p_custom_output.count) := l_custom_rec;
448:
441:
442: l_custom_rec.attribute_name := '&BIV_PREV_EFFEC_END_DATE';
443: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_prior_date),'dd/mm/yyyy');
444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
446: p_custom_output.extend;
447: p_custom_output(p_custom_output.count) := l_custom_rec;
448:
449: l_custom_rec.attribute_name := '&BIV_LAST_REFRESH_DATE';
447: p_custom_output(p_custom_output.count) := l_custom_rec;
448:
449: l_custom_rec.attribute_name := '&BIV_LAST_REFRESH_DATE';
450: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(last_refresh_date),'dd/mm/yyyy');
451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
453: p_custom_output.extend;
454: p_custom_output(p_custom_output.count) := l_custom_rec;
455:
448:
449: l_custom_rec.attribute_name := '&BIV_LAST_REFRESH_DATE';
450: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(last_refresh_date),'dd/mm/yyyy');
451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
453: p_custom_output.extend;
454: p_custom_output(p_custom_output.count) := l_custom_rec;
455:
456: