DBA Data[Home] [Help]

APPS.CSP_LOCATION_PKG dependencies on FND_API

Line 5: location_id NUMBER :=FND_API.G_MISS_NUM,

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,

Line 6: orig_system_reference 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,

Line 7: country VARCHAR2(60) := 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,

Line 8: address1 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,

Line 9: address2 VARCHAR2(240):= 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,

Line 10: address3 VARCHAR2(240):= 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,

Line 11: address4 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,
15: province VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 12: city 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,

Line 13: postal_code 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,

Line 14: state VARCHAR2(60) := 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,

Line 15: province VARCHAR2(60) := 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,

Line 16: county VARCHAR2(60) := 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,

Line 17: address_style VARCHAR2(30) := 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,

Line 18: validated_flag VARCHAR2(1) := 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,

Line 19: address_lines_phonetic VARCHAR2(560):= 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,

Line 20: apartment_flag VARCHAR2(1) := 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,

Line 21: po_box_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,

Line 22: house_number VARCHAR2(50) := 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,

Line 23: street_suffix 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,

Line 24: apartment_number 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,

Line 25: secondary_suffix_element VARCHAR2(240):= 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,

Line 26: street 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,

Line 27: rural_route_type 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,

Line 28: rural_route_number 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,

Line 29: street_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,
33: room VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 30: building 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,

Line 31: floor 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,
35: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 32: suite 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,

Line 33: room 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,
37: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 34: postal_plus4_code VARCHAR2(10) := 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,

Line 35: time_zone 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,

Line 36: overseas_address_flag VARCHAR2(1) := 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,

Line 37: post_office 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,
41: address_effective_date DATE := FND_API.G_MISS_DATE,

Line 38: position 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,
42: address_expiration_date DATE := FND_API.G_MISS_DATE,

Line 39: delivery_point_code VARCHAR2(50) := 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,
43: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 40: location_directions VARCHAR2(640):= 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,

Line 41: address_effective_date DATE := FND_API.G_MISS_DATE,

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,

Line 42: address_expiration_date DATE := FND_API.G_MISS_DATE,

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,

Line 43: address_error_code 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,
47: language VARCHAR2(4) := FND_API.G_MISS_CHAR,

Line 44: clli_code VARCHAR2(60) := 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,

Line 45: dodaac VARCHAR2(6) := 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,

Line 46: trailing_directory_code VARCHAR2(60) := 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,

Line 47: language VARCHAR2(4) := 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,

Line 48: life_cycle_status VARCHAR2(30) := 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,
52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,

Line 49: short_description VARCHAR2(240):= 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,
53: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 50: description VARCHAR2(2000):= 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,

Line 52: loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,

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,

Line 53: sales_tax_geocode 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,
57: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 54: sales_tax_inside_city_limits 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,

Line 55: fa_location_id NUMBER :=FND_API.G_MISS_NUM,

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,

Line 57: attribute_category VARCHAR2(30) := 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,

Line 58: attribute1 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,

Line 59: attribute2 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,

Line 60: attribute3 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,

Line 61: attribute4 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,

Line 62: attribute5 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,

Line 63: attribute6 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,

Line 64: attribute7 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,

Line 65: attribute8 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,

Line 66: attribute9 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,

Line 67: attribute10 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,

Line 68: attribute11 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,

Line 69: attribute12 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,

Line 70: attribute13 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,

Line 71: attribute14 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,

Line 72: attribute15 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,

Line 73: attribute16 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,

Line 74: attribute17 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,

Line 75: attribute18 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,
79: global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 76: attribute19 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,

Line 77: attribute20 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,

Line 78: global_attribute_category VARCHAR2(30) := 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,

Line 79: global_attribute1 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,

Line 80: global_attribute2 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,

Line 81: global_attribute3 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,

Line 82: global_attribute4 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,

Line 83: global_attribute5 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,

Line 84: global_attribute6 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,

Line 85: global_attribute7 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,

Line 86: global_attribute8 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,

Line 87: global_attribute9 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,

Line 88: global_attribute10 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,

Line 89: global_attribute11 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,

Line 90: global_attribute12 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,

Line 91: global_attribute13 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,

Line 92: global_attribute14 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,

Line 93: global_attribute15 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,

Line 94: global_attribute16 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,

Line 95: global_attribute17 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

Line 96: global_attribute18 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
100: ); */

Line 97: global_attribute19 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: ); */
101:

Line 98: global_attribute20 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:
102: --p_location_rec hz_location_pub.location_rec_type;

Line 99: wh_update_date DATE:= FND_API.G_MISS_DATE

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 (

Line 105: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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,

Line 106: p_commit IN 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,

Line 107: x_ADDRESS1 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,

Line 108: x_ADDRESS2 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,

Line 109: x_ADDRESS3 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,

Line 110: x_ADDRESS4 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,

Line 111: x_CITY 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,

Line 112: x_POSTAL_CODE 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,

Line 113: x_STATE 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,

Line 114: x_PROVINCE 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,

Line 115: x_ADDRESS_STYLE 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,

Line 116: x_ADDRESS_LINES_PHONETIC 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,

Line 117: x_COUNTY 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,
121: x_msg_count OUT NOCOPY NUMBER,

Line 118: x_COUNTRY 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,
122: x_msg_data OUT NOCOPY VARCHAR2,

Line 119: x_DESCRIPTION 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,
123: x_location_id OUT NOCOPY NUMBER,

Line 124: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

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,

Line 129: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

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,

Line 130: p_commit IN 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,

Line 132: x_ADDRESS1 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,

Line 133: x_ADDRESS2 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,

Line 134: x_ADDRESS3 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,

Line 135: x_ADDRESS4 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,

Line 136: x_CITY 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,

Line 137: x_POSTAL_CODE 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,

Line 138: x_STATE 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,

Line 139: x_PROVINCE 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,

Line 140: x_ADDRESS_STYLE 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,

Line 141: x_ADDRESS_LINES_PHONETIC 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,

Line 142: x_COUNTY 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,
146: x_msg_count OUT NOCOPY NUMBER,

Line 143: x_COUNTRY 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,
147: x_msg_data OUT NOCOPY VARCHAR2,

Line 144: x_DESCRIPTION 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,
148: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

Line 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;