41: * have the end date populated. If false, primary address can have overlap
42: * dates.
43: * @param p_person_id Identifies the person for whom you create the address
44: * record.
45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
42: * dates.
43: * @param p_person_id Identifies the person for whom you create the address
44: * record.
45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
43: * @param p_person_id Identifies the person for whom you create the address
44: * record.
45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
44: * record.
45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_province Province or Territory.
47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_province Province or Territory.
55: * @param p_postal_code Postal Code.
48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_province Province or Territory.
55: * @param p_postal_code Postal Code.
56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_province Province or Territory.
55: * @param p_postal_code Postal Code.
56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
57: * @param p_telephone_number_1 {@rep:casecolumn
52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_province Province or Territory.
55: * @param p_postal_code Postal Code.
56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
57: * @param p_telephone_number_1 {@rep:casecolumn
58: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
59: * @param p_telephone_number_2 {@rep:casecolumn
60: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
54: * @param p_province Province or Territory.
55: * @param p_postal_code Postal Code.
56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
57: * @param p_telephone_number_1 {@rep:casecolumn
58: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
59: * @param p_telephone_number_2 {@rep:casecolumn
60: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
61: * @param p_cma Census Metropolitan Area.
62: * @param p_addr_attribute_category This context value determines which
56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
57: * @param p_telephone_number_1 {@rep:casecolumn
58: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
59: * @param p_telephone_number_2 {@rep:casecolumn
60: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
61: * @param p_cma Census Metropolitan Area.
62: * @param p_addr_attribute_category This context value determines which
63: * flexfield structure to use with the Person Address descriptive flexfield
64: * segments.
108: ,p_primary_flag in varchar2
109: ,p_date_from in date
110: ,p_date_to in date default null
111: ,p_address_type in varchar2 default null
112: ,p_comments in per_addresses.comments%TYPE default null
113: ,p_address_line1 in varchar2
114: ,p_address_line2 in varchar2 default null
115: ,p_address_line3 in varchar2 default null
116: ,p_city in varchar2 default null
185: * @param p_object_version_number Pass in the current version number of the
186: * address to be updated. When the API completes if p_validate is false, will
187: * be set to the new version number of the updated address. If p_validate is
188: * true will be set to the same value which was passed in.
189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
186: * address to be updated. When the API completes if p_validate is false, will
187: * be set to the new version number of the updated address. If p_validate is
188: * true will be set to the same value which was passed in.
189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
187: * be set to the new version number of the updated address. If p_validate is
188: * true will be set to the same value which was passed in.
189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
188: * true will be set to the same value which was passed in.
189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
197: * @param p_province Province or Territory.
190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
197: * @param p_province Province or Territory.
198: * @param p_postal_code Postal Code.
191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
197: * @param p_province Province or Territory.
198: * @param p_postal_code Postal Code.
199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}
193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
197: * @param p_province Province or Territory.
198: * @param p_postal_code Postal Code.
199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
200: * @param p_telephone_number_1 {@rep:casecolumn
195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
197: * @param p_province Province or Territory.
198: * @param p_postal_code Postal Code.
199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
200: * @param p_telephone_number_1 {@rep:casecolumn
201: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
202: * @param p_telephone_number_2 {@rep:casecolumn
203: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
197: * @param p_province Province or Territory.
198: * @param p_postal_code Postal Code.
199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
200: * @param p_telephone_number_1 {@rep:casecolumn
201: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
202: * @param p_telephone_number_2 {@rep:casecolumn
203: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
204: * @param p_cma Census Metropolitan Area.
205: * @param p_addr_attribute_category This context value determines which
199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}
200: * @param p_telephone_number_1 {@rep:casecolumn
201: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
202: * @param p_telephone_number_2 {@rep:casecolumn
203: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
204: * @param p_cma Census Metropolitan Area.
205: * @param p_addr_attribute_category This context value determines which
206: * flexfield structure to use with the Person Address descriptive flexfield
207: * segments.
245: ,p_object_version_number in out nocopy number
246: ,p_date_from in date default hr_api.g_date
247: ,p_date_to in date default hr_api.g_date
248: ,p_address_type in varchar2 default hr_api.g_varchar2
249: ,p_comments in per_addresses.comments%TYPE default hr_api.g_varchar2
250: ,p_address_line1 in varchar2 default hr_api.g_varchar2
251: ,p_address_line2 in varchar2 default hr_api.g_varchar2
252: ,p_address_line3 in varchar2 default hr_api.g_varchar2
253: ,p_city in varchar2 default hr_api.g_varchar2