[Home] [Help]
91: -- ----------------------------------------------------------------------------
92: --
93: -- Description
94: -- This procedure validates the assignment_id with the following checks:
95: -- - the assignment_id exists in PER_ASSIGNMENTS_F
96: -- - the assignment's business group must match the tax record's bus grp.
97: -- The tax record's business_group_id is also validated by checking that it
98: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.
99: --
94: -- This procedure validates the assignment_id with the following checks:
95: -- - the assignment_id exists in PER_ASSIGNMENTS_F
96: -- - the assignment's business group must match the tax record's bus grp.
97: -- The tax record's business_group_id is also validated by checking that it
98: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.
99: --
100: -- Pre-Conditions
101: -- None.
102: --
127: --
128: l_proc varchar2(72) := g_package||'chk_assignment_id';
129: l_dummy varchar2(1);
130: l_api_updating boolean;
131: l_business_group_id per_assignments_f.business_group_id%TYPE;
132: --
133: cursor csr_bg_id is
134: select business_group_id
135: from per_assignments_f asg
131: l_business_group_id per_assignments_f.business_group_id%TYPE;
132: --
133: cursor csr_bg_id is
134: select business_group_id
135: from per_assignments_f asg
136: where asg.assignment_id = p_assignment_id
137: and p_effective_date between asg.effective_start_date
138: and asg.effective_end_date;
139: --
175: if csr_bg_id%notfound then
176: --
177: close csr_bg_id;
178: --
179: -- raise error as assignment_id not found in per_assignments_f
180: -- table.
181: --
182: hr_utility.set_message(801, 'HR_51746_ASG_INV_ASG_ID');
183: hr_utility.raise_error;