10: g_output CONSTANT NUMBER := fnd_file.output;
11: g_debug BOOLEAN;
12:
13: TYPE task_rec_type IS RECORD (
14: ID csf_ext_locations.csf_ext_location_id%TYPE,
15: task_id jtf_tasks_b.task_id%TYPE,
16: task_number jtf_tasks_b.task_number%TYPE,
17: location_id hz_locations.location_id%TYPE,
18: address_style hz_locations.address_style%TYPE,
27: province hz_locations.province%TYPE,
28: country hz_locations.country%TYPE,
29: short_description hz_locations.short_description%TYPE,
30: description hz_locations.description%TYPE,
31: validated_flag csf_ext_locations.validated_flag%TYPE,
32: override_flag csf_ext_locations.override_flag%TYPE,
33: log_detail_short csf_ext_locations.log_detail_short%TYPE,
34: log_detail_long csf_ext_locations.log_detail_long%TYPE,
35: country_code VARCHAR2 (30),
28: country hz_locations.country%TYPE,
29: short_description hz_locations.short_description%TYPE,
30: description hz_locations.description%TYPE,
31: validated_flag csf_ext_locations.validated_flag%TYPE,
32: override_flag csf_ext_locations.override_flag%TYPE,
33: log_detail_short csf_ext_locations.log_detail_short%TYPE,
34: log_detail_long csf_ext_locations.log_detail_long%TYPE,
35: country_code VARCHAR2 (30),
36: timezone_id hz_locations.timezone_id%TYPE
29: short_description hz_locations.short_description%TYPE,
30: description hz_locations.description%TYPE,
31: validated_flag csf_ext_locations.validated_flag%TYPE,
32: override_flag csf_ext_locations.override_flag%TYPE,
33: log_detail_short csf_ext_locations.log_detail_short%TYPE,
34: log_detail_long csf_ext_locations.log_detail_long%TYPE,
35: country_code VARCHAR2 (30),
36: timezone_id hz_locations.timezone_id%TYPE
37: );
30: description hz_locations.description%TYPE,
31: validated_flag csf_ext_locations.validated_flag%TYPE,
32: override_flag csf_ext_locations.override_flag%TYPE,
33: log_detail_short csf_ext_locations.log_detail_short%TYPE,
34: log_detail_long csf_ext_locations.log_detail_long%TYPE,
35: country_code VARCHAR2 (30),
36: timezone_id hz_locations.timezone_id%TYPE
37: );
38:
162: p_state IN hz_locations.state%TYPE,
163: p_province IN hz_locations.province%TYPE,
164: p_county IN hz_locations.county%TYPE,
165: p_country IN hz_locations.country%TYPE,
166: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
167: p_override_flag IN csf_ext_locations.override_flag%TYPE,
168: p_timezone_id IN hz_locations.timezone_id%TYPE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
163: p_province IN hz_locations.province%TYPE,
164: p_county IN hz_locations.county%TYPE,
165: p_country IN hz_locations.country%TYPE,
166: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
167: p_override_flag IN csf_ext_locations.override_flag%TYPE,
168: p_timezone_id IN hz_locations.timezone_id%TYPE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2