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_HR_UPDATE_API dependencies on PER_JOB_GROUPS

Line 31: ) RETURN per_job_groups.job_group_id%type

27:
28: -- This API returns the job group id for the corresponding Job
29: FUNCTION get_job_group_id(
30: P_job_id IN per_jobs.job_id%type
31: ) RETURN per_job_groups.job_group_id%type
32: IS
33: v_job_grp_id per_job_groups.job_group_id%type;
34:
35: BEGIN

Line 33: v_job_grp_id per_job_groups.job_group_id%type;

29: FUNCTION get_job_group_id(
30: P_job_id IN per_jobs.job_id%type
31: ) RETURN per_job_groups.job_group_id%type
32: IS
33: v_job_grp_id per_job_groups.job_group_id%type;
34:
35: BEGIN
36: v_job_grp_id := PA_JOB_UTILS.get_job_group_id(P_job_id);
37:

Line 73: ,P_job_group_id IN per_job_groups.job_group_id%type

69: -- This Function returns the job level DFF based on the job_id and Job_group_id
70: -- 24-Dec: Move the logic of the code to PA_JOB_UTILS and call the function here
71: FUNCTION get_job_level(
72: P_job_id IN per_jobs.job_id%type
73: ,P_job_group_id IN per_job_groups.job_group_id%type
74: ) RETURN NUMBER
75: IS
76: l_job_level NUMBER;
77:

Line 528: ,per_job_groups pjg

524: l_job_id per_jobs.job_id%type
525: ) is
526: SELECT l_job_id effected_job_id
527: FROM sys.dual
528: ,per_job_groups pjg
529: WHERE pjg.master_flag = 'Y'
530: AND pjg.job_group_id = get_job_group_id(l_job_id)
531: UNION
532: SELECT distinct pjr.from_job_id effected_job_id

Line 534: ,per_job_groups pjg

530: AND pjg.job_group_id = get_job_group_id(l_job_id)
531: UNION
532: SELECT distinct pjr.from_job_id effected_job_id
533: FROM pa_job_relationships pjr
534: ,per_job_groups pjg
535: WHERE pjg.master_flag = 'Y'
536: AND pjr.to_job_id = l_job_id
537: AND pjr.to_job_group_id = pjg.job_group_id
538: UNION

Line 541: ,per_job_groups pjg

537: AND pjr.to_job_group_id = pjg.job_group_id
538: UNION
539: SELECT distinct pjr.to_job_id effected_job_id
540: FROM pa_job_relationships pjr
541: ,per_job_groups pjg
542: WHERE pjg.master_flag = 'Y'
543: AND pjr.from_job_id = l_job_id
544: AND pjr.from_job_group_id = pjg.job_group_id;
545:

Line 924: ,P_job_group_id per_job_groups.job_group_id%type

920: PROCEDURE perform_job_updates
921: ( P_job_id per_jobs.job_id%type
922: ,P_job_level_old pa_resources_denorm.resource_job_level%type
923: ,P_job_level_new pa_resources_denorm.resource_job_level%type
924: ,P_job_group_id per_job_groups.job_group_id%type
925: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
926: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
927: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
928: ) IS

Line 934: l_job_group_id per_job_groups.job_group_id%type;

930: l_job_id PER_JOBS.JOB_ID%type;
931: l_master_job_id PER_JOBS.JOB_ID%type;
932: l_job_level_old pa_resources_denorm.resource_job_level%type;
933: l_job_level_new pa_resources_denorm.resource_job_level%type;
934: l_job_group_id per_job_groups.job_group_id%type;
935: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
936:
937: -- Cursor to get the associated master job id of the PRJG job id
938: CURSOR get_master_job (

Line 940: ,l_job_group_id per_job_groups.job_group_id%type

936:
937: -- Cursor to get the associated master job id of the PRJG job id
938: CURSOR get_master_job (
939: l_job_id per_jobs.job_id%type
940: ,l_job_group_id per_job_groups.job_group_id%type
941: ) IS
942:
943: SELECT distinct pjr.from_job_id effected_job_id
944: FROM pa_job_relationships pjr

Line 1055: l_job_group_id per_job_groups.job_group_id%type;

1051:
1052: l_job_id PER_JOBS.JOB_ID%type;
1053: l_job_level_old pa_resources_denorm.resource_job_level%type;
1054: l_job_level_new pa_resources_denorm.resource_job_level%type;
1055: l_job_group_id per_job_groups.job_group_id%type;
1056: l_isPRJG VARCHAR2(1);
1057: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1058:
1059: BEGIN

Line 1177: ,per_job_groups pjg

1173: l_job_id per_jobs.job_id%type
1174: ) is
1175: SELECT l_job_id effected_job_id
1176: FROM sys.dual
1177: ,per_job_groups pjg
1178: WHERE pjg.master_flag = 'Y'
1179: AND pjg.job_group_id = get_job_group_id(l_job_id)
1180: UNION
1181: SELECT distinct pjr.from_job_id effected_job_id

Line 1183: ,per_job_groups pjg

1179: AND pjg.job_group_id = get_job_group_id(l_job_id)
1180: UNION
1181: SELECT distinct pjr.from_job_id effected_job_id
1182: FROM pa_job_relationships pjr
1183: ,per_job_groups pjg
1184: WHERE pjg.master_flag = 'Y'
1185: AND pjr.to_job_id = l_job_id
1186: AND pjr.to_job_group_id = pjg.job_group_id
1187: UNION

Line 1190: ,per_job_groups pjg

1186: AND pjr.to_job_group_id = pjg.job_group_id
1187: UNION
1188: SELECT distinct pjr.to_job_id effected_job_id
1189: FROM pa_job_relationships pjr
1190: ,per_job_groups pjg
1191: WHERE pjg.master_flag = 'Y'
1192: AND pjr.from_job_id = l_job_id
1193: AND pjr.from_job_group_id = pjg.job_group_id
1194: UNION

Line 1197: ,per_job_groups pjg

1193: AND pjr.from_job_group_id = pjg.job_group_id
1194: UNION
1195: SELECT l_job_id effected_job_id
1196: FROM sys.dual
1197: ,per_job_groups pjg
1198: WHERE pjg.master_flag = 'N'
1199: AND pjg.job_group_id = get_job_group_id(l_job_id)
1200: AND NOT EXISTS (
1201: SELECT 'Y'

Line 1202: FROM per_job_groups

1198: WHERE pjg.master_flag = 'N'
1199: AND pjg.job_group_id = get_job_group_id(l_job_id)
1200: AND NOT EXISTS (
1201: SELECT 'Y'
1202: FROM per_job_groups
1203: WHERE master_flag = 'Y'
1204: AND job_group_id = get_job_group_id(l_job_id)
1205: );
1206: BEGIN

Line 1280: ,per_job_groups pjg

1276: v_msg_count NUMBER;
1277: CURSOR get_job_ids(l_grade_id per_grades.grade_id%type) is
1278: SELECT distinct pvg.job_id
1279: FROM per_valid_grades pvg
1280: ,per_job_groups pjg
1281: WHERE
1282: pvg.grade_id = l_grade_id
1283: AND pjg.master_flag = 'Y'
1284: AND pjg.job_group_id = get_job_group_id(pvg.job_id)

Line 1289: ,per_job_groups pjg

1285: UNION
1286: SELECT distinct pjr.from_job_id
1287: FROM per_valid_grades pvg
1288: ,pa_job_relationships pjr
1289: ,per_job_groups pjg
1290: WHERE pjg.master_flag = 'Y'
1291: AND pjr.to_job_id = pvg.job_id
1292: AND pjr.to_job_group_id = pjg.job_group_id
1293: AND pvg.grade_id = l_grade_id

Line 1298: ,per_job_groups pjg

1294: UNION
1295: SELECT distinct pjr.to_job_id
1296: FROM per_valid_grades pvg
1297: ,pa_job_relationships pjr
1298: ,per_job_groups pjg
1299: WHERE pjg.master_flag = 'Y'
1300: AND pjr.from_job_id = pvg.job_id
1301: AND pjr.from_job_group_id = pjg.job_group_id
1302: AND pvg.grade_id = l_grade_id

Line 1306: ,per_job_groups pjg

1302: AND pvg.grade_id = l_grade_id
1303: UNION
1304: SELECT distinct pvg.job_id
1305: FROM per_valid_grades pvg
1306: ,per_job_groups pjg
1307: WHERE pjg.master_flag = 'N'
1308: AND pjg.job_group_id = get_job_group_id(pvg.job_id)
1309: AND pvg.grade_id = l_grade_id
1310: AND NOT EXISTS (

Line 1312: FROM per_job_groups

1308: AND pjg.job_group_id = get_job_group_id(pvg.job_id)
1309: AND pvg.grade_id = l_grade_id
1310: AND NOT EXISTS (
1311: SELECT 'Y'
1312: FROM per_job_groups
1313: WHERE master_flag = 'Y'
1314: AND job_group_id = get_job_group_id(pvg.job_id)
1315: );
1316:

Line 3662: l_old_job_group_id per_job_groups.job_group_id%type;

3658: l_return_status VARCHAR2(1);
3659: l_resource_id NUMBER;
3660: l_resource_start_date DATE;
3661: l_resource_end_date DATE;
3662: l_old_job_group_id per_job_groups.job_group_id%type;
3663: l_new_job_group_id per_job_groups.job_group_id%type;
3664: l_old_job_level NUMBER;
3665: l_new_job_level NUMBER;
3666: l_old_job_billable pa_resources_denorm.billable_flag%type;

Line 3663: l_new_job_group_id per_job_groups.job_group_id%type;

3659: l_resource_id NUMBER;
3660: l_resource_start_date DATE;
3661: l_resource_end_date DATE;
3662: l_old_job_group_id per_job_groups.job_group_id%type;
3663: l_new_job_group_id per_job_groups.job_group_id%type;
3664: l_old_job_level NUMBER;
3665: l_new_job_level NUMBER;
3666: l_old_job_billable pa_resources_denorm.billable_flag%type;
3667: l_new_job_billable pa_resources_denorm.billable_flag%type;