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 271: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

267: hr_utility.set_location(' Leaving:'|| l_proc, 3);
268: exception
269: when app_exception.application_exception then
270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
272: ) then
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 4);
275: --

Line 314: (p_phone_id in per_phones.phone_id%TYPE

310: --
311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: procedure chk_phone_type_limits
314: (p_phone_id in per_phones.phone_id%TYPE
315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE

Line 315: ,p_date_from in per_phones.date_from%TYPE

311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: procedure chk_phone_type_limits
314: (p_phone_id in per_phones.phone_id%TYPE
315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE

Line 316: ,p_date_to in per_phones.date_to%TYPE

312: -- ----------------------------------------------------------------------------
313: procedure chk_phone_type_limits
314: (p_phone_id in per_phones.phone_id%TYPE
315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge

Line 317: ,p_phone_type in per_phones.phone_type%TYPE

313: procedure chk_phone_type_limits
314: (p_phone_id in per_phones.phone_id%TYPE
315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
321: ,p_object_version_number in per_phones.object_version_number%TYPE) is

Line 318: ,p_parent_id in per_phones.parent_id%TYPE

314: (p_phone_id in per_phones.phone_id%TYPE
315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
321: ,p_object_version_number in per_phones.object_version_number%TYPE) is
322: --

Line 319: ,p_parent_table in per_phones.parent_table%TYPE

315: ,p_date_from in per_phones.date_from%TYPE
316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
321: ,p_object_version_number in per_phones.object_version_number%TYPE) is
322: --
323: l_proc varchar2(72) := g_package||'chk_phone_type_limits';

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

316: ,p_date_to in per_phones.date_to%TYPE
317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
321: ,p_object_version_number in per_phones.object_version_number%TYPE) is
322: --
323: l_proc varchar2(72) := g_package||'chk_phone_type_limits';
324: l_api_updating boolean;

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

317: ,p_phone_type in per_phones.phone_type%TYPE
318: ,p_parent_id in per_phones.parent_id%TYPE
319: ,p_parent_table in per_phones.parent_table%TYPE
320: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
321: ,p_object_version_number in per_phones.object_version_number%TYPE) is
322: --
323: l_proc varchar2(72) := g_package||'chk_phone_type_limits';
324: l_api_updating boolean;
325: l_dummy number;

Line 329: from per_phones phn

325: l_dummy number;
326: --
327: cursor csr_home_phone_limit is
328: select phn.phone_id
329: from per_phones phn
330: where phn.phone_type = 'H1'
331: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
332: and (
333: p_date_from between phn.date_from and

Line 355: from per_phones phn

351:
352: --
353: cursor csr_work_phone_limit is
354: select phn.phone_id
355: from per_phones phn
356: where phn.phone_type = 'W1'
357: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
358: and (
359: p_date_from between phn.date_from and

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

377: --
378: begin
379: hr_utility.set_location('Entering:'|| l_proc, 1);
380: if hr_multi_message.no_all_inclusive_error
381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'

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

378: begin
379: hr_utility.set_location('Entering:'|| l_proc, 1);
380: if hr_multi_message.no_all_inclusive_error
381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

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

379: hr_utility.set_location('Entering:'|| l_proc, 1);
380: if hr_multi_message.no_all_inclusive_error
381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'

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

380: if hr_multi_message.no_all_inclusive_error
381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'

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

381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'

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

382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
390: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'

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

383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'
384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
390: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
391: ) then

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

384: ,p_check_column4 => 'PER_PHONES.PARENT_ID'
385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
390: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
391: ) then
392: --

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

385: ,p_check_column5 => 'PER_PHONES.PARTY_ID'
386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
390: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
391: ) then
392: --
393: -- Only proceed with validation if :

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

386: ,p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
387: ,p_associated_column2 => 'PER_PHONES.DATE_FROM'
388: ,p_associated_column3 => 'PER_PHONES.PARENT_TABLE'
389: ,p_associated_column4 => 'PER_PHONES.PARENT_ID'
390: ,p_associated_column5 => 'PER_PHONES.PARTY_ID'
391: ) then
392: --
393: -- Only proceed with validation if :
394: -- a) The current g_old_rec is current and

Line 493: p_parent_table in per_phones.parent_table%TYPE

489: --
490: -- ---------------------------------------------------------------------------
491: procedure chk_parent_table
492: (
493: p_parent_table in per_phones.parent_table%TYPE
494: ) is
495: --
496: l_proc varchar2(72) := g_package||'chk_parent_table';
497: --

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

520: --
521: exception
522: when app_exception.application_exception then
523: if hr_multi_message.exception_add
524: (p_associated_column1 => 'PER_PHONES.PARENT_TABLE'
525: ) then
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 6);
528: --

Line 570: (p_phone_id in per_phones.phone_id%TYPE

566: -- {End of Comments}
567: --
568: -- ---------------------------------------------------------------------------
569: procedure chk_parent_id
570: (p_phone_id in per_phones.phone_id%TYPE
571: ,p_parent_id in per_phones.parent_id%TYPE
572: ,p_parent_table in per_phones.parent_table%TYPE
573: ,p_object_version_number in per_phones.object_version_number%TYPE
574: ) is

Line 571: ,p_parent_id in per_phones.parent_id%TYPE

567: --
568: -- ---------------------------------------------------------------------------
569: procedure chk_parent_id
570: (p_phone_id in per_phones.phone_id%TYPE
571: ,p_parent_id in per_phones.parent_id%TYPE
572: ,p_parent_table in per_phones.parent_table%TYPE
573: ,p_object_version_number in per_phones.object_version_number%TYPE
574: ) is
575: --

Line 572: ,p_parent_table in per_phones.parent_table%TYPE

568: -- ---------------------------------------------------------------------------
569: procedure chk_parent_id
570: (p_phone_id in per_phones.phone_id%TYPE
571: ,p_parent_id in per_phones.parent_id%TYPE
572: ,p_parent_table in per_phones.parent_table%TYPE
573: ,p_object_version_number in per_phones.object_version_number%TYPE
574: ) is
575: --
576: l_proc varchar2(72) := g_package||'chk_parent_id';

Line 573: ,p_object_version_number in per_phones.object_version_number%TYPE

569: procedure chk_parent_id
570: (p_phone_id in per_phones.phone_id%TYPE
571: ,p_parent_id in per_phones.parent_id%TYPE
572: ,p_parent_table in per_phones.parent_table%TYPE
573: ,p_object_version_number in per_phones.object_version_number%TYPE
574: ) is
575: --
576: l_proc varchar2(72) := g_package||'chk_parent_id';
577: l_dummy number;

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

596: --
597: hr_utility.set_location(l_proc, 2);
598: --
599: if hr_multi_message.no_exclusive_error
600: (p_check_column1 => 'PER_PHONES.PARENT_TABLE'
601: ) then
602: --
603: hr_utility.set_location(l_proc, 3);
604: --

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

658: --
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
663: ) then
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 6);
666: --

Line 708: l_party_id per_phones.party_id%TYPE;

704: ,p_effective_date in date
705: )is
706: --
707: l_proc varchar2(72) := g_package||'chk_party_id';
708: l_party_id per_phones.party_id%TYPE;
709: l_party_id2 per_phones.party_id%TYPE;
710: --
711: --
712: -- cursor to check that the party_id maches person_id

Line 709: l_party_id2 per_phones.party_id%TYPE;

705: )is
706: --
707: l_proc varchar2(72) := g_package||'chk_party_id';
708: l_party_id per_phones.party_id%TYPE;
709: l_party_id2 per_phones.party_id%TYPE;
710: --
711: --
712: -- cursor to check that the party_id maches person_id
713: --

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

730: --
731: --
732: if p_rec.parent_id is not null then
733: if hr_multi_message.no_exclusive_error
734: (p_check_column1 => 'PER_PHONES.PARENT_ID'
735: ) then
736: --
737: open csr_get_party_id;
738: fetch csr_get_party_id into l_party_id;

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

747: if p_rec.party_id <> nvl(l_party_id,-1) then
748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
749: hr_utility.set_location(l_proc,40);
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
752: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
753: );
754: end if;
755: else

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

748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
749: hr_utility.set_location(l_proc,40);
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
752: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
753: );
754: end if;
755: else
756: --

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

767: if p_rec.party_id is null then
768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
769: hr_utility.set_location(l_proc,70);
770: hr_multi_message.add
771: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
772: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
773: );
774: else
775: open csr_valid_party_id;

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

768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
769: hr_utility.set_location(l_proc,70);
770: hr_multi_message.add
771: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
772: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
773: );
774: else
775: open csr_valid_party_id;
776: fetch csr_valid_party_id into l_party_id2;

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

781: close csr_valid_party_id;
782: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
783: hr_utility.set_location(l_proc,90);
784: hr_multi_message.add
785: (p_associated_column1 => 'PER_PHONES.PARTY_ID'
786: );
787: else
788: close csr_valid_party_id;
789: end if;

Line 826: p_object_version_number in per_phones.object_version_number%TYPE

822: --
823: -- ---------------------------------------------------------------------------
824: procedure chk_object_version_number
825: (
826: p_object_version_number in per_phones.object_version_number%TYPE
827: ) is
828: --
829: l_proc varchar2(72) := g_package||'chk_object_version_number';
830: --

Line 1065: ,p_descflex_name => 'PER_PHONES'

1061: -- b) During insert.
1062: --
1063: hr_dflex_utility.ins_or_upd_descflex_attribs
1064: (p_appl_short_name => 'PER'
1065: ,p_descflex_name => 'PER_PHONES'
1066: ,p_attribute_category => p_rec.attribute_category
1067: ,p_attribute1_name => 'ATTRIBUTE1'
1068: ,p_attribute1_value => p_rec.attribute1
1069: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1165: , p_validity in per_phones.validity%TYPE

1161: --
1162: -- ---------------------------------------------------------------------------
1163: procedure chk_validity
1164: ( p_effective_date in date
1165: , p_validity in per_phones.validity%TYPE
1166: )is
1167: --
1168: l_proc varchar2(72) := g_package||'chk_validity';
1169: --

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

1185: hr_utility.set_location(' Leaving:'||l_proc, 20);
1186: exception
1187: when app_exception.application_exception then
1188: if hr_multi_message.exception_add
1189: (p_associated_column1 => 'PER_PHONES.VALIDITY'
1190: ) then
1191: --
1192: hr_utility.set_location(' Leaving:'||l_proc, 30);
1193: --

Line 1443: , per_phones phn

1439: --
1440: cursor csr_leg_code is
1441: select pbg.legislation_code
1442: from per_business_groups pbg
1443: , per_phones phn
1444: , per_all_people_f per
1445: where phn.phone_id = p_phone_id
1446: and phn.parent_id = per.person_id
1447: and pbg.business_group_id = per.business_group_id;