149: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150: );
151:
152:
153: FUNCTION GetValJobGradeId (P_job_id IN per_jobs.job_id%TYPE,
154: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
155: return per_valid_grades.grade_id%type;
156: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
157:
150: );
151:
152:
153: FUNCTION GetValJobGradeId (P_job_id IN per_jobs.job_id%TYPE,
154: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
155: return per_valid_grades.grade_id%type;
156: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
157:
158: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
154: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
155: return per_valid_grades.grade_id%type;
156: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
157:
158: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
159: P_From_JobId IN per_jobs.job_id%TYPE,
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
155: return per_valid_grades.grade_id%type;
156: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
157:
158: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
159: P_From_JobId IN per_jobs.job_id%TYPE,
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
156: pragma RESTRICT_REFERENCES (GetValJobGradeId, WNDS );
157:
158: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
159: P_From_JobId IN per_jobs.job_id%TYPE,
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
157:
158: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
159: P_From_JobId IN per_jobs.job_id%TYPE,
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
165: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
159: P_From_JobId IN per_jobs.job_id%TYPE,
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
165: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
166: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
167:
160: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
165: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
166: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
167:
168:
161: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE); --File.Sql.39 bug 4440895
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
165: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
166: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
167:
168:
169:
162:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
164: P_From_JobId IN per_jobs.job_id%TYPE,
165: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
166: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
167:
168:
169:
170: