[Home] [Help]
2: /* $Header: PSPLDPGB.pls 120.8 2007/01/26 16:38:34 spchakra noship $ */
3: --
4:
5: -- Introduced the following for bug fix 2916848
6: g_bg_currency_code psp_payroll_controls.currency_code%TYPE; -- Business Group Currency
7: g_sob_currency_code gl_sets_of_books.currency_code%TYPE; -- SOB Currency (Introduced for bug 3107800)
8: g_currency_code psp_payroll_controls.currency_code%TYPE; -- Batch Currency
9: g_precision NUMBER;
10: g_ext_precision NUMBER;
4:
5: -- Introduced the following for bug fix 2916848
6: g_bg_currency_code psp_payroll_controls.currency_code%TYPE; -- Business Group Currency
7: g_sob_currency_code gl_sets_of_books.currency_code%TYPE; -- SOB Currency (Introduced for bug 3107800)
8: g_currency_code psp_payroll_controls.currency_code%TYPE; -- Batch Currency
9: g_precision NUMBER;
10: g_ext_precision NUMBER;
11: g_pop_exchange_rate_type BOOLEAN DEFAULT TRUE; -- Identifies if Exchange Rate Type has to be populated
12: -- End of bug fix 2916848
166: /* deleted cursors get_count_for_gl_csr, get_count_for_project_csr Bug 2007521 */
167:
168: CURSOR get_batch_name_csr is
169: SELECT count(*)
170: FROM psp_payroll_controls
171: WHERE source_type = 'P' and
172: batch_name = p_batch_name and
173: business_group_id = p_business_group_id and
174: set_of_books_id = p_set_of_books_id;
196: WHERE ptp.time_period_id = p_time_period_id;
197:
198: l_currency_count NUMBER;
199: l_period_end_date DATE;
200: l_exchange_rate_type psp_payroll_controls.exchange_rate_type%TYPE;
201: -- End of bug fix 2916848
202:
203: -- Introdced the following for bug fix 3107800
204: CURSOR sob_currency_cur IS
846: l_ft_payroll_id := g_for_total_rec.payroll_id;
847: end if;
848: if ( nvl(l_ft_source_code,' ') <> nvl(g_for_total_rec.source_code,' ') or
849: nvl(l_ft_time_period_id, 0) <> nvl(g_for_total_rec.time_period_id,0)) then
850: -- Insert a record in psp_payroll_controls
851: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
852: select psp_payroll_controls_s.nextval into l_control_id from dual;
853:
854: -- Introduced for bug fix 2916848
848: if ( nvl(l_ft_source_code,' ') <> nvl(g_for_total_rec.source_code,' ') or
849: nvl(l_ft_time_period_id, 0) <> nvl(g_for_total_rec.time_period_id,0)) then
850: -- Insert a record in psp_payroll_controls
851: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
852: select psp_payroll_controls_s.nextval into l_control_id from dual;
853:
854: -- Introduced for bug fix 2916848
855: OPEN period_end_date_cur(l_ft_time_period_id);
856: FETCH period_end_date_cur INTO l_period_end_date;
865: p_effective_date => l_period_end_date);
866: END IF;
867: -- End of bug fix 2916848
868:
869: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW (
870: X_ROWID => l_rowid,
871: X_PAYROLL_CONTROL_ID => l_control_id,
872: X_PAYROLL_ACTION_ID => 0,
873: X_PAYROLL_SOURCE_CODE => l_ft_Source_Code,
935: end if;
936: END LOOP;
937: -- Insert the last record into payroll_controls
938: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
939: select psp_payroll_controls_s.nextval into l_control_id from dual;
940:
941: -- Introduced for bug fix 2916848
942: OPEN period_end_date_cur(l_ft_time_period_id);
943: FETCH period_end_date_cur INTO l_period_end_date;
952: p_effective_date => l_period_end_date);
953: END IF;
954: -- End of bug fix 2916848
955:
956: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW (
957: X_ROWID => l_rowid,
958: X_PAYROLL_CONTROL_ID => l_control_id,
959: X_PAYROLL_ACTION_ID => 0,
960: X_PAYROLL_SOURCE_CODE => l_ft_Source_Code,
1770:
1771: --For Bug 2616807 : Modifying the Select to check for correct source type 'P' instead of 'N'
1772: CURSOR get_batch_name_csr is
1773: SELECT count(*)
1774: FROM psp_payroll_controls
1775: WHERE source_type = 'P' and
1776: batch_name = x_batch_name;
1777:
1778: l_batch_name_count number;