APPS.PAY_PPM_SHD dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 466: -- It is necessary to lock PAY_ORG_PAY_METHOD_USAGES_F for datetrack modes

462: -- Check to ensure the datetrack mode is not INSERT.
463: --
464: If (p_datetrack_mode <> 'INSERT') then
465: --
466: -- It is necessary to lock PAY_ORG_PAY_METHOD_USAGES_F for datetrack modes
467: -- that extend a PPM because return_effective_end_date needs to be ensure that
468: -- the usages are still valid when the record is valid. PAY_ORG_PAY_METHOD_USAGES_F
469: -- comes before PAY_PERSONAL_PAYMENT_METHODS_F in the HRMS lock ladder.
470: --

Line 468: -- the usages are still valid when the record is valid. PAY_ORG_PAY_METHOD_USAGES_F

464: If (p_datetrack_mode <> 'INSERT') then
465: --
466: -- It is necessary to lock PAY_ORG_PAY_METHOD_USAGES_F for datetrack modes
467: -- that extend a PPM because return_effective_end_date needs to be ensure that
468: -- the usages are still valid when the record is valid. PAY_ORG_PAY_METHOD_USAGES_F
469: -- comes before PAY_PERSONAL_PAYMENT_METHODS_F in the HRMS lock ladder.
470: --
471: --
472: if p_datetrack_mode = 'DELETE_NEXT_CHANGE' or p_datetrack_mode = 'FUTURE_CHANGE'

Line 474: l_lock_table := 'pay_org_pay_method_usages_f';

470: --
471: --
472: if p_datetrack_mode = 'DELETE_NEXT_CHANGE' or p_datetrack_mode = 'FUTURE_CHANGE'
473: then
474: l_lock_table := 'pay_org_pay_method_usages_f';
475: lock table pay_org_pay_method_usages_f in share mode nowait;
476: end if;
477: --
478: -- We must select and lock the current row.

Line 475: lock table pay_org_pay_method_usages_f in share mode nowait;

471: --
472: if p_datetrack_mode = 'DELETE_NEXT_CHANGE' or p_datetrack_mode = 'FUTURE_CHANGE'
473: then
474: l_lock_table := 'pay_org_pay_method_usages_f';
475: lock table pay_org_pay_method_usages_f in share mode nowait;
476: end if;
477: --
478: -- We must select and lock the current row.
479: --