APPS.BIV_DBI_COLLECTION_INC dependencies on FND_DATE

Line 736: fnd_date.date_to_displaydt(p_collect_from_date) ||

732:
733: if p_collect_from_date <> trunc(p_collect_from_date) then
734:
735: bis_collection_utilities.log('Merge activity from ' ||
736: fnd_date.date_to_displaydt(p_collect_from_date) ||
737: ' to ' ||
738: fnd_date.date_to_displaydt(least(p_collect_to_date
739: ,trunc(p_collect_from_date)+(86399/86400)))
740: ,1);

Line 738: fnd_date.date_to_displaydt(least(p_collect_to_date

734:
735: bis_collection_utilities.log('Merge activity from ' ||
736: fnd_date.date_to_displaydt(p_collect_from_date) ||
737: ' to ' ||
738: fnd_date.date_to_displaydt(least(p_collect_to_date
739: ,trunc(p_collect_from_date)+(86399/86400)))
740: ,1);
741:
742: merge

Line 860: fnd_date.date_to_displaydt(trunc(p_collect_from_date-(1/86400))+1) ||

856: if trunc(p_collect_to_date) >= trunc(p_collect_from_date) and
857: trunc(p_collect_from_date-(1/86400))+1 <= p_collect_to_date then
858:
859: bis_collection_utilities.log('Insert activity from ' ||
860: fnd_date.date_to_displaydt(trunc(p_collect_from_date-(1/86400))+1) ||
861: ' to ' ||
862: fnd_date.date_to_displaydt(p_collect_to_date)
863: ,1);
864: insert

Line 862: fnd_date.date_to_displaydt(p_collect_to_date)

858:
859: bis_collection_utilities.log('Insert activity from ' ||
860: fnd_date.date_to_displaydt(trunc(p_collect_from_date-(1/86400))+1) ||
861: ' to ' ||
862: fnd_date.date_to_displaydt(p_collect_to_date)
863: ,1);
864: insert
865: into biv_dbi_activity_sum_f a
866: ( activity_date

Line 1715: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

1711:
1712: if l_success_flag = 'N' then
1713:
1714: bis_collection_utilities.log('Resuming previous incomplete Incremental Load');
1715: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1716: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1717:
1718: l_process_success := process_incremental( l_log_rowid
1719: , l_collect_from_date

Line 1716: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

1712: if l_success_flag = 'N' then
1713:
1714: bis_collection_utilities.log('Resuming previous incomplete Incremental Load');
1715: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1716: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1717:
1718: l_process_success := process_incremental( l_log_rowid
1719: , l_collect_from_date
1720: , l_collect_to_date

Line 1801: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

1797: )
1798: returning rowid into l_log_rowid;
1799:
1800: bis_collection_utilities.log('Starting new Initial Load');
1801: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1802: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1803:
1804: commit;
1805:

Line 1802: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

1798: returning rowid into l_log_rowid;
1799:
1800: bis_collection_utilities.log('Starting new Initial Load');
1801: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1802: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1803:
1804: commit;
1805:
1806: l_process_success := process_incremental( l_log_rowid