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_BATCH_ELEMENT_ENTRY_API dependencies on PAY_BATCH_LINES

Line 25: pay_batch_lines btl

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: --
29: begin

Line 167: l_batch_id pay_batch_lines.batch_id%TYPE;

163: l_element_name pay_element_types_f.element_name%TYPE := null;
164: l_count number := 0;
165: l_legislation_code per_business_groups.legislation_code%TYPE := null;
166: l_business_group_id per_business_groups.business_group_id%TYPE;
167: l_batch_id pay_batch_lines.batch_id%TYPE;
168: l_effective_date pay_batch_lines.effective_date%TYPE;
169: --
170: cursor csr_element_type (p_ele_name varchar2
171: ,p_bus_group_id number

Line 168: l_effective_date pay_batch_lines.effective_date%TYPE;

164: l_count number := 0;
165: l_legislation_code per_business_groups.legislation_code%TYPE := null;
166: l_business_group_id per_business_groups.business_group_id%TYPE;
167: l_batch_id pay_batch_lines.batch_id%TYPE;
168: l_effective_date pay_batch_lines.effective_date%TYPE;
169: --
170: cursor csr_element_type (p_ele_name varchar2
171: ,p_bus_group_id number
172: ,p_leg_code varchar2

Line 203: from pay_batch_lines pbl

199: --
200: if p_effective_date = hr_api.g_date then
201: select effective_date
202: into l_effective_date
203: from pay_batch_lines pbl
204: where pbl.batch_line_id = p_batch_line_id;
205: else
206: l_effective_date := p_effective_date;
207: end if;

Line 212: from pay_batch_lines pbl

208: --
209: if (p_element_type_id = hr_api.g_number) then
210: select pbl.element_type_id
211: into l_element_type_id
212: from pay_batch_lines pbl
213: where pbl.batch_line_id = p_batch_line_id;
214: else
215: l_element_type_id := p_element_type_id;
216: end if;

Line 223: from pay_batch_lines pbl

219: --
220: if (p_batch_id is null and p_batch_line_id is not null) then
221: select pbl.batch_id
222: into l_batch_id
223: from pay_batch_lines pbl
224: where pbl.batch_line_id = p_batch_line_id;
225: else
226: l_batch_id := p_batch_id;
227: end if;

Line 232: from pay_batch_lines pbl

228: --
229: if p_element_name = hr_api.g_varchar2 then
230: select pbl.element_name
231: into l_element_name
232: from pay_batch_lines pbl
233: where pbl.batch_line_id = p_batch_line_id;
234: else
235: l_element_name := p_element_name;
236: end if;

Line 718: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;

714: --
715: -- Declare cursors and local variables
716: --
717: l_proc varchar2(72) := g_package||'create_batch_line';
718: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
719: l_object_version_number pay_batch_lines.object_version_number%TYPE;
720: l_session_date date;
721: l_effective_date date;
722: l_effective_start_date date;

Line 719: l_object_version_number pay_batch_lines.object_version_number%TYPE;

715: -- Declare cursors and local variables
716: --
717: l_proc varchar2(72) := g_package||'create_batch_line';
718: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
719: l_object_version_number pay_batch_lines.object_version_number%TYPE;
720: l_session_date date;
721: l_effective_date date;
722: l_effective_start_date date;
723: l_effective_end_date date;

Line 726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;

722: l_effective_start_date date;
723: l_effective_end_date date;
724: l_date_earned date;
725: --
726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

Line 727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;

723: l_effective_end_date date;
724: l_date_earned date;
725: --
726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

Line 728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;

724: l_date_earned date;
725: --
726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

Line 729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;

725: --
726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

Line 730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

726: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

Line 731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

727: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

Line 732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

728: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

Line 733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

729: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

Line 734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

730: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

Line 735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

731: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

Line 736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

732: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

Line 737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

733: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
741: --

Line 738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

734: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
741: --
742: l_bee_iv_upgrade varchar2(1);

Line 739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

735: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
741: --
742: l_bee_iv_upgrade varchar2(1);
743: --

Line 740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

736: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
737: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
738: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
739: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
740: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
741: --
742: l_bee_iv_upgrade varchar2(1);
743: --
744: begin

Line 1646: l_object_version_number pay_batch_lines.object_version_number%TYPE;

1642: --
1643: -- Declare cursors and local variables
1644: --
1645: l_proc varchar2(72) := g_package||'update_batch_line';
1646: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1647: l_session_date date;
1648: l_effective_date date;
1649: l_effective_start_date date;
1650: l_effective_end_date date;

Line 1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;

1649: l_effective_start_date date;
1650: l_effective_end_date date;
1651: l_date_earned date;
1652: --
1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

Line 1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;

1650: l_effective_end_date date;
1651: l_date_earned date;
1652: --
1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

Line 1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;

1651: l_date_earned date;
1652: --
1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

Line 1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;

1652: --
1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

Line 1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

1653: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

Line 1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

1654: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

Line 1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

1655: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

Line 1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

1656: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

Line 1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

1657: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

Line 1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

1658: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

Line 1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

1659: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

Line 1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

1660: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1668: --

Line 1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

1661: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1668: --
1669: l_bee_iv_upgrade varchar2(1);

Line 1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

1662: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1668: --
1669: l_bee_iv_upgrade varchar2(1);
1670: --

Line 1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

1663: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1664: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1665: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1666: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1667: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1668: --
1669: l_bee_iv_upgrade varchar2(1);
1670: --
1671: begin

Line 2296: from pay_batch_lines btl

2292: l_proc varchar2(72) := g_package||'delete_batch_header';
2293: --
2294: cursor csr_batch_lines is
2295: select btl.batch_line_id,btl.object_version_number
2296: from pay_batch_lines btl
2297: where btl.batch_id = p_batch_id;
2298: --
2299: cursor csr_batch_ctl_totals is
2300: select bct.batch_control_id,bct.object_version_number