[Home] [Help]
79: --
80: -- DESCRIPTION
81: -- ASSESSMENT_TYPE_ID is a foreign key to the table PER_ASSESSMENT_TYPES.
82: -- The value can be updated only if there are no rows in
83: -- PER_COMPETENCE_ELEMENTS for the particular assessment ie. if the
84: -- assessment hasn't been filled in at all (no ratings assigned to the
85: -- competences), then the ASSESSMENT_TYPE_ID can be updated.
86: --
87: -- Also the assessment_date has to be between the date_from and the date_to.
120: -- DEFINE CURSORS and the variable to hold results of fetch (if any)
121: --
122: cursor csr_ass_used_in_comp is
123: select null
124: from per_competence_elements
125: where p_assessment_id = assessment_id;
126: --
127: cursor csr_ast_date_from_date_to is
128: select date_from , date_to
151: hr_api.g_number)
152: <> nvl(p_assessment_type_id, hr_api.g_number))
153: or (not l_api_updating)) then
154: --
155: -- If updating, check whether rows exist in PER_COMPETENCE_ELEMENTS
156: --
157: if (l_api_updating) then
158: --
159: open csr_ass_used_in_comp;
1107: -- ----------------------------------------------------------------------------
1108: --
1109: -- DESCRIPTION
1110: -- Used to validate before the delete. This process checks to make sure that
1111: -- no rows exist in the PER_COMPETENCE_ELEMENTS table
1112: -- PRE-REQUISITES
1113: --
1114: -- IN PARAMETERS
1115: -- p_assessment_id
1128: l_proc varchar2(72):=g_package||'chk_comp_elements';
1129: --
1130: cursor csr_comp_elements_usage is
1131: select null
1132: from per_competence_elements
1133: where assessment_id = p_assessment_id;
1134: --
1135: l_exists varchar2(1);
1136: --