54: close csr_get_owner_std;
55: end if;
56:
57: IF p_category not in ('Y','N','ND') and l_upd in (0,1,2) THEN
58: hr_utility.set_message(800, 'HR_GB_78125_INVALID_CATEGORY');
59: hr_utility.raise_error;
60: END IF;
61: close csr_get_owner;
62: close csr_get_securityid;
55: end if;
56:
57: IF p_category not in ('Y','N','ND') and l_upd in (0,1,2) THEN
58: hr_utility.set_message(800, 'HR_GB_78125_INVALID_CATEGORY');
59: hr_utility.raise_error;
60: END IF;
61: close csr_get_owner;
62: close csr_get_securityid;
63:
122: close csr_get_owner_std;
123: end if;
124:
125: IF p_category not in ('Y','N','ND') and l_upd in (0,1,2) THEN
126: hr_utility.set_message(800, 'HR_GB_78125_INVALID_CATEGORY');
127: hr_utility.raise_error;
128: END IF;
129: close csr_get_owner;
130: close csr_get_securityid;
123: end if;
124:
125: IF p_category not in ('Y','N','ND') and l_upd in (0,1,2) THEN
126: hr_utility.set_message(800, 'HR_GB_78125_INVALID_CATEGORY');
127: hr_utility.raise_error;
128: END IF;
129: close csr_get_owner;
130: close csr_get_securityid;
131: