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 1302: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)

1298: l_msg_data VARCHAR2 (32767);
1299: l_error VARCHAR2 (2000);
1300: l_error_detail VARCHAR2 (2000);
1301:
1302: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
1303: IS
1304: SELECT task_id
1305: FROM csf_ext_locations
1306: WHERE task_id = l_task_id;

Line 1305: FROM csf_ext_locations

1301:
1302: CURSOR c_check_ext_locations (l_task_id csf_ext_locations.task_id%TYPE)
1303: IS
1304: SELECT task_id
1305: FROM csf_ext_locations
1306: WHERE task_id = l_task_id;
1307:
1308: l_location_id hz_locations.location_id%TYPE;
1309: l_task_id csf_ext_locations.task_id%TYPE;

Line 1309: l_task_id csf_ext_locations.task_id%TYPE;

1305: FROM csf_ext_locations
1306: WHERE task_id = l_task_id;
1307:
1308: l_location_id hz_locations.location_id%TYPE;
1309: l_task_id csf_ext_locations.task_id%TYPE;
1310: BEGIN
1311: -- Standard check for call compatibility
1312: IF NOT fnd_api.compatible_api_call (l_api_version,
1313: p_api_version,

Line 2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,

2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2148: p_timezone_id IN hz_locations.timezone_id%TYPE,
2149: x_return_status OUT NOCOPY VARCHAR2,
2150: x_msg_count OUT NOCOPY NUMBER,

Line 2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,

2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2148: p_timezone_id IN hz_locations.timezone_id%TYPE,
2149: x_return_status OUT NOCOPY VARCHAR2,
2150: x_msg_count OUT NOCOPY NUMBER,
2151: x_msg_data OUT NOCOPY VARCHAR2

Line 2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;

2152: )
2153: IS
2154: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_ADDRESS';
2155: l_api_version CONSTANT NUMBER := 1.0;
2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2158: l_country_code hz_locations.country%TYPE;
2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)

Line 2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;

2153: IS
2154: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_ADDRESS';
2155: l_api_version CONSTANT NUMBER := 1.0;
2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2158: l_country_code hz_locations.country%TYPE;
2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2161: IS

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

2420: l_msg_data VARCHAR2 (32767);
2421: l_error VARCHAR2 (2000);
2422: l_error_detail VARCHAR2 (2000);
2423:
2424: CURSOR c_check_ext_locations (l_location_id csf_ext_locations.location_id%TYPE)
2425: IS
2426: SELECT task_id
2427: FROM csf_ext_locations
2428: WHERE location_id = l_location_id

Line 2427: FROM csf_ext_locations

2423:
2424: CURSOR c_check_ext_locations (l_location_id csf_ext_locations.location_id%TYPE)
2425: IS
2426: SELECT task_id
2427: FROM csf_ext_locations
2428: WHERE location_id = l_location_id
2429: AND validated_flag = 'N'
2430: AND override_flag = 'N';
2431:

Line 2432: l_location_id csf_ext_locations.location_id%TYPE;

2428: WHERE location_id = l_location_id
2429: AND validated_flag = 'N'
2430: AND override_flag = 'N';
2431:
2432: l_location_id csf_ext_locations.location_id%TYPE;
2433: l_task_id csf_ext_locations.task_id%TYPE;
2434: BEGIN
2435: -- Standard check for call compatibility
2436: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 2433: l_task_id csf_ext_locations.task_id%TYPE;

2429: AND validated_flag = 'N'
2430: AND override_flag = 'N';
2431:
2432: l_location_id csf_ext_locations.location_id%TYPE;
2433: l_task_id csf_ext_locations.task_id%TYPE;
2434: BEGIN
2435: -- Standard check for call compatibility
2436: IF NOT fnd_api.compatible_api_call (l_api_version,
2437: p_api_version,