APPS.PER_PSH_BUS dependencies on PER_SCORECARD_SHARING

Line 31: , per_scorecard_sharing psh

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_scorecard_sharing psh
32: , per_all_people_f ppf
33: where psh.sharing_instance_id = p_sharing_instance_id
34: and psh.person_id = ppf.person_id
35: and ppf.business_group_id = pbg.business_group_id;

Line 103: , per_scorecard_sharing psh

99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , per_scorecard_sharing psh
104: , per_all_people_f ppf
105: where psh.sharing_instance_id = p_sharing_instance_id
106: and psh.person_id = ppf.person_id
107: and ppf.business_group_id = pbg.business_group_id;

Line 273: ,p_descflex_name => 'PER_SCORECARD_SHARING'

269: -- b) During insert.
270: --
271: hr_dflex_utility.ins_or_upd_descflex_attribs
272: (p_appl_short_name => 'PER'
273: ,p_descflex_name => 'PER_SCORECARD_SHARING'
274: ,p_attribute_category => p_rec.attribute_category
275: ,p_attribute1_name => 'ATTRIBUTE1'
276: ,p_attribute1_value => p_rec.attribute1
277: ,p_attribute2_name => 'ATTRIBUTE2'

Line 452: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID')

448: EXCEPTION
449:
450: WHEN app_exception.application_exception THEN
451: IF hr_multi_message.exception_add
452: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID')
453: THEN
454: hr_utility.set_location(' Leaving:'|| l_proc, 980);
455: RAISE;
456: END IF;

Line 518: (p_associated_column1 => 'PER_SCORECARD_SHARING.PERSON_ID'

514: --
515: exception
516: when app_exception.application_exception then
517: if hr_multi_message.exception_add
518: (p_associated_column1 => 'PER_SCORECARD_SHARING.PERSON_ID'
519: ) then
520: raise;
521: end if;
522:

Line 540: FROM per_scorecard_sharing

536: l_exists varchar2(1);
537: --
538: CURSOR csr_chk_unique IS
539: SELECT 'Y'
540: FROM per_scorecard_sharing
541: WHERE scorecard_id = p_scorecard_id
542: AND person_id = p_person_id;
543: --
544: BEGIN

Line 563: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID'

559: --
560: EXCEPTION
561: WHEN app_exception.application_exception THEN
562: IF hr_multi_message.exception_add
563: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID'
564: ,p_associated_column2 => 'PER_SCORECARD_SHARING.PERSON_ID')
565: THEN
566: hr_utility.set_location(' Leaving:'|| l_proc, 80);
567: RAISE;

Line 564: ,p_associated_column2 => 'PER_SCORECARD_SHARING.PERSON_ID')

560: EXCEPTION
561: WHEN app_exception.application_exception THEN
562: IF hr_multi_message.exception_add
563: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID'
564: ,p_associated_column2 => 'PER_SCORECARD_SHARING.PERSON_ID')
565: THEN
566: hr_utility.set_location(' Leaving:'|| l_proc, 80);
567: RAISE;
568: END IF;