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_PRV_BUS dependencies on PER_PERFORMANCE_REVIEWS

Line 59: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');

55: <> per_prv_shd.g_old_rec.performance_review_id) then
56: --
57: -- raise error as PK has changed
58: --
59: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');

65: if p_performance_review_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');
70: --
71: end if;
72: --
73: end if;

Line 145: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_FK2');

141: --
142: -- raise error as FK does not relate to PK in per_events
143: -- table.
144: --
145: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_FK2');
146: --
147: end if;
148: --
149: close get_event;

Line 177: from per_performance_reviews prv

173: and ppf.current_employee_flag='Y';
174:
175: cursor get_dup_date is
176: select 1
177: from per_performance_reviews prv
178: where prv.person_id=p_person_id
179: and prv.review_date=p_review_date;
180:
181: l_proc varchar2(72) := g_package||'chk_person_id_date';

Line 228: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_DT1');

224: --
225: -- raise error as FK does not relate to PK in per_events
226: -- table.
227: --
228: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_DT1');
229: --
230: end if;
231: --
232: close get_person;

Line 419: (p_performance_review_id in per_performance_reviews.performance_review_id%TYPE

415: -- Access Status:
416: -- Internal Table Handler Use Only.
417: --
418: procedure chk_performance_rating
419: (p_performance_review_id in per_performance_reviews.performance_review_id%TYPE
420: ,p_performance_rating in per_performance_reviews.performance_rating%TYPE
421: ,p_review_date in per_performance_reviews.review_date%TYPE
422: ,p_object_version_number in per_performance_reviews.object_version_number%TYPE
423: )

Line 420: ,p_performance_rating in per_performance_reviews.performance_rating%TYPE

416: -- Internal Table Handler Use Only.
417: --
418: procedure chk_performance_rating
419: (p_performance_review_id in per_performance_reviews.performance_review_id%TYPE
420: ,p_performance_rating in per_performance_reviews.performance_rating%TYPE
421: ,p_review_date in per_performance_reviews.review_date%TYPE
422: ,p_object_version_number in per_performance_reviews.object_version_number%TYPE
423: )
424: is

Line 421: ,p_review_date in per_performance_reviews.review_date%TYPE

417: --
418: procedure chk_performance_rating
419: (p_performance_review_id in per_performance_reviews.performance_review_id%TYPE
420: ,p_performance_rating in per_performance_reviews.performance_rating%TYPE
421: ,p_review_date in per_performance_reviews.review_date%TYPE
422: ,p_object_version_number in per_performance_reviews.object_version_number%TYPE
423: )
424: is
425: --

Line 422: ,p_object_version_number in per_performance_reviews.object_version_number%TYPE

418: procedure chk_performance_rating
419: (p_performance_review_id in per_performance_reviews.performance_review_id%TYPE
420: ,p_performance_rating in per_performance_reviews.performance_rating%TYPE
421: ,p_review_date in per_performance_reviews.review_date%TYPE
422: ,p_object_version_number in per_performance_reviews.object_version_number%TYPE
423: )
424: is
425: --
426: l_proc varchar2(72):= g_package||'chk_performance_rating';

Line 579: ,p_descflex_name => 'PER_PERFORMANCE_REVIEWS'

575: -- b) During insert.
576: --
577: hr_dflex_utility.ins_or_upd_descflex_attribs
578: (p_appl_short_name => 'PER'
579: ,p_descflex_name => 'PER_PERFORMANCE_REVIEWS'
580: ,p_attribute_category => p_rec.attribute_category
581: ,p_attribute1_name => 'ATTRIBUTE1'
582: ,p_attribute1_value => p_rec.attribute1
583: ,p_attribute2_name => 'ATTRIBUTE2'

Line 903: , per_performance_reviews prv

899: --
900: cursor csr_leg_code is
901: select pbg.legislation_code
902: from per_business_groups pbg
903: , per_performance_reviews prv
904: , per_all_people per
905: where prv.performance_review_id = p_performance_review_id
906: and per.person_id = prv.person_id
907: and per.business_group_id = pbg.business_group_id;