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_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 882: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.START_DATE'

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

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

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

Line 933: FROM per_personal_scorecards pms

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

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

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

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

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

Line 1175: FROM per_personal_scorecards pps

1171:
1172: CURSOR csr_appr_exists (p_scorecard_id IN number)
1173: IS
1174: SELECT 'Y' from dual where exists( select null
1175: FROM per_personal_scorecards pps
1176: , per_appraisal_periods pap
1177: WHERE scorecard_id = p_scorecard_id
1178: AND pap.plan_id = pps.plan_id
1179: AND NVL(p_obj_setting_deadline, hr_api.g_sot) >= pap.task_start_date