[Home] [Help]
2: /* $Header: PSPLDPGB.pls 120.9 2010/07/02 07:27:16 amakrish ship $ */
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
849: l_ft_payroll_id := g_for_total_rec.payroll_id;
850: end if;
851: if ( nvl(l_ft_source_code,' ') <> nvl(g_for_total_rec.source_code,' ') or
852: nvl(l_ft_time_period_id, 0) <> nvl(g_for_total_rec.time_period_id,0)) then
853: -- Insert a record in psp_payroll_controls
854: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
855: select psp_payroll_controls_s.nextval into l_control_id from dual;
856:
857: -- Introduced for bug fix 2916848
851: if ( nvl(l_ft_source_code,' ') <> nvl(g_for_total_rec.source_code,' ') or
852: nvl(l_ft_time_period_id, 0) <> nvl(g_for_total_rec.time_period_id,0)) then
853: -- Insert a record in psp_payroll_controls
854: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
855: select psp_payroll_controls_s.nextval into l_control_id from dual;
856:
857: -- Introduced for bug fix 2916848
858: OPEN period_end_date_cur(l_ft_time_period_id);
859: FETCH period_end_date_cur INTO l_period_end_date;
868: p_effective_date => l_period_end_date);
869: END IF;
870: -- End of bug fix 2916848
871:
872: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW (
873: X_ROWID => l_rowid,
874: X_PAYROLL_CONTROL_ID => l_control_id,
875: X_PAYROLL_ACTION_ID => 0,
876: X_PAYROLL_SOURCE_CODE => l_ft_Source_Code,
938: end if;
939: END LOOP;
940: -- Insert the last record into payroll_controls
941: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
942: select psp_payroll_controls_s.nextval into l_control_id from dual;
943:
944: -- Introduced for bug fix 2916848
945: OPEN period_end_date_cur(l_ft_time_period_id);
946: FETCH period_end_date_cur INTO l_period_end_date;
955: p_effective_date => l_period_end_date);
956: END IF;
957: -- End of bug fix 2916848
958:
959: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW (
960: X_ROWID => l_rowid,
961: X_PAYROLL_CONTROL_ID => l_control_id,
962: X_PAYROLL_ACTION_ID => 0,
963: X_PAYROLL_SOURCE_CODE => l_ft_Source_Code,
1773:
1774: --For Bug 2616807 : Modifying the Select to check for correct source type 'P' instead of 'N'
1775: CURSOR get_batch_name_csr is
1776: SELECT count(*)
1777: FROM psp_payroll_controls
1778: WHERE source_type = 'P' and
1779: batch_name = x_batch_name;
1780:
1781: l_batch_name_count number;