APPS.PER_CNL_UPD dependencies on HR_API

Line 106: When hr_api.check_integrity_violated Then

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));

Line 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

Line 111: When hr_api.parent_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
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 116: When hr_api.unique_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
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 272: when hr_api.cannot_find_prog_unit then

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');

Line 274: hr_api.cannot_find_prog_unit_error

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;

Line 337: If (p_rec.configuration_code = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 501: ,p_configuration_code in varchar2 default hr_api.g_varchar2

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

Line 502: ,p_configuration_context 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

Line 503: ,p_location_code 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

Line 504: ,p_description 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

Line 505: ,p_style 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

Line 506: ,p_address_line_1 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

Line 507: ,p_address_line_2 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

Line 508: ,p_address_line_3 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

Line 509: ,p_town_or_city 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

Line 510: ,p_country 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

Line 511: ,p_postal_code 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

Line 512: ,p_region_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

Line 513: ,p_region_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

Line 514: ,p_region_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

Line 515: ,p_telephone_number_1 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

Line 516: ,p_telephone_number_2 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

Line 517: ,p_telephone_number_3 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

Line 518: ,p_loc_information13 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

Line 519: ,p_loc_information14 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

Line 520: ,p_loc_information15 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

Line 521: ,p_loc_information16 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

Line 522: ,p_loc_information17 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

Line 523: ,p_loc_information18 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
527: --

Line 524: ,p_loc_information19 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: --
528: l_rec per_cnl_shd.g_rec_type;

Line 525: ,p_loc_information20 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;
529: l_proc varchar2(72) := g_package||'upd';