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 1147: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,

1143: END delete_grant;
1144:
1145:
1146:
1147: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1148: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1149: RETURN per_valid_grades.grade_id%type
1150:
1151: IS

Line 1148: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)

1144:
1145:
1146:
1147: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1148: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1149: RETURN per_valid_grades.grade_id%type
1150:
1151: IS
1152:

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

1246: If the job_group_ids are same, it returns the same job id
1247: as what is passed in (does not looking into the mapping table
1248: since there will be no mapping)
1249: -------------------------------------------------------------------- */
1250: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1251: P_From_JobId IN per_jobs.job_id%TYPE,
1252: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1253: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1254: IS

Line 1251: P_From_JobId IN per_jobs.job_id%TYPE,

1247: as what is passed in (does not looking into the mapping table
1248: since there will be no mapping)
1249: -------------------------------------------------------------------- */
1250: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1251: P_From_JobId IN per_jobs.job_id%TYPE,
1252: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1253: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1254: IS
1255:

Line 1252: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

1248: since there will be no mapping)
1249: -------------------------------------------------------------------- */
1250: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1251: P_From_JobId IN per_jobs.job_id%TYPE,
1252: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1253: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1254: IS
1255:
1256: BEGIN

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

1249: -------------------------------------------------------------------- */
1250: PROCEDURE GetToJobId (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1251: P_From_JobId IN per_jobs.job_id%TYPE,
1252: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1253: X_To_JobId OUT NOCOPY per_jobs.job_id%TYPE ) --File.Sql.39 bug 4440895
1254: IS
1255:
1256: BEGIN
1257:

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

1278: /* --------------------------------------------------------------------
1279: Procedure: GetToJobName
1280: PURPOSE: This procedure returns the job name from the job mapping table.
1281: If the job_group_ids are same, it returns the job name
1282: of the passed in job_id (from the per_jobs_table)
1283: -------------------------------------------------------------------- */
1284: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1285: P_From_JobId IN per_jobs.job_id%TYPE,
1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

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

1280: PURPOSE: This procedure returns the job name from the job mapping table.
1281: If the job_group_ids are same, it returns the job name
1282: of the passed in job_id (from the per_jobs_table)
1283: -------------------------------------------------------------------- */
1284: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1285: P_From_JobId IN per_jobs.job_id%TYPE,
1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1287: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1288: IS

Line 1285: P_From_JobId IN per_jobs.job_id%TYPE,

1281: If the job_group_ids are same, it returns the job name
1282: of the passed in job_id (from the per_jobs_table)
1283: -------------------------------------------------------------------- */
1284: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1285: P_From_JobId IN per_jobs.job_id%TYPE,
1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1287: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1288: IS
1289:

Line 1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,

1282: of the passed in job_id (from the per_jobs_table)
1283: -------------------------------------------------------------------- */
1284: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1285: P_From_JobId IN per_jobs.job_id%TYPE,
1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1287: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1288: IS
1289:
1290: BEGIN

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

1283: -------------------------------------------------------------------- */
1284: PROCEDURE GetToJobName (P_From_Forecast_JobGrpId IN per_jobs.job_group_id%TYPE,
1285: P_From_JobId IN per_jobs.job_id%TYPE,
1286: P_To_Proj_Cost_JobGrpId IN per_jobs.job_group_id%TYPE,
1287: X_To_JobName OUT NOCOPY per_jobs.name%TYPE) --File.Sql.39 bug 4440895
1288: IS
1289:
1290: BEGIN
1291:

Line 1295: FROM per_jobs

1291:
1292: IF P_From_Forecast_JobGrpId = P_To_Proj_Cost_JobGrpId THEN
1293: SELECT name
1294: INTO X_To_JobName
1295: FROM per_jobs
1296: WHERE job_id = P_From_JobId
1297: AND ROWNUM = 1;
1298: ELSE
1299: select to_job_name