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 HZ_LOCATIONS

Line 49: UPDATE hz_locations

45: PROCEDURE update_geometry (p_location_id IN NUMBER)
46: IS
47: PRAGMA AUTONOMOUS_TRANSACTION;
48: BEGIN
49: UPDATE hz_locations
50: SET geometry = NULL
51: WHERE location_id = p_location_id;
52:
53: COMMIT;

Line 439: l_location_id hz_locations.location_id%TYPE;

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;
441: BEGIN
442: -- Standard check for call compatibility
443: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 691: location_id hz_locations.location_id%TYPE,

687:
688: TYPE task_address_rec_type IS RECORD (
689: task_id jtf_tasks_b.task_id%TYPE,
690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,

Line 692: address_style hz_locations.address_style%TYPE,

688: TYPE task_address_rec_type IS RECORD (
689: task_id jtf_tasks_b.task_id%TYPE,
690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,

Line 693: address1 hz_locations.address1%TYPE,

689: task_id jtf_tasks_b.task_id%TYPE,
690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,

Line 694: address2 hz_locations.address2%TYPE,

690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,

Line 695: address3 hz_locations.address3%TYPE,

691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,

Line 696: address4 hz_locations.address4%type,

692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,

Line 697: city hz_locations.city%TYPE,

693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,

Line 698: postal_code hz_locations.postal_code%TYPE,

694: address2 hz_locations.address2%TYPE,
695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,

Line 699: county hz_locations.county%TYPE,

695: address3 hz_locations.address3%TYPE,
696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,
703: country_code VARCHAR2 (30),

Line 700: state hz_locations.state%TYPE,

696: address4 hz_locations.address4%type,
697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,
703: country_code VARCHAR2 (30),
704: timezone_id hz_locations.timezone_id%type

Line 701: province hz_locations.province%TYPE,

697: city hz_locations.city%TYPE,
698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,
703: country_code VARCHAR2 (30),
704: timezone_id hz_locations.timezone_id%type
705: );

Line 702: country hz_locations.country%TYPE,

698: postal_code hz_locations.postal_code%TYPE,
699: county hz_locations.county%TYPE,
700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,
703: country_code VARCHAR2 (30),
704: timezone_id hz_locations.timezone_id%type
705: );
706:

Line 704: timezone_id hz_locations.timezone_id%type

700: state hz_locations.state%TYPE,
701: province hz_locations.province%TYPE,
702: country hz_locations.country%TYPE,
703: country_code VARCHAR2 (30),
704: timezone_id hz_locations.timezone_id%type
705: );
706:
707: i_retrieve_task_data task_address_rec_type;
708: BEGIN

Line 730: hz_locations l,

726: l.country country_code,
727: l.timezone_id
728: FROM jtf_tasks_b t,
729: jtf_task_types_b tt,
730: hz_locations l,
731: fnd_territories_tl tl,
732: jtf_task_statuses_vl jts,
733: csf_sdm_ctry_profiles' || p_dataset || ' cp,
734: csf_spatial_ctry_mappings cm

Line 774: hz_locations l,

770: l.timezone_id
771: FROM jtf_tasks_b t,
772: jtf_task_types_b tt,
773: hz_party_sites hps,
774: hz_locations l,
775: fnd_territories_tl tl,
776: jtf_task_statuses_vl jts,
777: csf_sdm_ctry_profiles' || p_dataset || ' cp,
778: csf_spatial_ctry_mappings cm

Line 817: hz_locations l,

813: l.country country_code,
814: l.timezone_id
815: FROM jtf_tasks_b t,
816: jtf_task_types_b tt,
817: hz_locations l,
818: fnd_territories_tl tl,
819: jtf_task_statuses_vl jts,
820: csf_odf_ctry_mapping coc
821: WHERE tt.task_type_id = t.task_type_id

Line 859: hz_locations l,

855: l.timezone_id
856: FROM jtf_tasks_b t,
857: jtf_task_types_b tt,
858: hz_party_sites hps,
859: hz_locations l,
860: fnd_territories_tl tl,
861: jtf_task_statuses_vl jts,
862: csf_odf_ctry_mapping coc
863: WHERE tt.task_type_id = t.task_type_id

Line 1027: returns the locus given the location_id from the hz locations table

1023: END retrieve_data;
1024:
1025: /*
1026: Utility procedure to fetch the locus for a location id.
1027: returns the locus given the location_id from the hz locations table
1028: */
1029: PROCEDURE get_geometry (
1030: p_api_version IN NUMBER,
1031: p_init_msg_list IN VARCHAR2,

Line 1034: p_location_id IN hz_locations.location_id%TYPE,

1030: p_api_version IN NUMBER,
1031: p_init_msg_list IN VARCHAR2,
1032: p_commit IN VARCHAR2,
1033: p_validation_level IN NUMBER,
1034: p_location_id IN hz_locations.location_id%TYPE,
1035: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2,
1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2

Line 1035: x_locus OUT NOCOPY hz_locations.geometry%TYPE,

1031: p_init_msg_list IN VARCHAR2,
1032: p_commit IN VARCHAR2,
1033: p_validation_level IN NUMBER,
1034: p_location_id IN hz_locations.location_id%TYPE,
1035: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2,
1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2
1039: )

Line 1044: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)

1040: IS
1041: l_api_name CONSTANT VARCHAR2 (30) := 'GET_GEOMETRY';
1042: l_api_version CONSTANT NUMBER := 1.0;
1043:
1044: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)
1045: IS
1046: SELECT geometry
1047: FROM hz_locations
1048: WHERE location_id = l_location_id;

Line 1047: FROM hz_locations

1043:
1044: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)
1045: IS
1046: SELECT geometry
1047: FROM hz_locations
1048: WHERE location_id = l_location_id;
1049: BEGIN
1050: -- Standard check for call compatibility
1051: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 1149: p_locus IN hz_locations.geometry%TYPE,

1145: p_api_version IN NUMBER,
1146: p_init_msg_list IN VARCHAR2,
1147: p_commit IN VARCHAR2,
1148: p_validation_level IN NUMBER,
1149: p_locus IN hz_locations.geometry%TYPE,
1150: x_result OUT NOCOPY VARCHAR2,
1151: x_return_status OUT NOCOPY VARCHAR2,
1152: x_msg_count OUT NOCOPY NUMBER,
1153: x_msg_data OUT NOCOPY VARCHAR2

Line 1674: l_location_id hz_locations.location_id%TYPE;

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;
1676: BEGIN
1677: -- Standard check for call compatibility
1678: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 2342: p_location_id IN hz_locations.location_id%TYPE,

2338: p_init_msg_list IN VARCHAR2,
2339: p_commit IN VARCHAR2,
2340: p_validation_level IN NUMBER,
2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,

Line 2343: p_address1 IN hz_locations.address1%TYPE,

2339: p_commit IN VARCHAR2,
2340: p_validation_level IN NUMBER,
2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,

Line 2344: p_address2 IN hz_locations.address2%TYPE,

2340: p_validation_level IN NUMBER,
2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,

Line 2345: p_address3 IN hz_locations.address3%TYPE,

2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,

Line 2346: p_address4 IN hz_locations.address4%TYPE,

2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,

Line 2347: p_city IN hz_locations.city%TYPE,

2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,

Line 2348: p_postal_code IN hz_locations.postal_code%TYPE,

2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,

Line 2349: p_state IN hz_locations.state%TYPE,

2345: p_address3 IN hz_locations.address3%TYPE,
2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,
2353: p_timezone_id IN hz_locations.timezone_id%TYPE,

Line 2350: p_province IN hz_locations.province%TYPE,

2346: p_address4 IN hz_locations.address4%TYPE,
2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,
2353: p_timezone_id IN hz_locations.timezone_id%TYPE,
2354: x_result OUT NOCOPY VARCHAR2,

Line 2351: p_county IN hz_locations.county%TYPE,

2347: p_city IN hz_locations.city%TYPE,
2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,
2353: p_timezone_id IN hz_locations.timezone_id%TYPE,
2354: x_result OUT NOCOPY VARCHAR2,
2355: x_return_status OUT NOCOPY VARCHAR2,

Line 2352: p_country IN hz_locations.country%TYPE,

2348: p_postal_code IN hz_locations.postal_code%TYPE,
2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,
2353: p_timezone_id IN hz_locations.timezone_id%TYPE,
2354: x_result OUT NOCOPY VARCHAR2,
2355: x_return_status OUT NOCOPY VARCHAR2,
2356: x_msg_count OUT NOCOPY NUMBER,

Line 2353: p_timezone_id IN hz_locations.timezone_id%TYPE,

2349: p_state IN hz_locations.state%TYPE,
2350: p_province IN hz_locations.province%TYPE,
2351: p_county IN hz_locations.county%TYPE,
2352: p_country IN hz_locations.country%TYPE,
2353: p_timezone_id IN hz_locations.timezone_id%TYPE,
2354: x_result OUT NOCOPY VARCHAR2,
2355: x_return_status OUT NOCOPY VARCHAR2,
2356: x_msg_count OUT NOCOPY NUMBER,
2357: x_msg_data OUT NOCOPY VARCHAR2

Line 2362: l_locus hz_locations.geometry%TYPE;

2358: )
2359: IS
2360: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_TASK_DATA';
2361: l_api_version CONSTANT NUMBER := 1.0;
2362: l_locus hz_locations.geometry%TYPE;
2363: l_country_code hz_locations.country%TYPE;
2364: l_time_zone_check BOOLEAN;
2365: l_timezone_id VARCHAR2 (80);
2366: l_dup_msg_data VARCHAR2 (2000);

Line 2363: l_country_code hz_locations.country%TYPE;

2359: IS
2360: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_TASK_DATA';
2361: l_api_version CONSTANT NUMBER := 1.0;
2362: l_locus hz_locations.geometry%TYPE;
2363: l_country_code hz_locations.country%TYPE;
2364: l_time_zone_check BOOLEAN;
2365: l_timezone_id VARCHAR2 (80);
2366: l_dup_msg_data VARCHAR2 (2000);
2367:

Line 2374: CURSOR c_country_code (p_country hz_locations.country%TYPE)

2370: SELECT NAME
2371: FROM hz_timezones_vl
2372: WHERE timezone_id = p_timezone_id;
2373:
2374: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2375: IS
2376: SELECT ftt.territory_code country_code
2377: FROM fnd_territories_tl ftt
2378: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)

Line 2589: p_location_id IN hz_locations.location_id%TYPE,

2585: p_api_version IN NUMBER,
2586: p_init_msg_list IN VARCHAR2,
2587: p_commit IN VARCHAR2,
2588: p_validation_level IN NUMBER,
2589: p_location_id IN hz_locations.location_id%TYPE,
2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,

Line 2590: p_address1 IN hz_locations.address1%TYPE,

2586: p_init_msg_list IN VARCHAR2,
2587: p_commit IN VARCHAR2,
2588: p_validation_level IN NUMBER,
2589: p_location_id IN hz_locations.location_id%TYPE,
2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,

Line 2591: p_address2 IN hz_locations.address2%TYPE,

2587: p_commit IN VARCHAR2,
2588: p_validation_level IN NUMBER,
2589: p_location_id IN hz_locations.location_id%TYPE,
2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%TYPE,

Line 2592: p_address3 IN hz_locations.address3%TYPE,

2588: p_validation_level IN NUMBER,
2589: p_location_id IN hz_locations.location_id%TYPE,
2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%TYPE,
2596: p_state IN hz_locations.state%TYPE,

Line 2593: p_address4 IN hz_locations.address4%TYPE,

2589: p_location_id IN hz_locations.location_id%TYPE,
2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%TYPE,
2596: p_state IN hz_locations.state%TYPE,
2597: p_province IN hz_locations.province%TYPE,

Line 2594: p_city IN hz_locations.city%TYPE,

2590: p_address1 IN hz_locations.address1%TYPE,
2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%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,

Line 2595: p_postal_code IN hz_locations.postal_code%TYPE,

2591: p_address2 IN hz_locations.address2%TYPE,
2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%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,

Line 2596: p_state IN hz_locations.state%TYPE,

2592: p_address3 IN hz_locations.address3%TYPE,
2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%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,

Line 2597: p_province IN hz_locations.province%TYPE,

2593: p_address4 IN hz_locations.address4%TYPE,
2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%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,

Line 2598: p_county IN hz_locations.county%TYPE,

2594: p_city IN hz_locations.city%TYPE,
2595: p_postal_code IN hz_locations.postal_code%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,

Line 2599: p_country IN hz_locations.country%TYPE,

2595: p_postal_code IN hz_locations.postal_code%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,

Line 2602: p_timezone_id IN hz_locations.timezone_id%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
2606: )

Line 2612: l_country_code hz_locations.country%TYPE;

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
2616: SELECT ftt.territory_code country_code

Line 2613: l_country hz_locations.country%TYPE;

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
2616: SELECT ftt.territory_code country_code
2617: FROM fnd_territories_tl ftt

Line 2614: CURSOR c_country_code (p_country hz_locations.country%TYPE)

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
2616: SELECT ftt.territory_code country_code
2617: FROM fnd_territories_tl ftt
2618: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)