[Home] [Help]
14: l_org_Id NUMBER := nvl(P_Org_Id, pa_moac_utils.get_current_org_id); -- 12i MOAC changes
15:
16:
17: --Bug 3065754
18: l_imp_period_set_name pa_implementations_all.period_set_name%type;
19:
20: CURSOR NewPeriods
21: IS
22: SELECT
28: pa_periods_copy_v;
29:
30: BEGIN
31:
32: x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';
33: --Bug 3065754
34: SELECT set_of_books_id, period_set_name
35: INTO X_sob_id , l_imp_period_set_name
36: FROM pa_implementations;
32: x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';
33: --Bug 3065754
34: SELECT set_of_books_id, period_set_name
35: INTO X_sob_id , l_imp_period_set_name
36: FROM pa_implementations;
37:
38: X_user_id := fnd_global.user_id;
39: X_login_id := fnd_global.login_id;
40:
141: WHERE PP.PERIOD_NAME = GPS.PERIOD_NAME );
142:
143: BEGIN
144:
145: x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';
146: SELECT set_of_books_id
147: INTO X_sob_id
148: FROM pa_implementations;
149:
144:
145: x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';
146: SELECT set_of_books_id
147: INTO X_sob_id
148: FROM pa_implementations;
149:
150: X_user_id := fnd_global.user_id;
151: X_login_id := fnd_global.login_id;
152:
229:
230: CURSOR period_cur IS
231: SELECT period_name
232: FROM PA_PERIODS_ALL prd,
233: PA_IMPLEMENTATIONS_ALL imp,
234: GL_SETS_OF_BOOKS sob
235: WHERE (period_name = p_period_name
236: OR gl_period_name = p_period_name)
237: AND prd.org_id = imp.org_id /* Removed the NVL check for bug 6811046*/
250:
251: SELECT COUNT(*)
252: into l_rec_count
253: FROM PA_PERIODS_ALL prd,
254: PA_IMPLEMENTATIONS_ALL imp
255: WHERE ( period_name = p_period_name
256: OR gl_period_name =p_period_name)
257: AND prd.org_id = imp.org_id /* Removed the NVL check for bug 6811046*/
258: AND period_set_name = p_period_set_name --added this condition for the bug 4119508