33:
34: FUNCTION get_csc_application_id RETURN NUMBER;
35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country 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,
34: FUNCTION get_csc_application_id RETURN NUMBER;
35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country 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,
35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: country 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county 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: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number 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: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
96: