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