eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CNL_UPD dependencies on PER_CNL_SHD

Line 55: (p_rec in out nocopy per_cnl_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_cnl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 109: per_cnl_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: per_cnl_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --

Line 114: per_cnl_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: per_cnl_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: per_cnl_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: per_cnl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 159: (p_rec in per_cnl_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure pre_update
159: (p_rec in per_cnl_shd.g_rec_type
160: ) is
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --

Line 204: ,p_rec in per_cnl_shd.g_rec_type

200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_update
203: (p_effective_date in date
204: ,p_rec in per_cnl_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --

Line 242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code

238: ,p_loc_information18 => p_rec.loc_information18
239: ,p_loc_information19 => p_rec.loc_information19
240: ,p_loc_information20 => p_rec.loc_information20
241: ,p_object_version_number => p_rec.object_version_number
242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style

Line 243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context

239: ,p_loc_information19 => p_rec.loc_information19
240: ,p_loc_information20 => p_rec.loc_information20
241: ,p_object_version_number => p_rec.object_version_number
242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1

Line 244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code

240: ,p_loc_information20 => p_rec.loc_information20
241: ,p_object_version_number => p_rec.object_version_number
242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2

Line 245: ,p_description_o => per_cnl_shd.g_old_rec.description

241: ,p_object_version_number => p_rec.object_version_number
242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3

Line 246: ,p_style_o => per_cnl_shd.g_old_rec.style

242: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city

Line 247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1

243: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country

Line 248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2

244: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code

Line 249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3

245: ,p_description_o => per_cnl_shd.g_old_rec.description
246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1

Line 250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city

246: ,p_style_o => per_cnl_shd.g_old_rec.style
247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2

Line 251: ,p_country_o => per_cnl_shd.g_old_rec.country

247: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3

Line 252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code

248: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1

Line 253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1

249: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2

Line 254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2

250: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3

Line 255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3

251: ,p_country_o => per_cnl_shd.g_old_rec.country
252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13

Line 256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1

252: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14

Line 257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2

253: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15

Line 258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3

254: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16

Line 259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13

255: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17

Line 260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14

256: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18

Line 261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15

257: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19

Line 262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16

258: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20

Line 263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17

259: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number

Line 264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18

260: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
268: );

Line 265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19

261: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
268: );
269: --

Line 266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20

262: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
268: );
269: --
270: exception

Line 267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number

263: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
264: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
265: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
266: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
267: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
268: );
269: --
270: exception
271: --

Line 327: (p_rec in out nocopy per_cnl_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs
327: (p_rec in out nocopy per_cnl_shd.g_rec_type
328: ) is
329: --
330: Begin
331: --

Line 339: per_cnl_shd.g_old_rec.configuration_code;

335: -- is being used then we must set to the 'current' argument value.
336: --
337: If (p_rec.configuration_code = hr_api.g_varchar2) then
338: p_rec.configuration_code :=
339: per_cnl_shd.g_old_rec.configuration_code;
340: End If;
341: If (p_rec.configuration_context = hr_api.g_varchar2) then
342: p_rec.configuration_context :=
343: per_cnl_shd.g_old_rec.configuration_context;

Line 343: per_cnl_shd.g_old_rec.configuration_context;

339: per_cnl_shd.g_old_rec.configuration_code;
340: End If;
341: If (p_rec.configuration_context = hr_api.g_varchar2) then
342: p_rec.configuration_context :=
343: per_cnl_shd.g_old_rec.configuration_context;
344: End If;
345: If (p_rec.location_code = hr_api.g_varchar2) then
346: p_rec.location_code :=
347: per_cnl_shd.g_old_rec.location_code;

Line 347: per_cnl_shd.g_old_rec.location_code;

343: per_cnl_shd.g_old_rec.configuration_context;
344: End If;
345: If (p_rec.location_code = hr_api.g_varchar2) then
346: p_rec.location_code :=
347: per_cnl_shd.g_old_rec.location_code;
348: End If;
349: If (p_rec.description = hr_api.g_varchar2) then
350: p_rec.description :=
351: per_cnl_shd.g_old_rec.description;

Line 351: per_cnl_shd.g_old_rec.description;

347: per_cnl_shd.g_old_rec.location_code;
348: End If;
349: If (p_rec.description = hr_api.g_varchar2) then
350: p_rec.description :=
351: per_cnl_shd.g_old_rec.description;
352: End If;
353: If (p_rec.style = hr_api.g_varchar2) then
354: p_rec.style :=
355: per_cnl_shd.g_old_rec.style;

Line 355: per_cnl_shd.g_old_rec.style;

351: per_cnl_shd.g_old_rec.description;
352: End If;
353: If (p_rec.style = hr_api.g_varchar2) then
354: p_rec.style :=
355: per_cnl_shd.g_old_rec.style;
356: End If;
357: If (p_rec.address_line_1 = hr_api.g_varchar2) then
358: p_rec.address_line_1 :=
359: per_cnl_shd.g_old_rec.address_line_1;

Line 359: per_cnl_shd.g_old_rec.address_line_1;

355: per_cnl_shd.g_old_rec.style;
356: End If;
357: If (p_rec.address_line_1 = hr_api.g_varchar2) then
358: p_rec.address_line_1 :=
359: per_cnl_shd.g_old_rec.address_line_1;
360: End If;
361: If (p_rec.address_line_2 = hr_api.g_varchar2) then
362: p_rec.address_line_2 :=
363: per_cnl_shd.g_old_rec.address_line_2;

Line 363: per_cnl_shd.g_old_rec.address_line_2;

359: per_cnl_shd.g_old_rec.address_line_1;
360: End If;
361: If (p_rec.address_line_2 = hr_api.g_varchar2) then
362: p_rec.address_line_2 :=
363: per_cnl_shd.g_old_rec.address_line_2;
364: End If;
365: If (p_rec.address_line_3 = hr_api.g_varchar2) then
366: p_rec.address_line_3 :=
367: per_cnl_shd.g_old_rec.address_line_3;

Line 367: per_cnl_shd.g_old_rec.address_line_3;

363: per_cnl_shd.g_old_rec.address_line_2;
364: End If;
365: If (p_rec.address_line_3 = hr_api.g_varchar2) then
366: p_rec.address_line_3 :=
367: per_cnl_shd.g_old_rec.address_line_3;
368: End If;
369: If (p_rec.town_or_city = hr_api.g_varchar2) then
370: p_rec.town_or_city :=
371: per_cnl_shd.g_old_rec.town_or_city;

Line 371: per_cnl_shd.g_old_rec.town_or_city;

367: per_cnl_shd.g_old_rec.address_line_3;
368: End If;
369: If (p_rec.town_or_city = hr_api.g_varchar2) then
370: p_rec.town_or_city :=
371: per_cnl_shd.g_old_rec.town_or_city;
372: End If;
373: If (p_rec.country = hr_api.g_varchar2) then
374: p_rec.country :=
375: per_cnl_shd.g_old_rec.country;

Line 375: per_cnl_shd.g_old_rec.country;

371: per_cnl_shd.g_old_rec.town_or_city;
372: End If;
373: If (p_rec.country = hr_api.g_varchar2) then
374: p_rec.country :=
375: per_cnl_shd.g_old_rec.country;
376: End If;
377: If (p_rec.postal_code = hr_api.g_varchar2) then
378: p_rec.postal_code :=
379: per_cnl_shd.g_old_rec.postal_code;

Line 379: per_cnl_shd.g_old_rec.postal_code;

375: per_cnl_shd.g_old_rec.country;
376: End If;
377: If (p_rec.postal_code = hr_api.g_varchar2) then
378: p_rec.postal_code :=
379: per_cnl_shd.g_old_rec.postal_code;
380: End If;
381: If (p_rec.region_1 = hr_api.g_varchar2) then
382: p_rec.region_1 :=
383: per_cnl_shd.g_old_rec.region_1;

Line 383: per_cnl_shd.g_old_rec.region_1;

379: per_cnl_shd.g_old_rec.postal_code;
380: End If;
381: If (p_rec.region_1 = hr_api.g_varchar2) then
382: p_rec.region_1 :=
383: per_cnl_shd.g_old_rec.region_1;
384: End If;
385: If (p_rec.region_2 = hr_api.g_varchar2) then
386: p_rec.region_2 :=
387: per_cnl_shd.g_old_rec.region_2;

Line 387: per_cnl_shd.g_old_rec.region_2;

383: per_cnl_shd.g_old_rec.region_1;
384: End If;
385: If (p_rec.region_2 = hr_api.g_varchar2) then
386: p_rec.region_2 :=
387: per_cnl_shd.g_old_rec.region_2;
388: End If;
389: If (p_rec.region_3 = hr_api.g_varchar2) then
390: p_rec.region_3 :=
391: per_cnl_shd.g_old_rec.region_3;

Line 391: per_cnl_shd.g_old_rec.region_3;

387: per_cnl_shd.g_old_rec.region_2;
388: End If;
389: If (p_rec.region_3 = hr_api.g_varchar2) then
390: p_rec.region_3 :=
391: per_cnl_shd.g_old_rec.region_3;
392: End If;
393: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
394: p_rec.telephone_number_1 :=
395: per_cnl_shd.g_old_rec.telephone_number_1;

Line 395: per_cnl_shd.g_old_rec.telephone_number_1;

391: per_cnl_shd.g_old_rec.region_3;
392: End If;
393: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
394: p_rec.telephone_number_1 :=
395: per_cnl_shd.g_old_rec.telephone_number_1;
396: End If;
397: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
398: p_rec.telephone_number_2 :=
399: per_cnl_shd.g_old_rec.telephone_number_2;

Line 399: per_cnl_shd.g_old_rec.telephone_number_2;

395: per_cnl_shd.g_old_rec.telephone_number_1;
396: End If;
397: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
398: p_rec.telephone_number_2 :=
399: per_cnl_shd.g_old_rec.telephone_number_2;
400: End If;
401: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
402: p_rec.telephone_number_3 :=
403: per_cnl_shd.g_old_rec.telephone_number_3;

Line 403: per_cnl_shd.g_old_rec.telephone_number_3;

399: per_cnl_shd.g_old_rec.telephone_number_2;
400: End If;
401: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
402: p_rec.telephone_number_3 :=
403: per_cnl_shd.g_old_rec.telephone_number_3;
404: End If;
405: If (p_rec.loc_information13 = hr_api.g_varchar2) then
406: p_rec.loc_information13 :=
407: per_cnl_shd.g_old_rec.loc_information13;

Line 407: per_cnl_shd.g_old_rec.loc_information13;

403: per_cnl_shd.g_old_rec.telephone_number_3;
404: End If;
405: If (p_rec.loc_information13 = hr_api.g_varchar2) then
406: p_rec.loc_information13 :=
407: per_cnl_shd.g_old_rec.loc_information13;
408: End If;
409: If (p_rec.loc_information14 = hr_api.g_varchar2) then
410: p_rec.loc_information14 :=
411: per_cnl_shd.g_old_rec.loc_information14;

Line 411: per_cnl_shd.g_old_rec.loc_information14;

407: per_cnl_shd.g_old_rec.loc_information13;
408: End If;
409: If (p_rec.loc_information14 = hr_api.g_varchar2) then
410: p_rec.loc_information14 :=
411: per_cnl_shd.g_old_rec.loc_information14;
412: End If;
413: If (p_rec.loc_information15 = hr_api.g_varchar2) then
414: p_rec.loc_information15 :=
415: per_cnl_shd.g_old_rec.loc_information15;

Line 415: per_cnl_shd.g_old_rec.loc_information15;

411: per_cnl_shd.g_old_rec.loc_information14;
412: End If;
413: If (p_rec.loc_information15 = hr_api.g_varchar2) then
414: p_rec.loc_information15 :=
415: per_cnl_shd.g_old_rec.loc_information15;
416: End If;
417: If (p_rec.loc_information16 = hr_api.g_varchar2) then
418: p_rec.loc_information16 :=
419: per_cnl_shd.g_old_rec.loc_information16;

Line 419: per_cnl_shd.g_old_rec.loc_information16;

415: per_cnl_shd.g_old_rec.loc_information15;
416: End If;
417: If (p_rec.loc_information16 = hr_api.g_varchar2) then
418: p_rec.loc_information16 :=
419: per_cnl_shd.g_old_rec.loc_information16;
420: End If;
421: If (p_rec.loc_information17 = hr_api.g_varchar2) then
422: p_rec.loc_information17 :=
423: per_cnl_shd.g_old_rec.loc_information17;

Line 423: per_cnl_shd.g_old_rec.loc_information17;

419: per_cnl_shd.g_old_rec.loc_information16;
420: End If;
421: If (p_rec.loc_information17 = hr_api.g_varchar2) then
422: p_rec.loc_information17 :=
423: per_cnl_shd.g_old_rec.loc_information17;
424: End If;
425: If (p_rec.loc_information18 = hr_api.g_varchar2) then
426: p_rec.loc_information18 :=
427: per_cnl_shd.g_old_rec.loc_information18;

Line 427: per_cnl_shd.g_old_rec.loc_information18;

423: per_cnl_shd.g_old_rec.loc_information17;
424: End If;
425: If (p_rec.loc_information18 = hr_api.g_varchar2) then
426: p_rec.loc_information18 :=
427: per_cnl_shd.g_old_rec.loc_information18;
428: End If;
429: If (p_rec.loc_information19 = hr_api.g_varchar2) then
430: p_rec.loc_information19 :=
431: per_cnl_shd.g_old_rec.loc_information19;

Line 431: per_cnl_shd.g_old_rec.loc_information19;

427: per_cnl_shd.g_old_rec.loc_information18;
428: End If;
429: If (p_rec.loc_information19 = hr_api.g_varchar2) then
430: p_rec.loc_information19 :=
431: per_cnl_shd.g_old_rec.loc_information19;
432: End If;
433: If (p_rec.loc_information20 = hr_api.g_varchar2) then
434: p_rec.loc_information20 :=
435: per_cnl_shd.g_old_rec.loc_information20;

Line 435: per_cnl_shd.g_old_rec.loc_information20;

431: per_cnl_shd.g_old_rec.loc_information19;
432: End If;
433: If (p_rec.loc_information20 = hr_api.g_varchar2) then
434: p_rec.loc_information20 :=
435: per_cnl_shd.g_old_rec.loc_information20;
436: End If;
437: --
438: End convert_defs;
439: --

Line 445: ,p_rec in out nocopy per_cnl_shd.g_rec_type

441: -- |---------------------------------< upd >----------------------------------|
442: -- ----------------------------------------------------------------------------
443: Procedure upd
444: (p_effective_date in date
445: ,p_rec in out nocopy per_cnl_shd.g_rec_type
446: ) is
447: --
448: l_proc varchar2(72) := g_package||'upd';
449: --

Line 455: per_cnl_shd.lck

451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- We must lock the row which we need to update.
454: --
455: per_cnl_shd.lck
456: (p_rec.location_id
457: ,p_rec.object_version_number
458: );
459: --

Line 528: l_rec per_cnl_shd.g_rec_type;

524: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
525: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
526: ) is
527: --
528: l_rec per_cnl_shd.g_rec_type;
529: l_proc varchar2(72) := g_package||'upd';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);

Line 538: per_cnl_shd.convert_args

534: -- Call conversion function to turn arguments into the
535: -- l_rec structure.
536: --
537: l_rec :=
538: per_cnl_shd.convert_args
539: (p_configuration_code
540: ,p_configuration_context
541: ,p_location_id
542: ,p_location_code