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_PPM_INS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 548: -- Need to validate against PAY_ORG_PAYMENT_METHODS_F and

544: Begin
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.

Line 554: l_lock_table := 'pay_org_payment_methods_f';

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: --
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;

Line 555: lock table pay_org_payment_methods_f in share mode nowait;

551: -- SELECT ... FOR UPDATE NOWAIT causes too many failures for concurrent
552: -- API usage cases such as self-service or data pump.
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

Line 602: p_parent_table_name1 => 'pay_org_payment_methods_f',

598: p_datetrack_mode => p_datetrack_mode,
599: p_base_table_name => 'pay_personal_payment_methods_f',
600: p_base_key_column => 'personal_payment_method_id',
601: p_base_key_value => p_rec.personal_payment_method_id,
602: p_parent_table_name1 => 'pay_org_payment_methods_f',
603: p_parent_key_column1 => 'org_payment_method_id',
604: p_parent_key_value1 => p_rec.org_payment_method_id,
605: p_enforce_foreign_locking => false,
606: p_validation_start_date => l_validation_start_date1,