DBA Data[Home] [Help]

APPS.BIV_DBI_BAK_AGE_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 405: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

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;

Line 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:

Line 410: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

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';

Line 416: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 417: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

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';

Line 423: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 424: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

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';

Line 430: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 431: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

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';

Line 437: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 438: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

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';

Line 444: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 445: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

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';

Line 451: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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:

Line 452: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

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: