eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_OLA_BUS dependencies on HR_API

Line 51: and nvl(p_csr_activities_id,hr_api.g_number)

47: (p_csr_activities_id => p_csr_activities_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_csr_activities_id,hr_api.g_number)
52: <> ben_ola_shd.g_old_rec.csr_activities_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 129: and nvl(p_function_name,hr_api.g_varchar2)

125: (p_csr_activities_id => p_csr_activities_id,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_function_name,hr_api.g_varchar2)
130: <> ben_ola_shd.g_old_rec.function_name
131: or not l_api_updating)
132: and p_function_name is not null then
133: --

Line 159: if hr_api.not_exists_in_hr_lookups

155:
156:
157: -- Bug 2382144 start
158: /*
159: if hr_api.not_exists_in_hr_lookups
160: (p_lookup_type => 'BEN_ON_LINE_ACT',
161: p_lookup_code => p_function_name,
162: p_effective_date => sysdate) then
163: --

Line 231: <> nvl(ben_ola_shd.g_old_rec.function_type,hr_api.g_varchar2)

227: p_object_version_number => p_object_version_number);
228: --
229: if (l_api_updating
230: and p_function_type
231: <> nvl(ben_ola_shd.g_old_rec.function_type,hr_api.g_varchar2)
232: or not l_api_updating)
233: and p_function_type is not null then
234: --
235: -- check if value of lookup falls within lookup type.

Line 237: if hr_api.not_exists_in_hr_lookups

233: and p_function_type is not null then
234: --
235: -- check if value of lookup falls within lookup type.
236: --
237: if hr_api.not_exists_in_hr_lookups
238: (p_lookup_type => 'BEN_FUNCTION_TYPE',
239: p_lookup_code => p_function_type,
240: p_effective_date => sysdate) then
241: --

Line 360: and nvl(bca.end_date, hr_api.g_eot) >= nvl(p_csr_start_date, hr_api.g_sot)

356: from BEN_CSR_ACTIVITIES bca
357: where bca.business_group_id +0 = p_business_group_id
358: and bca.csr_activities_id <> nvl(p_csr_activities_id,-1)
359: and bca.ordr_num = p_ordr_num
360: and nvl(bca.end_date, hr_api.g_eot) >= nvl(p_csr_start_date, hr_api.g_sot)
361: and nvl(bca.start_date, hr_api.g_sot) <= nvl(p_csr_end_date, hr_api.g_eot);
362: --
363: Begin
364: --

Line 361: and nvl(bca.start_date, hr_api.g_sot) <= nvl(p_csr_end_date, hr_api.g_eot);

357: where bca.business_group_id +0 = p_business_group_id
358: and bca.csr_activities_id <> nvl(p_csr_activities_id,-1)
359: and bca.ordr_num = p_ordr_num
360: and nvl(bca.end_date, hr_api.g_eot) >= nvl(p_csr_start_date, hr_api.g_sot)
361: and nvl(bca.start_date, hr_api.g_sot) <= nvl(p_csr_end_date, hr_api.g_eot);
362: --
363: Begin
364: --
365: hr_utility.set_location('Entering:'||l_proc, 5);

Line 376: and ((nvl(p_ordr_num,hr_api.g_number)

372: --Inserting a new record or
373: --Updating ordr_num/start_date/end_date
374: --
375: if ((l_api_updating
376: and ((nvl(p_ordr_num,hr_api.g_number)
377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)

Line 377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or

373: --Updating ordr_num/start_date/end_date
374: --
375: if ((l_api_updating
376: and ((nvl(p_ordr_num,hr_api.g_number)
377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)
381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))

Line 378: (nvl(p_csr_start_date,hr_api.g_date)

374: --
375: if ((l_api_updating
376: and ((nvl(p_ordr_num,hr_api.g_number)
377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)
381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))
382: ))

Line 379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or

375: if ((l_api_updating
376: and ((nvl(p_ordr_num,hr_api.g_number)
377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)
381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))
382: ))
383: or not l_api_updating) then

Line 380: (nvl(p_csr_end_date,hr_api.g_date)

376: and ((nvl(p_ordr_num,hr_api.g_number)
377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)
381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))
382: ))
383: or not l_api_updating) then
384: --

Line 381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))

377: <> nvl(ben_ola_shd.g_old_rec.ordr_num,hr_api.g_number)) or
378: (nvl(p_csr_start_date,hr_api.g_date)
379: <> nvl(ben_ola_shd.g_old_rec.start_date,hr_api.g_date)) or
380: (nvl(p_csr_end_date,hr_api.g_date)
381: <> nvl(ben_ola_shd.g_old_rec.end_date,hr_api.g_date))
382: ))
383: or not l_api_updating) then
384: --
385: -- Check if order no. is unique

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

417: --
418: -- Call all supporting business operations
419: --
420: --
421: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
422: --
423: chk_csr_activities_id
424: (p_csr_activities_id => p_rec.csr_activities_id,
425: p_object_version_number => p_rec.object_version_number);

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

466: --
467: -- Call all supporting business operations
468: --
469: --
470: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
471: --
472: chk_csr_activities_id
473: (p_csr_activities_id => p_rec.csr_activities_id,
474: p_object_version_number => p_rec.object_version_number);

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

545: hr_utility.set_location('Entering:'|| l_proc, 10);
546: --
547: -- Ensure that all the mandatory parameter are not null
548: --
549: hr_api.mandatory_arg_error(p_api_name => l_proc,
550: p_argument => 'csr_activities_id',
551: p_argument_value => p_csr_activities_id);
552: --
553: open csr_leg_code;