APPS.CSC_RESPONSE_CENTER_PKG dependencies on FND_API

Line 84: location_id NUMBER := FND_API.G_MISS_NUM,

80: -- wh_update_date is addded in the record. This is used as last update date in
81: -- Update address proc. Fix for bug #1567159
82:
83: TYPE address_rec_type IS RECORD(
84: location_id NUMBER := FND_API.G_MISS_NUM,
85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

81: -- Update address proc. Fix for bug #1567159
82:
83: TYPE address_rec_type IS RECORD(
84: location_id NUMBER := FND_API.G_MISS_NUM,
85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,

Line 86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

82:
83: TYPE address_rec_type IS RECORD(
84: location_id NUMBER := FND_API.G_MISS_NUM,
85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

83: TYPE address_rec_type IS RECORD(
84: location_id NUMBER := FND_API.G_MISS_NUM,
85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

84: location_id NUMBER := FND_API.G_MISS_NUM,
85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,

85: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,

86: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,

87: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

88: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,

Line 93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,

89: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,

90: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,

91: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,

92: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,

93: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

94: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

95: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,

Line 100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,

96: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,

97: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

98: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,

99: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

100: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,

101: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,

102: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,

103: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

104: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

105: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,

106: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,

107: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,

108: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

109: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,

Line 114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,

110: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,

111: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

112: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,

Line 117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,

113: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

114: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

115: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,

116: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

117: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,

118: address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,

119: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,

Line 124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

120: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,

Line 125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

121: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,

Line 126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,

122: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 127: timezone_id NUMBER := FND_API.G_MISS_NUM,

123: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: wh_update_date DATE := FND_API.G_MISS_DATE);

Line 128: address_effective_date DATE := FND_API.G_MISS_DATE,

124: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: wh_update_date DATE := FND_API.G_MISS_DATE);
132:

Line 129: address_expiration_date DATE := FND_API.G_MISS_DATE,

125: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: wh_update_date DATE := FND_API.G_MISS_DATE);
132:
133: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG.ADDRESS_REC_TYPE;

Line 130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,

126: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: wh_update_date DATE := FND_API.G_MISS_DATE);
132:
133: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG.ADDRESS_REC_TYPE;
134:

Line 131: wh_update_date DATE := FND_API.G_MISS_DATE);

127: timezone_id NUMBER := FND_API.G_MISS_NUM,
128: address_effective_date DATE := FND_API.G_MISS_DATE,
129: address_expiration_date DATE := FND_API.G_MISS_DATE,
130: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: wh_update_date DATE := FND_API.G_MISS_DATE);
132:
133: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG.ADDRESS_REC_TYPE;
134:
135: