APPS.BEN_PCU_BUS dependencies on HR_API

Line 54: and nvl(p_per_cm_usg_id,hr_api.g_number)

50: p_per_cm_usg_id => p_per_cm_usg_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_per_cm_usg_id,hr_api.g_number)
55: <> ben_pcu_shd.g_old_rec.per_cm_usg_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 109: (p_cm_typ_usg_id in number default hr_api.g_number,

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_cm_typ_usg_id in number default hr_api.g_number,
110: p_per_cm_id in number default hr_api.g_number,
111: p_datetrack_mode in varchar2,
112: p_validation_start_date in date,
113: p_validation_end_date in date) Is

Line 110: p_per_cm_id in number default hr_api.g_number,

106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_cm_typ_usg_id in number default hr_api.g_number,
110: p_per_cm_id in number default hr_api.g_number,
111: p_datetrack_mode in varchar2,
112: p_validation_start_date in date,
113: p_validation_end_date in date) Is
114: --

Line 124: hr_api.mandatory_arg_error

120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Ensure that the p_datetrack_mode argument is not null
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc,
126: p_argument => 'datetrack_mode',
127: p_argument_value => p_datetrack_mode);
128: --

Line 136: hr_api.mandatory_arg_error

132: --
133: --
134: -- Ensure the arguments are not null
135: --
136: hr_api.mandatory_arg_error
137: (p_api_name => l_proc,
138: p_argument => 'validation_start_date',
139: p_argument_value => p_validation_start_date);
140: --

Line 141: hr_api.mandatory_arg_error

137: (p_api_name => l_proc,
138: p_argument => 'validation_start_date',
139: p_argument_value => p_validation_start_date);
140: --
141: hr_api.mandatory_arg_error
142: (p_api_name => l_proc,
143: p_argument => 'validation_end_date',
144: p_argument_value => p_validation_end_date);
145: --

Line 146: If ((nvl(p_cm_typ_usg_id, hr_api.g_number) <> hr_api.g_number) and

142: (p_api_name => l_proc,
143: p_argument => 'validation_end_date',
144: p_argument_value => p_validation_end_date);
145: --
146: If ((nvl(p_cm_typ_usg_id, hr_api.g_number) <> hr_api.g_number) and
147: NOT (dt_api.check_min_max_dates
148: (p_base_table_name => 'ben_cm_typ_usg_f',
149: p_base_key_column => 'cm_typ_usg_id',
150: p_base_key_value => p_cm_typ_usg_id,

Line 156: If ((nvl(p_per_cm_id, hr_api.g_number) <> hr_api.g_number) and

152: p_to_date => p_validation_end_date))) Then
153: l_table_name := 'ben_cm_typ_usg_f';
154: Raise l_integrity_error;
155: End If;
156: If ((nvl(p_per_cm_id, hr_api.g_number) <> hr_api.g_number) and
157: NOT (dt_api.check_min_max_dates
158: (p_base_table_name => 'ben_per_cm_f',
159: p_base_key_column => 'per_cm_id',
160: p_base_key_value => p_per_cm_id,

Line 239: hr_api.mandatory_arg_error

235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Ensure that the p_datetrack_mode argument is not null
238: --
239: hr_api.mandatory_arg_error
240: (p_api_name => l_proc,
241: p_argument => 'datetrack_mode',
242: p_argument_value => p_datetrack_mode);
243: --

Line 253: hr_api.mandatory_arg_error

249: --
250: --
251: -- Ensure the arguments are not null
252: --
253: hr_api.mandatory_arg_error
254: (p_api_name => l_proc,
255: p_argument => 'validation_start_date',
256: p_argument_value => p_validation_start_date);
257: --

Line 258: hr_api.mandatory_arg_error

254: (p_api_name => l_proc,
255: p_argument => 'validation_start_date',
256: p_argument_value => p_validation_start_date);
257: --
258: hr_api.mandatory_arg_error
259: (p_api_name => l_proc,
260: p_argument => 'validation_end_date',
261: p_argument_value => p_validation_end_date);
262: --

Line 263: hr_api.mandatory_arg_error

259: (p_api_name => l_proc,
260: p_argument => 'validation_end_date',
261: p_argument_value => p_validation_end_date);
262: --
263: hr_api.mandatory_arg_error
264: (p_api_name => l_proc,
265: p_argument => 'per_cm_usg_id',
266: p_argument_value => p_per_cm_usg_id);
267: --

Line 310: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

306: --
307: -- Call all supporting business operations
308: --
309: --
310: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
311: --
312: chk_per_cm_usg_id
313: (p_per_cm_usg_id => p_rec.per_cm_usg_id,
314: p_effective_date => p_effective_date,

Line 338: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

334: --
335: -- Call all supporting business operations
336: --
337: --
338: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
339: --
340: chk_per_cm_usg_id
341: (p_per_cm_usg_id => p_rec.per_cm_usg_id,
342: p_effective_date => p_effective_date,

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

407: hr_utility.set_location('Entering:'|| l_proc, 10);
408: --
409: -- Ensure that all the mandatory parameter are not null
410: --
411: hr_api.mandatory_arg_error(p_api_name => l_proc,
412: p_argument => 'per_cm_usg_id',
413: p_argument_value => p_per_cm_usg_id);
414: --
415: open csr_leg_code;