31: and psv.version_number = X_Version_Number
32: and (psv.rowid <> X_Rowid
33: or X_Rowid is null));
34: --
35: hr_utility.set_message('801','HR_6077_PO_POS_DUP_VER');
36: hr_utility.raise_error;
37: --
38: exception
39: when no_data_found then
32: and (psv.rowid <> X_Rowid
33: or X_Rowid is null));
34: --
35: hr_utility.set_message('801','HR_6077_PO_POS_DUP_VER');
36: hr_utility.raise_error;
37: --
38: exception
39: when no_data_found then
40: null;
155: and psv.position_structure_id = X_Position_Structure_Id
156: and (psv.rowid <> X_Rowid
157: or X_Rowid is null));
158: --
159: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
160: hr_utility.raise_error;
161: --
162: end;
163: exception
156: and (psv.rowid <> X_Rowid
157: or X_Rowid is null));
158: --
159: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
160: hr_utility.raise_error;
161: --
162: end;
163: exception
164: when no_data_found then
235: where exists( select null
236: from PER_POS_STRUCTURE_ELEMENTS PSE
237: where PSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id);
238: --
239: hr_utility.set_message('801','HR_6205_PO_POS_POS_NO_DEL');
240: hr_utility.raise_error;
241: exception
242: when no_data_found then
243: null;
236: from PER_POS_STRUCTURE_ELEMENTS PSE
237: where PSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id);
238: --
239: hr_utility.set_message('801','HR_6205_PO_POS_POS_NO_DEL');
240: hr_utility.raise_error;
241: exception
242: when no_data_found then
243: null;
244: end;
251: from per_security_profiles
252: where business_group_id + 0 = X_Business_Group_Id
253: and position_structure_id = X_Position_Structure_Id);
254: --
255: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
256: hr_utility.raise_error;
257: exception
258: when no_data_found then
259: null;
252: where business_group_id + 0 = X_Business_Group_Id
253: and position_structure_id = X_Position_Structure_Id);
254: --
255: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
256: hr_utility.raise_error;
257: exception
258: when no_data_found then
259: null;
260: end;