APPS.PAY_PPM_INS dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 549: -- PAY_ORG_PAY_METHOD_USAGES_F so lock in SHARE mode. This is because the

545: hr_utility.set_location('Entering:'||l_proc, 5);
546: begin
547: --
548: -- Need to validate against PAY_ORG_PAYMENT_METHODS_F and
549: -- PAY_ORG_PAY_METHOD_USAGES_F so lock in SHARE mode. This is because the
550: -- data is infrequently updated, but is referenced by many pay methods.
551: -- SELECT ... FOR UPDATE NOWAIT causes too many failures for concurrent
552: -- API usage cases such as self-service or data pump.
553: --

Line 557: l_lock_table := 'pay_org_pay_method_usages_f';

553: --
554: l_lock_table := 'pay_org_payment_methods_f';
555: lock table pay_org_payment_methods_f in share mode nowait;
556: --
557: l_lock_table := 'pay_org_pay_method_usages_f';
558: lock table pay_org_pay_method_usages_f in share mode nowait;
559: exception
560: When HR_Api.Object_Locked then
561: --

Line 558: lock table pay_org_pay_method_usages_f in share mode nowait;

554: l_lock_table := 'pay_org_payment_methods_f';
555: lock table pay_org_payment_methods_f in share mode nowait;
556: --
557: l_lock_table := 'pay_org_pay_method_usages_f';
558: lock table pay_org_pay_method_usages_f in share mode nowait;
559: exception
560: When HR_Api.Object_Locked then
561: --
562: -- The object is locked therefore we need to supply a meaningful