[Home] [Help]
50: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
51: l_object_version_number per_salary_surveys.object_version_number%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_salary_survey;
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_salary_survey;
59: hr_utility.set_location(l_proc, 20);
60: --
61: -- Call Before Process User Hook
62: --
63: begin
97: (p_module_name => 'create_salary_survey'
98: ,p_hook_type => 'BP'
99: );
100: end;
101: hr_utility.set_location(l_proc, 30);
102: --
103: -- Process Logic
104: --
105: per_pss_ins.ins(p_salary_survey_id => l_salary_survey_id
132: ,p_attribute18 => p_attribute18
133: ,p_attribute19 => p_attribute19
134: ,p_attribute20 => p_attribute20
135: );
136: hr_utility.set_location(l_proc, 50);
137: --
138: -- Call After Process User Hook
139: --
140: begin
176: (p_module_name => 'create_salary_survey'
177: ,p_hook_type => 'AP'
178: );
179: end;
180: hr_utility.set_location(l_proc, 60);
181: --
182: -- When in validation only mode raise the Validate_Enabled exception
183: --
184: if p_validate then
191: --
192: p_salary_survey_id := l_salary_survey_id;
193: p_object_version_number := l_object_version_number;
194: --
195: hr_utility.set_location(' Leaving:'||l_proc, 70);
196: --
197: exception
198: when hr_api.validate_enabled then
199: --
208: --
209: p_salary_survey_id := null;
210: p_object_version_number := null;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 80);
213: --
214: when others then
215: --
216: -- A validation or unexpected error has occured
218: p_salary_survey_id := null;
219: p_object_version_number := null;
220: rollback to create_salary_survey;
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 90);
223: --
224: raise;
225: --
226: end create_salary_survey;
270: l_object_version_number per_salary_surveys.object_version_number%TYPE;
271: l_temp_ovn number := p_object_version_number;
272: --
273: begin
274: hr_utility.set_location('Entering:'|| l_proc, 10);
275: --
276: -- Issue a savepoint
277: --
278: savepoint update_salary_survey;
275: --
276: -- Issue a savepoint
277: --
278: savepoint update_salary_survey;
279: hr_utility.set_location(l_proc, 20);
280: --
281: -- Call Before Process User Hook
282: --
283: l_object_version_number := p_object_version_number;
320: (p_module_name => 'update_salary_survey'
321: ,p_hook_type => 'BP'
322: );
323: end;
324: hr_utility.set_location(l_proc, 30);
325: --
326: -- Process Logic
327: --
328: per_pss_upd.upd(p_salary_survey_id => l_salary_survey_id,
353: p_attribute18 => p_attribute18,
354: p_attribute19 => p_attribute19,
355: p_attribute20 => p_attribute20
356: );
357: hr_utility.set_location(l_proc, 50);
358: --
359: -- Call After Process User Hook
360: --
361: begin
395: (p_module_name => 'update_salary_survey'
396: ,p_hook_type => 'AP'
397: );
398: end;
399: hr_utility.set_location(l_proc, 60);
400: --
401: -- When in validation only mode raise the Validate_Enabled exception
402: --
403: if p_validate then
409: -- Set all output arguments
410: --
411: p_object_version_number := l_object_version_number;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: --
415: exception
416: when hr_api.validate_enabled then
417: --
425: -- when validation only mode is being used.)
426: --
427: p_object_version_number := null;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 80);
430: --
431: when others then
432: --
433: -- A validation or unexpected error has occured
434: --
435: p_object_version_number := l_temp_ovn;
436: rollback to update_salary_survey;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 90);
439: --
440: raise;
441: --
442: end update_salary_survey;
460: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
461: l_object_version_number per_salary_surveys.object_version_number%TYPE;
462: --
463: begin
464: hr_utility.set_location('Entering:'|| l_proc, 10);
465: --
466: -- Issue a savepoint
467: --
468: savepoint delete_salary_survey;
466: -- Issue a savepoint
467: --
468: savepoint delete_salary_survey;
469: --
470: hr_utility.set_location(l_proc, 20);
471: --
472: -- Call Before Process User Hook
473: --
474: --
489: ,p_hook_type => 'BP'
490: );
491: end;
492: --
493: hr_utility.set_location(l_proc, 30);
494: --
495: -- Process Logic
496: --
497: per_pss_del.del(p_salary_survey_id => l_salary_survey_id
497: per_pss_del.del(p_salary_survey_id => l_salary_survey_id
498: ,p_object_version_number => l_object_version_number
499: );
500: --
501: hr_utility.set_location(l_proc, 50);
502: --
503: -- Call After Process User Hook
504: --
505: begin
513: (p_module_name => 'delete_salary_survey'
514: ,p_hook_type => 'AP'
515: );
516: end;
517: hr_utility.set_location(l_proc, 60);
518: --
519: -- When in validation only mode raise the Validate_Enabled exception
520: --
521: if p_validate then
523: raise hr_api.validate_enabled;
524: --
525: end if;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 70);
528: --
529: exception
530: when hr_api.validate_enabled then
531: --
538: -- (Any key or derived arguments must be set to null
539: -- when validation only mode is being used.)
540: --
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 80);
543: --
544: when others then
545: --
546: -- A validation or unexpected error has occured
546: -- A validation or unexpected error has occured
547: --
548: rollback to delete_salary_survey;
549: --
550: hr_utility.set_location(' Leaving:'||l_proc, 90);
551: --
552: raise;
553: --
554: end delete_salary_survey;