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_CSR_BUS dependencies on HR_API

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

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

Line 128: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)

124: ,p_validation_end_date date) IS
125: SELECT css_rltd_per_per_in_ler_id
126: FROM ben_css_rltd_per_per_in_ler
127: WHERE css_rltd_per_per_in_ler_id <>
128: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)
129: AND business_group_id + 0 = p_business_group_id
130: AND ordr_to_prcs_num = nvl(p_ordr_to_prcs_num,hr_api.g_number)
131: AND ler_id = p_ler_id
132: AND p_validation_start_date <= effective_end_date

Line 130: AND ordr_to_prcs_num = nvl(p_ordr_to_prcs_num,hr_api.g_number)

126: FROM ben_css_rltd_per_per_in_ler
127: WHERE css_rltd_per_per_in_ler_id <>
128: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)
129: AND business_group_id + 0 = p_business_group_id
130: AND ordr_to_prcs_num = nvl(p_ordr_to_prcs_num,hr_api.g_number)
131: AND ler_id = p_ler_id
132: AND p_validation_start_date <= effective_end_date
133: AND p_validation_end_date >= effective_start_date;
134:

Line 150: and nvl(p_ordr_to_prcs_num,hr_api.g_number)

146: p_effective_date => p_effective_date,
147: p_object_version_number => p_object_version_number);
148:
149: if (l_api_updating
150: and nvl(p_ordr_to_prcs_num,hr_api.g_number)
151: <> ben_csr_shd.g_old_rec.ordr_to_prcs_num
152: or not l_api_updating) then
153:
154: open l_csr_csr

Line 225: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)

221: ,p_validation_end_date date) IS
222: SELECT css_rltd_per_per_in_ler_id
223: FROM ben_css_rltd_per_per_in_ler
224: WHERE css_rltd_per_per_in_ler_id <>
225: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)
226: AND business_group_id + 0 = p_business_group_id
227: AND rsltg_ler_id = p_rsltg_ler_id
228: AND ler_id = p_ler_id
229: AND p_validation_start_date <= effective_end_date

Line 247: and nvl(p_rsltg_ler_id,hr_api.g_number)

243: p_effective_date => p_effective_date,
244: p_object_version_number => p_object_version_number);
245:
246: if (l_api_updating
247: and nvl(p_rsltg_ler_id,hr_api.g_number)
248: <> ben_csr_shd.g_old_rec.rsltg_ler_id
249: or not l_api_updating) then
250:
251: open l_csr_csr

Line 305: (p_ler_id in number default hr_api.g_number,

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure dt_update_validate
305: (p_ler_id in number default hr_api.g_number,
306: p_rsltg_ler_id in number default hr_api.g_number,
307: p_datetrack_mode in varchar2,
308: p_validation_start_date in date,
309: p_validation_end_date in date) Is

Line 306: p_rsltg_ler_id in number default hr_api.g_number,

302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure dt_update_validate
305: (p_ler_id in number default hr_api.g_number,
306: p_rsltg_ler_id in number default hr_api.g_number,
307: p_datetrack_mode in varchar2,
308: p_validation_start_date in date,
309: p_validation_end_date in date) Is
310: --

Line 320: hr_api.mandatory_arg_error

316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- Ensure that the p_datetrack_mode argument is not null
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc,
322: p_argument => 'datetrack_mode',
323: p_argument_value => p_datetrack_mode);
324: --

Line 332: hr_api.mandatory_arg_error

328: --
329: --
330: -- Ensure the arguments are not null
331: --
332: hr_api.mandatory_arg_error
333: (p_api_name => l_proc,
334: p_argument => 'validation_start_date',
335: p_argument_value => p_validation_start_date);
336: --

Line 337: hr_api.mandatory_arg_error

333: (p_api_name => l_proc,
334: p_argument => 'validation_start_date',
335: p_argument_value => p_validation_start_date);
336: --
337: hr_api.mandatory_arg_error
338: (p_api_name => l_proc,
339: p_argument => 'validation_end_date',
340: p_argument_value => p_validation_end_date);
341: --

Line 342: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

338: (p_api_name => l_proc,
339: p_argument => 'validation_end_date',
340: p_argument_value => p_validation_end_date);
341: --
342: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
343: NOT (dt_api.check_min_max_dates
344: (p_base_table_name => 'ben_ler_f',
345: p_base_key_column => 'ler_id',
346: p_base_key_value => p_ler_id,

Line 357: elsif ((nvl(p_rsltg_ler_id, hr_api.g_number) <> hr_api.g_number) and

353: -- if the ler_id and rsltg_ler_id are the same, there is no need to call
354: -- the date track api with both values.
355: if p_ler_id = p_rsltg_ler_id then
356: null;
357: elsif ((nvl(p_rsltg_ler_id, hr_api.g_number) <> hr_api.g_number) and
358: NOT (dt_api.check_min_max_dates
359: (p_base_table_name => 'ben_ler_f',
360: p_base_key_column => 'ler_id',
361: p_base_key_value => p_rsltg_ler_id,

Line 439: hr_api.mandatory_arg_error

435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Ensure that the p_datetrack_mode argument is not null
438: --
439: hr_api.mandatory_arg_error
440: (p_api_name => l_proc,
441: p_argument => 'datetrack_mode',
442: p_argument_value => p_datetrack_mode);
443: --

Line 453: hr_api.mandatory_arg_error

449: --
450: --
451: -- Ensure the arguments are not null
452: --
453: hr_api.mandatory_arg_error
454: (p_api_name => l_proc,
455: p_argument => 'validation_start_date',
456: p_argument_value => p_validation_start_date);
457: --

Line 458: hr_api.mandatory_arg_error

454: (p_api_name => l_proc,
455: p_argument => 'validation_start_date',
456: p_argument_value => p_validation_start_date);
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc,
460: p_argument => 'validation_end_date',
461: p_argument_value => p_validation_end_date);
462: --

Line 463: hr_api.mandatory_arg_error

459: (p_api_name => l_proc,
460: p_argument => 'validation_end_date',
461: p_argument_value => p_validation_end_date);
462: --
463: hr_api.mandatory_arg_error
464: (p_api_name => l_proc,
465: p_argument => 'css_rltd_per_per_in_ler_id',
466: p_argument_value => p_css_rltd_per_per_in_ler_id);
467: --

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

505: --
506: -- Call all supporting business operations
507: --
508: --
509: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
510: --
511: chk_css_rltd_per_per_in_ler_id
512: (p_css_rltd_per_per_in_ler_id => p_rec.css_rltd_per_per_in_ler_id,
513: p_effective_date => p_effective_date,

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

553: --
554: -- Call all supporting business operations
555: --
556: --
557: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
558: --
559: chk_css_rltd_per_per_in_ler_id
560: (p_css_rltd_per_per_in_ler_id => p_rec.css_rltd_per_per_in_ler_id,
561: p_effective_date => p_effective_date,

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

646: hr_utility.set_location('Entering:'|| l_proc, 10);
647: --
648: -- Ensure that all the mandatory parameter are not null
649: --
650: hr_api.mandatory_arg_error(p_api_name => l_proc,
651: p_argument => 'css_rltd_per_per_in_ler_id',
652: p_argument_value => p_css_rltd_per_per_in_ler_id);
653: --
654: open csr_leg_code;