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:
176: p_state IN hz_locations.state%TYPE,
177: p_province IN hz_locations.province%TYPE,
178: p_county IN hz_locations.county%TYPE,
179: p_country IN hz_locations.country%TYPE,
180: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
181: p_override_flag IN csf_ext_locations.override_flag%TYPE,
182: p_timezone_id IN hz_locations.timezone_id%TYPE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
177: p_province IN hz_locations.province%TYPE,
178: p_county IN hz_locations.county%TYPE,
179: p_country IN hz_locations.country%TYPE,
180: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
181: p_override_flag IN csf_ext_locations.override_flag%TYPE,
182: p_timezone_id IN hz_locations.timezone_id%TYPE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2