DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_FORECAST_GLOB

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

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:

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

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:

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

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:

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

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: --

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

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

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

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: --

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

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

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

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

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

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: --

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

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

Line 140: x_ResourceOUTab OUT NOcopy PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */

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

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

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:

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

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: --

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

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

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

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

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

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: