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 249: (p_element_type_id in number default hr_api.g_number

245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure dt_update_validate
249: (p_element_type_id in number default hr_api.g_number
250: ,p_datetrack_mode in varchar2
251: ,p_validation_start_date in date
252: ,p_validation_end_date in date
253: ) Is

Line 261: hr_api.mandatory_arg_error

257: Begin
258: --
259: -- Ensure that the p_datetrack_mode argument is not null
260: --
261: hr_api.mandatory_arg_error
262: (p_api_name => l_proc
263: ,p_argument => 'datetrack_mode'
264: ,p_argument_value => p_datetrack_mode
265:

Line 272: hr_api.mandatory_arg_error

268: -- Mode will be valid, as this is checked at the start of the upd.
269: --
270: -- Ensure the arguments are not null
271: --
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc
274: ,p_argument => 'validation_start_date'
275: ,p_argument_value => p_validation_start_date
276: );

Line 278: hr_api.mandatory_arg_error

274: ,p_argument => 'validation_start_date'
275: ,p_argument_value => p_validation_start_date
276: );
277: --
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc
280: ,p_argument => 'validation_end_date'
281: ,p_argument_value => p_validation_end_date
282: );

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

280: ,p_argument => 'validation_end_date'
281: ,p_argument_value => p_validation_end_date
282: );
283: --
284: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
285: NOT (dt_api.check_min_max_dates
286: (p_base_table_name => 'pay_element_types_f'
287: ,p_base_key_column => 'ELEMENT_TYPE_ID'
288: ,p_base_key_value => p_element_type_id

Line 360: hr_api.mandatory_arg_error

356: Begin
357: --
358: -- Ensure that the p_datetrack_mode argument is not null
359: --
360: hr_api.mandatory_arg_error
361:
362: (p_api_name => l_proc
363: ,p_argument => 'datetrack_mode'
364: ,p_argument_value => p_datetrack_mode

Line 370: If (p_datetrack_mode = hr_api.g_delete or

366: --
367: -- Only perform the validation if the datetrack mode is either
368: -- DELETE or ZAP
369: --
370: If (p_datetrack_mode = hr_api.g_delete or
371: p_datetrack_mode = hr_api.g_zap) then
372: --
373: --
374: -- Ensure the arguments are not null

Line 371: p_datetrack_mode = hr_api.g_zap) then

367: -- Only perform the validation if the datetrack mode is either
368: -- DELETE or ZAP
369: --
370: If (p_datetrack_mode = hr_api.g_delete or
371: p_datetrack_mode = hr_api.g_zap) then
372: --
373: --
374: -- Ensure the arguments are not null
375: --

Line 376: hr_api.mandatory_arg_error

372: --
373: --
374: -- Ensure the arguments are not null
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc
378: ,p_argument => 'validation_start_date'
379: ,p_argument_value => p_validation_start_date
380: );

Line 382: hr_api.mandatory_arg_error

378: ,p_argument => 'validation_start_date'
379: ,p_argument_value => p_validation_start_date
380: );
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc
384: ,p_argument => 'validation_end_date'
385:
386: ,p_argument_value => p_validation_end_date

Line 389: hr_api.mandatory_arg_error

385:
386: ,p_argument_value => p_validation_end_date
387: );
388: --
389: hr_api.mandatory_arg_error
390: (p_api_name => l_proc
391: ,p_argument => 'input_value_id'
392: ,p_argument_value => p_input_value_id
393: );

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

493: select 'X' from hr_lookups
494: where upper(lookup_type) = nvl(upper(p_lookup_type),lookup_type)
495: and enabled_flag = 'Y'
496: and p_effective_date between
497: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
498:
499: l_dummy varchar2(1);
500:
501: l_proc varchar2(72) := g_package||'chk_lookup_type';

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

986: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
987: and lookup_type = 'UNITS'
988: and enabled_flag = 'Y'
989: and p_effective_date between
990: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
991:
992: l_dummy varchar2(1);
993:
994: l_count number;

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

1257: where upper(lookup_code) = nvl(upper(p_uom),lookup_code)
1258: and lookup_type = 'UNITS'
1259: and enabled_flag = 'Y'
1260: and p_effective_date between
1261: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1262:
1263: l_dummy varchar2(1);
1264:
1265: l_proc varchar2(72) := g_package||'chk_uom';

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

1320: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1321: and lookup_type = p_lookup_type
1322: and enabled_flag = 'Y'
1323: and p_effective_date between
1324: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1325: --
1326: l_dummy varchar(1);
1327: l_proc varchar2(72) := g_package||'chk_default_value';
1328: --

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

1424: select 'X'
1425: from hr_lookups
1426: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1427: and lookup_type = decode(p_lookup_type,
1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1429: p_lookup_type)
1430: and enabled_flag = 'Y'
1431: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1432: and nvl(end_date_active,hr_api.g_eot);

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

1427: and lookup_type = decode(p_lookup_type,
1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1429: p_lookup_type)
1430: and enabled_flag = 'Y'
1431: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1432: and nvl(end_date_active,hr_api.g_eot);
1433: --
1434: l_dummy varchar(1);
1435: l_value_set_id number;

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

1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1429: p_lookup_type)
1430: and enabled_flag = 'Y'
1431: and p_effective_date between nvl(start_date_active,hr_api.g_sot)
1432: and nvl(end_date_active,hr_api.g_eot);
1433: --
1434: l_dummy varchar(1);
1435: l_value_set_id number;
1436: l_proc varchar2(72) := g_package||'chk_upd_default_value';

Line 1444: p_lookup_type = hr_api.g_varchar2

1440: hr_utility.set_location(' Entering:'|| l_proc, 10);
1441: --
1442: if p_lookup_type is not null or (
1443: pay_ivl_shd.g_old_rec.lookup_type is not null and
1444: p_lookup_type = hr_api.g_varchar2
1445: ) then
1446: --
1447: open csr_lookup;
1448: fetch csr_lookup into l_dummy;

Line 1462: p_default_value <> hr_api.g_varchar2 and (

1458: --
1459: close csr_lookup;
1460: --
1461: elsif p_value_set_id is not null and p_default_value is not null and
1462: p_default_value <> hr_api.g_varchar2 and (
1463: p_value_set_id <> hr_api.g_number or (
1464: pay_ivl_shd.g_old_rec.value_set_id is not null and
1465: p_value_set_id = hr_api.g_number
1466: )

Line 1463: p_value_set_id <> hr_api.g_number or (

1459: close csr_lookup;
1460: --
1461: elsif p_value_set_id is not null and p_default_value is not null and
1462: p_default_value <> hr_api.g_varchar2 and (
1463: p_value_set_id <> hr_api.g_number or (
1464: pay_ivl_shd.g_old_rec.value_set_id is not null and
1465: p_value_set_id = hr_api.g_number
1466: )
1467: ) then

Line 1465: p_value_set_id = hr_api.g_number

1461: elsif p_value_set_id is not null and p_default_value is not null and
1462: p_default_value <> hr_api.g_varchar2 and (
1463: p_value_set_id <> hr_api.g_number or (
1464: pay_ivl_shd.g_old_rec.value_set_id is not null and
1465: p_value_set_id = hr_api.g_number
1466: )
1467: ) then
1468: --
1469: if p_value_set_id = hr_api.g_number then

Line 1469: if p_value_set_id = hr_api.g_number then

1465: p_value_set_id = hr_api.g_number
1466: )
1467: ) then
1468: --
1469: if p_value_set_id = hr_api.g_number then
1470: --
1471: -- Value set id is not changing, use the old one
1472: --
1473: l_value_set_id := pay_ivl_shd.g_old_rec.value_set_id;

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

1599: where upper(lookup_code) = nvl(upper(p_warning_or_error),lookup_code)
1600: and lookup_type = 'WARNING_ERROR'
1601: and enabled_flag = 'Y'
1602: and p_effective_date between
1603: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1604:
1605: l_dummy varchar2(1);
1606: l_proc varchar2(72) := g_package||'chk_warning_or_error';
1607: BEGIN

Line 1990: hr_api.validate_bus_grp_id

1986: NOT IN ('GENERIC','STARTUP') THEN
1987: --
1988: -- Validate Important Attributes
1989: --
1990: hr_api.validate_bus_grp_id
1991: (p_business_group_id => p_rec.business_group_id
1992: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
1993: || '.BUSINESS_GROUP_ID');
1994: --

Line 2131: hr_api.validate_bus_grp_id

2127: --
2128: -- Validate Important Attributes
2129: --
2130:
2131: hr_api.validate_bus_grp_id
2132: (p_business_group_id => p_rec.business_group_id
2133: ,p_associated_column1 => pay_ivl_shd.g_tab_nam
2134: || '.BUSINESS_GROUP_ID');
2135: --

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

2236: ,p_max => p_rec.max_value
2237: ,p_warning_or_error => p_rec.warning_or_error
2238: ,p_link_inp_val_warning => p_link_inp_val_warning);
2239:
2240: if p_rec.default_value <> hr_api.g_varchar2 then
2241: pay_ivl_bus.chk_upd_default_value
2242: ( p_default_value => p_rec.default_value
2243: ,p_lookup_type => p_rec.lookup_type
2244: ,p_value_set_id => p_rec.value_set_id