34: -- wh_update_date is addded in the record. This is used as last update date in
35: -- Update address proc. Fix for bug #1567159
36:
37: TYPE address_rec_type IS RECORD(
38: location_id NUMBER := FND_API.G_MISS_NUM,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: -- Update address proc. Fix for bug #1567159
36:
37: TYPE address_rec_type IS RECORD(
38: location_id NUMBER := FND_API.G_MISS_NUM,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
36:
37: TYPE address_rec_type IS RECORD(
38: location_id NUMBER := FND_API.G_MISS_NUM,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: TYPE address_rec_type IS RECORD(
38: location_id NUMBER := FND_API.G_MISS_NUM,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: location_id NUMBER := FND_API.G_MISS_NUM,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
43: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
47: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
48: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
53: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
55: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
56: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
61: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
62: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
71: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
71: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: created_by_module VARCHAR2(30) := 'SR');
65: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
71: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: created_by_module VARCHAR2(30) := 'SR');
73:
66: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
71: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: created_by_module VARCHAR2(30) := 'SR');
73:
74: FUNCTION GET_ADDRESS_REC_TYPE RETURN CS_SR_CUST_CONT_MAINT_PVT.ADDRESS_REC_TYPE;
67: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: timezone_id NUMBER := FND_API.G_MISS_NUM,
69: address_effective_date DATE := FND_API.G_MISS_DATE,
70: address_expiration_date DATE := FND_API.G_MISS_DATE,
71: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: created_by_module VARCHAR2(30) := 'SR');
73:
74: FUNCTION GET_ADDRESS_REC_TYPE RETURN CS_SR_CUST_CONT_MAINT_PVT.ADDRESS_REC_TYPE;
75: