DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PER_JOBS

Line 172: FUNCTION GetValJobGradeId (P_job_id IN per_jobs.job_id%TYPE,

168: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: );
170:
171:
172: FUNCTION GetValJobGradeId (P_job_id IN per_jobs.job_id%TYPE,
173: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
174: return per_valid_grades.grade_id%type;
175: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
176:

Line 173: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)

169: );
170:
171:
172: FUNCTION GetValJobGradeId (P_job_id IN per_jobs.job_id%TYPE,
173: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
174: return per_valid_grades.grade_id%type;
175: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
176:
177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,

Line 177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,

173: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
174: return per_valid_grades.grade_id%type;
175: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
176:
177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
178: P_From_JobId IN per_jobs.job_id%TYPE,
179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:

Line 178: P_From_JobId IN per_jobs.job_id%TYPE,

174: return per_valid_grades.grade_id%type;
175: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
176:
177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
178: P_From_JobId IN per_jobs.job_id%TYPE,
179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,

Line 179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

175: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
176:
177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
178: P_From_JobId IN per_jobs.job_id%TYPE,
179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,

Line 180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895

176:
177: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
178: P_From_JobId IN per_jobs.job_id%TYPE,
179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,
184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

Line 182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,

178: P_From_JobId IN per_jobs.job_id%TYPE,
179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,
184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
185: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
186:

Line 183: P_From_JobId IN per_jobs.job_id%TYPE,

179: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,
184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
185: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
186:
187:

Line 184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

180: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,
184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
185: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
186:
187:
188:

Line 185: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895

181:
182: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
183: P_From_JobId IN per_jobs.job_id%TYPE,
184: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
185: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
186:
187:
188:
189: