40: * primary address overlap.
41: * @param p_validate_county Validate county details in the address. Set to true
42: * by default.
43: * @param p_person_id Identifies the person record to modify.
44: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
45: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
46: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
47: * @param p_address_type Indicates the Type of Address. Valid values are
48: * defined by 'ADDRESS_TYPE' lookup type.
41: * @param p_validate_county Validate county details in the address. Set to true
42: * by default.
43: * @param p_person_id Identifies the person record to modify.
44: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
45: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
46: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
47: * @param p_address_type Indicates the Type of Address. Valid values are
48: * defined by 'ADDRESS_TYPE' lookup type.
49: * @param p_comments Comment text.
42: * by default.
43: * @param p_person_id Identifies the person record to modify.
44: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}
45: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
46: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
47: * @param p_address_type Indicates the Type of Address. Valid values are
48: * defined by 'ADDRESS_TYPE' lookup type.
49: * @param p_comments Comment text.
50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
46: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
47: * @param p_address_type Indicates the Type of Address. Valid values are
48: * defined by 'ADDRESS_TYPE' lookup type.
49: * @param p_comments Comment text.
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_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
47: * @param p_address_type Indicates the Type of Address. Valid values are
48: * defined by 'ADDRESS_TYPE' lookup type.
49: * @param p_comments Comment text.
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_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
55: * United States).
48: * defined by 'ADDRESS_TYPE' lookup type.
49: * @param p_comments Comment text.
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_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
55: * United States).
56: * @param p_region_2 Determined by p_style (eg. State for United States).
49: * @param p_comments Comment text.
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_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
54: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
55: * United States).
56: * @param p_region_2 Determined by p_style (eg. State for United States).
57: * @param p_region_3 Determined by p_style (eg. PO Box for Saudi Arabia).
54: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
55: * United States).
56: * @param p_region_2 Determined by p_style (eg. State for United States).
57: * @param p_region_3 Determined by p_style (eg. PO Box for Saudi Arabia).
58: * @param p_postcode {@rep:casecolumn PER_ADDRESSES.POSTAL_CODE}
59: * @param p_country Indicates which country the person was born. Valid values
60: * as applicable are defined by 'NATIONALITY' lookup type.
61: * @param p_telephone_number_1 {@rep:casecolumn
62: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
58: * @param p_postcode {@rep:casecolumn PER_ADDRESSES.POSTAL_CODE}
59: * @param p_country Indicates which country the person was born. Valid values
60: * as applicable are defined by 'NATIONALITY' lookup type.
61: * @param p_telephone_number_1 {@rep:casecolumn
62: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
63: * @param p_telephone_number_2 {@rep:casecolumn
64: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
65: * @param p_telephone_number_3 {@rep:casecolumn
66: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
60: * as applicable are defined by 'NATIONALITY' lookup type.
61: * @param p_telephone_number_1 {@rep:casecolumn
62: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
63: * @param p_telephone_number_2 {@rep:casecolumn
64: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
65: * @param p_telephone_number_3 {@rep:casecolumn
66: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
67: * @param p_addr_attribute_category This context value determines which
68: * flexfield structure to use with the Person Address descriptive flexfield
62: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
63: * @param p_telephone_number_2 {@rep:casecolumn
64: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
65: * @param p_telephone_number_3 {@rep:casecolumn
66: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
67: * @param p_addr_attribute_category This context value determines which
68: * flexfield structure to use with the Person Address descriptive flexfield
69: * segments.
70: * @param p_addr_attribute1 Descriptive flexfield segment.
124: ,p_primary_flag IN VARCHAR2
125: ,p_date_from IN DATE
126: ,p_date_to IN DATE DEFAULT NULL
127: ,p_address_type IN VARCHAR2 DEFAULT NULL
128: ,p_comments IN per_addresses.comments%TYPE DEFAULT NULL
129: ,p_address_line1 IN VARCHAR2
130: ,p_address_line2 IN VARCHAR2 DEFAULT NULL
131: ,p_address_line3 IN VARCHAR2 DEFAULT NULL
132: ,p_town_or_city IN VARCHAR2 DEFAULT NULL
200: * @param p_effective_date Determines when the DateTrack operation takes
201: * effect.
202: * @param p_validate_county Validate county details in the address. Set to true
203: * by default.
204: * @param p_address_id {@rep:casecolumn PER_ADDRESSES.ADDRESS_ID}
205: * @param p_object_version_number Pass in the current version number of the
206: * person address to be updated. When the API completes if p_validate is false,
207: * will be set to the new version number of the updated person address. If
208: * p_validate is true will be set to the same value which was passed in.
205: * @param p_object_version_number Pass in the current version number of the
206: * person address to be updated. When the API completes if p_validate is false,
207: * will be set to the new version number of the updated person address. If
208: * p_validate is true will be set to the same value which was passed in.
209: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
210: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
211: * @param p_primary_flag Flag specifying if this is a primary address. Valid
212: * values are 'Y' or 'N'.
213: * @param p_address_type Indicates the Type of Address. Valid values are
206: * person address to be updated. When the API completes if p_validate is false,
207: * will be set to the new version number of the updated person address. If
208: * p_validate is true will be set to the same value which was passed in.
209: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}
210: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}
211: * @param p_primary_flag Flag specifying if this is a primary address. Valid
212: * values are 'Y' or 'N'.
213: * @param p_address_type Indicates the Type of Address. Valid values are
214: * defined by 'ADDRESS_TYPE' lookup type.
212: * values are 'Y' or 'N'.
213: * @param p_address_type Indicates the Type of Address. Valid values are
214: * defined by 'ADDRESS_TYPE' lookup type.
215: * @param p_comments Comment text.
216: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
217: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
218: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
219: * @param p_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
220: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
213: * @param p_address_type Indicates the Type of Address. Valid values are
214: * defined by 'ADDRESS_TYPE' lookup type.
215: * @param p_comments Comment text.
216: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
217: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
218: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
219: * @param p_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
220: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
221: * United States).
214: * defined by 'ADDRESS_TYPE' lookup type.
215: * @param p_comments Comment text.
216: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
217: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
218: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
219: * @param p_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
220: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
221: * United States).
222: * @param p_region_2 Determined by p_style (eg. State for United States).
215: * @param p_comments Comment text.
216: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}
217: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}
218: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}
219: * @param p_town_or_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}
220: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
221: * United States).
222: * @param p_region_2 Determined by p_style (eg. State for United States).
223: * @param p_region_3 Determined by p_style (eg. PO Box for Saudi Arabia).
220: * @param p_region_1 Determined by p_style (eg. County for United Kingdom and
221: * United States).
222: * @param p_region_2 Determined by p_style (eg. State for United States).
223: * @param p_region_3 Determined by p_style (eg. PO Box for Saudi Arabia).
224: * @param p_postcode {@rep:casecolumn PER_ADDRESSES.POSTAL_CODE}
225: * @param p_country Indicates which country the person was born. Valid values
226: * as applicable are defined by 'NATIONALITY' lookup type.
227: * @param p_telephone_number_1 {@rep:casecolumn
228: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
224: * @param p_postcode {@rep:casecolumn PER_ADDRESSES.POSTAL_CODE}
225: * @param p_country Indicates which country the person was born. Valid values
226: * as applicable are defined by 'NATIONALITY' lookup type.
227: * @param p_telephone_number_1 {@rep:casecolumn
228: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
229: * @param p_telephone_number_2 {@rep:casecolumn
230: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
231: * @param p_telephone_number_3 {@rep:casecolumn
232: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
226: * as applicable are defined by 'NATIONALITY' lookup type.
227: * @param p_telephone_number_1 {@rep:casecolumn
228: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
229: * @param p_telephone_number_2 {@rep:casecolumn
230: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
231: * @param p_telephone_number_3 {@rep:casecolumn
232: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
233: * @param p_addr_attribute_category This context value determines which
234: * flexfield structure to use with the Person Address descriptive flexfield
228: * PER_ADDRESSES.TELEPHONE_NUMBER_1}
229: * @param p_telephone_number_2 {@rep:casecolumn
230: * PER_ADDRESSES.TELEPHONE_NUMBER_2}
231: * @param p_telephone_number_3 {@rep:casecolumn
232: * PER_ADDRESSES.TELEPHONE_NUMBER_3}
233: * @param p_addr_attribute_category This context value determines which
234: * flexfield structure to use with the Person Address descriptive flexfield
235: * segments.
236: * @param p_addr_attribute1 Descriptive flexfield segment.
285: ,p_date_from IN DATE DEFAULT hr_api.g_date
286: ,p_date_to IN DATE DEFAULT hr_api.g_date
287: ,p_primary_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_address_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_comments IN per_addresses.comments%TYPE DEFAULT hr_api.g_varchar2
290: ,p_address_line1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_address_line2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2