[Home] [Help]
151: --
152: cursor csr_bat
153: is
154: select *
155: from pay_batch_element_links
156: where batch_element_link_id = p_batch_element_link_id;
157: --
158: l_bat_rec csr_bat%rowtype;
159: l_link_rec t_element_link_rec;
275: );
276: --
277: -- Update the batch link
278: --
279: update pay_batch_element_links
280: set element_link_id = l_link_rec.element_link_id
281: where batch_element_link_id = p_batch_element_link_id;
282:
283: --
412: is
413: select
414: bat.batch_element_link_id
415: from
416: pay_batch_element_links bat
417: where
418: bat.business_group_id = p_bgid
419: and (bat.batch_element_link_id = p_batlink_id
420: or ( p_gen_link_type = 'A'
465: --
466: -- Failed to lock the batch link.
467: --
468: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
469: hr_utility.set_message_token('TABLE_NAME', 'pay_batch_element_links');
470: hr_utility.raise_error;
471: end;
472: --
473: -- Load batch element links