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_PAR_BUS dependencies on PER_PARTICIPANTS

Line 275: (p_participant_id in per_participants.participant_id%TYPE

271: -- Internal Row Handler Use Only.
272: --
273: -- ----------------------------------------------------------------------------
274: procedure chk_participation_type
275: (p_participant_id in per_participants.participant_id%TYPE
276: ,p_object_version_number in per_participants.object_version_number%TYPE
277: ,p_participation_type in per_participants.participation_type%TYPE
278: ,p_effective_date in date
279: )

Line 276: ,p_object_version_number in per_participants.object_version_number%TYPE

272: --
273: -- ----------------------------------------------------------------------------
274: procedure chk_participation_type
275: (p_participant_id in per_participants.participant_id%TYPE
276: ,p_object_version_number in per_participants.object_version_number%TYPE
277: ,p_participation_type in per_participants.participation_type%TYPE
278: ,p_effective_date in date
279: )
280: is

Line 277: ,p_participation_type in per_participants.participation_type%TYPE

273: -- ----------------------------------------------------------------------------
274: procedure chk_participation_type
275: (p_participant_id in per_participants.participant_id%TYPE
276: ,p_object_version_number in per_participants.object_version_number%TYPE
277: ,p_participation_type in per_participants.participation_type%TYPE
278: ,p_effective_date in date
279: )
280: is
281: --

Line 319: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_TYPE'

315: --
316: EXCEPTION
317: when app_exception.application_exception then
318: if hr_multi_message.exception_add
319: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_TYPE'
320: ) then
321: raise;
322: end if;
323: end chk_participation_type;

Line 354: (p_participation_status in per_participants.participation_status%TYPE

350: -- Access Status:
351: -- Internal Row Handler Use Only.
352: -- ----------------------------------------------------------------------------
353: procedure chk_participation_status
354: (p_participation_status in per_participants.participation_status%TYPE
355: ,p_effective_date in date
356: )
357: is
358: --

Line 381: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_STATUS'

377: --
378: EXCEPTION
379: when app_exception.application_exception then
380: if hr_multi_message.exception_add
381: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_STATUS'
382: ) then
383: raise;
384: end if;
385:

Line 413: (p_participation_in_table in per_participants.participation_in_table%TYPE

409: -- Access Status
410: -- Internal Table Handler Use Only.
411: --
412: procedure chk_participation_in_table
413: (p_participation_in_table in per_participants.participation_in_table%TYPE
414: )
415: is
416: --
417: l_api_updating boolean;

Line 452: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_TABLE'

448: hr_utility.set_location('Leaving: '|| l_proc, 10);
449: EXCEPTION
450: when app_exception.application_exception then
451: if hr_multi_message.exception_add
452: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_TABLE'
453: ) then
454: raise;
455: end if;
456: end chk_participation_in_table;

Line 486: (p_participation_in_table in per_participants.participation_in_table%TYPE

482: -- Access Status
483: -- Internal Table Handler Use Only.
484: --
485: procedure chk_participation_in_column
486: (p_participation_in_table in per_participants.participation_in_table%TYPE
487: ,p_participation_in_column in per_participants.participation_in_column%TYPE
488: )
489: is
490: --

Line 487: ,p_participation_in_column in per_participants.participation_in_column%TYPE

483: -- Internal Table Handler Use Only.
484: --
485: procedure chk_participation_in_column
486: (p_participation_in_table in per_participants.participation_in_table%TYPE
487: ,p_participation_in_column in per_participants.participation_in_column%TYPE
488: )
489: is
490: --
491: l_api_updating boolean;

Line 526: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_COLUMN'

522:
523: EXCEPTION
524: when app_exception.application_exception then
525: if hr_multi_message.exception_add
526: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_COLUMN'
527: ) then
528: raise;
529: end if;
530: end chk_participation_in_column;

Line 563: (p_participation_in_table in per_participants.participation_in_table%TYPE

559: -- Access Status
560: -- Internal Table Handler Use Only.
561: --
562: procedure chk_participation_in_id
563: (p_participation_in_table in per_participants.participation_in_table%TYPE
564: ,p_participation_in_column in per_participants.participation_in_column%TYPE
565: ,p_participation_in_id in per_participants.participation_in_id%TYPE
566: ,p_business_group_id in per_participants.business_group_id%TYPE
567: )

Line 564: ,p_participation_in_column in per_participants.participation_in_column%TYPE

560: -- Internal Table Handler Use Only.
561: --
562: procedure chk_participation_in_id
563: (p_participation_in_table in per_participants.participation_in_table%TYPE
564: ,p_participation_in_column in per_participants.participation_in_column%TYPE
565: ,p_participation_in_id in per_participants.participation_in_id%TYPE
566: ,p_business_group_id in per_participants.business_group_id%TYPE
567: )
568: is

Line 565: ,p_participation_in_id in per_participants.participation_in_id%TYPE

561: --
562: procedure chk_participation_in_id
563: (p_participation_in_table in per_participants.participation_in_table%TYPE
564: ,p_participation_in_column in per_participants.participation_in_column%TYPE
565: ,p_participation_in_id in per_participants.participation_in_id%TYPE
566: ,p_business_group_id in per_participants.business_group_id%TYPE
567: )
568: is
569: --

Line 566: ,p_business_group_id in per_participants.business_group_id%TYPE

562: procedure chk_participation_in_id
563: (p_participation_in_table in per_participants.participation_in_table%TYPE
564: ,p_participation_in_column in per_participants.participation_in_column%TYPE
565: ,p_participation_in_id in per_participants.participation_in_id%TYPE
566: ,p_business_group_id in per_participants.business_group_id%TYPE
567: )
568: is
569: --
570: l_business_group_id per_participants.business_group_id%TYPE;

Line 570: l_business_group_id per_participants.business_group_id%TYPE;

566: ,p_business_group_id in per_participants.business_group_id%TYPE
567: )
568: is
569: --
570: l_business_group_id per_participants.business_group_id%TYPE;
571: l_exists varchar2(1);
572: l_proc varchar2(72) := g_package||'chk_participation_in_id';
573: l_sql_cursor integer; -- Dynamic sql cursor
574: l_dynamic_sql varchar2(2000); -- Dynamic sql text

Line 695: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_ID'

691: Exception
692:
693: when app_exception.application_exception then
694: if hr_multi_message.exception_add
695: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_ID'
696: ) then
697: raise;
698: end if;
699:

Line 759: (p_participant_id in per_participants.participant_id%TYPE

755: -- Internal Table Handler Use Only.
756: --
757: --
758: procedure chk_person_id
759: (p_participant_id in per_participants.participant_id%TYPE
760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE

Line 760: ,p_object_version_number in per_participants.object_version_number%TYPE

756: --
757: --
758: procedure chk_person_id
759: (p_participant_id in per_participants.participant_id%TYPE
760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE

Line 761: ,p_person_id in per_participants.person_id%TYPE

757: --
758: procedure chk_person_id
759: (p_participant_id in per_participants.participant_id%TYPE
760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE
765: ,p_participation_in_id in per_participants.participation_in_id%TYPE

Line 762: ,p_business_group_id in per_participants.business_group_id%TYPE

758: procedure chk_person_id
759: (p_participant_id in per_participants.participant_id%TYPE
760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE
765: ,p_participation_in_id in per_participants.participation_in_id%TYPE
766: ,p_effective_date in date

Line 763: ,p_participation_in_table in per_participants.participation_in_table%TYPE

759: (p_participant_id in per_participants.participant_id%TYPE
760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE
765: ,p_participation_in_id in per_participants.participation_in_id%TYPE
766: ,p_effective_date in date
767: )

Line 764: ,p_participation_in_column in per_participants.participation_in_column%TYPE

760: ,p_object_version_number in per_participants.object_version_number%TYPE
761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE
765: ,p_participation_in_id in per_participants.participation_in_id%TYPE
766: ,p_effective_date in date
767: )
768: is

Line 765: ,p_participation_in_id in per_participants.participation_in_id%TYPE

761: ,p_person_id in per_participants.person_id%TYPE
762: ,p_business_group_id in per_participants.business_group_id%TYPE
763: ,p_participation_in_table in per_participants.participation_in_table%TYPE
764: ,p_participation_in_column in per_participants.participation_in_column%TYPE
765: ,p_participation_in_id in per_participants.participation_in_id%TYPE
766: ,p_effective_date in date
767: )
768: is
769: --

Line 772: l_business_group_id per_participants.business_group_id%TYPE;

768: is
769: --
770: l_exists varchar2(1);
771: l_api_updating boolean;
772: l_business_group_id per_participants.business_group_id%TYPE;
773: l_proc varchar2(72) := g_package||'chk_chk_person_id';
774: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
775:
776: --

Line 828: from per_participants par

824: --
825: Cursor csr_person_id_unique
826: is
827: select 'Y'
828: from per_participants par
829: where ( (p_participant_id is null)
830: or(p_participant_id <> par.participant_id)
831: )
832: and par.participation_in_table = p_participation_in_table

Line 983: (p_associated_column1 => 'PER_PARTICIPANTS.PERSON_ID'

979: --
980: EXCEPTION
981: when app_exception.application_exception then
982: if hr_multi_message.exception_add
983: (p_associated_column1 => 'PER_PARTICIPANTS.PERSON_ID'
984: ) then
985: raise;
986: end if;
987: end chk_person_id;

Line 1077: ,p_descflex_name => 'PER_PARTICIPANTS'

1073: -- b) During insert.
1074: --
1075: hr_dflex_utility.ins_or_upd_descflex_attribs
1076: (p_appl_short_name => 'PER'
1077: ,p_descflex_name => 'PER_PARTICIPANTS'
1078: ,p_attribute_category => p_rec.attribute_category
1079: ,p_attribute1_name => 'ATTRIBUTE1'
1080: ,p_attribute1_value => p_rec.attribute1
1081: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1214: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPANT_USAGE_STATUS')

1210: EXCEPTION
1211:
1212: WHEN app_exception.application_exception THEN
1213: IF hr_multi_message.exception_add
1214: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPANT_USAGE_STATUS')
1215: THEN
1216: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1217: RAISE;
1218: END IF;

Line 1413: per_participants par

1409: --
1410: cursor csr_leg_code is
1411: select legislation_code
1412: from per_business_groups pbg,
1413: per_participants par
1414: where par.participant_id = p_participant_id
1415: and pbg.business_group_id = par.business_group_id;
1416:
1417: l_proc varchar2(72) := g_package||'return_legislation_code';