APPS.PA_FORECAST_GRC_PVT dependencies on PA_FORECAST_GRC_PVT

Line 1: PACKAGE BODY PA_FORECAST_GRC_PVT AS

1: PACKAGE BODY PA_FORECAST_GRC_PVT AS
2: /* $Header: PARFGRCB.pls 120.2 2005/08/24 04:13:25 avaithia noship $ */
3: --------------------------------------------------------------------------------------
4: -- Description This procedure will calculate the total possible
5: -- working hours of a person between the input start

Line 221: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',

217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: x_msg_count := 1;
220: x_msg_data := SQLERRM;
221: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',
222: p_procedure_name => 'get_resource_capacity');
223: x_resource_capacity := NULL ; -- RESET the other OUT param also 4537865
224: END Get_Resource_Capacity;
225:

Line 415: PA_FORECAST_GRC_PVT.get_resource_capacity(

411: , p_run_end_date);
412:
413: --get the resource capacity
414: --get the resource capacity
415: PA_FORECAST_GRC_PVT.get_resource_capacity(
416: p_org_id => l_exp_orgz_id,
417: p_person_id => l_person_id,
418: p_start_date => start_date_to_be_used,
419: p_end_date => end_date_to_be_used,

Line 476: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success

472:
473: j := j+1;
474: jj := j;
475:
476: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success
477:
478: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity
479:
480: END LOOP; -- PA_PERIODS_CUR loop

Line 478: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity

474: jj := j;
475:
476: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success
477:
478: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity
479:
480: END LOOP; -- PA_PERIODS_CUR loop
481:
482: END IF; -- l_pa_period_flag = 'Y'

Line 509: PA_FORECAST_GRC_PVT.get_resource_capacity(

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(
510: p_org_id => l_exp_orgz_id,
511: p_person_id => l_person_id,
512: p_start_date => start_date_to_be_used,
513: p_end_date => end_date_to_be_used,

Line 570: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success

566:
567: j := j+1;
568: jj := j;
569:
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

Line 572: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity

568: jj := j;
569:
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

Line 604: PA_FORECAST_GRC_PVT.get_resource_capacity(

600: end_date_to_be_used := LEAST(ge_periods_cur_rec.GE_DATE
601: , p_in_res_eff_e_date_tab(i)
602: , p_run_end_date);
603:
604: PA_FORECAST_GRC_PVT.get_resource_capacity(
605: p_org_id => l_exp_orgz_id,
606: p_person_id => l_person_id,
607: p_start_date => start_date_to_be_used,
608: p_end_date => end_date_to_be_used,

Line 665: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success

661:
662: j := j+1;
663: jj := j;
664:
665: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success
666:
667: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity
668:
669: END LOOP; -- GE_PERIODS_CUR loop

Line 667: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity

663: jj := j;
664:
665: END IF; -- PA_FORECAST_GRC_PVT.get_resource_capacity returns success
666:
667: END IF; -- PA_FORECAST_GRC_PVT.checking date effectivity
668:
669: END LOOP; -- GE_PERIODS_CUR loop
670:
671: END IF; -- l_ge_period_flag = 'Y'

Line 698: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',

694:
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := 1;
697: x_msg_data := SQLERRM;
698: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',
699: p_procedure_name => 'Get_Capacity_Vector');
700: RAISE ; -- 4537865 : Based on usage included RAISE
701: END Get_Capacity_Vector;
702:

Line 703: END PA_FORECAST_GRC_PVT;

699: p_procedure_name => 'Get_Capacity_Vector');
700: RAISE ; -- 4537865 : Based on usage included RAISE
701: END Get_Capacity_Vector;
702:
703: END PA_FORECAST_GRC_PVT;