eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FORECAST_GRC_PVT dependencies on GL_PERIODS

Line 290: FROM gl_periods pglp

286: ,pglp.end_date AS PERIOD_END_DATE
287: ,pglp.period_year AS PERIOD_YEAR
288: ,pglp.quarter_num AS PERIOD_QUARTER
289: ,(pglp.period_year*10000) + pglp.period_num AS PERIOD_NUM
290: FROM gl_periods pglp
291: WHERE exists
292: (select null
293: from gl_date_period_map p
294: where pglp.period_set_name = p.period_set_name

Line 304: CURSOR GL_PERIODS_CUR is

300: AND p_run_start_date <= pglp.end_date
301: ;
302:
303: -- Cursor to find the periods within GL
304: CURSOR GL_PERIODS_CUR is
305: SELECT
306: gglp.period_name AS PERIOD_NAME
307: ,gglp.start_date AS PERIOD_START_DATE
308: ,gglp.end_date AS PERIOD_END_DATE

Line 312: FROM gl_periods gglp

308: ,gglp.end_date AS PERIOD_END_DATE
309: ,gglp.period_year AS PERIOD_YEAR
310: ,gglp.quarter_num AS PERIOD_QUARTER
311: ,(gglp.period_year*10000) + gglp.period_num AS PERIOD_NUM
312: FROM gl_periods gglp
313: WHERE exists
314: (select null
315: from gl_date_period_map g
316: where gglp.period_set_name = g.period_set_name

Line 339: gl_periods_cur_rec GL_PERIODS_CUR%ROWTYPE;

335: AND to_number(to_char(ge_week_dt,'YYYY')) = period_year
336: ;
337:
338: pa_periods_cur_rec PA_PERIODS_CUR%ROWTYPE;
339: gl_periods_cur_rec GL_PERIODS_CUR%ROWTYPE;
340: ge_periods_cur_rec GE_PERIODS_CUR%ROWTYPE;
341:
342: start_date_to_be_used DATE;
343: end_date_to_be_used DATE;

Line 488: FOR gl_periods_cur_rec in GL_PERIODS_CUR LOOP

484: j := jj;
485:
486: -- IF and loop for GL
487: IF l_gl_period_flag = 'Y' then
488: FOR gl_periods_cur_rec in GL_PERIODS_CUR LOOP
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490: IF (
491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )

Line 491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE

487: IF l_gl_period_flag = 'Y' then
488: FOR gl_periods_cur_rec in GL_PERIODS_CUR LOOP
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490: IF (
491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
493: OR
494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )

Line 492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )

488: FOR gl_periods_cur_rec in GL_PERIODS_CUR LOOP
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490: IF (
491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
493: OR
494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
496: OR

Line 494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE

490: IF (
491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
493: OR
494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
496: OR
497: ( gl_periods_cur_rec.PERIOD_START_DATE >= p_in_res_eff_s_date_tab(i)
498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )

Line 495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )

491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
493: OR
494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
496: OR
497: ( gl_periods_cur_rec.PERIOD_START_DATE >= p_in_res_eff_s_date_tab(i)
498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )
499: ) THEN

Line 497: ( gl_periods_cur_rec.PERIOD_START_DATE >= p_in_res_eff_s_date_tab(i)

493: OR
494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
496: OR
497: ( gl_periods_cur_rec.PERIOD_START_DATE >= p_in_res_eff_s_date_tab(i)
498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )
499: ) THEN
500:
501:

Line 498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )

494: ( p_in_res_eff_e_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
495: and p_in_res_eff_e_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
496: OR
497: ( gl_periods_cur_rec.PERIOD_START_DATE >= p_in_res_eff_s_date_tab(i)
498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )
499: ) THEN
500:
501:
502: start_date_to_be_used := GREATEST(gl_periods_cur_rec.PERIOD_START_DATE

Line 502: start_date_to_be_used := GREATEST(gl_periods_cur_rec.PERIOD_START_DATE

498: and gl_periods_cur_rec.PERIOD_START_DATE <= p_in_res_eff_e_date_tab(i) )
499: ) THEN
500:
501:
502: start_date_to_be_used := GREATEST(gl_periods_cur_rec.PERIOD_START_DATE
503: , p_in_res_eff_s_date_tab(i)
504: , p_run_start_date);
505: end_date_to_be_used := LEAST(gl_periods_cur_rec.PERIOD_END_DATE
506: , p_in_res_eff_e_date_tab(i)

Line 505: end_date_to_be_used := LEAST(gl_periods_cur_rec.PERIOD_END_DATE

501:
502: start_date_to_be_used := GREATEST(gl_periods_cur_rec.PERIOD_START_DATE
503: , p_in_res_eff_s_date_tab(i)
504: , p_run_start_date);
505: end_date_to_be_used := LEAST(gl_periods_cur_rec.PERIOD_END_DATE
506: , p_in_res_eff_e_date_tab(i)
507: , p_run_end_date);
508:
509: PA_FORECAST_GRC_PVT.get_resource_capacity(

Line 533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME

529: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
530: and bal.period_type = l_gl_period_type
531: -- and bal.period_set_name = l_period_set_name
532: and bal.period_set_name = l_gl_period_set_name -- bug 3434019
533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME
534: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
535: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
536: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
537: and obj.balance_type_code = l_balance_type_code

Line 561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;

557: x_resource_capacity_tab(j) := l_resource_capacity - l_period_balance;
558: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
559: x_person_id_tab(j) := l_person_id;
560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;
565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;

Line 563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;

559: x_person_id_tab(j) := l_person_id;
560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;
565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;
566:
567: j := j+1;

Line 564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;

560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;
565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;
566:
567: j := j+1;
568: jj := j;

Line 565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;

561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;
565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;
566:
567: j := j+1;
568: jj := j;
569:

Line 574: END LOOP; -- GL_PERIODS_CUR loop

570: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success
571:
572: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity
573:
574: END LOOP; -- GL_PERIODS_CUR loop
575:
576: END IF; -- l_gl_period_flag = 'Y
577:
578: j := jj;