DBA Data[Home] [Help]

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 753: not pay_pur_shd.api_updating

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

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

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

Line 909: not pay_pur_shd.api_updating

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

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

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

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

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

Line 1313: ,p_rec in pay_pur_shd.g_rec_type

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

Line 1325: IF NOT pay_pur_shd.api_updating

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

Line 1338: pay_pur_shd.g_old_rec.user_table_id then

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

Line 1342: ,p_base_table => pay_pur_shd.g_tab_nam

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

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

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

Line 1351: ,p_base_table => pay_pur_shd.g_tab_nam

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

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

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

Line 1360: ,p_base_table => pay_pur_shd.g_tab_nam

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

Line 1594: (p_rec in out nocopy pay_pur_shd.g_rec_type

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

Line 1629: ,p_associated_column1 => pay_pur_shd.g_tab_nam

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

Line 1711: (p_rec in out nocopy pay_pur_shd.g_rec_type

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

Line 1746: ,p_associated_column1 => pay_pur_shd.g_tab_nam

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

Line 1822: (p_rec in pay_pur_shd.g_rec_type

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

Line 1842: ,pay_pur_shd.g_old_rec.business_group_id

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

Line 1843: ,pay_pur_shd.g_old_rec.legislation_code

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

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

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

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

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

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

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

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

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

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

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