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 182: l_batch_id pay_batch_lines.batch_id%TYPE;

178: l_element_name pay_element_types_f.element_name%TYPE := null;
179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;
182: l_batch_id pay_batch_lines.batch_id%TYPE;
183: l_effective_date pay_batch_lines.effective_date%TYPE;
184: l_date_prof_value varchar2(80);
185: --
186: /*Temporary variables for doing only validation when BEE_IV_UPG is 'N'*/

Line 183: l_effective_date pay_batch_lines.effective_date%TYPE;

179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;
182: l_batch_id pay_batch_lines.batch_id%TYPE;
183: l_effective_date pay_batch_lines.effective_date%TYPE;
184: l_date_prof_value varchar2(80);
185: --
186: /*Temporary variables for doing only validation when BEE_IV_UPG is 'N'*/
187: --

Line 188: temp_iv1 pay_batch_lines.value_1%TYPE := null;

184: l_date_prof_value varchar2(80);
185: --
186: /*Temporary variables for doing only validation when BEE_IV_UPG is 'N'*/
187: --
188: temp_iv1 pay_batch_lines.value_1%TYPE := null;
189: --
190:
191: lv_dummy varchar2(100);
192: cursor csr_element_type (p_ele_name varchar2

Line 228: from pay_batch_lines pbl

224: --
225: if p_effective_date = hr_api.g_date then
226: select effective_date
227: into l_effective_date
228: from pay_batch_lines pbl
229: where pbl.batch_line_id = p_batch_line_id;
230: else
231: l_effective_date := p_effective_date;
232: end if;

Line 237: from pay_batch_lines pbl

233: --
234: if (p_element_type_id = hr_api.g_number) then
235: select pbl.element_type_id
236: into l_element_type_id
237: from pay_batch_lines pbl
238: where pbl.batch_line_id = p_batch_line_id;
239: else
240: l_element_type_id := p_element_type_id;
241: end if;

Line 248: from pay_batch_lines pbl

244: --
245: if (p_batch_id is null and p_batch_line_id is not null) then
246: select pbl.batch_id
247: into l_batch_id
248: from pay_batch_lines pbl
249: where pbl.batch_line_id = p_batch_line_id;
250: else
251: l_batch_id := p_batch_id;
252: end if;

Line 257: from pay_batch_lines pbl

253: --
254: if p_element_name = hr_api.g_varchar2 then
255: select pbl.element_name
256: into l_element_name
257: from pay_batch_lines pbl
258: where pbl.batch_line_id = p_batch_line_id;
259: else
260: l_element_name := p_element_name;
261: end if;

Line 1063: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;

1059: --
1060: -- Declare cursors and local variables
1061: --
1062: l_proc varchar2(72) := g_package||'create_batch_line';
1063: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
1064: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1065: l_session_date date;
1066: l_effective_date date;
1067: l_effective_start_date date;

Line 1064: l_object_version_number pay_batch_lines.object_version_number%TYPE;

1060: -- Declare cursors and local variables
1061: --
1062: l_proc varchar2(72) := g_package||'create_batch_line';
1063: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
1064: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1065: l_session_date date;
1066: l_effective_date date;
1067: l_effective_start_date date;
1068: l_effective_end_date date;

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

1067: l_effective_start_date date;
1068: l_effective_end_date date;
1069: l_date_earned date;
1070: --
1071: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

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

1068: l_effective_end_date date;
1069: l_date_earned date;
1070: --
1071: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

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

1069: l_date_earned date;
1070: --
1071: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

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

1070: --
1071: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

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

1071: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

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

1072: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

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

1073: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

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

1074: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

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

1075: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

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

1076: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

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

1077: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1085: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

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

1078: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1085: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1086: --

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

1079: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1085: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1086: --
1087: l_bee_iv_upgrade varchar2(1);

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

1080: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1085: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1086: --
1087: l_bee_iv_upgrade varchar2(1);
1088: --

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

1081: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
1082: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
1083: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
1084: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
1085: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
1086: --
1087: l_bee_iv_upgrade varchar2(1);
1088: --
1089: CURSOR CSR_CHECK_FND_SESSION (p_eff_date date)

Line 1640: from pay_input_values_f pivf, pay_element_types_f petf, pay_batch_lines pbl

1636: p_control_type varchar2,
1637: p_control_column_name varchar2
1638: ) is
1639: select distinct petf.input_currency_code, pivf.uom
1640: from pay_input_values_f pivf, pay_element_types_f petf, pay_batch_lines pbl
1641: where pbl.batch_id = p_batch_id
1642: and pbl.element_type_id = petf.element_type_id
1643: and petf.element_type_id = pivf.element_type_id
1644: and pivf.uom <> 'D'

Line 2076: l_object_version_number pay_batch_lines.object_version_number%TYPE;

2072: --
2073: -- Declare cursors and local variables
2074: --
2075: l_proc varchar2(72) := g_package||'update_batch_line';
2076: l_object_version_number pay_batch_lines.object_version_number%TYPE;
2077: l_session_date date;
2078: l_effective_date date;
2079: l_effective_start_date date;
2080: l_effective_end_date date;

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

2079: l_effective_start_date date;
2080: l_effective_end_date date;
2081: l_date_earned date;
2082: --
2083: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;

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

2080: l_effective_end_date date;
2081: l_date_earned date;
2082: --
2083: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;

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

2081: l_date_earned date;
2082: --
2083: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;

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

2082: --
2083: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;

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

2083: l_value_1 pay_batch_lines.value_1%TYPE := p_value_1;
2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;

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

2084: l_value_2 pay_batch_lines.value_2%TYPE := p_value_2;
2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;

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

2085: l_value_3 pay_batch_lines.value_3%TYPE := p_value_3;
2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;

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

2086: l_value_4 pay_batch_lines.value_4%TYPE := p_value_4;
2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;

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

2087: l_value_5 pay_batch_lines.value_5%TYPE := p_value_5;
2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;

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

2088: l_value_6 pay_batch_lines.value_6%TYPE := p_value_6;
2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;

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

2089: l_value_7 pay_batch_lines.value_7%TYPE := p_value_7;
2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
2097: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;

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

2090: l_value_8 pay_batch_lines.value_8%TYPE := p_value_8;
2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
2097: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
2098: --

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

2091: l_value_9 pay_batch_lines.value_9%TYPE := p_value_9;
2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
2097: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
2098: --
2099: l_bee_iv_upgrade varchar2(1);

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

2092: l_value_10 pay_batch_lines.value_10%TYPE := p_value_10;
2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
2097: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
2098: --
2099: l_bee_iv_upgrade varchar2(1);
2100: --

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

2093: l_value_11 pay_batch_lines.value_11%TYPE := p_value_11;
2094: l_value_12 pay_batch_lines.value_12%TYPE := p_value_12;
2095: l_value_13 pay_batch_lines.value_13%TYPE := p_value_13;
2096: l_value_14 pay_batch_lines.value_14%TYPE := p_value_14;
2097: l_value_15 pay_batch_lines.value_15%TYPE := p_value_15;
2098: --
2099: l_bee_iv_upgrade varchar2(1);
2100: --
2101: begin

Line 2726: from pay_batch_lines btl

2722: l_proc varchar2(72) := g_package||'delete_batch_header';
2723: --
2724: cursor csr_batch_lines is
2725: select btl.batch_line_id,btl.object_version_number
2726: from pay_batch_lines btl
2727: where btl.batch_id = p_batch_id;
2728: --
2729: cursor csr_batch_ctl_totals is
2730: select bct.batch_control_id,bct.object_version_number