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 17: location_id hz_locations.location_id%TYPE,

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,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,

Line 18: address_style hz_locations.address_style%TYPE,

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,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,

Line 19: address1 hz_locations.address1%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,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,

Line 20: address2 hz_locations.address2%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,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,

Line 21: address3 hz_locations.address3%TYPE,

17: location_id hz_locations.location_id%TYPE,
18: address_style hz_locations.address_style%TYPE,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,

Line 22: address4 hz_locations.address4%TYPE,

18: address_style hz_locations.address_style%TYPE,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%TYPE,

Line 23: postal_code hz_locations.postal_code%TYPE,

19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%TYPE,
27: province hz_locations.province%TYPE,

Line 24: city hz_locations.city%TYPE,

20: address2 hz_locations.address2%TYPE,
21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%TYPE,
27: province hz_locations.province%TYPE,
28: country hz_locations.country%TYPE,

Line 25: county hz_locations.county%TYPE,

21: address3 hz_locations.address3%TYPE,
22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%TYPE,
27: province hz_locations.province%TYPE,
28: country hz_locations.country%TYPE,
29: short_description hz_locations.short_description%TYPE,

Line 26: state hz_locations.state%TYPE,

22: address4 hz_locations.address4%TYPE,
23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%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,

Line 27: province hz_locations.province%TYPE,

23: postal_code hz_locations.postal_code%TYPE,
24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%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,

Line 28: country hz_locations.country%TYPE,

24: city hz_locations.city%TYPE,
25: county hz_locations.county%TYPE,
26: state hz_locations.state%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,

Line 29: short_description hz_locations.short_description%TYPE,

25: county hz_locations.county%TYPE,
26: state hz_locations.state%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,

Line 30: description hz_locations.description%TYPE,

26: state hz_locations.state%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,

Line 36: timezone_id hz_locations.timezone_id%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:
39: TYPE task_rec_tbl_type IS TABLE OF task_rec_type
40: INDEX BY BINARY_INTEGER;

Line 51: -- This procedure is used to retrieve data from the hz_locations table.

47: p_end_date in varchar2 default null,
48: p_unstamped_only IN VARCHAR2 DEFAULT 'Yes'
49: );
50:
51: -- This procedure is used to retrieve data from the hz_locations table.
52: PROCEDURE retrieve_data (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2,
55: p_commit IN VARCHAR2,

Line 72: p_location_id IN hz_locations.location_id%TYPE,

68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2,
70: p_commit IN VARCHAR2,
71: p_validation_level IN NUMBER,
72: p_location_id IN hz_locations.location_id%TYPE,
73: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2

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

69: p_init_msg_list IN VARCHAR2,
70: p_commit IN VARCHAR2,
71: p_validation_level IN NUMBER,
72: p_location_id IN hz_locations.location_id%TYPE,
73: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2
77: );

Line 89: p_locus IN hz_locations.geometry%TYPE,

85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2,
87: p_commit IN VARCHAR2,
88: p_validation_level IN NUMBER,
89: p_locus IN hz_locations.geometry%TYPE,
90: x_result OUT NOCOPY VARCHAR2,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2

Line 141: p_location_id IN hz_locations.location_id%TYPE,

137: p_init_msg_list IN VARCHAR2,
138: p_commit IN VARCHAR2,
139: p_validation_level IN NUMBER,
140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,

Line 142: p_address1 IN hz_locations.address1%TYPE,

138: p_commit IN VARCHAR2,
139: p_validation_level IN NUMBER,
140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,

Line 143: p_address2 IN hz_locations.address2%TYPE,

139: p_validation_level IN NUMBER,
140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,

Line 144: p_address3 IN hz_locations.address3%TYPE,

140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,

Line 145: p_address4 IN hz_locations.address4%TYPE,

141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,

Line 146: p_city IN hz_locations.city%TYPE,

142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,

Line 147: p_postal_code IN hz_locations.postal_code%TYPE,

143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,

Line 148: p_state IN hz_locations.state%TYPE,

144: p_address3 IN hz_locations.address3%TYPE,
145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,
152: p_timezone_id IN hz_locations.timezone_id%TYPE,

Line 149: p_province IN hz_locations.province%TYPE,

145: p_address4 IN hz_locations.address4%TYPE,
146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,
152: p_timezone_id IN hz_locations.timezone_id%TYPE,
153: x_result OUT NOCOPY VARCHAR2,

Line 150: p_county IN hz_locations.county%TYPE,

146: p_city IN hz_locations.city%TYPE,
147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,
152: p_timezone_id IN hz_locations.timezone_id%TYPE,
153: x_result OUT NOCOPY VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2,

Line 151: p_country IN hz_locations.country%TYPE,

147: p_postal_code IN hz_locations.postal_code%TYPE,
148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,
152: p_timezone_id IN hz_locations.timezone_id%TYPE,
153: x_result OUT NOCOPY VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,

Line 152: p_timezone_id IN hz_locations.timezone_id%TYPE,

148: p_state IN hz_locations.state%TYPE,
149: p_province IN hz_locations.province%TYPE,
150: p_county IN hz_locations.county%TYPE,
151: p_country IN hz_locations.country%TYPE,
152: p_timezone_id IN hz_locations.timezone_id%TYPE,
153: x_result OUT NOCOPY VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2

Line 169: p_location_id IN hz_locations.location_id%TYPE,

165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2,
167: p_commit IN VARCHAR2,
168: p_validation_level IN NUMBER,
169: p_location_id IN hz_locations.location_id%TYPE,
170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,

Line 170: p_address1 IN hz_locations.address1%TYPE,

166: p_init_msg_list IN VARCHAR2,
167: p_commit IN VARCHAR2,
168: p_validation_level IN NUMBER,
169: p_location_id IN hz_locations.location_id%TYPE,
170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,

Line 171: p_address2 IN hz_locations.address2%TYPE,

167: p_commit IN VARCHAR2,
168: p_validation_level IN NUMBER,
169: p_location_id IN hz_locations.location_id%TYPE,
170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,

Line 172: p_address3 IN hz_locations.address3%TYPE,

168: p_validation_level IN NUMBER,
169: p_location_id IN hz_locations.location_id%TYPE,
170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
176: p_state IN hz_locations.state%TYPE,

Line 173: p_address4 IN hz_locations.address4%TYPE,

169: p_location_id IN hz_locations.location_id%TYPE,
170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
176: p_state IN hz_locations.state%TYPE,
177: p_province IN hz_locations.province%TYPE,

Line 174: p_city IN hz_locations.city%TYPE,

170: p_address1 IN hz_locations.address1%TYPE,
171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
176: p_state IN hz_locations.state%TYPE,
177: p_province IN hz_locations.province%TYPE,
178: p_county IN hz_locations.county%TYPE,

Line 175: p_postal_code IN hz_locations.postal_code%TYPE,

171: p_address2 IN hz_locations.address2%TYPE,
172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 176: p_state IN hz_locations.state%TYPE,

172: p_address3 IN hz_locations.address3%TYPE,
173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 177: p_province IN hz_locations.province%TYPE,

173: p_address4 IN hz_locations.address4%TYPE,
174: p_city IN hz_locations.city%TYPE,
175: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 178: p_county IN hz_locations.county%TYPE,

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

Line 179: p_country IN hz_locations.country%TYPE,

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

Line 182: p_timezone_id IN hz_locations.timezone_id%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
186: );