DBA Data[Home] [Help]

APPS.PAY_PPD_BUS dependencies on PAY_PPD_SHD

Line 189: ,p_rec in pay_ppd_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_ppd_shd.g_rec_type
190: ) IS
191: --
192: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
193:

Line 209: IF NOT pay_ppd_shd.api_updating

205: --
206: -- Only proceed with the validation if a row exists for the current
207: -- record in the HR Schema.
208: --
209: IF NOT pay_ppd_shd.api_updating
210: (p_paye_details_id => p_rec.paye_details_id
211: ,p_effective_date => p_effective_date
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN

Line 221: nvl(pay_ppd_shd.g_old_rec.business_group_id

217: fnd_message.raise_error;
218: END IF;
219: --
220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
221: nvl(pay_ppd_shd.g_old_rec.business_group_id
222: ,hr_api.g_number
223: ) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc

Line 227: ,p_base_table => pay_ppd_shd.g_tab_nam

223: ) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'BUSINESS_GROUP_ID'
227: ,p_base_table => pay_ppd_shd.g_tab_nam
228: );
229: end if;
230:
231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>

Line 232: nvl(pay_ppd_shd.g_old_rec.contract_category

228: );
229: end if;
230:
231: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
232: nvl(pay_ppd_shd.g_old_rec.contract_category
233: ,hr_api.g_varchar2
234: ) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc

Line 238: ,p_base_table => pay_ppd_shd.g_tab_nam

234: ) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'CONTRACT_CATEGORY'
238: ,p_base_table => pay_ppd_shd.g_tab_nam
239: );
240: end if;
241:
242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>

Line 243: nvl(pay_ppd_shd.g_old_rec.per_or_asg_id

239: );
240: end if;
241:
242: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
243: nvl(pay_ppd_shd.g_old_rec.per_or_asg_id
244: ,hr_api.g_number
245: ) then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc

Line 249: ,p_base_table => pay_ppd_shd.g_tab_nam

245: ) then
246: hr_api.argument_changed_error
247: (p_api_name => l_proc
248: ,p_argument => 'PER_OR_ASG_ID'
249: ,p_base_table => pay_ppd_shd.g_tab_nam
250: );
251: end if;
252: -- Check to Income Reduction for CIVIL contract its non updateable
253: If p_rec.contract_category in ('CIVIL','LUMP','F_LUMP') then

Line 255: nvl(pay_ppd_shd.g_old_rec.income_reduction

251: end if;
252: -- Check to Income Reduction for CIVIL contract its non updateable
253: If p_rec.contract_category in ('CIVIL','LUMP','F_LUMP') then
254: if nvl(p_rec.income_reduction, hr_api.g_varchar2) <>
255: nvl(pay_ppd_shd.g_old_rec.income_reduction
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc

Line 261: ,p_base_table => pay_ppd_shd.g_tab_nam

257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'INCOME_REDUCTION'
261: ,p_base_table => pay_ppd_shd.g_tab_nam
262: );
263: end if;
264: End if;
265:

Line 278: nvl(pay_ppd_shd.g_old_rec.rate_of_tax

274: close csr_contract_type;
275:
276: if l_contract_type in ('L01','L02','L03','L04','L09','L10','L11') then
277: if nvl(p_rec.rate_of_tax, hr_api.g_varchar2) <>
278: nvl(pay_ppd_shd.g_old_rec.rate_of_tax
279: ,hr_api.g_varchar2
280: ) then
281: hr_api.argument_changed_error
282: (p_api_name => l_proc

Line 284: ,p_base_table => pay_ppd_shd.g_tab_nam

280: ) then
281: hr_api.argument_changed_error
282: (p_api_name => l_proc
283: ,p_argument => 'RATE_OF_TAX'
284: ,p_base_table => pay_ppd_shd.g_tab_nam
285: );
286: end if;
287: end if;
288: end if;

Line 471: (p_rec in pay_ppd_shd.g_rec_type

467: -- ----------------------------------------------------------------------------
468: -- |---------------------------< insert_validate >----------------------------|
469: -- ----------------------------------------------------------------------------
470: Procedure insert_validate
471: (p_rec in pay_ppd_shd.g_rec_type
472: ,p_effective_date in date
473: ,p_datetrack_mode in varchar2
474: ,p_validation_start_date in date
475: ,p_validation_end_date in date

Line 487: ,p_associated_column1 => pay_ppd_shd.g_tab_nam

483: -- Call all supporting business operations
484: --
485: hr_api.validate_bus_grp_id
486: (p_business_group_id => p_rec.business_group_id
487: ,p_associated_column1 => pay_ppd_shd.g_tab_nam
488: || '.BUSINESS_GROUP_ID');
489: --
490: -- After validating the set of important attributes,
491: -- if Multiple Message detection is enabled and at least

Line 567: (p_rec in pay_ppd_shd.g_rec_type

563: -- ----------------------------------------------------------------------------
564: -- |---------------------------< update_validate >----------------------------|
565: -- ----------------------------------------------------------------------------
566: Procedure update_validate
567: (p_rec in pay_ppd_shd.g_rec_type
568: ,p_effective_date in date
569: ,p_datetrack_mode in varchar2
570: ,p_validation_start_date in date
571: ,p_validation_end_date in date

Line 583: ,p_associated_column1 => pay_ppd_shd.g_tab_nam

579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id
582: (p_business_group_id => p_rec.business_group_id
583: ,p_associated_column1 => pay_ppd_shd.g_tab_nam
584: || '.BUSINESS_GROUP_ID');
585: --
586: -- After validating the set of important attributes,
587: -- if Multiple Message detection is enabled and at least

Line 652: (p_rec in pay_ppd_shd.g_rec_type

648: -- ----------------------------------------------------------------------------
649: -- |---------------------------< delete_validate >----------------------------|
650: -- ----------------------------------------------------------------------------
651: Procedure delete_validate
652: (p_rec in pay_ppd_shd.g_rec_type
653: ,p_effective_date in date
654: ,p_datetrack_mode in varchar2
655: ,p_validation_start_date in date
656: ,p_validation_end_date in date

Line 918: ,p_associated_column1 => pay_ppd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');

914: );
915:
916: hr_api.validate_bus_grp_id
917: (p_business_group_id => p_business_group_id
918: ,p_associated_column1 => pay_ppd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');
919:
920: hr_multi_message.end_validation_set;
921:
922: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1005: l_api_updating := pay_ppd_shd.api_updating

1001: -- a) The current g_old_rec is current and
1002: -- b) Rate of Tax value has changed
1003: -- c) A record is being inserted
1004: --
1005: l_api_updating := pay_ppd_shd.api_updating
1006: (p_paye_details_id => p_paye_details_id
1007: ,p_effective_date => p_effective_date
1008: ,p_object_version_number => p_object_version_number);
1009:

Line 1010: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.rate_of_tax,

1006: (p_paye_details_id => p_paye_details_id
1007: ,p_effective_date => p_effective_date
1008: ,p_object_version_number => p_object_version_number);
1009:
1010: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.rate_of_tax,
1011: hr_api.g_varchar2)
1012: <> nvl(p_rate_of_tax,hr_api.g_varchar2)) or
1013: (NOT l_api_updating)) then
1014:

Line 1124: l_api_updating := pay_ppd_shd.api_updating

1120: -- a) The current g_old_rec is current and
1121: -- b) Tax Reduction value has changed
1122: -- c) A record is being inserted
1123: --
1124: l_api_updating := pay_ppd_shd.api_updating
1125: (p_paye_details_id => p_paye_details_id
1126: ,p_effective_date => p_effective_date
1127: ,p_object_version_number => p_object_version_number);
1128:

Line 1129: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_reduction,

1125: (p_paye_details_id => p_paye_details_id
1126: ,p_effective_date => p_effective_date
1127: ,p_object_version_number => p_object_version_number);
1128:
1129: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_reduction,
1130: hr_api.g_varchar2)
1131: <> nvl(p_tax_reduction,hr_api.g_varchar2)) or
1132: (NOT l_api_updating)) then
1133:

Line 1209: l_api_updating := pay_ppd_shd.api_updating

1205: -- a) The current g_old_rec is current and
1206: -- b) Tax Calculation with Spouse or Child value has changed
1207: -- c) A record is being inserted
1208: --
1209: l_api_updating := pay_ppd_shd.api_updating
1210: (p_paye_details_id => p_paye_details_id
1211: ,p_effective_date => p_effective_date
1212: ,p_object_version_number => p_object_version_number);
1213:

Line 1214: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child,

1210: (p_paye_details_id => p_paye_details_id
1211: ,p_effective_date => p_effective_date
1212: ,p_object_version_number => p_object_version_number);
1213:
1214: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child,
1215: hr_api.g_varchar2)
1216: <> nvl(p_tax_calc_with_spouse_child,hr_api.g_varchar2)) or
1217: (NOT l_api_updating)) then
1218:

Line 1294: l_api_updating := pay_ppd_shd.api_updating

1290: -- a) The current g_old_rec is current and
1291: -- b) Income Reduction value has changed
1292: -- c) A record is being inserted
1293: --
1294: l_api_updating := pay_ppd_shd.api_updating
1295: (p_paye_details_id => p_paye_details_id
1296: ,p_effective_date => p_effective_date
1297: ,p_object_version_number => p_object_version_number);
1298:

Line 1299: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.income_reduction,

1295: (p_paye_details_id => p_paye_details_id
1296: ,p_effective_date => p_effective_date
1297: ,p_object_version_number => p_object_version_number);
1298:
1299: if ((l_api_updating and nvl(pay_ppd_shd.g_old_rec.income_reduction,
1300: hr_api.g_varchar2)
1301: <> nvl(p_income_reduction,hr_api.g_varchar2)) or
1302: (NOT l_api_updating)) then
1303: