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_AST_BUS dependencies on PER_RATING_SCALES

Line 512: -- WEIGHTING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),

508: -- |-------------------------< chk_weighting_scale_id >-----------------------|
509: -- ----------------------------------------------------------------------------
510: --
511: -- Description
512: -- WEIGHTING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),
513: -- therefore values entered for this column must exist in the referenced table
514: -- where PER_RATING_SCALES(TYPE) = 'WEIGHTING' and the business group is the
515: -- same.
516: --

Line 514: -- where PER_RATING_SCALES(TYPE) = 'WEIGHTING' and the business group is the

510: --
511: -- Description
512: -- WEIGHTING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),
513: -- therefore values entered for this column must exist in the referenced table
514: -- where PER_RATING_SCALES(TYPE) = 'WEIGHTING' and the business group is the
515: -- same.
516: --
517: -- The weighting_scale_id can only be updated if it the assessment_type is
518: -- not being used by an assessment.

Line 542: -- Define the cursor the get the type and bg from per_rating_scales

538: ,p_object_version_number in per_assessment_types.object_version_number%TYPE
539: )
540: is
541: --
542: -- Define the cursor the get the type and bg from per_rating_scales
543: -- ngundura changes for pa requirements.
544: cursor csr_weighting_scale_id is
545: select type,business_group_id
546: from per_rating_scales

Line 546: from per_rating_scales

542: -- Define the cursor the get the type and bg from per_rating_scales
543: -- ngundura changes for pa requirements.
544: cursor csr_weighting_scale_id is
545: select type,business_group_id
546: from per_rating_scales
547: where p_weighting_scale_id = rating_scale_id
548: and (nvl(p_business_group_id,-1) = nvl(business_group_id,-1) or business_group_id is null);
549:
550:

Line 567: l_type per_rating_scales.type%TYPE;

563: l_api_updating boolean;
564: --
565: -- Define the local variables for the cursor to use
566: --
567: l_type per_rating_scales.type%TYPE;
568: l_business_group_id per_rating_scales.business_group_id%TYPE;
569: l_proc varchar2(72):=g_package||'chk_weighting_scale_id';
570: l_csr_not_found boolean := FALSE;
571: --

Line 568: l_business_group_id per_rating_scales.business_group_id%TYPE;

564: --
565: -- Define the local variables for the cursor to use
566: --
567: l_type per_rating_scales.type%TYPE;
568: l_business_group_id per_rating_scales.business_group_id%TYPE;
569: l_proc varchar2(72):=g_package||'chk_weighting_scale_id';
570: l_csr_not_found boolean := FALSE;
571: --
572: begin

Line 645: -- ie. if the type of the weighing_scale in per_rating_scales is not equal

641: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK3');
642: --
643: --
644: -- Check if the weighting_scale_id is of the wrong type
645: -- ie. if the type of the weighing_scale in per_rating_scales is not equal
646: -- to 'WEIGHTING' then error.
647: --
648: elsif l_type <> 'WEIGHTING' then
649: hr_utility.set_location(l_proc,30);

Line 652: -- table per_rating_scales can be used again, because as far as the api

648: elsif l_type <> 'WEIGHTING' then
649: hr_utility.set_location(l_proc,30);
650: --
651: -- The same error that is displayed when the value doesn't exist in the
652: -- table per_rating_scales can be used again, because as far as the api
653: -- is concerned the value doesn't exist even if it does but is of a
654: -- different type.
655: --
656: per_ast_shd.constraint_error

Line 714: -- RATING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),

710: -- |---------------------------< chk_rating_scale_id >------------------------|
711: -- ----------------------------------------------------------------------------
712: --
713: -- Description
714: -- RATING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),
715: -- therefore values entered for this column must exist in the referenced
716: -- table where PER_RATING_SCALES(TYPE)= 'PERFORMANCE'.
717: -- Also if rating_scale_id exists, assessment_classification must be of type
718: -- 'PERFORMANCE' or 'BOTH' and not of type 'PROFICIENCY'.

Line 716: -- table where PER_RATING_SCALES(TYPE)= 'PERFORMANCE'.

712: --
713: -- Description
714: -- RATING_SCALE_ID is a foreign key to PER_RATING_SCALES(RATING_SCALE_ID),
715: -- therefore values entered for this column must exist in the referenced
716: -- table where PER_RATING_SCALES(TYPE)= 'PERFORMANCE'.
717: -- Also if rating_scale_id exists, assessment_classification must be of type
718: -- 'PERFORMANCE' or 'BOTH' and not of type 'PROFICIENCY'.
719: -- Pre-conditions
720: -- business_group_id is valid

Line 744: -- Define the cursor to get the info. from per_rating_scales

740: ,p_object_version_number in per_assessment_types.object_version_number%TYPE
741: ,p_weighting_classification in per_assessment_types.weighting_classification%TYPE
742: )
743: is
744: -- Define the cursor to get the info. from per_rating_scales
745: -- ngundura changes done for pa requirements
746: cursor csr_rating_scale_id is
747: select type
748: from per_rating_scales

Line 748: from per_rating_scales

744: -- Define the cursor to get the info. from per_rating_scales
745: -- ngundura changes done for pa requirements
746: cursor csr_rating_scale_id is
747: select type
748: from per_rating_scales
749: where p_rating_scale_id = rating_scale_id
750: and (nvl(p_business_group_id,-1) = nvl(business_group_id,-1) or business_group_id is null) ;
751:
752: -- ngundura end of changes

Line 763: l_type per_rating_scales.type%TYPE;

759: and business_group_id = p_business_group_id;
760: --
761: -- Define the local variables for the cursor to go
762: --
763: l_type per_rating_scales.type%TYPE;
764: l_proc varchar2(72):=g_package||'chk_rating_scale_id';
765: l_csr_not_found boolean := FALSE;
766: l_exists varchar2(1);
767: l_api_updating boolean;

Line 858: -- ie if the type of the rating_scale in per_rating_scales

854: per_ast_shd.constraint_error
855: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK2');
856: --
857: -- Check if the rating_scale_id is of the wrong type.
858: -- ie if the type of the rating_scale in per_rating_scales
859: -- is not equal to PERFORMANCE, then error.
860: --
861: elsif l_type <> 'PERFORMANCE' then
862: -- Bug#885806

Line 871: -- in the table per_rating_scales can be used here as even thought the

867: --
868: hr_utility.set_location(l_proc,30);
869: --
870: -- The same error message that gets used when the value can be found
871: -- in the table per_rating_scales can be used here as even thought the
872: -- value entered exists it is of the wrong type therefore it may as well
873: -- not exist.
874: --
875: