APPS.PER_PMS_BUS dependencies on PER_PERSONAL_SCORECARDS

Line 33: , per_personal_scorecards pms

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_all_assignments_f paf
33: , per_personal_scorecards pms
34: where pms.scorecard_id = p_scorecard_id
35: and pms.assignment_id = paf.assignment_id
36: and paf.business_group_id = pbg.business_group_id;
37:

Line 106: , per_personal_scorecards pms

102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , per_all_assignments_f paf
106: , per_personal_scorecards pms
107: where pms.scorecard_id = p_scorecard_id
108: and pms.assignment_id = paf.assignment_id
109: and paf.business_group_id = pbg.business_group_id;
110:

Line 276: ,p_descflex_name => 'PER_PERSONAL_SCORECARDS'

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

Line 525: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')

521: EXCEPTION
522:
523: WHEN app_exception.application_exception THEN
524: IF hr_multi_message.exception_add
525: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')
526: THEN
527: hr_utility.set_location(' Leaving:'|| l_proc, 980);
528: RAISE;
529: END IF;

Line 616: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID')

612: EXCEPTION
613:
614: WHEN app_exception.application_exception THEN
615: IF hr_multi_message.exception_add
616: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID')
617: THEN
618: hr_utility.set_location(' Leaving:'|| l_proc, 980);
619: RAISE;
620: END IF;

Line 663: FROM per_personal_scorecards pms

659: --
660:
661: CURSOR csr_chk_duplicate IS
662: SELECT 'TRUE'
663: FROM per_personal_scorecards pms
664: WHERE pms.plan_id = p_plan_id
665: AND pms.assignment_id = p_assignment_id
666: AND pms.scorecard_id <> nvl(p_scorecard_id, hr_api.g_number)
667: AND pms.STATUS_CODE <> 'TRANSFER_OUT';

Line 720: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID'

716: EXCEPTION
717:
718: WHEN app_exception.application_exception THEN
719: IF hr_multi_message.exception_add
720: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID'
721: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')
722: THEN
723: hr_utility.set_location(' Leaving:'|| l_proc, 980);
724: RAISE;

Line 721: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')

717:
718: WHEN app_exception.application_exception THEN
719: IF hr_multi_message.exception_add
720: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID'
721: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.ASSIGNMENT_ID')
722: THEN
723: hr_utility.set_location(' Leaving:'|| l_proc, 980);
724: RAISE;
725: END IF;

Line 879: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.START_DATE'

875: EXCEPTION
876:
877: WHEN app_exception.application_exception THEN
878: IF hr_multi_message.exception_add
879: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.START_DATE'
880: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.END_DATE')
881: THEN
882: hr_utility.set_location(' Leaving:'|| l_proc, 980);
883: RAISE;

Line 880: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.END_DATE')

876:
877: WHEN app_exception.application_exception THEN
878: IF hr_multi_message.exception_add
879: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.START_DATE'
880: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.END_DATE')
881: THEN
882: hr_utility.set_location(' Leaving:'|| l_proc, 980);
883: RAISE;
884: END IF;

Line 930: FROM per_personal_scorecards pms

926: --
927:
928: CURSOR csr_chk_scorecard_name IS
929: SELECT 'TRUE'
930: FROM per_personal_scorecards pms
931: WHERE pms.assignment_id = p_assignment_id
932: AND pms.scorecard_id <> nvl(p_scorecard_id, hr_api.g_number)
933: AND upper(trim(pms.scorecard_name)) = upper(trim(p_scorecard_name));
934: --

Line 1043: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.CREATOR_TYPE')

1039: EXCEPTION
1040:
1041: WHEN app_exception.application_exception THEN
1042: IF hr_multi_message.exception_add
1043: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.CREATOR_TYPE')
1044: THEN
1045: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1046: RAISE;
1047: END IF;

Line 1131: (p_associated_column1 =>'PER_PERSONAL_SCORECARDS.STATUS_CODE')

1127: EXCEPTION
1128:
1129: WHEN app_exception.application_exception THEN
1130: IF hr_multi_message.exception_add
1131: (p_associated_column1 =>'PER_PERSONAL_SCORECARDS.STATUS_CODE')
1132: THEN
1133: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1134: RAISE;
1135: END IF;