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_PHN_BUS dependencies on PER_PHONES

Line 106: (p_phone_id in per_phones.phone_id%TYPE

102: -- {End of Comments}
103: --
104: -- ---------------------------------------------------------------------------
105: procedure chk_date_from
106: (p_phone_id in per_phones.phone_id%TYPE
107: ,p_date_from in per_phones.date_from%TYPE
108: ,p_date_to in per_phones.date_to%TYPE
109: ,p_object_version_number in per_phones.object_version_number%TYPE
110: ) is

Line 107: ,p_date_from in per_phones.date_from%TYPE

103: --
104: -- ---------------------------------------------------------------------------
105: procedure chk_date_from
106: (p_phone_id in per_phones.phone_id%TYPE
107: ,p_date_from in per_phones.date_from%TYPE
108: ,p_date_to in per_phones.date_to%TYPE
109: ,p_object_version_number in per_phones.object_version_number%TYPE
110: ) is
111: --

Line 108: ,p_date_to in per_phones.date_to%TYPE

104: -- ---------------------------------------------------------------------------
105: procedure chk_date_from
106: (p_phone_id in per_phones.phone_id%TYPE
107: ,p_date_from in per_phones.date_from%TYPE
108: ,p_date_to in per_phones.date_to%TYPE
109: ,p_object_version_number in per_phones.object_version_number%TYPE
110: ) is
111: --
112: l_proc varchar2(72) := g_package||'chk_date_from';

Line 109: ,p_object_version_number in per_phones.object_version_number%TYPE

105: procedure chk_date_from
106: (p_phone_id in per_phones.phone_id%TYPE
107: ,p_date_from in per_phones.date_from%TYPE
108: ,p_date_to in per_phones.date_to%TYPE
109: ,p_object_version_number in per_phones.object_version_number%TYPE
110: ) is
111: --
112: l_proc varchar2(72) := g_package||'chk_date_from';
113: l_api_updating boolean;

Line 157: (p_associated_column1 => 'PER_PHONES.DATE_FROM'

153: --
154: exception
155: when app_exception.application_exception then
156: if hr_multi_message.exception_add
157: (p_associated_column1 => 'PER_PHONES.DATE_FROM'
158: ,p_associated_column2 => 'PER_PHONES.DATE_TO'
159: ) then
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 158: ,p_associated_column2 => 'PER_PHONES.DATE_TO'

154: exception
155: when app_exception.application_exception then
156: if hr_multi_message.exception_add
157: (p_associated_column1 => 'PER_PHONES.DATE_FROM'
158: ,p_associated_column2 => 'PER_PHONES.DATE_TO'
159: ) then
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 4);
162: --

Line 205: (p_phone_id in per_phones.phone_id%TYPE

201: --
202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: procedure chk_phone_type
205: (p_phone_id in per_phones.phone_id%TYPE
206: ,p_phone_type in per_phones.phone_type%TYPE
207: ,p_phone_number in per_phones.phone_number%TYPE
208: ,p_effective_date in date
209: ,p_object_version_number in per_phones.object_version_number%TYPE) is

Line 206: ,p_phone_type in per_phones.phone_type%TYPE

202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: procedure chk_phone_type
205: (p_phone_id in per_phones.phone_id%TYPE
206: ,p_phone_type in per_phones.phone_type%TYPE
207: ,p_phone_number in per_phones.phone_number%TYPE
208: ,p_effective_date in date
209: ,p_object_version_number in per_phones.object_version_number%TYPE) is
210: --

Line 207: ,p_phone_number in per_phones.phone_number%TYPE

203: -- ----------------------------------------------------------------------------
204: procedure chk_phone_type
205: (p_phone_id in per_phones.phone_id%TYPE
206: ,p_phone_type in per_phones.phone_type%TYPE
207: ,p_phone_number in per_phones.phone_number%TYPE
208: ,p_effective_date in date
209: ,p_object_version_number in per_phones.object_version_number%TYPE) is
210: --
211: l_proc varchar2(72) := g_package||'chk_phone_type';

Line 209: ,p_object_version_number in per_phones.object_version_number%TYPE) is

205: (p_phone_id in per_phones.phone_id%TYPE
206: ,p_phone_type in per_phones.phone_type%TYPE
207: ,p_phone_number in per_phones.phone_number%TYPE
208: ,p_effective_date in date
209: ,p_object_version_number in per_phones.object_version_number%TYPE) is
210: --
211: l_proc varchar2(72) := g_package||'chk_phone_type';
212: l_api_updating boolean;
213: --

Line 277: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

273: hr_utility.set_location(' Leaving:'|| l_proc, 3);
274: exception
275: when app_exception.application_exception then
276: if hr_multi_message.exception_add
277: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
278: ) then
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 4);
281: --

Line 320: (p_phone_id in per_phones.phone_id%TYPE

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: procedure chk_phone_type_limits
320: (p_phone_id in per_phones.phone_id%TYPE
321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE

Line 321: ,p_date_from in per_phones.date_from%TYPE

317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: procedure chk_phone_type_limits
320: (p_phone_id in per_phones.phone_id%TYPE
321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE

Line 322: ,p_date_to in per_phones.date_to%TYPE

318: -- ----------------------------------------------------------------------------
319: procedure chk_phone_type_limits
320: (p_phone_id in per_phones.phone_id%TYPE
321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge

Line 323: ,p_phone_type in per_phones.phone_type%TYPE

319: procedure chk_phone_type_limits
320: (p_phone_id in per_phones.phone_id%TYPE
321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
327: ,p_object_version_number in per_phones.object_version_number%TYPE) is

Line 324: ,p_parent_id in per_phones.parent_id%TYPE

320: (p_phone_id in per_phones.phone_id%TYPE
321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
327: ,p_object_version_number in per_phones.object_version_number%TYPE) is
328: --

Line 325: ,p_parent_table in per_phones.parent_table%TYPE

321: ,p_date_from in per_phones.date_from%TYPE
322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
327: ,p_object_version_number in per_phones.object_version_number%TYPE) is
328: --
329: l_proc varchar2(72) := g_package||'chk_phone_type_limits';

Line 326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge

322: ,p_date_to in per_phones.date_to%TYPE
323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
327: ,p_object_version_number in per_phones.object_version_number%TYPE) is
328: --
329: l_proc varchar2(72) := g_package||'chk_phone_type_limits';
330: l_api_updating boolean;

Line 327: ,p_object_version_number in per_phones.object_version_number%TYPE) is

323: ,p_phone_type in per_phones.phone_type%TYPE
324: ,p_parent_id in per_phones.parent_id%TYPE
325: ,p_parent_table in per_phones.parent_table%TYPE
326: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
327: ,p_object_version_number in per_phones.object_version_number%TYPE) is
328: --
329: l_proc varchar2(72) := g_package||'chk_phone_type_limits';
330: l_api_updating boolean;
331: l_dummy number;

Line 335: from per_phones phn

331: l_dummy number;
332: --
333: cursor csr_home_phone_limit is
334: select phn.phone_id
335: from per_phones phn
336: where phn.phone_type = 'H1'
337: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
338: and (
339: p_date_from between phn.date_from and

Line 361: from per_phones phn

357:
358: --
359: cursor csr_work_phone_limit is
360: select phn.phone_id
361: from per_phones phn
362: where phn.phone_type = 'W1'
363: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
364: and (
365: p_date_from between phn.date_from and

Line 387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'

383: --
384: begin
385: hr_utility.set_location('Entering:'|| l_proc, 1);
386: if hr_multi_message.no_all_inclusive_error
387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'

Line 388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'

384: begin
385: hr_utility.set_location('Entering:'|| l_proc, 1);
386: if hr_multi_message.no_all_inclusive_error
387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

Line 389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'

385: hr_utility.set_location('Entering:'|| l_proc, 1);
386: if hr_multi_message.no_all_inclusive_error
387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'

Line 390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'

386: if hr_multi_message.no_all_inclusive_error
387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'

Line 391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'

387: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'

Line 392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

388: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'

Line 393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'

389: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
397: ) then

Line 394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'

390: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
397: ) then
398: --

Line 395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'

391: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
397: ) then
398: --
399: -- Only proceed with validation if :

Line 396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'

392: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
393: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
394: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
395: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
396: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
397: ) then
398: --
399: -- Only proceed with validation if :
400: -- a) The current g_old_rec is current and

Line 499: p_parent_table in per_phones.parent_table%TYPE

495: --
496: -- ---------------------------------------------------------------------------
497: procedure chk_parent_table
498: (
499: p_parent_table in per_phones.parent_table%TYPE
500: ) is
501: --
502: l_proc varchar2(72) := g_package||'chk_parent_table';
503: --

Line 530: (p_associated_column1 => 'PER_PHONES.PARENT_TABLE'

526: --
527: exception
528: when app_exception.application_exception then
529: if hr_multi_message.exception_add
530: (p_associated_column1 => 'PER_PHONES.PARENT_TABLE'
531: ) then
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 6);
534: --

Line 576: (p_phone_id in per_phones.phone_id%TYPE

572: -- {End of Comments}
573: --
574: -- ---------------------------------------------------------------------------
575: procedure chk_parent_id
576: (p_phone_id in per_phones.phone_id%TYPE
577: ,p_parent_id in per_phones.parent_id%TYPE
578: ,p_parent_table in per_phones.parent_table%TYPE
579: ,p_object_version_number in per_phones.object_version_number%TYPE
580: ) is

Line 577: ,p_parent_id in per_phones.parent_id%TYPE

573: --
574: -- ---------------------------------------------------------------------------
575: procedure chk_parent_id
576: (p_phone_id in per_phones.phone_id%TYPE
577: ,p_parent_id in per_phones.parent_id%TYPE
578: ,p_parent_table in per_phones.parent_table%TYPE
579: ,p_object_version_number in per_phones.object_version_number%TYPE
580: ) is
581: --

Line 578: ,p_parent_table in per_phones.parent_table%TYPE

574: -- ---------------------------------------------------------------------------
575: procedure chk_parent_id
576: (p_phone_id in per_phones.phone_id%TYPE
577: ,p_parent_id in per_phones.parent_id%TYPE
578: ,p_parent_table in per_phones.parent_table%TYPE
579: ,p_object_version_number in per_phones.object_version_number%TYPE
580: ) is
581: --
582: l_proc varchar2(72) := g_package||'chk_parent_id';

Line 579: ,p_object_version_number in per_phones.object_version_number%TYPE

575: procedure chk_parent_id
576: (p_phone_id in per_phones.phone_id%TYPE
577: ,p_parent_id in per_phones.parent_id%TYPE
578: ,p_parent_table in per_phones.parent_table%TYPE
579: ,p_object_version_number in per_phones.object_version_number%TYPE
580: ) is
581: --
582: l_proc varchar2(72) := g_package||'chk_parent_id';
583: l_dummy number;

Line 606: (p_check_column1 => 'PER_PHONES.PARENT_TABLE'

602: --
603: hr_utility.set_location(l_proc, 2);
604: --
605: if hr_multi_message.no_exclusive_error
606: (p_check_column1 => 'PER_PHONES.PARENT_TABLE'
607: ) then
608: --
609: hr_utility.set_location(l_proc, 3);
610: --

Line 668: (p_associated_column1 => 'PER_PHONES.PARENT_ID'

664: --
665: exception
666: when app_exception.application_exception then
667: if hr_multi_message.exception_add
668: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
669: ) then
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 6);
672: --

Line 714: l_party_id per_phones.party_id%TYPE;

710: ,p_effective_date in date
711: )is
712: --
713: l_proc varchar2(72) := g_package||'chk_party_id';
714: l_party_id per_phones.party_id%TYPE;
715: l_party_id2 per_phones.party_id%TYPE;
716: --
717: --
718: -- cursor to check that the party_id maches person_id

Line 715: l_party_id2 per_phones.party_id%TYPE;

711: )is
712: --
713: l_proc varchar2(72) := g_package||'chk_party_id';
714: l_party_id per_phones.party_id%TYPE;
715: l_party_id2 per_phones.party_id%TYPE;
716: --
717: --
718: -- cursor to check that the party_id maches person_id
719: --

Line 740: (p_check_column1 => 'PER_PHONES.PARENT_ID'

736: --
737: --
738: if p_rec.parent_id is not null then
739: if hr_multi_message.no_exclusive_error
740: (p_check_column1 => 'PER_PHONES.PARENT_ID'
741: ) then
742: --
743: open csr_get_party_id;
744: fetch csr_get_party_id into l_party_id;

Line 757: (p_associated_column1 => 'PER_PHONES.PARENT_ID'

753: if p_rec.party_id <> nvl(l_party_id,-1) then
754: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
755: hr_utility.set_location(l_proc,40);
756: hr_multi_message.add
757: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
758: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
759: );
760: end if;
761: else

Line 758: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'

754: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
755: hr_utility.set_location(l_proc,40);
756: hr_multi_message.add
757: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
758: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
759: );
760: end if;
761: else
762: --

Line 777: (p_associated_column1 => 'PER_PHONES.PARENT_ID'

773: if p_rec.party_id is null then
774: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
775: hr_utility.set_location(l_proc,70);
776: hr_multi_message.add
777: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
778: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
779: );
780: else
781: open csr_valid_party_id;

Line 778: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'

774: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
775: hr_utility.set_location(l_proc,70);
776: hr_multi_message.add
777: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
778: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
779: );
780: else
781: open csr_valid_party_id;
782: fetch csr_valid_party_id into l_party_id2;

Line 791: (p_associated_column1 => 'PER_PHONES.PARTY_ID'

787: close csr_valid_party_id;
788: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
789: hr_utility.set_location(l_proc,90);
790: hr_multi_message.add
791: (p_associated_column1 => 'PER_PHONES.PARTY_ID'
792: );
793: else
794: close csr_valid_party_id;
795: end if;

Line 832: p_object_version_number in per_phones.object_version_number%TYPE

828: --
829: -- ---------------------------------------------------------------------------
830: procedure chk_object_version_number
831: (
832: p_object_version_number in per_phones.object_version_number%TYPE
833: ) is
834: --
835: l_proc varchar2(72) := g_package||'chk_object_version_number';
836: --

Line 1071: ,p_descflex_name => 'PER_PHONES'

1067: -- b) During insert.
1068: --
1069: hr_dflex_utility.ins_or_upd_descflex_attribs
1070: (p_appl_short_name => 'PER'
1071: ,p_descflex_name => 'PER_PHONES'
1072: ,p_attribute_category => p_rec.attribute_category
1073: ,p_attribute1_name => 'ATTRIBUTE1'
1074: ,p_attribute1_value => p_rec.attribute1
1075: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1171: , p_validity in per_phones.validity%TYPE

1167: --
1168: -- ---------------------------------------------------------------------------
1169: procedure chk_validity
1170: ( p_effective_date in date
1171: , p_validity in per_phones.validity%TYPE
1172: )is
1173: --
1174: l_proc varchar2(72) := g_package||'chk_validity';
1175: --

Line 1195: (p_associated_column1 => 'PER_PHONES.VALIDITY'

1191: hr_utility.set_location(' Leaving:'||l_proc, 20);
1192: exception
1193: when app_exception.application_exception then
1194: if hr_multi_message.exception_add
1195: (p_associated_column1 => 'PER_PHONES.VALIDITY'
1196: ) then
1197: --
1198: hr_utility.set_location(' Leaving:'||l_proc, 30);
1199: --

Line 1494: , per_phones phn

1490: --
1491: cursor csr_leg_code is
1492: select pbg.legislation_code
1493: from per_business_groups pbg
1494: , per_phones phn
1495: , per_all_people_f per
1496: where phn.phone_id = p_phone_id
1497: and phn.parent_id = per.person_id
1498: and pbg.business_group_id = per.business_group_id;