eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_UTILS dependencies on PER_JOBS

Line 1068: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,

1064: END delete_grant;
1065:
1066:
1067:
1068: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1069: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1070: RETURN per_valid_grades.grade_id%type
1071:
1072: IS

Line 1069: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)

1065:
1066:
1067:
1068: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1069: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1070: RETURN per_valid_grades.grade_id%type
1071:
1072: IS
1073:

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

1167: If the job_group_ids are same, it returns the same job id
1168: as what is passed in (does not looking into the mapping table
1169: since there will be no mapping)
1170: -------------------------------------------------------------------- */
1171: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1172: P_From_JobId IN per_jobs.job_id%TYPE,
1173: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1174: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1175: IS

Line 1172: P_From_JobId IN per_jobs.job_id%TYPE,

1168: as what is passed in (does not looking into the mapping table
1169: since there will be no mapping)
1170: -------------------------------------------------------------------- */
1171: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1172: P_From_JobId IN per_jobs.job_id%TYPE,
1173: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1174: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1175: IS
1176:

Line 1173: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

1169: since there will be no mapping)
1170: -------------------------------------------------------------------- */
1171: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1172: P_From_JobId IN per_jobs.job_id%TYPE,
1173: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1174: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1175: IS
1176:
1177: BEGIN

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

1170: -------------------------------------------------------------------- */
1171: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1172: P_From_JobId IN per_jobs.job_id%TYPE,
1173: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1174: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1175: IS
1176:
1177: BEGIN
1178:

Line 1203: of the passed in job_id (from the per_jobs_table)

1199: /* --------------------------------------------------------------------
1200: Procedure: GetToJobName
1201: PURPOSE: This procedure returns the job name from the job mapping table.
1202: If the job_group_ids are same, it returns the job name
1203: of the passed in job_id (from the per_jobs_table)
1204: -------------------------------------------------------------------- */
1205: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1206: P_From_JobId IN per_jobs.job_id%TYPE,
1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

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

1201: PURPOSE: This procedure returns the job name from the job mapping table.
1202: If the job_group_ids are same, it returns the job name
1203: of the passed in job_id (from the per_jobs_table)
1204: -------------------------------------------------------------------- */
1205: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1206: P_From_JobId IN per_jobs.job_id%TYPE,
1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1208: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1209: IS

Line 1206: P_From_JobId IN per_jobs.job_id%TYPE,

1202: If the job_group_ids are same, it returns the job name
1203: of the passed in job_id (from the per_jobs_table)
1204: -------------------------------------------------------------------- */
1205: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1206: P_From_JobId IN per_jobs.job_id%TYPE,
1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1208: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1209: IS
1210:

Line 1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

1203: of the passed in job_id (from the per_jobs_table)
1204: -------------------------------------------------------------------- */
1205: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1206: P_From_JobId IN per_jobs.job_id%TYPE,
1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1208: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1209: IS
1210:
1211: BEGIN

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

1204: -------------------------------------------------------------------- */
1205: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1206: P_From_JobId IN per_jobs.job_id%TYPE,
1207: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1208: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1209: IS
1210:
1211: BEGIN
1212:

Line 1216: FROM per_jobs

1212:
1213: IF P_From_Forecast_JobGrpId = P_To_Proj_Cost_JobGrpId THEN
1214: SELECT name
1215: INTO X_To_JobName
1216: FROM per_jobs
1217: WHERE job_id = P_From_JobId
1218: AND ROWNUM = 1;
1219: ELSE
1220: select to_job_name