DBA Data[Home] [Help]

APPS.BIV_DBI_BAK_AGE_PKG dependencies on FND_DATE

Line 429: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_start_date),'dd/mm/yyyy');

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

Line 436: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_current_date),'dd/mm/yyyy');

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

Line 443: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(l_prior_date),'dd/mm/yyyy');

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

Line 450: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(last_refresh_date),'dd/mm/yyyy');

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

Line 1169: , fnd_date.date_to_displaydate(fact.incident_date) biv_measure12' ||

1165: , st.value biv_measure8 -- status
1166: , decode(fact.escalated_date,null,&NO,&YES) biv_measure9
1167: , decode(fact.unowned_date,null,&NO,&YES) biv_measure10
1168: , fact.age biv_measure11
1169: , fnd_date.date_to_displaydate(fact.incident_date) biv_measure12' ||
1170: case
1171: when l_drill_url is not null then
1172: '
1173: , ''pFunctionName=' || l_drill_url || '&' || l_sr_id || '=''||fact.incident_id biv_attribute1'