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_TDF_BUS dependencies on PAY_TDF_SHD

Line 189: ,p_rec in pay_tdf_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure chk_non_updateable_args
188: (p_effective_date in date
189: ,p_rec in pay_tdf_shd.g_rec_type
190: ,p_time_def_used in boolean
191: ,p_regenerate_periods out nocopy boolean
192: ,p_delete_periods out nocopy boolean
193: ) IS

Line 202: IF NOT pay_tdf_shd.api_updating

198: --
199: -- Only proceed with the validation if a row exists for the current
200: -- record in the HR Schema.
201: --
202: IF NOT pay_tdf_shd.api_updating
203: (p_time_definition_id => p_rec.time_definition_id
204: ,p_object_version_number => p_rec.object_version_number
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then

209: fnd_message.raise_error;
210: END IF;
211: --
212: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
214: hr_api.argument_changed_error
215: (p_api_name => l_proc
216: ,p_argument => 'BUSINESS_GROUP_ID'
217: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 217: ,p_base_table => pay_tdf_shd.g_tab_nam

213: nvl(pay_tdf_shd.g_old_rec.business_group_id, hr_api.g_number) then
214: hr_api.argument_changed_error
215: (p_api_name => l_proc
216: ,p_argument => 'BUSINESS_GROUP_ID'
217: ,p_base_table => pay_tdf_shd.g_tab_nam
218: );
219: end if;
220: --
221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

218: );
219: end if;
220: --
221: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
223: hr_api.argument_changed_error
224: (p_api_name => l_proc
225: ,p_argument => 'LEGISLATION_CODE'
226: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 226: ,p_base_table => pay_tdf_shd.g_tab_nam

222: nvl(pay_tdf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
223: hr_api.argument_changed_error
224: (p_api_name => l_proc
225: ,p_argument => 'LEGISLATION_CODE'
226: ,p_base_table => pay_tdf_shd.g_tab_nam
227: );
228: end if;
229: --
230: if nvl(p_rec.short_name, hr_api.g_varchar2) <>

Line 231: pay_tdf_shd.g_old_rec.short_name then

227: );
228: end if;
229: --
230: if nvl(p_rec.short_name, hr_api.g_varchar2) <>
231: pay_tdf_shd.g_old_rec.short_name then
232: hr_api.argument_changed_error
233: (p_api_name => l_proc
234: ,p_argument => 'SHORT_NAME'
235: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 235: ,p_base_table => pay_tdf_shd.g_tab_nam

231: pay_tdf_shd.g_old_rec.short_name then
232: hr_api.argument_changed_error
233: (p_api_name => l_proc
234: ,p_argument => 'SHORT_NAME'
235: ,p_base_table => pay_tdf_shd.g_tab_nam
236: );
237: end if;
238: --
239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>

Line 240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then

236: );
237: end if;
238: --
239: if nvl(p_rec.definition_type, hr_api.g_varchar2) <>
240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then
241: hr_api.argument_changed_error
242: (p_api_name => l_proc
243: ,p_argument => 'DEFINITION_TYPE'
244: ,p_base_table => pay_tdf_shd.g_tab_nam

Line 244: ,p_base_table => pay_tdf_shd.g_tab_nam

240: nvl(pay_tdf_shd.g_old_rec.definition_type, hr_api.g_varchar2) then
241: hr_api.argument_changed_error
242: (p_api_name => l_proc
243: ,p_argument => 'DEFINITION_TYPE'
244: ,p_base_table => pay_tdf_shd.g_tab_nam
245: );
246: end if;
247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>

Line 249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR

245: );
246: end if;
247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR

Line 251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR

247: --
248: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR

Line 253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR

249: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2) OR
250: nvl(p_rec.period_unit, hr_api.g_varchar2) <>
251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR

Line 255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR

251: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) OR
252: nvl(p_rec.day_adjustment, hr_api.g_varchar2) <>
253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then

Line 257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR

253: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) OR
254: nvl(p_rec.dynamic_code, hr_api.g_varchar2) <>
255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:
261: if p_time_def_used then

Line 259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then

255: nvl(pay_tdf_shd.g_old_rec.dynamic_code, hr_api.g_varchar2) OR
256: nvl(p_rec.start_date, hr_api.g_date) <>
257: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) OR
258: nvl(p_rec.period_time_definition_id, hr_api.g_number) <>
259: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number) then
260:
261: if p_time_def_used then
262:
263: p_regenerate_periods := false;

Line 277: nvl(pay_tdf_shd.g_old_rec.time_definition_id, hr_api.g_number) then

273:
274: end if;
275:
276: elsif nvl(p_rec.number_of_years, hr_api.g_number) <>
277: nvl(pay_tdf_shd.g_old_rec.time_definition_id, hr_api.g_number) then
278:
279: p_regenerate_periods := true;
280: p_delete_periods := false;
281:

Line 538: l_api_updating := pay_tdf_shd.api_updating

534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: l_api_updating := pay_tdf_shd.api_updating
539: (p_time_definition_id => p_time_definition_id
540: ,p_object_version_number => p_object_version_number);
541:
542: if hr_multi_message.no_exclusive_error

Line 548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )

544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'
545: ) and (
546: not l_api_updating or
547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>
548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )
549: ) then
550:
551: if p_definition_type in ('P','E','C')
552: and p_number_of_years is not null then

Line 577: p_number_of_years < nvl(pay_tdf_shd.g_old_rec.number_of_years,0) then

573:
574: end if;
575:
576: if l_api_updating and p_definition_type = 'S' and
577: p_number_of_years < nvl(pay_tdf_shd.g_old_rec.number_of_years,0) then
578:
579: fnd_message.set_name('PAY', 'PAY_34055_FLSA_YEARS_INV_UPD');
580: fnd_message.raise_error;
581:

Line 783: l_api_updating := pay_tdf_shd.api_updating

779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: l_api_updating := pay_tdf_shd.api_updating
784: (p_time_definition_id => p_time_definition_id
785: ,p_object_version_number => p_object_version_number);
786:
787: if hr_multi_message.no_exclusive_error

Line 793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )

789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'
790: ) and (
791: not l_api_updating or
792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>
793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )
794: ) then
795:
796: if p_definition_type in ('E','C')
797: and p_period_type is not null then

Line 890: l_api_updating := pay_tdf_shd.api_updating

886: --
887: Begin
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --
890: l_api_updating := pay_tdf_shd.api_updating
891: (p_time_definition_id => p_time_definition_id
892: ,p_object_version_number => p_object_version_number);
893:
894: if hr_multi_message.no_exclusive_error

Line 900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )

896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'
897: ) and (
898: not l_api_updating or
899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>
900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )
901: ) then
902:
903: if p_definition_type in ('S','E','C')
904: and p_period_unit is not null then

Line 970: l_api_updating := pay_tdf_shd.api_updating

966: --
967: Begin
968: hr_utility.set_location('Entering:'||l_proc, 5);
969: --
970: l_api_updating := pay_tdf_shd.api_updating
971: (p_time_definition_id => p_time_definition_id
972: ,p_object_version_number => p_object_version_number);
973:
974: if hr_multi_message.no_exclusive_error

Line 980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )

976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'
977: ) and (
978: not l_api_updating or
979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>
980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )
981: ) then
982:
983: if p_definition_type in ('S','E','C')
984: and p_day_adjustment is not null then

Line 1049: l_api_updating := pay_tdf_shd.api_updating

1045: --
1046: Begin
1047: hr_utility.set_location('Entering:'||l_proc, 5);
1048: --
1049: l_api_updating := pay_tdf_shd.api_updating
1050: (p_time_definition_id => p_time_definition_id
1051: ,p_object_version_number => p_object_version_number);
1052:
1053: if hr_multi_message.no_exclusive_error

Line 1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )

1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'
1056: ) and (
1057: not l_api_updating or
1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>
1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )
1060: ) then
1061:
1062: if p_definition_type in ('P','E','C')
1063: and p_start_date is not null then

Line 1168: l_api_updating := pay_tdf_shd.api_updating

1164: --
1165: Begin
1166: hr_utility.set_location('Entering:'||l_proc, 5);
1167: --
1168: l_api_updating := pay_tdf_shd.api_updating
1169: (p_time_definition_id => p_time_definition_id
1170: ,p_object_version_number => p_object_version_number);
1171:
1172: if hr_multi_message.no_exclusive_error

Line 1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )

1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'
1175: ) and (
1176: not l_api_updating or
1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>
1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )
1179: ) then
1180:
1181: if p_definition_type in ('P','E','C')
1182: and p_period_time_definition_id is not null then

Line 1297: l_api_updating := pay_tdf_shd.api_updating

1293: --
1294: Begin
1295: hr_utility.set_location('Entering:'||l_proc, 5);
1296: --
1297: l_api_updating := pay_tdf_shd.api_updating
1298: (p_time_definition_id => p_time_definition_id
1299: ,p_object_version_number => p_object_version_number);
1300:
1301: if not l_api_updating or

Line 1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )

1299: ,p_object_version_number => p_object_version_number);
1300:
1301: if not l_api_updating or
1302: ( l_api_updating and nvl(p_definition_name, hr_api.g_varchar2) <>
1303: nvl(pay_tdf_shd.g_old_rec.definition_name, hr_api.g_varchar2 )
1304: ) then
1305:
1306: hr_api.mandatory_arg_error
1307: (p_api_name => l_proc

Line 1592: ,p_rec in pay_tdf_shd.g_rec_type

1588: -- |---------------------------< insert_validate >----------------------------|
1589: -- ----------------------------------------------------------------------------
1590: Procedure insert_validate
1591: (p_effective_date in date
1592: ,p_rec in pay_tdf_shd.g_rec_type
1593: ) is
1594: --
1595: l_proc varchar2(72) := g_package||'insert_validate';
1596: --

Line 1615: ,p_associated_column1 => pay_tdf_shd.g_tab_nam

1611: -- Validate Important Attributes
1612: --
1613: hr_api.validate_bus_grp_id
1614: (p_business_group_id => p_rec.business_group_id
1615: ,p_associated_column1 => pay_tdf_shd.g_tab_nam
1616: || '.BUSINESS_GROUP_ID');
1617: --
1618: -- after validating the set of important attributes,
1619: -- if Multiple Message Detection is enabled and at least

Line 1722: ,p_rec in pay_tdf_shd.g_rec_type

1718: -- |---------------------------< update_validate >----------------------------|
1719: -- ----------------------------------------------------------------------------
1720: Procedure update_validate
1721: (p_effective_date in date
1722: ,p_rec in pay_tdf_shd.g_rec_type
1723: ,p_regenerate_periods out nocopy boolean
1724: ,p_delete_periods out nocopy boolean
1725: ) is
1726: --

Line 1748: ,p_associated_column1 => pay_tdf_shd.g_tab_nam

1744: -- Validate Important Attributes
1745: --
1746: hr_api.validate_bus_grp_id
1747: (p_business_group_id => p_rec.business_group_id
1748: ,p_associated_column1 => pay_tdf_shd.g_tab_nam
1749: || '.BUSINESS_GROUP_ID');
1750: --
1751: -- After validating the set of important attributes,
1752: -- if Multiple Message Detection is enabled and at least

Line 1843: (p_rec in pay_tdf_shd.g_rec_type

1839: -- ----------------------------------------------------------------------------
1840: -- |---------------------------< delete_validate >----------------------------|
1841: -- ----------------------------------------------------------------------------
1842: Procedure delete_validate
1843: (p_rec in pay_tdf_shd.g_rec_type
1844: ) is
1845: --
1846: l_proc varchar2(72) := g_package||'delete_validate';
1847: l_time_def_usage boolean;

Line 1854: ,pay_tdf_shd.g_old_rec.business_group_id

1850: hr_utility.set_location('Entering:'||l_proc, 5);
1851: --
1852: --
1853: chk_startup_action(false
1854: ,pay_tdf_shd.g_old_rec.business_group_id
1855: ,pay_tdf_shd.g_old_rec.legislation_code
1856: );
1857: IF hr_startup_data_api_support.g_startup_mode
1858: NOT IN ('GENERIC','STARTUP') THEN

Line 1855: ,pay_tdf_shd.g_old_rec.legislation_code

1851: --
1852: --
1853: chk_startup_action(false
1854: ,pay_tdf_shd.g_old_rec.business_group_id
1855: ,pay_tdf_shd.g_old_rec.legislation_code
1856: );
1857: IF hr_startup_data_api_support.g_startup_mode
1858: NOT IN ('GENERIC','STARTUP') THEN
1859: --

Line 1874: ,p_definition_type => pay_tdf_shd.g_old_rec.definition_type

1870: -- Call all supporting business operations
1871: --
1872: l_time_def_usage := chk_time_def_usage
1873: ( p_time_definition_id => p_rec.time_definition_id
1874: ,p_definition_type => pay_tdf_shd.g_old_rec.definition_type
1875: );
1876:
1877: if l_time_def_usage then
1878: