DBA Data[Home] [Help]

APPS.PAY_KR_ENTRIES_PKG dependencies on HR_API

Line 97: p_effective_date in date default hr_api.g_sys

93: function element_type_rec
94: (
95: p_element_name in varchar2,
96: p_business_group_id in number default null,
97: p_effective_date in date default hr_api.g_sys
98: ) return PAY_ELEMENT_TYPES_F%ROWTYPE
99: is
100:
101: l_legislation_code varchar2(30);

Line 118: := hr_api.return_legislation_code(p_business_group_id);

114: or pet.business_group_id = p_business_group_id);
115:
116: begin
117: l_legislation_code
118: := hr_api.return_legislation_code(p_business_group_id);
119:
120: open csr( p_element_name,
121: p_business_group_id,
122: l_legislation_code,

Line 720: if hr_api.not_exists_in_hr_lookups(

716: if l_rec.lookup_type is not NULL then
717: --
718: -- Lookup_type validation with effective_date.
719: --
720: if hr_api.not_exists_in_hr_lookups(
721: p_effective_date => p_effective_date,
722: p_lookup_type => l_rec.lookup_type,
723: p_lookup_code => p_canonical_value) then
724: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');

Line 1029: hr_api.mandatory_arg_error(p_api_name => l_proc,

1025: end if;
1026: --
1027: -- Ensure that all the mandatory arguments are not null
1028: --
1029: hr_api.mandatory_arg_error(p_api_name => l_proc,
1030: p_argument => 'effective_date',
1031: p_argument_value => p_effective_date);
1032: --
1033: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1033: hr_api.mandatory_arg_error(p_api_name => l_proc,

1029: hr_api.mandatory_arg_error(p_api_name => l_proc,
1030: p_argument => 'effective_date',
1031: p_argument_value => p_effective_date);
1032: --
1033: hr_api.mandatory_arg_error(p_api_name => l_proc,
1034: p_argument => 'datetrack_mode',
1035: p_argument_value => p_datetrack_mode);
1036: --
1037: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1037: hr_api.mandatory_arg_error(p_api_name => l_proc,

1033: hr_api.mandatory_arg_error(p_api_name => l_proc,
1034: p_argument => 'datetrack_mode',
1035: p_argument_value => p_datetrack_mode);
1036: --
1037: hr_api.mandatory_arg_error(p_api_name => l_proc,
1038: p_argument => 'element_entry_id',
1039: p_argument_value => p_element_entry_id);
1040: --
1041: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1041: hr_api.mandatory_arg_error(p_api_name => l_proc,

1037: hr_api.mandatory_arg_error(p_api_name => l_proc,
1038: p_argument => 'element_entry_id',
1039: p_argument_value => p_element_entry_id);
1040: --
1041: hr_api.mandatory_arg_error(p_api_name => l_proc,
1042: p_argument => 'object_version_number',
1043: p_argument_value => p_object_version_number);
1044: --
1045: -- Check to ensure the datetrack mode is not INSERT.

Line 1118: when hr_api.object_locked then

1114: --
1115: -- We need to trap the ORA LOCK exception
1116: --
1117: exception
1118: when hr_api.object_locked then
1119: --
1120: -- The object is locked therefore we need to supply a meaningful
1121: -- error message.
1122: --