DBA Data[Home] [Help]

APPS.PAY_UCI_BUS dependencies on PAY_UCI_SHD

Line 182: ,p_rec in pay_uci_shd.g_rec_type

178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure chk_non_updateable_args
181: (p_effective_date in date
182: ,p_rec in pay_uci_shd.g_rec_type
183: ) IS
184: --
185: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
186: --

Line 194: IF NOT pay_uci_shd.api_updating

190: --
191: -- Only proceed with the validation if a row exists for the current
192: -- record in the HR Schema.
193: --
194: IF NOT pay_uci_shd.api_updating
195: (p_user_column_instance_id => p_rec.user_column_instance_id
196: ,p_effective_date => p_effective_date
197: ,p_object_version_number => p_rec.object_version_number
198: ) THEN

Line 207: pay_uci_shd.g_old_rec.user_row_id then

203: END IF;
204: --
205: --
206: if nvl(p_rec.user_row_id, hr_api.g_number) <>
207: pay_uci_shd.g_old_rec.user_row_id then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'USER_ROW_ID'
211: ,p_base_table => pay_uci_shd.g_tab_nam

Line 211: ,p_base_table => pay_uci_shd.g_tab_nam

207: pay_uci_shd.g_old_rec.user_row_id then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'USER_ROW_ID'
211: ,p_base_table => pay_uci_shd.g_tab_nam
212: );
213: end if;
214: --
215: if nvl(p_rec.user_column_id, hr_api.g_number) <>

Line 216: pay_uci_shd.g_old_rec.user_column_id then

212: );
213: end if;
214: --
215: if nvl(p_rec.user_column_id, hr_api.g_number) <>
216: pay_uci_shd.g_old_rec.user_column_id then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'USER_COLUMN_ID'
220: ,p_base_table => pay_uci_shd.g_tab_nam

Line 220: ,p_base_table => pay_uci_shd.g_tab_nam

216: pay_uci_shd.g_old_rec.user_column_id then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'USER_COLUMN_ID'
220: ,p_base_table => pay_uci_shd.g_tab_nam
221: );
222: end if;
223: --
224: if nvl(p_rec.business_group_id, hr_api.g_number) <>

Line 225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then

221: );
222: end if;
223: --
224: if nvl(p_rec.business_group_id, hr_api.g_number) <>
225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'BUSINESS_GROUP_ID'
229: ,p_base_table => pay_uci_shd.g_tab_nam

Line 229: ,p_base_table => pay_uci_shd.g_tab_nam

225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'BUSINESS_GROUP_ID'
229: ,p_base_table => pay_uci_shd.g_tab_nam
230: );
231: end if;
232: --
233: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

230: );
231: end if;
232: --
233: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'LEGISLATION_CODE'
238: ,p_base_table => pay_uci_shd.g_tab_nam

Line 238: ,p_base_table => pay_uci_shd.g_tab_nam

234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'LEGISLATION_CODE'
238: ,p_base_table => pay_uci_shd.g_tab_nam
239: );
240: end if;
241: --
242: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 320: (p_associated_column1 => pay_uci_shd.g_tab_nam || '.USER_ROW_ID');

316: ,p_to_date => p_validation_end_date))) Then
317: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
318: fnd_message.set_token('TABLE_NAME','user rows');
319: hr_multi_message.add
320: (p_associated_column1 => pay_uci_shd.g_tab_nam || '.USER_ROW_ID');
321: End If;
322: --
323: Exception
324: When Others Then

Line 948: not pay_uci_shd.api_updating

944: if hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
946: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE'
947: ) and (
948: not pay_uci_shd.api_updating
949: (p_user_column_instance_id => p_user_column_instance_id
950: ,p_effective_date => p_effective_date
951: ,p_object_version_number => p_object_version_number
952: ) or

Line 954: nvl(pay_uci_shd.g_old_rec.value, hr_api.g_varchar2)

950: ,p_effective_date => p_effective_date
951: ,p_object_version_number => p_object_version_number
952: ) or
953: nvl(p_value, hr_api.g_varchar2) <>
954: nvl(pay_uci_shd.g_old_rec.value, hr_api.g_varchar2)
955: ) then
956: --
957: open csr_formula_id;
958: fetch csr_formula_id into l_formula_id;

Line 1082: (p_rec in pay_uci_shd.g_rec_type

1078: -- ----------------------------------------------------------------------------
1079: -- |---------------------------< insert_validate >----------------------------|
1080: -- ----------------------------------------------------------------------------
1081: Procedure insert_validate
1082: (p_rec in pay_uci_shd.g_rec_type
1083: ,p_effective_date in date
1084: ,p_datetrack_mode in varchar2
1085: ,p_validation_start_date in date
1086: ,p_validation_end_date in date

Line 1108: ,p_associated_column1 => pay_uci_shd.g_tab_nam

1104: -- Validate Important Attributes
1105: --
1106: hr_api.validate_bus_grp_id
1107: (p_business_group_id => p_rec.business_group_id
1108: ,p_associated_column1 => pay_uci_shd.g_tab_nam
1109: || '.BUSINESS_GROUP_ID');
1110: --
1111: -- after validating the set of important attributes,
1112: -- if Multiple Message Detection is enabled and at least

Line 1176: (p_rec in pay_uci_shd.g_rec_type

1172: -- ----------------------------------------------------------------------------
1173: -- |---------------------------< update_validate >----------------------------|
1174: -- ----------------------------------------------------------------------------
1175: Procedure update_validate
1176: (p_rec in pay_uci_shd.g_rec_type
1177: ,p_effective_date in date
1178: ,p_datetrack_mode in varchar2
1179: ,p_validation_start_date in date
1180: ,p_validation_end_date in date

Line 1202: ,p_associated_column1 => pay_uci_shd.g_tab_nam

1198: -- Validate Important Attributes
1199: --
1200: hr_api.validate_bus_grp_id
1201: (p_business_group_id => p_rec.business_group_id
1202: ,p_associated_column1 => pay_uci_shd.g_tab_nam
1203: || '.BUSINESS_GROUP_ID');
1204: --
1205: -- After validating the set of important attributes,
1206: -- if Multiple Message Detection is enabled and at least

Line 1248: (p_rec in pay_uci_shd.g_rec_type

1244: -- ----------------------------------------------------------------------------
1245: -- |---------------------------< delete_validate >----------------------------|
1246: -- ----------------------------------------------------------------------------
1247: Procedure delete_validate
1248: (p_rec in pay_uci_shd.g_rec_type
1249: ,p_effective_date in date
1250: ,p_datetrack_mode in varchar2
1251: ,p_validation_start_date in date
1252: ,p_validation_end_date in date

Line 1262: ,pay_uci_shd.g_old_rec.business_group_id

1258: hr_utility.set_location('Entering:'||l_proc, 5);
1259: --
1260: --
1261: chk_startup_action(false
1262: ,pay_uci_shd.g_old_rec.business_group_id
1263: ,pay_uci_shd.g_old_rec.legislation_code
1264: );
1265: IF hr_startup_data_api_support.g_startup_mode
1266: NOT IN ('GENERIC','STARTUP') THEN

Line 1263: ,pay_uci_shd.g_old_rec.legislation_code

1259: --
1260: --
1261: chk_startup_action(false
1262: ,pay_uci_shd.g_old_rec.business_group_id
1263: ,pay_uci_shd.g_old_rec.legislation_code
1264: );
1265: IF hr_startup_data_api_support.g_startup_mode
1266: NOT IN ('GENERIC','STARTUP') THEN
1267: --