DBA Data[Home] [Help]

APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_ELEMENT_SETS_PKG

Line 1: PACKAGE BODY PAY_ELEMENT_SETS_PKG as

1: PACKAGE BODY PAY_ELEMENT_SETS_PKG as
2: /* $Header: pyels01t.pkb 120.1 2005/09/30 00:32:03 tvankayl noship $ */
3: --
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: pay_element_sets_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +===========================================================================+
9: Name
10: pay_element_sets_pkg
11: Purpose
12: Supports the ELS block in the form PAYWSDRP (Define Element and
13: Distributuion Set.
14: Notes

Line 68: 'pay_element_sets_pkg.lock_element_set');

64: if csr_element_set%notfound then
65: close csr_element_set;
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE',
68: 'pay_element_sets_pkg.lock_element_set');
69: hr_utility.set_message_token('STEP','1');
70: hr_utility.raise_error;
71: else
72: close csr_element_set;

Line 411: 'pay_element_sets_pkg.insert_row');

407: if (C%NOTFOUND) then
408: CLOSE C;
409: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
410: hr_utility.set_message_token('PROCEDURE',
411: 'pay_element_sets_pkg.insert_row');
412: hr_utility.set_message_token('STEP','1');
413: hr_utility.raise_error;
414: end if;
415: CLOSE C;

Line 452: 'pay_element_sets_pkg.lock_row');

448: if (C%NOTFOUND) then
449: CLOSE C;
450: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
451: hr_utility.set_message_token('PROCEDURE',
452: 'pay_element_sets_pkg.lock_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;
455: end if;
456: CLOSE C;

Line 558: 'pay_element_sets_pkg.update_row');

554: --
555: if (SQL%NOTFOUND) then
556: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
557: hr_utility.set_message_token('PROCEDURE',
558: 'pay_element_sets_pkg.update_row');
559: hr_utility.set_message_token('STEP','1');
560: hr_utility.raise_error;
561: end if;
562: --

Line 602: 'pay_element_sets_pkg.delete_row');

598: --
599: if (SQL%NOTFOUND) then
600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PROCEDURE',
602: 'pay_element_sets_pkg.delete_row');
603: hr_utility.set_message_token('STEP','1');
604: hr_utility.raise_error;
605: end if;
606: --

Line 735: l_package_name := 'PAY_ELEMENT_SETS_PKG.VALIDATE_TRANSLATION';

731: l_business_group_id NUMBER;
732: l_legislation_code VARCHAR2(150);
733:
734: BEGIN
735: l_package_name := 'PAY_ELEMENT_SETS_PKG.VALIDATE_TRANSLATION';
736: l_business_group_id := p_business_group_id;
737: l_legislation_code := p_legislation_code;
738: hr_utility.set_location (l_package_name,10);
739: OPEN c_translation(language, element_set_name,element_set_id,

Line 765: END PAY_ELEMENT_SETS_PKG;

761: return g_dml_status;
762: end return_dml_status;
763: --
764: --
765: END PAY_ELEMENT_SETS_PKG;