378: Close C_Sel1;
379: --
380: -- The primary key is invalid therefore we must error
381: --
382: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
383: fnd_message.raise_error;
384: End If;
385: Close C_Sel1;
386: If (p_object_version_number
379: --
380: -- The primary key is invalid therefore we must error
381: --
382: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
383: fnd_message.raise_error;
384: End If;
385: Close C_Sel1;
386: If (p_object_version_number
387: <> l_no) Then
384: End If;
385: Close C_Sel1;
386: If (p_object_version_number
387: <> l_no) Then
388: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
389: fnd_message.raise_error;
390: End If;
391:
392: --first get the child rows if any for the hierarchy_id
385: Close C_Sel1;
386: If (p_object_version_number
387: <> l_no) Then
388: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
389: fnd_message.raise_error;
390: End If;
391:
392: --first get the child rows if any for the hierarchy_id
393: