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 BEN_OLA_SHD

Line 46: l_api_updating := ben_ola_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_ola_shd.api_updating
47: (p_csr_activities_id => p_csr_activities_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_ola_shd.g_old_rec.csr_activities_id) then

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: --
56: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');

Line 56: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');

52: <> ben_ola_shd.g_old_rec.csr_activities_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');

62: if p_csr_activities_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');
67: --
68: end if;
69: --
70: end if;

Line 124: l_api_updating := ben_ola_shd.api_updating

120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: --
124: l_api_updating := ben_ola_shd.api_updating
125: (p_csr_activities_id => p_csr_activities_id,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating

Line 130: <> ben_ola_shd.g_old_rec.function_name

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: --
134: -- check if value of function name is valid.

Line 225: l_api_updating := ben_ola_shd.api_updating

221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: l_api_updating := ben_ola_shd.api_updating
226: (p_csr_activities_id => p_csr_activities_id,
227: p_object_version_number => p_object_version_number);
228: --
229: if (l_api_updating

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 367: l_api_updating := ben_ola_shd.api_updating

363: Begin
364: --
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: l_api_updating := ben_ola_shd.api_updating
368: (p_csr_activities_id => p_csr_activities_id,
369: p_object_version_number => p_object_version_number);
370: --
371: --We need to check the duplicate seq no. when

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 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 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 411: Procedure insert_validate(p_rec in ben_ola_shd.g_rec_type) is

407:
408: -- ----------------------------------------------------------------------------
409: -- |---------------------------< insert_validate >----------------------------|
410: -- ----------------------------------------------------------------------------
411: Procedure insert_validate(p_rec in ben_ola_shd.g_rec_type) is
412: --
413: l_proc varchar2(72) := g_package||'insert_validate';
414: --
415: Begin

Line 460: Procedure update_validate(p_rec in ben_ola_shd.g_rec_type) is

456: --
457: -- ----------------------------------------------------------------------------
458: -- |---------------------------< update_validate >----------------------------|
459: -- ----------------------------------------------------------------------------
460: Procedure update_validate(p_rec in ben_ola_shd.g_rec_type) is
461: --
462: l_proc varchar2(72) := g_package||'update_validate';
463: --
464: Begin

Line 509: Procedure delete_validate(p_rec in ben_ola_shd.g_rec_type) is

505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< delete_validate >----------------------------|
508: -- ----------------------------------------------------------------------------
509: Procedure delete_validate(p_rec in ben_ola_shd.g_rec_type) is
510: --
511: l_proc varchar2(72) := g_package||'delete_validate';
512: --
513: Begin