41: end check_parameters;
42: --
43: begin
44: --
45: hr_utility.set_location ('Entering '||l_proc,1);
46: --
47: check_parameters;
48: --
49: -- Only perform check if we are not updating or if we are updating the
62: fetch csr_duplicate into l_dummy;
63: if csr_duplicate%found then
64: --
65: close csr_duplicate;
66: hr_utility.set_message (801,'HR_51081_PAT_UK01');
67: hr_utility.raise_error;
68: --
69: else
70: --
63: if csr_duplicate%found then
64: --
65: close csr_duplicate;
66: hr_utility.set_message (801,'HR_51081_PAT_UK01');
67: hr_utility.raise_error;
68: --
69: else
70: --
71: close csr_duplicate;
73: end if;
74: --
75: end if;
76: --
77: hr_utility.set_location ('Leaving '||l_proc,10);
78: --
79: end chk_pattern_name;
80: -- ----------------------------------------------------------------------------
81: -- |---------------------------< insert_validate >----------------------------|
84: --
85: l_proc varchar2(72) := g_package||'insert_validate';
86: --
87: Begin
88: hr_utility.set_location('Entering:'||l_proc, 5);
89: --
90: -- Call all supporting business operations
91: --
92: chk_pattern_name (p_pattern_name=> p_rec.pattern_name);
91: --
92: chk_pattern_name (p_pattern_name=> p_rec.pattern_name);
93: --
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: End insert_validate;
97: --
98: -- ----------------------------------------------------------------------------
99: -- |---------------------------< update_validate >----------------------------|
102: --
103: l_proc varchar2(72) := g_package||'update_validate';
104: --
105: Begin
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: --
108: -- Call all supporting business operations
109: --
110: chk_pattern_name (p_pattern_name=> p_rec.pattern_name,
111: p_pattern_id=> p_rec.pattern_id,
112: p_object_version_number=> p_rec.object_version_number);
113: --
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End update_validate;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< delete_validate >----------------------------|
122: --
123: l_proc varchar2(72) := g_package||'delete_validate';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: -- Call all supporting business operations
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: -- Call all supporting business operations
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: End delete_validate;
132: --
133: end hr_pat_bus;