49: --
50: begin
51: l_proc := g_package||'create_au_module_parameter';
52: --
53: hr_utility.set_location('Entering:'|| l_proc, 5);
54: --
55: -- Issue a savepoint if operating in validation only mode.
56: --
57: if p_validate then
57: if p_validate then
58: savepoint create_au_module_parameter;
59: end if;
60: --
61: hr_utility.set_location(l_proc, 10);
62: --
63: --
64: -- Process Logic
65: --
96: );
97: end if;
98: close csr_valid_combo;
99: --
100: hr_utility.set_location(l_proc, 20);
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
109: --
110: p_module_parameter_id := l_module_parameter_id;
111: p_object_version_number := l_object_version_number;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 100);
114: exception
115: when hr_api.validate_enabled then
116: --
117: -- Only set output warning arguments
140: --
141: begin
142: l_proc := g_package||'delete_au_module_parameter';
143:
144: hr_utility.set_location('Entering:'|| l_proc, 5);
145: --
146: -- Issue a savepoint if operating in validation only mode.
147: --
148: if p_validate then
148: if p_validate then
149: savepoint delete_au_module_parameter;
150: end if;
151: --
152: hr_utility.set_location(l_proc, 10);
153: --
154: -- Validation in addition to Table Handlers
155: --
156: -- None required.
160: pay_amp_del.del
161: (p_module_parameter_id => p_module_parameter_id,
162: p_object_version_number => p_object_version_number);
163: --
164: hr_utility.set_location(l_proc, 20);
165: --
166: -- When in validation only mode raise the Validate_Enabled exception
167: --
168: if p_validate then
168: if p_validate then
169: raise hr_api.validate_enabled;
170: end if;
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 100);
173: exception
174: when hr_api.validate_enabled then
175: --
176: -- As the Validate_Enabled exception has been raised
207: --
208: begin
209: l_proc := g_package||'update_au_module_parameter';
210: --
211: hr_utility.set_location('Entering:'|| l_proc, 5);
212: --
213: -- Issue a savepoint if operating in validation only mode.
214: --
215: if p_validate then
215: if p_validate then
216: savepoint update_au_module_parameter;
217: end if;
218: --
219: hr_utility.set_location(l_proc, 10);
220: --
221: -- Validation in addition to Table Handlers
222: --
223: -- None required.
241: p_database_item_name => p_database_item_name,
242: p_constant_value => p_constant_value
243: );
244: --
245: hr_utility.set_location(l_proc, 20);
246: --
247: -- When in validation only mode raise the Validate_Enabled exception
248: --
249: if p_validate then
249: if p_validate then
250: raise hr_api.validate_enabled;
251: end if;
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 100);
254: exception
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised