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_ITEMS_UTILS dependencies on PA_FORECAST_GLOB

Line 185: x_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */

181: PROCEDURE Get_Resource_Asgn_Schedules (
182: p_resource_id IN NUMBER,
183: p_start_date IN DATE,
184: p_end_date IN DATE,
185: x_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
186: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
187: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
188: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
189: IS

Line 291: X_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */

287: PROCEDURE Get_Assignment_Schedule(p_assignment_id IN NUMBER,
288: p_start_date IN DATE ,
289: p_end_date IN DATE,
290: p_process_mode IN VARCHAR2,
291: X_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
292: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
293: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
294: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
295:

Line 551: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

547: ---------------------------------------------------------------------------------------------------------------
548: PROCEDURE Get_PA_Period_Name(p_org_id IN NUMBER,
549: p_start_date IN DATE,
550: p_end_date IN DATE,
551: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
552: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
553: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
554: IS
555:

Line 552: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

548: PROCEDURE Get_PA_Period_Name(p_org_id IN NUMBER,
549: p_start_date IN DATE,
550: p_end_date IN DATE,
551: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
552: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
553: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
554: IS
555:
556: BEGIN

Line 553: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */

549: p_start_date IN DATE,
550: p_end_date IN DATE,
551: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
552: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
553: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
554: IS
555:
556: BEGIN
557:

Line 702: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

698: ------------------------------------------------------------------------------------------------------------
699: PROCEDURE Get_GL_Period_Name(p_org_id IN NUMBER,
700: p_start_date IN DATE,
701: p_end_date IN DATE,
702: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
703: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
704: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
705: IS
706:

Line 703: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

699: PROCEDURE Get_GL_Period_Name(p_org_id IN NUMBER,
700: p_start_date IN DATE,
701: p_end_date IN DATE,
702: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
703: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
704: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
705: IS
706:
707: BEGIN

Line 704: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */

700: p_start_date IN DATE,
701: p_end_date IN DATE,
702: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
703: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
704: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
705: IS
706:
707: BEGIN
708: PA_FORECASTITEM_PVT.print_message('Inside Get_GL_Period_Name');

Line 813: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

809: ----------------------------------------------------------------------------------------------------------
810: PROCEDURE Get_Resource_OU(p_resource_id IN NUMBER,
811: p_start_date IN DATE,
812: p_end_date IN DATE,
813: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
814: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
815: x_ResourceOUTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
816: IS
817:

Line 814: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

810: PROCEDURE Get_Resource_OU(p_resource_id IN NUMBER,
811: p_start_date IN DATE,
812: p_end_date IN DATE,
813: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
814: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
815: x_ResourceOUTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
816: IS
817:
818: ld_start_date DATE;

Line 815: x_ResourceOUTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */

811: p_start_date IN DATE,
812: p_end_date IN DATE,
813: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
814: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
815: x_ResourceOUTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
816: IS
817:
818: ld_start_date DATE;
819: ld_end_date DATE;

Line 833: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;

829:
830: g_TimelineProfileSetup PA_TIMELINE_GLOB.TimelineProfileSetup;
831: AVAILABILITY_DURATION NUMBER;
832:
833: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
834: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
835: l_new_ResourceOUTab PA_FORECAST_GLOB.NumberTabTyp;
836: li_new_index NUMBER;
837: ld_prev_end_date DATE;

Line 834: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;

830: g_TimelineProfileSetup PA_TIMELINE_GLOB.TimelineProfileSetup;
831: AVAILABILITY_DURATION NUMBER;
832:
833: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
834: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
835: l_new_ResourceOUTab PA_FORECAST_GLOB.NumberTabTyp;
836: li_new_index NUMBER;
837: ld_prev_end_date DATE;
838: l_msg_index_out NUMBER;

Line 835: l_new_ResourceOUTab PA_FORECAST_GLOB.NumberTabTyp;

831: AVAILABILITY_DURATION NUMBER;
832:
833: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
834: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
835: l_new_ResourceOUTab PA_FORECAST_GLOB.NumberTabTyp;
836: li_new_index NUMBER;
837: ld_prev_end_date DATE;
838: l_msg_index_out NUMBER;
839:

Line 980: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */

976: ---------------------------------------------------------------------------------------------------------------
977: PROCEDURE Get_Res_Org_And_Job(p_person_id IN NUMBER,
978: p_start_date IN DATE,
979: p_end_date IN DATE,
980: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
981: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp,/* 2674619 - Nocopy change */
982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS

Line 981: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp,/* 2674619 - Nocopy change */

977: PROCEDURE Get_Res_Org_And_Job(p_person_id IN NUMBER,
978: p_start_date IN DATE,
979: p_end_date IN DATE,
980: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
981: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp,/* 2674619 - Nocopy change */
982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS
985:

Line 982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */

978: p_start_date IN DATE,
979: p_end_date IN DATE,
980: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
981: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp,/* 2674619 - Nocopy change */
982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS
985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;

Line 983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */

979: p_end_date IN DATE,
980: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
981: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp,/* 2674619 - Nocopy change */
982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS
985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;
987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;

Line 986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;

982: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS
985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;
987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
988: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
989: l_new_ResourceJobIDTab PA_FORECAST_GLOB.NumberTabTyp;
990: li_new_index NUMBER;

Line 987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;

983: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp) /* 2674619 - Nocopy change */
984: IS
985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;
987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
988: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
989: l_new_ResourceJobIDTab PA_FORECAST_GLOB.NumberTabTyp;
990: li_new_index NUMBER;
991: ld_prev_end_date DATE;

Line 988: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;

984: IS
985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;
987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
988: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
989: l_new_ResourceJobIDTab PA_FORECAST_GLOB.NumberTabTyp;
990: li_new_index NUMBER;
991: ld_prev_end_date DATE;
992:

Line 989: l_new_ResourceJobIDTab PA_FORECAST_GLOB.NumberTabTyp;

985:
986: l_new_ResOrganizationIDTab PA_FORECAST_GLOB.NumberTabTyp;
987: l_new_StartDateTab PA_FORECAST_GLOB.DateTabTyp;
988: l_new_EndDateTab PA_FORECAST_GLOB.DateTabTyp;
989: l_new_ResourceJobIDTab PA_FORECAST_GLOB.NumberTabTyp;
990: li_new_index NUMBER;
991: ld_prev_end_date DATE;
992:
993: ld_start_date DATE;

Line 1343: x_week_date_range_tab OUT NOCOPY PA_FORECAST_GLOB.WeekDatesRangeFcTabTyp , /* 2674619 - Nocopy change */

1339: -- X_Week_Date_Range_Tab WEEKDATESRANGEFCTABTYP YES Used to store week start and end date
1340: -----------------------------------------------------------------------------------------------------------------------
1341: PROCEDURE Get_Week_Dates_Range_Fc( p_start_date IN DATE,
1342: p_end_date IN DATE,
1343: x_week_date_range_tab OUT NOCOPY PA_FORECAST_GLOB.WeekDatesRangeFcTabTyp , /* 2674619 - Nocopy change */
1344: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1345: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1346: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1347: