APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on FND_DATE

Line 782: if nvl(fnd_date.canonical_to_date(p_start_date), to_date('01-01-1900', 'DD-MM-YYYY')) > nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')) then

778: return;
779:
780: end if;
781:
782: if nvl(fnd_date.canonical_to_date(p_start_date), to_date('01-01-1900', 'DD-MM-YYYY')) > nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')) then
783: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');
784: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');
785: retcode := -1;
786: return;

Line 804: populate_demantra_prl_table(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list, nvl(fnd_date.canonical_to_date(p_start_date),

800: retcode_store := retcode;
801:
802: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
803: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
804: populate_demantra_prl_table(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list, nvl(fnd_date.canonical_to_date(p_start_date),
805: to_date('01-01-1900', 'DD-MM-YYYY')), nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')));
806:
807: commit;
808:

Line 805: to_date('01-01-1900', 'DD-MM-YYYY')), nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')));

801:
802: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
803: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
804: populate_demantra_prl_table(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list, nvl(fnd_date.canonical_to_date(p_start_date),
805: to_date('01-01-1900', 'DD-MM-YYYY')), nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')));
806:
807: commit;
808:
809: