1: package CSP_LOCATION_PKG AUTHID CURRENT_USER AS
2: /*$Header: cspgtlos.pls 115.3 2002/11/26 06:52:42 hhaugeru ship $*/
3:
4: /*TYPE csp_location_rec_type IS RECORD(
5: location_id NUMBER :=FND_API.G_MISS_NUM,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
2: /*$Header: cspgtlos.pls 115.3 2002/11/26 06:52:42 hhaugeru ship $*/
3:
4: /*TYPE csp_location_rec_type IS RECORD(
5: location_id NUMBER :=FND_API.G_MISS_NUM,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
3:
4: /*TYPE csp_location_rec_type IS RECORD(
5: location_id NUMBER :=FND_API.G_MISS_NUM,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
4: /*TYPE csp_location_rec_type IS RECORD(
5: location_id NUMBER :=FND_API.G_MISS_NUM,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
5: location_id NUMBER :=FND_API.G_MISS_NUM,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
6: orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
7: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
8: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
9: address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
11: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
12: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
14: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
16: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
17: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
18: validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
19: address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
20: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
21: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
23: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
24: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
25: secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
26: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
27: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
28: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
30: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
31: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
32: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
34: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
36: overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
38: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
40: location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: address_effective_date DATE := FND_API.G_MISS_DATE,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
44: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
45: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
49: short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51: geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: wh_update_date DATE:= FND_API.G_MISS_DATE
92: global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: wh_update_date DATE:= FND_API.G_MISS_DATE
100: ); */
93: global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: wh_update_date DATE:= FND_API.G_MISS_DATE
100: ); */
101:
94: global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: wh_update_date DATE:= FND_API.G_MISS_DATE
100: ); */
101:
102: --p_location_rec hz_location_pub.location_rec_type;
95: global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: wh_update_date DATE:= FND_API.G_MISS_DATE
100: ); */
101:
102: --p_location_rec hz_location_pub.location_rec_type;
103: procedure csp_create_location (
101:
102: --p_location_rec hz_location_pub.location_rec_type;
103: procedure csp_create_location (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
102: --p_location_rec hz_location_pub.location_rec_type;
103: procedure csp_create_location (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
103: procedure csp_create_location (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
106: p_commit IN VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
107: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
108: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
109: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
110: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
111: x_CITY VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
112: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
113: x_STATE VARCHAR2:= FND_API.G_FALSE,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
114: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
115: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: x_location_id OUT NOCOPY NUMBER,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: x_location_id OUT NOCOPY NUMBER,
124: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
125: );
126:
127: procedure csp_update_location (
128: p_api_version IN NUMBER,
125: );
126:
127: procedure csp_update_location (
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
130: p_commit IN VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
126:
127: procedure csp_update_location (
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
130: p_commit IN VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
130: p_commit IN VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
129: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
130: p_commit IN VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
130: p_commit IN VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
131: x_location_id NUMBER,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
132: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
133: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
134: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
135: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
136: x_CITY VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
137: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
138: x_STATE VARCHAR2:= FND_API.G_FALSE,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
139: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
140: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
144: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
149: ) ;
150:
151: END CSP_LOCATION_PKG;