eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASK_ADDRESS_PVT dependencies on CSF_EXT_LOCATIONS

Line 433: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)

429: l_error VARCHAR2 (2000);
430: l_error_detail VARCHAR2 (2000);
431: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
432:
433: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
434: IS
435: SELECT task_id
436: FROM csf_ext_locations
437: WHERE task_id = l_task_id;

Line 436: FROM csf_ext_locations

432:
433: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
434: IS
435: SELECT task_id
436: FROM csf_ext_locations
437: WHERE task_id = l_task_id;
438:
439: l_location_id hz_locations.location_id%TYPE;
440: l_task_id csf_ext_locations.task_id%TYPE;

Line 440: l_task_id csf_ext_locations.task_id%TYPE;

436: FROM csf_ext_locations
437: WHERE task_id = l_task_id;
438:
439: l_location_id hz_locations.location_id%TYPE;
440: l_task_id csf_ext_locations.task_id%TYPE;
441: BEGIN
442: -- Standard check for call compatibility
443: IF NOT fnd_api.compatible_api_call (l_api_version,
444: p_api_version,

Line 1668: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)

1664: l_msg_data VARCHAR2 (32767);
1665: l_error VARCHAR2 (2000);
1666: l_error_detail VARCHAR2 (2000);
1667:
1668: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
1669: IS
1670: SELECT task_id
1671: FROM csf_ext_locations
1672: WHERE task_id = l_task_id;

Line 1671: FROM csf_ext_locations

1667:
1668: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
1669: IS
1670: SELECT task_id
1671: FROM csf_ext_locations
1672: WHERE task_id = l_task_id;
1673:
1674: l_location_id hz_locations.location_id%TYPE;
1675: l_task_id csf_ext_locations.task_id%TYPE;

Line 1675: l_task_id csf_ext_locations.task_id%TYPE;

1671: FROM csf_ext_locations
1672: WHERE task_id = l_task_id;
1673:
1674: l_location_id hz_locations.location_id%TYPE;
1675: l_task_id csf_ext_locations.task_id%TYPE;
1676: BEGIN
1677: -- Standard check for call compatibility
1678: IF NOT fnd_api.compatible_api_call (l_api_version,
1679: p_api_version,

Line 2600: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,

2596: p_state IN hz_locations.state%TYPE,
2597: p_province IN hz_locations.province%TYPE,
2598: p_county IN hz_locations.county%TYPE,
2599: p_country IN hz_locations.country%TYPE,
2600: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2601: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2602: p_timezone_id IN hz_locations.timezone_id%TYPE,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,

Line 2601: p_override_flag IN csf_ext_locations.override_flag%TYPE,

2597: p_province IN hz_locations.province%TYPE,
2598: p_county IN hz_locations.county%TYPE,
2599: p_country IN hz_locations.country%TYPE,
2600: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2601: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2602: p_timezone_id IN hz_locations.timezone_id%TYPE,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2

Line 2610: l_short_msg csf_ext_locations.log_detail_short%TYPE;

2606: )
2607: IS
2608: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_ADDRESS';
2609: l_api_version CONSTANT NUMBER := 1.0;
2610: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2611: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2612: l_country_code hz_locations.country%TYPE;
2613: l_country hz_locations.country%TYPE;
2614: CURSOR c_country_code (p_country hz_locations.country%TYPE)

Line 2611: l_long_msg csf_ext_locations.log_detail_long%TYPE;

2607: IS
2608: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_ADDRESS';
2609: l_api_version CONSTANT NUMBER := 1.0;
2610: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2611: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2612: l_country_code hz_locations.country%TYPE;
2613: l_country hz_locations.country%TYPE;
2614: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2615: IS

Line 2878: CURSOR c_check_ext_locations (l_location_id csf_ext_locations.location_id%TYPE)

2874: l_msg_data VARCHAR2 (32767);
2875: l_error VARCHAR2 (2000);
2876: l_error_detail VARCHAR2 (2000);
2877:
2878: CURSOR c_check_ext_locations (l_location_id csf_ext_locations.location_id%TYPE)
2879: IS
2880: SELECT task_id
2881: FROM csf_ext_locations
2882: WHERE location_id = l_location_id

Line 2881: FROM csf_ext_locations

2877:
2878: CURSOR c_check_ext_locations (l_location_id csf_ext_locations.location_id%TYPE)
2879: IS
2880: SELECT task_id
2881: FROM csf_ext_locations
2882: WHERE location_id = l_location_id
2883: AND validated_flag = 'N'
2884: AND override_flag = 'N';
2885:

Line 2886: l_location_id csf_ext_locations.location_id%TYPE;

2882: WHERE location_id = l_location_id
2883: AND validated_flag = 'N'
2884: AND override_flag = 'N';
2885:
2886: l_location_id csf_ext_locations.location_id%TYPE;
2887: l_task_id csf_ext_locations.task_id%TYPE;
2888: BEGIN
2889: -- Standard check for call compatibility
2890: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 2887: l_task_id csf_ext_locations.task_id%TYPE;

2883: AND validated_flag = 'N'
2884: AND override_flag = 'N';
2885:
2886: l_location_id csf_ext_locations.location_id%TYPE;
2887: l_task_id csf_ext_locations.task_id%TYPE;
2888: BEGIN
2889: -- Standard check for call compatibility
2890: IF NOT fnd_api.compatible_api_call (l_api_version,
2891: p_api_version,