APPS.BEN_OPP_BUS dependencies on HR_API

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

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

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

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_oipl_id in number default hr_api.g_number,
110: p_plip_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_plip_id in number default hr_api.g_number,

106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_oipl_id in number default hr_api.g_number,
110: p_plip_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_oipl_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_oipl_id, hr_api.g_number) <> hr_api.g_number) and
147: NOT (dt_api.check_min_max_dates
148: (p_base_table_name => 'ben_oipl_f',
149: p_base_key_column => 'oipl_id',
150: p_base_key_value => p_oipl_id,

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

152: p_to_date => p_validation_end_date))) Then
153: l_table_name := 'ben_oipl_f';
154: Raise l_integrity_error;
155: End If;
156: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
157: NOT (dt_api.check_min_max_dates
158: (p_base_table_name => 'ben_plip_f',
159: p_base_key_column => 'plip_id',
160: p_base_key_value => p_plip_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 => 'oiplip_id',
266: p_argument_value => p_oiplip_id);
267: --

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

308: -- Call all supporting business operations
309: --
310: --
311: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
312: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
313: end if;
314: --
315: chk_oiplip_id
316: (p_oiplip_id => p_rec.oiplip_id,

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

338: -- Call all supporting business operations
339: --
340: --
341: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
342: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
343: end if;
344: --
345: chk_oiplip_id
346: (p_oiplip_id => p_rec.oiplip_id,

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

413: hr_utility.set_location('Entering:'|| l_proc, 10);
414: --
415: -- Ensure that all the mandatory parameter are not null
416: --
417: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: p_argument => 'oiplip_id',
419: p_argument_value => p_oiplip_id);
420: --
421: open csr_leg_code;