45: PROCEDURE Get_Resource_Asgn_Schedules (
46: p_resource_id IN NUMBER,
47: p_start_date IN DATE,
48: p_end_date IN DATE,
49: x_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
50: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
52: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
53:
63: PROCEDURE Get_Assignment_Schedule(p_assignment_id IN NUMBER,
64: p_start_date IN DATE ,
65: p_end_date IN DATE,
66: p_process_mode IN VARCHAR2,
67: X_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
68: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
71:
105:
106: PROCEDURE Get_PA_Period_Name(p_org_id IN NUMBER,
107: p_start_date IN DATE,
108: p_end_date IN DATE,
109: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
110: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
111: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) ; /* 2674619 - Nocopy change */
112:
113:
106: PROCEDURE Get_PA_Period_Name(p_org_id IN NUMBER,
107: p_start_date IN DATE,
108: p_end_date IN DATE,
109: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
110: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
111: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) ; /* 2674619 - Nocopy change */
112:
113:
114: --
107: p_start_date IN DATE,
108: p_end_date IN DATE,
109: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
110: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
111: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) ; /* 2674619 - Nocopy change */
112:
113:
114: --
115: -- Procedure Get_PA_Period_Name
120:
121: PROCEDURE Get_GL_Period_Name(p_org_id IN NUMBER,
122: p_start_date IN DATE,
123: p_end_date IN DATE,
124: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
125: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
126: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp); /* 2674619 - Nocopy change */
127:
128: --
121: PROCEDURE Get_GL_Period_Name(p_org_id IN NUMBER,
122: p_start_date IN DATE,
123: p_end_date IN DATE,
124: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
125: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
126: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp); /* 2674619 - Nocopy change */
127:
128: --
129: -- Procedure Get_GL_Period_Name
122: p_start_date IN DATE,
123: p_end_date IN DATE,
124: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
125: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
126: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp); /* 2674619 - Nocopy change */
127:
128: --
129: -- Procedure Get_GL_Period_Name
130: -- Purpose To get the GL Period name for OU
134:
135: PROCEDURE Get_Resource_OU(p_resource_id IN NUMBER,
136: p_start_date IN DATE,
137: p_end_date IN DATE,
138: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
139: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
140: x_ResourceOUTab OUT NOcopy PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
141:
142: --
135: PROCEDURE Get_Resource_OU(p_resource_id IN NUMBER,
136: p_start_date IN DATE,
137: p_end_date IN DATE,
138: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
139: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
140: x_ResourceOUTab OUT NOcopy PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
141:
142: --
143: -- Procedure Get_Resource_OU
136: p_start_date IN DATE,
137: p_end_date IN DATE,
138: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
139: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
140: x_ResourceOUTab OUT NOcopy PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
141:
142: --
143: -- Procedure Get_Resource_OU
144: -- Purpose To get the Resource OU for a Period
148:
149: PROCEDURE Get_Res_Org_And_Job(p_person_id IN NUMBER,
150: p_start_date IN DATE,
151: p_end_date IN DATE,
152: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
153: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
154: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
155: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
156:
149: PROCEDURE Get_Res_Org_And_Job(p_person_id IN NUMBER,
150: p_start_date IN DATE,
151: p_end_date IN DATE,
152: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
153: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
154: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
155: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
156:
157: --
150: p_start_date IN DATE,
151: p_end_date IN DATE,
152: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
153: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
154: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
155: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
156:
157: --
158: -- Procedure Get_Res_Org_And_Job
151: p_end_date IN DATE,
152: x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
153: x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
154: x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
155: x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
156:
157: --
158: -- Procedure Get_Res_Org_And_Job
159: -- Purpose To get the Resource Organization for Period
208:
209:
210: PROCEDURE Get_Week_Dates_Range_Fc( p_start_date IN DATE,
211: p_end_date IN DATE,
212: x_week_date_range_tab OUT NOCOPY PA_FORECAST_GLOB.WeekDatesRangeFcTabTyp , /* 2674619 - Nocopy change */
213: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
214: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
215: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
216: