[Home] [Help]
84: display in the screen */
85:
86: BEGIN
87: /* NPE Changes - The MO: Operating Unit should be checked here .
88: If we can put a join with pa_implementations then
89: in NO_data_found, we can raise message for missing Mo: operating Unit.
90: Since I am not very sure, so keeping the logic to check for Mo operating unit
91: later in the code*/
92:
204: WHEN NO_DATA_FOUND THEN
205:
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
208: select count(*) into org_count from pa_implementations;
209:
210: IF l_default_calendar is null THEN
211: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
212: FROM fnd_profile_options_tl
323:
324: BEGIN
325: /* NPE Changes - The MO: Operating Unit should be checked here .
326: I am not sure that why we are taking _all tables
327: here. If we can put a join with pa_implementations then
328: in NO_data_found, we can raise message for missing Mo: operating Unit.
329: Since we are not sure, so keeping the logic to check for Mo operating unit
330: later in the code*/
331:
435: WHEN NO_DATA_FOUND THEN
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
439: select count(*) into org_count from pa_implementations;
440:
441: IF l_default_calendar is null THEN
442: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
443: FROM fnd_profile_options_tl
825: CURSOR cur_period_set_name
826: IS
827: SELECT sob.period_set_name
828: FROM gl_sets_of_books sob,
829: pa_implementations_all pia
830: WHERE pia.set_of_books_id = sob.set_of_books_id
831: AND ((mo_global.get_current_org_id is NULL AND -- 4874283
832: mo_global.check_access(pia.org_id) = 'Y') -- 4874283
833: OR -- 4874283
1201: SELECT distinct
1202: glper.period_name,
1203: glper.start_date,
1204: glper.end_date
1205: FROM pa_implementations imp,
1206: gl_sets_of_books gl,
1207: gl_periods glper,
1208: gl_period_statuses glpersts,
1209: gl_lookups prsts,