[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
430: WHERE business_group_id = l_resp_business_group_id;
431:
432: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;
433: l_legislation_code per_business_groups.legislation_code%TYPE;
434: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
435: l_prev_currency_code psp_payroll_controls.currency_code%TYPE;
436:
437: TYPE v_num_array IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
438: TYPE v_currency_code IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
431:
432: --l_proration_option pqp_configuration_values.pcv_information1%TYPE;
433: l_legislation_code per_business_groups.legislation_code%TYPE;
434: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
435: l_prev_currency_code psp_payroll_controls.currency_code%TYPE;
436:
437: TYPE v_num_array IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
438: TYPE v_currency_code IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
439: TYPE v_amount_array is table of NUMBER(15,5) INDEX by BINARY_INTEGER;
478: from (select count(distinct ppl.assignment_id) cnt_asg,
479: ppl.payroll_action_type,
480: ppc.time_period_id,
481: ppc.parent_payroll_control_id
482: from psp_payroll_controls ppc,
483: psp_payroll_lines ppl
484: where ppc.run_id = l_run_id
485: and ppc.payroll_control_id = ppl.payroll_control_id
486: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
1260:
1261: l_counter := l_counter + 1;
1262:
1263: ---hr_utility.trace(' No data found in payroll_lines ');
1264: -- If first record insert a record in psp_payroll_controls
1265:
1266:
1267: hr_utility.trace(' l_counter = '||l_counter);
1268: IF l_counter > 0 then
1311:
1312: IF (l_export_id IS NULL) THEN
1313: -- End of bug fix 2916848
1314:
1315: SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
1316: FROM DUAL;
1317:
1318: l_total_num_rec:= l_total_num_rec + 1;
1319: l_cur_rec:= l_total_num_rec;
1336:
1337: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1338:
1339:
1340: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW(
1341: X_ROWID => x_rowid,
1342: X_PAYROLL_CONTROL_ID => l_export_id,
1343: X_PAYROLL_ACTION_ID => g_payroll_asg_rec.payroll_action_id,
1344: X_PAYROLL_SOURCE_CODE => l_payroll_source,
1376: time_period_id_a(l_array_count) := g_pay_costs_rec.time_period_id;
1377: payroll_control_id_a(l_array_count ) := l_export_id;
1378: currency_code_a(l_array_count) := g_pay_costs_rec.output_currency_code; -- Bug 6468271
1379:
1380: update psp_payroll_controls
1381: set run_id = l_run_id
1382: where payroll_control_id = l_export_id;
1383: end if;
1384: END IF; -- Introduced for bug fix 2916848
1494: X_OR_AWARD_ID => l_or_award_id,
1495: X_OR_EXPENDITURE_ORG_ID => l_or_expenditure_org_id,
1496: X_OR_EXPENDITURE_TYPE => l_or_expenditure_type);
1497:
1498: -- The following code is required as psp_payroll_controls will be updated with the total debit and credit amount
1499: hr_utility.trace('-pass 30');
1500:
1501: IF g_pay_costs_rec.debit_or_credit = 'D' then
1502: r_payroll_control_array.r_tot_dr(l_cur_rec)
1913: payroll_control_id_a.delete;
1914: time_period_id_a.delete;
1915: currency_code_a.delete; -- Bug 6468271
1916:
1917: hr_utility.trace(' Finally Updating psp_payroll_controls');
1918:
1919: FORALL k in 1 .. l_total_num_rec
1920: UPDATE psp_payroll_controls
1921: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1916:
1917: hr_utility.trace(' Finally Updating psp_payroll_controls');
1918:
1919: FORALL k in 1 .. l_total_num_rec
1920: UPDATE psp_payroll_controls
1921: set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
1922: number_of_dr = r_payroll_Control_array.r_tot_dr(k),
1923: total_dr_amount = r_payroll_control_array.r_dr_amount(k),
1924: total_cr_amount =r_payroll_control_array.r_cr_amount(k)
1927: --end if;
1928:
1929:
1930: FORALL k in 1 .. l_total_num_rec
1931: update psp_payroll_controls
1932: set sublines_dr_amount = ( select sum(pay_amount)
1933: from psp_payroll_sub_lines
1934: where payroll_line_id in (
1935: select payroll_line_id
8931: /*Bug 6886237*/
8932: SELECT end_date
8933: INTO l_tp_end_date
8934: FROM per_time_periods
8935: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8936: where payroll_control_id = (select payroll_control_id from
8937: psp_payroll_lines
8938: where payroll_line_id = x_payroll_line_id));
8939: