12: ,p_short_name varchar2
13: )return varchar2 is
14: --
15: l_status pay_upgrade_status.status%type;
16: l_business_group_id pay_batch_headers.business_group_id%TYPE;
17: --
18: cursor csr_bg_id is
19: select bth.business_group_id
20: from pay_batch_headers bth
16: l_business_group_id pay_batch_headers.business_group_id%TYPE;
17: --
18: cursor csr_bg_id is
19: select bth.business_group_id
20: from pay_batch_headers bth
21: where bth.batch_id = p_batch_id
22: union all
23: select bth.business_group_id
24: from pay_batch_headers bth,
20: from pay_batch_headers bth
21: where bth.batch_id = p_batch_id
22: union all
23: select bth.business_group_id
24: from pay_batch_headers bth,
25: pay_batch_lines btl
26: where bth.batch_id = btl.batch_id
27: and btl.batch_line_id = p_batch_line_id;
28: --
237: --
238: select pbg.business_group_id,pbg.legislation_code
239: into l_business_group_id,l_legislation_code
240: from per_business_groups pbg,
241: pay_batch_headers pbh
242: where pbh.batch_id = l_batch_id
243: and pbg.business_group_id = pbh.business_group_id;
244: --
245: open csr_element_type(l_element_name
445: --
446: -- Declare cursors and local variables
447: --
448: l_proc varchar2(72) := g_package||'create_batch_header';
449: l_batch_id pay_batch_headers.batch_id%TYPE;
450: l_object_version_number pay_batch_headers.object_version_number%TYPE;
451: l_session_date date;
452: --
453: begin
446: -- Declare cursors and local variables
447: --
448: l_proc varchar2(72) := g_package||'create_batch_header';
449: l_batch_id pay_batch_headers.batch_id%TYPE;
450: l_object_version_number pay_batch_headers.object_version_number%TYPE;
451: l_session_date date;
452: --
453: begin
454: hr_utility.set_location('Entering:'|| l_proc, 10);
1376: --
1377: -- Declare cursors and local variables
1378: --
1379: l_proc varchar2(72) := g_package||'update_batch_header';
1380: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1381: l_session_date date;
1382: --
1383: begin
1384: hr_utility.set_location('Entering:'|| l_proc, 10);