DBA Data[Home] [Help]

APPS.HZ_GNR_PKG dependencies on FND_DATE

Line 213: l_start_date := fnd_date.canonical_to_date(p_start_date);

209: END IF;
210:
211: l_from_location_id := to_number(p_from_location_id);
212: l_to_location_id := to_number(p_to_location_id);
213: l_start_date := fnd_date.canonical_to_date(p_start_date);
214: l_end_date := fnd_date.canonical_to_date(p_end_date);
215:
216:
217: -- Validate location range.

Line 214: l_end_date := fnd_date.canonical_to_date(p_end_date);

210:
211: l_from_location_id := to_number(p_from_location_id);
212: l_to_location_id := to_number(p_to_location_id);
213: l_start_date := fnd_date.canonical_to_date(p_start_date);
214: l_end_date := fnd_date.canonical_to_date(p_end_date);
215:
216:
217: -- Validate location range.
218: -- Both location id from and location id to should be not null

Line 888: l_start_date := fnd_date.canonical_to_date(p_start_date);

884: l_num_success_locations := 0;
885:
886: l_from_location_id := TO_NUMBER(p_from_location_id);
887: l_to_location_id := TO_NUMBER(p_to_location_id);
888: l_start_date := fnd_date.canonical_to_date(p_start_date);
889: l_end_date := fnd_date.canonical_to_date(p_end_date);
890: l_num_workers := TO_NUMBER(p_num_workers);
891: l_worker_number := TO_NUMBER(p_worker_number);
892: l_commit_size := NVL(fnd_profile.value('HZ_GNR_COMMIT_SIZE'),1000);

Line 889: l_end_date := fnd_date.canonical_to_date(p_end_date);

885:
886: l_from_location_id := TO_NUMBER(p_from_location_id);
887: l_to_location_id := TO_NUMBER(p_to_location_id);
888: l_start_date := fnd_date.canonical_to_date(p_start_date);
889: l_end_date := fnd_date.canonical_to_date(p_end_date);
890: l_num_workers := TO_NUMBER(p_num_workers);
891: l_worker_number := TO_NUMBER(p_worker_number);
892: l_commit_size := NVL(fnd_profile.value('HZ_GNR_COMMIT_SIZE'),1000);
893: l_run_type := NVL(p_run_type,'ALL'); -- Complete refresh for passed location ids