[Home] [Help]
6: g_ext_precision NUMBER;
7: -- End of bug fix 2916848
8:
9: -- Introduced the following for bug fix 3107800
10: g_bg_currency_code psp_payroll_controls.currency_code%TYPE;
11: g_sob_currency_code gl_sets_of_books.currency_code%TYPE;
12: g_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
13: g_uom VARCHAR2(1);
14: g_entry_date_earned DATE;
8:
9: -- Introduced the following for bug fix 3107800
10: g_bg_currency_code psp_payroll_controls.currency_code%TYPE;
11: g_sob_currency_code gl_sets_of_books.currency_code%TYPE;
12: g_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
13: g_uom VARCHAR2(1);
14: g_entry_date_earned DATE;
15: g_effective_start_date DATE; -- LD Added
16: g_effective_end_date DATE; -- LD Added
428: WHERE business_group_id = l_resp_business_group_id;
429:
430: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;
431: l_legislation_code per_business_groups.legislation_code%TYPE;
432: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
433: l_prev_currency_code psp_payroll_controls.currency_code%TYPE;
434:
435: TYPE v_num_array IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
436: TYPE v_currency_code IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
429:
430: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;
431: l_legislation_code per_business_groups.legislation_code%TYPE;
432: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
433: l_prev_currency_code psp_payroll_controls.currency_code%TYPE;
434:
435: TYPE v_num_array IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
436: TYPE v_currency_code IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
437: TYPE v_amount_array is table of NUMBER(15,5) INDEX by BINARY_INTEGER;
476: from (select count(distinct ppl.assignment_id) cnt_asg,
477: ppl.payroll_action_type,
478: ppc.time_period_id,
479: ppc.parent_payroll_control_id
480: from psp_payroll_controls ppc,
481: psp_payroll_lines ppl
482: where ppc.run_id = l_run_id
483: and ppc.payroll_control_id = ppl.payroll_control_id
484: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
1222: IF check_payroll_lines_csr%NOTFOUND then
1223: l_counter := l_counter + 1;
1224:
1225: ---hr_utility.trace(' No data found in payroll_lines ');
1226: -- If first record insert a record in psp_payroll_controls
1227:
1228:
1229: hr_utility.trace(' l_counter = '||l_counter);
1230: IF l_counter > 0 then
1272:
1273: IF (l_export_id IS NULL) THEN
1274: -- End of bug fix 2916848
1275:
1276: SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
1277: FROM DUAL;
1278:
1279: l_total_num_rec:= l_total_num_rec + 1;
1280: l_cur_rec:= l_total_num_rec;
1297:
1298: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1299:
1300:
1301: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW(
1302: X_ROWID => x_rowid,
1303: X_PAYROLL_CONTROL_ID => l_export_id,
1304: X_PAYROLL_ACTION_ID => g_payroll_asg_rec.payroll_action_id,
1305: X_PAYROLL_SOURCE_CODE => l_payroll_source,
1337: time_period_id_a(l_array_count) := g_pay_costs_rec.time_period_id;
1338: payroll_control_id_a(l_array_count ) := l_export_id;
1339: currency_code_a(l_array_count) := g_pay_costs_rec.output_currency_code; -- Bug 6468271
1340:
1341: update psp_payroll_controls
1342: set run_id = l_run_id
1343: where payroll_control_id = l_export_id;
1344: end if;
1345: END IF; -- Introduced for bug fix 2916848
1435: X_OR_AWARD_ID => l_or_award_id,
1436: X_OR_EXPENDITURE_ORG_ID => l_or_expenditure_org_id,
1437: X_OR_EXPENDITURE_TYPE => l_or_expenditure_type);
1438:
1439: -- The following code is required as psp_payroll_controls will be updated with the total debit and credit amount
1440:
1441:
1442: IF g_pay_costs_rec.debit_or_credit = 'D' then
1443: r_payroll_control_array.r_tot_dr(l_cur_rec)
1839: payroll_control_id_a.delete;
1840: time_period_id_a.delete;
1841: currency_code_a.delete; -- Bug 6468271
1842:
1843: hr_utility.trace(' Finally Updating psp_payroll_controls');
1844:
1845: FORALL k in 1 .. l_total_num_rec
1846: UPDATE psp_payroll_controls
1847: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1842:
1843: hr_utility.trace(' Finally Updating psp_payroll_controls');
1844:
1845: FORALL k in 1 .. l_total_num_rec
1846: UPDATE psp_payroll_controls
1847: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1848: number_of_dr = r_payroll_Control_array.r_tot_dr(k),
1849: total_dr_amount = r_payroll_control_array.r_dr_amount(k),
1850: total_cr_amount =r_payroll_control_array.r_cr_amount(k)
1853: --end if;
1854:
1855:
1856: FORALL k in 1 .. l_total_num_rec
1857: update psp_payroll_controls
1858: set sublines_dr_amount = ( select sum(pay_amount)
1859: from psp_payroll_sub_lines
1860: where payroll_line_id in (
1861: select payroll_line_id
8857: /*Bug 6886237*/
8858: SELECT end_date
8859: INTO l_tp_end_date
8860: FROM per_time_periods
8861: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8862: where payroll_control_id = (select payroll_control_id from
8863: psp_payroll_lines
8864: where payroll_line_id = x_payroll_line_id));
8865: