102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
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));
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: --
114: per_cnl_shd.constraint_error
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: --
114: per_cnl_shd.constraint_error
115: (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: --
119: per_cnl_shd.constraint_error
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: --
119: per_cnl_shd.constraint_error
120: (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;
124: End update_dml;
268: );
269: --
270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'PER_RI_CONFIG_LOCATIONS'
276: ,p_hook_type => 'AU');
270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'PER_RI_CONFIG_LOCATIONS'
276: ,p_hook_type => 'AU');
277: --
278: end;
333: -- p_rec plsql record structure
334: -- to see if a system default is being used. If a system default
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
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;
344: End If;
345: If (p_rec.location_code = hr_api.g_varchar2) then
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;
348: End If;
349: If (p_rec.description = hr_api.g_varchar2) then
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;
352: End If;
353: If (p_rec.style = hr_api.g_varchar2) then
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;
356: End If;
357: If (p_rec.address_line_1 = hr_api.g_varchar2) then
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;
360: End If;
361: If (p_rec.address_line_2 = hr_api.g_varchar2) then
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;
364: End If;
365: If (p_rec.address_line_3 = hr_api.g_varchar2) then
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;
368: End If;
369: If (p_rec.town_or_city = hr_api.g_varchar2) then
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;
372: End If;
373: If (p_rec.country = hr_api.g_varchar2) then
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;
376: End If;
377: If (p_rec.postal_code = hr_api.g_varchar2) then
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;
380: End If;
381: If (p_rec.region_1 = hr_api.g_varchar2) then
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;
384: End If;
385: If (p_rec.region_2 = hr_api.g_varchar2) then
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;
388: End If;
389: If (p_rec.region_3 = hr_api.g_varchar2) then
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;
392: End If;
393: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
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;
396: End If;
397: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
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;
400: End If;
401: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
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;
404: End If;
405: If (p_rec.loc_information13 = hr_api.g_varchar2) then
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;
408: End If;
409: If (p_rec.loc_information14 = hr_api.g_varchar2) then
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;
412: End If;
413: If (p_rec.loc_information15 = hr_api.g_varchar2) then
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;
416: End If;
417: If (p_rec.loc_information16 = hr_api.g_varchar2) then
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;
420: End If;
421: If (p_rec.loc_information17 = hr_api.g_varchar2) then
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;
424: End If;
425: If (p_rec.loc_information18 = hr_api.g_varchar2) then
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;
428: End If;
429: If (p_rec.loc_information19 = hr_api.g_varchar2) then
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;
432: End If;
433: If (p_rec.loc_information20 = hr_api.g_varchar2) then
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;
436: End If;
437: --
497: Procedure upd
498: (p_effective_date in date
499: ,p_location_id in number
500: ,p_object_version_number in out nocopy number
501: ,p_configuration_code in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
498: (p_effective_date in date
499: ,p_location_id in number
500: ,p_object_version_number in out nocopy number
501: ,p_configuration_code in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
499: ,p_location_id in number
500: ,p_object_version_number in out nocopy number
501: ,p_configuration_code in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
500: ,p_object_version_number in out nocopy number
501: ,p_configuration_code in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
501: ,p_configuration_code in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
502: ,p_configuration_context in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
503: ,p_location_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
504: ,p_description in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
505: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
506: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
507: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
508: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
509: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
510: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
511: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
512: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
513: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
514: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
515: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
516: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
524: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
517: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
524: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
525: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
518: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
524: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
525: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
526: ) is
519: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
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: --
520: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
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;
521: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
522: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
523: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
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';