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.PAY_IVL_BUS dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52:
53: ,p_argument => 'input_value_id'
54: ,p_argument_value => p_input_value_id

Line 78: hr_api.set_security_group_id

74: --
75: -- Set the security_group_id in CLIENT_INFO
76:
77: --
78: hr_api.set_security_group_id
79: (p_security_group_id => l_security_group_id
80: );
81: end if;
82: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'input_value_id'
120: ,p_argument_value => p_input_value_id
121: );

Line 123: if ( nvl(pay_ivl_bus.g_input_value_id, hr_api.g_number)

119: ,p_argument => 'input_value_id'
120: ,p_argument_value => p_input_value_id
121: );
122: --
123: if ( nvl(pay_ivl_bus.g_input_value_id, hr_api.g_number)
124:
125: = p_input_value_id) then
126: --
127: -- The legislation code has already been found with a previous

Line 317: (p_element_type_id in number default hr_api.g_number

313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure dt_update_validate
317: (p_element_type_id in number default hr_api.g_number
318: ,p_datetrack_mode in varchar2
319: ,p_validation_start_date in date
320: ,p_validation_end_date in date
321: ) Is

Line 329: hr_api.mandatory_arg_error

325: Begin
326: --
327: -- Ensure that the p_datetrack_mode argument is not null
328: --
329: hr_api.mandatory_arg_error
330: (p_api_name => l_proc
331: ,p_argument => 'datetrack_mode'
332: ,p_argument_value => p_datetrack_mode
333:

Line 340: hr_api.mandatory_arg_error

336: -- Mode will be valid, as this is checked at the start of the upd.
337: --
338: -- Ensure the arguments are not null
339: --
340: hr_api.mandatory_arg_error
341: (p_api_name => l_proc
342: ,p_argument => 'validation_start_date'
343: ,p_argument_value => p_validation_start_date
344: );

Line 346: hr_api.mandatory_arg_error

342: ,p_argument => 'validation_start_date'
343: ,p_argument_value => p_validation_start_date
344: );
345: --
346: hr_api.mandatory_arg_error
347: (p_api_name => l_proc
348: ,p_argument => 'validation_end_date'
349: ,p_argument_value => p_validation_end_date
350: );

Line 352: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and

348: ,p_argument => 'validation_end_date'
349: ,p_argument_value => p_validation_end_date
350: );
351: --
352: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
353: NOT (dt_api.check_min_max_dates
354: (p_base_table_name => 'pay_element_types_f'
355: ,p_base_key_column => 'ELEMENT_TYPE_ID'
356: ,p_base_key_value => p_element_type_id

Line 428: hr_api.mandatory_arg_error

424: Begin
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error
429:
430: (p_api_name => l_proc
431: ,p_argument => 'datetrack_mode'
432: ,p_argument_value => p_datetrack_mode

Line 438: If (p_datetrack_mode = hr_api.g_delete or

434: --
435: -- Only perform the validation if the datetrack mode is either
436: -- DELETE or ZAP
437: --
438: If (p_datetrack_mode = hr_api.g_delete or
439: p_datetrack_mode = hr_api.g_zap) then
440: --
441: --
442: -- Ensure the arguments are not null

Line 439: p_datetrack_mode = hr_api.g_zap) then

435: -- Only perform the validation if the datetrack mode is either
436: -- DELETE or ZAP
437: --
438: If (p_datetrack_mode = hr_api.g_delete or
439: p_datetrack_mode = hr_api.g_zap) then
440: --
441: --
442: -- Ensure the arguments are not null
443: --

Line 444: hr_api.mandatory_arg_error

440: --
441: --
442: -- Ensure the arguments are not null
443: --
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc
446: ,p_argument => 'validation_start_date'
447: ,p_argument_value => p_validation_start_date
448: );

Line 450: hr_api.mandatory_arg_error

446: ,p_argument => 'validation_start_date'
447: ,p_argument_value => p_validation_start_date
448: );
449: --
450: hr_api.mandatory_arg_error
451: (p_api_name => l_proc
452: ,p_argument => 'validation_end_date'
453:
454: ,p_argument_value => p_validation_end_date

Line 457: hr_api.mandatory_arg_error

453:
454: ,p_argument_value => p_validation_end_date
455: );
456: --
457: hr_api.mandatory_arg_error
458: (p_api_name => l_proc
459: ,p_argument => 'input_value_id'
460: ,p_argument_value => p_input_value_id
461: );

Line 565: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

561: select 'X' from hr_lookups
562: where upper(lookup_type) = nvl(upper(p_lookup_type),lookup_type)
563: and enabled_flag = 'Y'
564: and p_effective_date between
565: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
566:
567: l_dummy varchar2(1);
568:
569: l_proc varchar2(72) := g_package||'chk_lookup_type';

Line 1058: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

1054: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
1055: and lookup_type = 'UNITS'
1056: and enabled_flag = 'Y'
1057: and p_effective_date between
1058: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1059:
1060: l_dummy varchar2(1);
1061:
1062: l_count number;

Line 1329: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

1325: where upper(lookup_code) = nvl(upper(p_uom),lookup_code)
1326: and lookup_type = 'UNITS'
1327: and enabled_flag = 'Y'
1328: and p_effective_date between
1329: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1330:
1331: l_dummy varchar2(1);
1332:
1333: l_proc varchar2(72) := g_package||'chk_uom';

Line 1395: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

1391: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1392: and lookup_type = p_lookup_type
1393: and enabled_flag = 'Y'
1394: and p_effective_date between
1395: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1396: --
1397: cursor csr_currency(p_element_type_id number) is
1398: select input_currency_code
1399: from pay_element_types_f

Line 1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,

1507: select 'X'
1508: from hr_lookups
1509: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1510: and lookup_type = decode(p_lookup_type,
1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1512: p_lookup_type)
1513: and enabled_flag = 'Y'
1514: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1515: and nvl(end_date_active,hr_api.g_eot);

Line 1514: and p_effective_date between nvl(start_date_active,hr_api.g_sot)

1510: and lookup_type = decode(p_lookup_type,
1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1512: p_lookup_type)
1513: and enabled_flag = 'Y'
1514: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1515: and nvl(end_date_active,hr_api.g_eot);
1516: --
1517: l_dummy varchar(1);
1518: l_value_set_id number;

Line 1515: and nvl(end_date_active,hr_api.g_eot);

1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1512: p_lookup_type)
1513: and enabled_flag = 'Y'
1514: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1515: and nvl(end_date_active,hr_api.g_eot);
1516: --
1517: l_dummy varchar(1);
1518: l_value_set_id number;
1519: l_proc varchar2(72) := g_package||'chk_upd_default_value';

Line 1527: p_lookup_type = hr_api.g_varchar2

1523: hr_utility.set_location(' Entering:'|| l_proc, 10);
1524: --
1525: if p_lookup_type is not null or (
1526: pay_ivl_shd.g_old_rec.lookup_type is not null and
1527: p_lookup_type = hr_api.g_varchar2
1528: ) then
1529: --
1530: open csr_lookup;
1531: fetch csr_lookup into l_dummy;

Line 1545: p_default_value <> hr_api.g_varchar2 and (

1541: --
1542: close csr_lookup;
1543: --
1544: elsif p_value_set_id is not null and p_default_value is not null and
1545: p_default_value <> hr_api.g_varchar2 and (
1546: p_value_set_id <> hr_api.g_number or (
1547: pay_ivl_shd.g_old_rec.value_set_id is not null and
1548: p_value_set_id = hr_api.g_number
1549: )

Line 1546: p_value_set_id <> hr_api.g_number or (

1542: close csr_lookup;
1543: --
1544: elsif p_value_set_id is not null and p_default_value is not null and
1545: p_default_value <> hr_api.g_varchar2 and (
1546: p_value_set_id <> hr_api.g_number or (
1547: pay_ivl_shd.g_old_rec.value_set_id is not null and
1548: p_value_set_id = hr_api.g_number
1549: )
1550: ) then

Line 1548: p_value_set_id = hr_api.g_number

1544: elsif p_value_set_id is not null and p_default_value is not null and
1545: p_default_value <> hr_api.g_varchar2 and (
1546: p_value_set_id <> hr_api.g_number or (
1547: pay_ivl_shd.g_old_rec.value_set_id is not null and
1548: p_value_set_id = hr_api.g_number
1549: )
1550: ) then
1551: --
1552: if p_value_set_id = hr_api.g_number then

Line 1552: if p_value_set_id = hr_api.g_number then

1548: p_value_set_id = hr_api.g_number
1549: )
1550: ) then
1551: --
1552: if p_value_set_id = hr_api.g_number then
1553: --
1554: -- Value set id is not changing, use the old one
1555: --
1556: l_value_set_id := pay_ivl_shd.g_old_rec.value_set_id;

Line 1731: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);

1727: where upper(lookup_code) = nvl(upper(p_warning_or_error),lookup_code)
1728: and lookup_type = 'WARNING_ERROR'
1729: and enabled_flag = 'Y'
1730: and p_effective_date between
1731: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1732:
1733: l_dummy varchar2(1);
1734: l_proc varchar2(72) := g_package||'chk_warning_or_error';
1735: BEGIN

Line 2121: hr_api.validate_bus_grp_id

2117: NOT IN ('GENERIC','STARTUP') THEN
2118: --
2119: -- Validate Important Attributes
2120: --
2121: hr_api.validate_bus_grp_id
2122: (p_business_group_id => p_rec.business_group_id
2123: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2124: || '.BUSINESS_GROUP_ID');
2125: --

Line 2270: hr_api.validate_bus_grp_id

2266: --
2267: -- Validate Important Attributes
2268: --
2269:
2270: hr_api.validate_bus_grp_id
2271: (p_business_group_id => p_rec.business_group_id
2272: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2273: || '.BUSINESS_GROUP_ID');
2274: --

Line 2397: if p_rec.default_value <> hr_api.g_varchar2 then

2393: ,p_warning_or_error => p_rec.warning_or_error
2394: ,p_link_inp_val_warning => p_link_inp_val_warning);
2395:
2396: /* Bug 6164772
2397: if p_rec.default_value <> hr_api.g_varchar2 then
2398: pay_ivl_bus.chk_upd_default_value
2399: ( p_default_value => p_rec.default_value
2400: ,p_lookup_type => p_rec.lookup_type
2401: ,p_value_set_id => p_rec.value_set_id