DBA Data[Home] [Help]

APPS.PER_CA_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 45: * @param p_primary_flag {@rep:casecolumn PER_ADDRESSES.PRIMARY_FLAG}

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}

Line 46: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}

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}

Line 47: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}

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}

Line 48: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}

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}

Line 49: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}

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}

Line 50: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}

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.

Line 51: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}

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.

Line 52: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}

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}

Line 53: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}

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

Line 56: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}

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}

Line 58: * PER_ADDRESSES.TELEPHONE_NUMBER_1}

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

Line 60: * PER_ADDRESSES.TELEPHONE_NUMBER_2}

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.

Line 112: ,p_comments in per_addresses.comments%TYPE default null

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

Line 189: * @param p_date_from {@rep:casecolumn PER_ADDRESSES.DATE_FROM}

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}

Line 190: * @param p_date_to {@rep:casecolumn PER_ADDRESSES.DATE_TO}

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}

Line 191: * @param p_address_type {@rep:casecolumn PER_ADDRESSES.ADDRESS_TYPE}

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}

Line 192: * @param p_comments {@rep:casecolumn PER_ADDRESSES.COMMENTS}

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}

Line 193: * @param p_address_line1 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE1}

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.

Line 194: * @param p_address_line2 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE2}

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.

Line 195: * @param p_address_line3 {@rep:casecolumn PER_ADDRESSES.ADDRESS_LINE3}

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}

Line 196: * @param p_city {@rep:casecolumn PER_ADDRESSES.TOWN_OR_CITY}

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

Line 199: * @param p_country {@rep:casecolumn PER_ADDRESSES.COUNTRY}

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}

Line 201: * PER_ADDRESSES.TELEPHONE_NUMBER_1}

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

Line 203: * PER_ADDRESSES.TELEPHONE_NUMBER_2}

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.

Line 249: ,p_comments in per_addresses.comments%TYPE default hr_api.g_varchar2

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