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_PUR_BUS dependencies on PAY_PUR_SHD

Line 599: not pay_pur_shd.api_updating

595: if hr_multi_message.no_exclusive_error
596: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
597: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
598: ) and (
599: not pay_pur_shd.api_updating
600: (p_user_row_id => p_user_row_id
601: ,p_effective_date => p_effective_date
602: ,p_object_version_number => p_object_version_number
603: ) or

Line 605: pay_pur_shd.g_old_rec.row_low_range_or_name

601: ,p_effective_date => p_effective_date
602: ,p_object_version_number => p_object_version_number
603: ) or
604: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
605: pay_pur_shd.g_old_rec.row_low_range_or_name
606: ) then
607: --
608: -- The name is mandatory.
609: --

Line 754: not pay_pur_shd.api_updating

750: if hr_multi_message.no_exclusive_error
751: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
752: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
753: ) and (
754: not pay_pur_shd.api_updating
755: (p_user_row_id => p_user_row_id
756: ,p_effective_date => p_effective_date
757: ,p_object_version_number => p_object_version_number
758: ) or

Line 760: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2)

756: ,p_effective_date => p_effective_date
757: ,p_object_version_number => p_object_version_number
758: ) or
759: nvl(p_row_high_range, hr_api.g_varchar2) <>
760: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2)
761: ) then
762: --
763: -- Ignore all validations for ROW_HIGH_RANGE for Exact Match User Tables.
764: --

Line 910: not pay_pur_shd.api_updating

906: ,p_check_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
907: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
908: ,p_associated_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
909: ) and (
910: not pay_pur_shd.api_updating
911: (p_user_row_id => p_user_row_id
912: ,p_effective_date => p_effective_date
913: ,p_object_version_number => p_object_version_number
914: ) or (

Line 916: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or

912: ,p_effective_date => p_effective_date
913: ,p_object_version_number => p_object_version_number
914: ) or (
915: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
916: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
917: nvl(p_row_high_range, hr_api.g_varchar2) <>
918: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
919: ) then
920:

Line 918: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))

914: ) or (
915: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
916: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
917: nvl(p_row_high_range, hr_api.g_varchar2) <>
918: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
919: ) then
920:
921: if p_disable_range_overlap_check is null then
922: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

Line 1316: ,p_rec in pay_pur_shd.g_rec_type

1312: -- {End Of Comments}
1313: -- ----------------------------------------------------------------------------
1314: Procedure chk_non_updateable_args
1315: (p_effective_date in date
1316: ,p_rec in pay_pur_shd.g_rec_type
1317: ) IS
1318: --
1319: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1320: --

Line 1328: IF NOT pay_pur_shd.api_updating

1324: --
1325: -- Only proceed with the validation if a row exists for the current
1326: -- record in the HR Schema.
1327: --
1328: IF NOT pay_pur_shd.api_updating
1329: (p_user_row_id => p_rec.user_row_id
1330: ,p_effective_date => p_effective_date
1331: ,p_object_version_number => p_rec.object_version_number
1332: ) THEN

Line 1341: pay_pur_shd.g_old_rec.user_table_id then

1337: END IF;
1338: --
1339: --
1340: if nvl(p_rec.user_table_id, hr_api.g_number) <>
1341: pay_pur_shd.g_old_rec.user_table_id then
1342: hr_api.argument_changed_error
1343: (p_api_name => l_proc
1344: ,p_argument => 'USER_TABLE_ID'
1345: ,p_base_table => pay_pur_shd.g_tab_nam

Line 1345: ,p_base_table => pay_pur_shd.g_tab_nam

1341: pay_pur_shd.g_old_rec.user_table_id then
1342: hr_api.argument_changed_error
1343: (p_api_name => l_proc
1344: ,p_argument => 'USER_TABLE_ID'
1345: ,p_base_table => pay_pur_shd.g_tab_nam
1346: );
1347: end if;
1348: --
1349: if nvl(p_rec.business_group_id, hr_api.g_number) <>

Line 1350: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then

1346: );
1347: end if;
1348: --
1349: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1350: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then
1351: hr_api.argument_changed_error
1352: (p_api_name => l_proc
1353: ,p_argument => 'BUSINESS_GROUP_ID'
1354: ,p_base_table => pay_pur_shd.g_tab_nam

Line 1354: ,p_base_table => pay_pur_shd.g_tab_nam

1350: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then
1351: hr_api.argument_changed_error
1352: (p_api_name => l_proc
1353: ,p_argument => 'BUSINESS_GROUP_ID'
1354: ,p_base_table => pay_pur_shd.g_tab_nam
1355: );
1356: end if;
1357: --
1358: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 1359: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

1355: );
1356: end if;
1357: --
1358: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
1359: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
1360: hr_api.argument_changed_error
1361: (p_api_name => l_proc
1362: ,p_argument => 'LEGISLATION_CODE'
1363: ,p_base_table => pay_pur_shd.g_tab_nam

Line 1363: ,p_base_table => pay_pur_shd.g_tab_nam

1359: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
1360: hr_api.argument_changed_error
1361: (p_api_name => l_proc
1362: ,p_argument => 'LEGISLATION_CODE'
1363: ,p_base_table => pay_pur_shd.g_tab_nam
1364: );
1365: end if;
1366: --
1367: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1597: (p_rec in out nocopy pay_pur_shd.g_rec_type

1593: -- ----------------------------------------------------------------------------
1594: -- |---------------------------< insert_validate >----------------------------|
1595: -- ----------------------------------------------------------------------------
1596: Procedure insert_validate
1597: (p_rec in out nocopy pay_pur_shd.g_rec_type
1598: ,p_effective_date in date
1599: ,p_datetrack_mode in varchar2
1600: ,p_validation_start_date in date
1601: ,p_validation_end_date in date

Line 1632: ,p_associated_column1 => pay_pur_shd.g_tab_nam

1628: -- Validate Important Attributes
1629: --
1630: hr_api.validate_bus_grp_id
1631: (p_business_group_id => p_rec.business_group_id
1632: ,p_associated_column1 => pay_pur_shd.g_tab_nam
1633: || '.BUSINESS_GROUP_ID');
1634: --
1635: -- after validating the set of important attributes,
1636: -- if Multiple Message Detection is enabled and at least

Line 1714: (p_rec in out nocopy pay_pur_shd.g_rec_type

1710: -- ----------------------------------------------------------------------------
1711: -- |---------------------------< update_validate >----------------------------|
1712: -- ----------------------------------------------------------------------------
1713: Procedure update_validate
1714: (p_rec in out nocopy pay_pur_shd.g_rec_type
1715: ,p_effective_date in date
1716: ,p_datetrack_mode in varchar2
1717: ,p_validation_start_date in date
1718: ,p_validation_end_date in date

Line 1749: ,p_associated_column1 => pay_pur_shd.g_tab_nam

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

Line 1825: (p_rec in pay_pur_shd.g_rec_type

1821: -- ----------------------------------------------------------------------------
1822: -- |---------------------------< delete_validate >----------------------------|
1823: -- ----------------------------------------------------------------------------
1824: Procedure delete_validate
1825: (p_rec in pay_pur_shd.g_rec_type
1826: ,p_effective_date in date
1827: ,p_datetrack_mode in varchar2
1828: ,p_disable_range_overlap_check in boolean
1829: ,p_validation_start_date in date

Line 1845: ,pay_pur_shd.g_old_rec.business_group_id

1841: g_range_or_match := NULL;
1842: --
1843: --
1844: chk_startup_action(false
1845: ,pay_pur_shd.g_old_rec.business_group_id
1846: ,pay_pur_shd.g_old_rec.legislation_code
1847: );
1848: IF hr_startup_data_api_support.g_startup_mode
1849: NOT IN ('GENERIC','STARTUP') THEN

Line 1846: ,pay_pur_shd.g_old_rec.legislation_code

1842: --
1843: --
1844: chk_startup_action(false
1845: ,pay_pur_shd.g_old_rec.business_group_id
1846: ,pay_pur_shd.g_old_rec.legislation_code
1847: );
1848: IF hr_startup_data_api_support.g_startup_mode
1849: NOT IN ('GENERIC','STARTUP') THEN
1850: --

Line 1872: (p_user_table_id => pay_pur_shd.g_old_rec.user_table_id

1868: );
1869: --
1870: --
1871: chk_delete
1872: (p_user_table_id => pay_pur_shd.g_old_rec.user_table_id
1873: ,p_user_row_id => p_rec.user_row_id
1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
1876: ,p_datetrack_mode => p_datetrack_mode

Line 1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name

1870: --
1871: chk_delete
1872: (p_user_table_id => pay_pur_shd.g_old_rec.user_table_id
1873: ,p_user_row_id => p_rec.user_row_id
1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
1876: ,p_datetrack_mode => p_datetrack_mode
1877: ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id
1878: ,p_legislation_code => pay_pur_shd.g_old_rec.legislation_code

Line 1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range

1871: chk_delete
1872: (p_user_table_id => pay_pur_shd.g_old_rec.user_table_id
1873: ,p_user_row_id => p_rec.user_row_id
1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
1876: ,p_datetrack_mode => p_datetrack_mode
1877: ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id
1878: ,p_legislation_code => pay_pur_shd.g_old_rec.legislation_code
1879: ,p_disable_range_overlap_check => p_disable_range_overlap_check

Line 1877: ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id

1873: ,p_user_row_id => p_rec.user_row_id
1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
1876: ,p_datetrack_mode => p_datetrack_mode
1877: ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id
1878: ,p_legislation_code => pay_pur_shd.g_old_rec.legislation_code
1879: ,p_disable_range_overlap_check => p_disable_range_overlap_check
1880: ,p_validation_start_date => p_validation_start_date
1881: ,p_validation_end_date => p_validation_end_date

Line 1878: ,p_legislation_code => pay_pur_shd.g_old_rec.legislation_code

1874: ,p_row_low_range_or_name => pay_pur_shd.g_old_rec.row_low_range_or_name
1875: ,p_row_high_range => pay_pur_shd.g_old_rec.row_high_range
1876: ,p_datetrack_mode => p_datetrack_mode
1877: ,p_business_group_id => pay_pur_shd.g_old_rec.business_group_id
1878: ,p_legislation_code => pay_pur_shd.g_old_rec.legislation_code
1879: ,p_disable_range_overlap_check => p_disable_range_overlap_check
1880: ,p_validation_start_date => p_validation_start_date
1881: ,p_validation_end_date => p_validation_end_date
1882: );