APPS.CSF_TASK_ADDRESS_PVT dependencies on FND_PROFILE

Line 129: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');

125: END IF;
126:
127: --
128: -- get date format
129: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');
130:
131: IF l_fmt IS NULL
132: THEN
133: l_fmt := 'dd-MON-yyyy';

Line 496: AND sp.spatial_dataset = fnd_profile.value('CSF_SPATIAL_DATASET_NAME')

492: AND t.location_id is not null
493: AND l.location_id = t.location_id
494: AND tl.territory_code = l.country
495: AND l.country = sp.hr_country_code
496: AND sp.spatial_dataset = fnd_profile.value('CSF_SPATIAL_DATASET_NAME')
497: AND tl.language = 'US'
498: AND t.source_object_type_code = 'SR'
499: AND t.deleted_flag <> 'Y'
500: AND tt.rule = 'DISPATCH'

Line 535: AND sp.spatial_dataset = fnd_profile.value('CSF_SPATIAL_DATASET_NAME')

531: AND t.address_id = hps.party_site_id
532: AND l.location_id = hps.location_id
533: AND tl.territory_code = l.country
534: AND l.country = sp.hr_country_code
535: AND sp.spatial_dataset = fnd_profile.value('CSF_SPATIAL_DATASET_NAME')
536: AND tl.language = 'US'
537: AND t.source_object_type_code = 'SR'
538: AND t.deleted_flag <> 'Y'
539: AND tt.rule = 'DISPATCH'

Line 567: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

563: x_return_status := fnd_api.g_ret_sts_success;
564: -- API body
565: i := 1;
566:
567: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
568:
569: IF (l_data_set_name IS NULL OR l_data_set_name = 'NONE' ) THEN
570: FOR i_retrieve_task_data IN c_retrieve_task_data_with_date
571: LOOP

Line 939: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

935: -- Initialize API return status to success
936: x_return_status := fnd_api.g_ret_sts_success;
937:
938:
939: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
940:
941: open ctry_hr_to_spatial;
942: fetch ctry_hr_to_spatial into l_country;
943: close ctry_hr_to_spatial;

Line 1235: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

1231: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1232: BEGIN
1233:
1234: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1235: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1236: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1237: IF (l_exp_accuracy_level = '0')
1238: THEN
1239: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

Line 1558: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

1554: THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1558: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
1559:
1560: open ctry_hr_to_spatial;
1561: fetch ctry_hr_to_spatial into l_country;
1562: close ctry_hr_to_spatial;

Line 1859: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

1855: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1856: BEGIN
1857:
1858: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1859: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1860: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1861: IF (l_exp_accuracy_level = '0')
1862: THEN
1863: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

Line 2546: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

2542: sql_stmt_str VARCHAR2(1000);
2543: l_data_set_name VARCHAR2(40);
2544: BEGIN
2545:
2546: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
2547: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
2548: l_data_set_name := '';
2549: END IF;
2550: sql_stmt_str := 'SELECT PLACE_ID, COUNTRY_CODE_A3 FROM csf_sdm_ctry_profiles'||l_data_set_name||'

Line 2567: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

2563: sql_stmt_str VARCHAR2(1000);
2564: l_data_set_name VARCHAR2(40);
2565: BEGIN
2566:
2567: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
2568: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
2569: l_data_set_name := '';
2570: END IF;
2571: