[Home] [Help]
349: (p_effective_date => p_effective_date
350: ,p_base_table_name => 'pay_element_entries_f'
351: ,p_base_key_column => 'element_entry_id'
352: ,p_base_key_value => p_base_key_value
353: ,p_parent_table_name1 => 'per_all_assignments_f'
354: ,p_parent_key_column1 => 'assignment_id'
355: ,p_parent_key_value1 => l_parent_key_value1
356: ,p_parent_table_name2 => 'pay_element_links_f'
357: ,p_parent_key_column2 => 'element_link_id'
560: -- Assignment locking cursor
561: --
562: cursor c_sel4 is
563: select assignment_id
564: from per_all_assignments_f
565: where assignment_id = pay_ele_shd.g_old_rec.assignment_id
566: for update nowait;
567: --
568:
644:
645: --
646: -- Note, we are doing the foreign table locking ourselves now
647: -- First, lock all rows with given assignment ID on
648: -- PER_ALL_ASSIGNMENTS_F table with exclusive row locks
649: --
650: -- Lock rows in per_all_assignments_f based on passed assignment_id.
651: -- Simply select the row for update to lock it in exclusive mode
652: -- as we are taking this functionality out of the validate_dt_mode
646: -- Note, we are doing the foreign table locking ourselves now
647: -- First, lock all rows with given assignment ID on
648: -- PER_ALL_ASSIGNMENTS_F table with exclusive row locks
649: --
650: -- Lock rows in per_all_assignments_f based on passed assignment_id.
651: -- Simply select the row for update to lock it in exclusive mode
652: -- as we are taking this functionality out of the validate_dt_mode
653: -- below
654: for i in c_sel4 loop
667: ,p_datetrack_mode => p_datetrack_mode
668: ,p_base_table_name => 'pay_element_entries_f'
669: ,p_base_key_column => 'element_entry_id'
670: ,p_base_key_value => p_element_entry_id
671: ,p_parent_table_name1 => 'per_all_assignments_f'
672: ,p_parent_key_column1 => 'assignment_id'
673: ,p_parent_key_value1 => pay_ele_shd.g_old_rec.assignment_id
674: ,p_parent_table_name2 => 'pay_element_links_f'
675: ,p_parent_key_column2 => 'element_link_id'