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_PRT_BUS dependencies on PER_PERFORMANCE_RATINGS

Line 92: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE

88: -- - Internal table handler use only.
89:
90:
91: procedure chk_appraisal_id
92: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
93: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
94: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
95: )
96: is

Line 93: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE

89:
90:
91: procedure chk_appraisal_id
92: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
93: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
94: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
95: )
96: is
97:

Line 94: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE

90:
91: procedure chk_appraisal_id
92: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
93: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
94: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
95: )
96: is
97:
98: -- Declare local variables

Line 150: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'

146: hr_utility.set_location(' Leaving:'|| l_proc, 30);
147: exception
148: when app_exception.application_exception then
149: if hr_multi_message.exception_add
150: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'
151: ) then
152: raise;
153: end if;
154:

Line 199: (p_objective_id in per_performance_ratings.objective_id%TYPE

195: -- - Internal table handler use only.
196:
197:
198: procedure chk_objective_id
199: (p_objective_id in per_performance_ratings.objective_id%TYPE
200: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
201: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
202: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
203: )

Line 200: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE

196:
197:
198: procedure chk_objective_id
199: (p_objective_id in per_performance_ratings.objective_id%TYPE
200: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
201: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
202: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
203: )
204: is

Line 201: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE

197:
198: procedure chk_objective_id
199: (p_objective_id in per_performance_ratings.objective_id%TYPE
200: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
201: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
202: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
203: )
204: is
205:

Line 202: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE

198: procedure chk_objective_id
199: (p_objective_id in per_performance_ratings.objective_id%TYPE
200: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
201: ,p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
202: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE
203: )
204: is
205:
206: -- Declare local variables

Line 229: from per_performance_ratings p

225: and a.business_group_id = l_business_group_id;
226:
227: cursor csr_objective_id_exists is
228: select null
229: from per_performance_ratings p
230: where objective_id = p_objective_id
231: and appraisal_id = p_appraisal_id;
232:
233: begin

Line 313: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'

309: hr_utility.set_location(' Leaving:'|| l_proc, 70);
310: exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'
314: ) then
315: raise;
316: end if;
317:

Line 362: (p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE

358: -- - Internal table handler use only.
359:
360:
361: procedure chk_performance_level_id
362: (p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
363: ,p_performance_level_id in per_performance_ratings.performance_level_id%TYPE
364: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
365: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
366: is

Line 363: ,p_performance_level_id in per_performance_ratings.performance_level_id%TYPE

359:
360:
361: procedure chk_performance_level_id
362: (p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
363: ,p_performance_level_id in per_performance_ratings.performance_level_id%TYPE
364: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
365: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
366: is
367:

Line 364: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE

360:
361: procedure chk_performance_level_id
362: (p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
363: ,p_performance_level_id in per_performance_ratings.performance_level_id%TYPE
364: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
365: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
366: is
367:
368: -- Declare local variables

Line 365: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)

361: procedure chk_performance_level_id
362: (p_performance_rating_id in per_performance_ratings.performance_rating_id%TYPE
363: ,p_performance_level_id in per_performance_ratings.performance_level_id%TYPE
364: ,p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
365: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
366: is
367:
368: -- Declare local variables
369:

Line 507: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.PERFORMANCE_LEVEL_ID'

503: hr_utility.set_location(' Leaving:'|| l_proc, 100);
504: exception
505: when app_exception.application_exception then
506: if hr_multi_message.exception_add
507: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.PERFORMANCE_LEVEL_ID'
508: ) then
509: raise;
510: end if;
511:

Line 551: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE

547: -- Access Status:
548: -- - Internal table handler use only.
549:
550: procedure chk_for_duplicates
551: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
552: ,p_objective_id in per_performance_ratings.objective_id%TYPE
553: ,p_person_id in per_performance_ratings.person_id%TYPE
554: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
555: is

Line 552: ,p_objective_id in per_performance_ratings.objective_id%TYPE

548: -- - Internal table handler use only.
549:
550: procedure chk_for_duplicates
551: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
552: ,p_objective_id in per_performance_ratings.objective_id%TYPE
553: ,p_person_id in per_performance_ratings.person_id%TYPE
554: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
555: is
556: -- Declare local variables

Line 553: ,p_person_id in per_performance_ratings.person_id%TYPE

549:
550: procedure chk_for_duplicates
551: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
552: ,p_objective_id in per_performance_ratings.objective_id%TYPE
553: ,p_person_id in per_performance_ratings.person_id%TYPE
554: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
555: is
556: -- Declare local variables
557: l_proc varchar2(72) := g_package||'chk_for_duplicates';

Line 554: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)

550: procedure chk_for_duplicates
551: (p_appraisal_id in per_performance_ratings.appraisal_id%TYPE
552: ,p_objective_id in per_performance_ratings.objective_id%TYPE
553: ,p_person_id in per_performance_ratings.person_id%TYPE
554: ,p_object_version_number in per_performance_ratings.object_version_number%TYPE)
555: is
556: -- Declare local variables
557: l_proc varchar2(72) := g_package||'chk_for_duplicates';
558: l_exists varchar2(1);

Line 564: from per_performance_ratings ppr

560: -- Cursor to check if there are no multiple rows for a combination of
561: -- appraisal_id, objective_id and person_id
562: cursor csr_num_rows is
563: select 'Y'
564: from per_performance_ratings ppr
565: where ppr.appraisal_id = p_appraisal_id
566: and ppr.objective_id = p_objective_id
567: and ppr.person_id = p_person_id;
568:

Line 603: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'

599:
600: exception
601: when app_exception.application_exception then
602: if hr_multi_message.exception_add
603: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'
604: ,p_associated_column2 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'
605: ,p_associated_column3 => 'PER_PERFORMANCE_RATINGS.PERSON_ID'
606: ) then
607: raise;

Line 604: ,p_associated_column2 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'

600: exception
601: when app_exception.application_exception then
602: if hr_multi_message.exception_add
603: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'
604: ,p_associated_column2 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'
605: ,p_associated_column3 => 'PER_PERFORMANCE_RATINGS.PERSON_ID'
606: ) then
607: raise;
608: end if;

Line 605: ,p_associated_column3 => 'PER_PERFORMANCE_RATINGS.PERSON_ID'

601: when app_exception.application_exception then
602: if hr_multi_message.exception_add
603: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'
604: ,p_associated_column2 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'
605: ,p_associated_column3 => 'PER_PERFORMANCE_RATINGS.PERSON_ID'
606: ) then
607: raise;
608: end if;
609: end chk_for_duplicates;

Line 705: ,p_descflex_name => 'PER_PERFORMANCE_RATINGS'

701: -- b) During insert.
702:
703: hr_dflex_utility.ins_or_upd_descflex_attribs
704: (p_appl_short_name => 'PER'
705: ,p_descflex_name => 'PER_PERFORMANCE_RATINGS'
706: ,p_attribute_category => p_rec.attribute_category
707: ,p_attribute1_name => 'ATTRIBUTE1'
708: ,p_attribute1_value => p_rec.attribute1
709: ,p_attribute2_name => 'ATTRIBUTE2'

Line 804: -- validate that there are no records in per_performance_ratings for the combination

800: ,p_object_version_number => p_rec.object_version_number);
801:
802: hr_utility.set_location(l_proc, 40);
803:
804: -- validate that there are no records in per_performance_ratings for the combination
805: -- of appraisal_id, objective_id and person_id
806:
807: per_prt_bus.chk_for_duplicates
808: (p_appraisal_id => p_rec.appraisal_id

Line 899: per_performance_ratings ppr,

895:
896: cursor csr_leg_code is
897: select legislation_code
898: from per_business_groups pbg,
899: per_performance_ratings ppr,
900: per_objectives pob
901: where ppr.performance_rating_id = p_performance_rating_id
902: and ppr.objective_id = pob.objective_id
903: and pbg.business_group_id = pob.business_group_id;

Line 949: FROM per_performance_ratings

945: ( p_objective_id per_objectives.objective_id%TYPE
946: )
947: IS
948: SELECT performance_rating_id, object_version_number
949: FROM per_performance_ratings
950: WHERE objective_id = p_objective_id;
951: BEGIN
952: OPEN csr_objpr
953: ( p_objective_id => p_objective_id