DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PER_JOBS

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

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:

Line 154: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)

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,

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

Line 159: P_From_JobId IN per_jobs.job_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:
163: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,

Line 160: P_To_Proj_Cost_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,

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

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,

Line 163: PROCEDURE GetToJobName (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,
166: X_To_JobName OUT NOCOPY per_jobs.name%TYPE); --File.Sql.39 bug 4440895
167:

Line 164: 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:
168:

Line 165: 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:
169:

Line 166: X_To_JobName OUT NOCOPY per_jobs.name%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:
170: