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 50: -- This procedure is used to retrieve data from the hz_locations table.

46: p_start_date IN VARCHAR2 DEFAULT NULL,
47: p_end_date IN VARCHAR2 DEFAULT NULL
48: );
49:
50: -- This procedure is used to retrieve data from the hz_locations table.
51: PROCEDURE retrieve_data (
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2,
54: p_commit IN VARCHAR2,

Line 70: p_location_id IN hz_locations.location_id%TYPE,

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

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

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

Line 87: p_locus IN hz_locations.geometry%TYPE,

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

Line 127: p_location_id IN hz_locations.location_id%TYPE,

123: p_init_msg_list IN VARCHAR2,
124: p_commit IN VARCHAR2,
125: p_validation_level IN NUMBER,
126: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
127: p_location_id IN hz_locations.location_id%TYPE,
128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,

Line 128: p_address1 IN hz_locations.address1%TYPE,

124: p_commit IN VARCHAR2,
125: p_validation_level IN NUMBER,
126: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
127: p_location_id IN hz_locations.location_id%TYPE,
128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,

Line 129: p_address2 IN hz_locations.address2%TYPE,

125: p_validation_level IN NUMBER,
126: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
127: p_location_id IN hz_locations.location_id%TYPE,
128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,

Line 130: p_address3 IN hz_locations.address3%TYPE,

126: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
127: p_location_id IN hz_locations.location_id%TYPE,
128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,

Line 131: p_address4 IN hz_locations.address4%TYPE,

127: p_location_id IN hz_locations.location_id%TYPE,
128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,

Line 132: p_city IN hz_locations.city%TYPE,

128: p_address1 IN hz_locations.address1%TYPE,
129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,

Line 133: p_postal_code IN hz_locations.postal_code%TYPE,

129: p_address2 IN hz_locations.address2%TYPE,
130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,

Line 134: p_state IN hz_locations.state%TYPE,

130: p_address3 IN hz_locations.address3%TYPE,
131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,
138: p_timezone_id IN hz_locations.timezone_id%TYPE,

Line 135: p_province IN hz_locations.province%TYPE,

131: p_address4 IN hz_locations.address4%TYPE,
132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,
138: p_timezone_id IN hz_locations.timezone_id%TYPE,
139: x_result OUT NOCOPY VARCHAR2,

Line 136: p_county IN hz_locations.county%TYPE,

132: p_city IN hz_locations.city%TYPE,
133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,
138: p_timezone_id IN hz_locations.timezone_id%TYPE,
139: x_result OUT NOCOPY VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2,

Line 137: p_country IN hz_locations.country%TYPE,

133: p_postal_code IN hz_locations.postal_code%TYPE,
134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,
138: p_timezone_id IN hz_locations.timezone_id%TYPE,
139: x_result OUT NOCOPY VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,

Line 138: p_timezone_id IN hz_locations.timezone_id%TYPE,

134: p_state IN hz_locations.state%TYPE,
135: p_province IN hz_locations.province%TYPE,
136: p_county IN hz_locations.county%TYPE,
137: p_country IN hz_locations.country%TYPE,
138: p_timezone_id IN hz_locations.timezone_id%TYPE,
139: x_result OUT NOCOPY VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2

Line 155: p_location_id IN hz_locations.location_id%TYPE,

151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2,
153: p_commit IN VARCHAR2,
154: p_validation_level IN NUMBER,
155: p_location_id IN hz_locations.location_id%TYPE,
156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,

Line 156: p_address1 IN hz_locations.address1%TYPE,

152: p_init_msg_list IN VARCHAR2,
153: p_commit IN VARCHAR2,
154: p_validation_level IN NUMBER,
155: p_location_id IN hz_locations.location_id%TYPE,
156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,

Line 157: p_address2 IN hz_locations.address2%TYPE,

153: p_commit IN VARCHAR2,
154: p_validation_level IN NUMBER,
155: p_location_id IN hz_locations.location_id%TYPE,
156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,

Line 158: p_address3 IN hz_locations.address3%TYPE,

154: p_validation_level IN NUMBER,
155: p_location_id IN hz_locations.location_id%TYPE,
156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
162: p_state IN hz_locations.state%TYPE,

Line 159: p_address4 IN hz_locations.address4%TYPE,

155: p_location_id IN hz_locations.location_id%TYPE,
156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
162: p_state IN hz_locations.state%TYPE,
163: p_province IN hz_locations.province%TYPE,

Line 160: p_city IN hz_locations.city%TYPE,

156: p_address1 IN hz_locations.address1%TYPE,
157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
162: p_state IN hz_locations.state%TYPE,
163: p_province IN hz_locations.province%TYPE,
164: p_county IN hz_locations.county%TYPE,

Line 161: p_postal_code IN hz_locations.postal_code%TYPE,

157: p_address2 IN hz_locations.address2%TYPE,
158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 162: p_state IN hz_locations.state%TYPE,

158: p_address3 IN hz_locations.address3%TYPE,
159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 163: p_province IN hz_locations.province%TYPE,

159: p_address4 IN hz_locations.address4%TYPE,
160: p_city IN hz_locations.city%TYPE,
161: p_postal_code IN hz_locations.postal_code%TYPE,
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,

Line 164: p_county IN hz_locations.county%TYPE,

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

Line 165: p_country IN hz_locations.country%TYPE,

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

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