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 531: ,per_job_groups pjg

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

Line 537: ,per_job_groups pjg

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

Line 544: ,per_job_groups pjg

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

Line 927: ,P_job_group_id per_job_groups.job_group_id%type

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

Line 937: l_job_group_id per_job_groups.job_group_id%type;

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

Line 943: ,l_job_group_id per_job_groups.job_group_id%type

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

Line 1058: l_job_group_id per_job_groups.job_group_id%type;

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

Line 1180: ,per_job_groups pjg

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

Line 1186: ,per_job_groups pjg

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

Line 1193: ,per_job_groups pjg

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

Line 1200: ,per_job_groups pjg

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

Line 1205: FROM per_job_groups

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

Line 1283: ,per_job_groups pjg

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

Line 1292: ,per_job_groups pjg

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

Line 1301: ,per_job_groups pjg

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

Line 1309: ,per_job_groups pjg

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

Line 1315: FROM per_job_groups

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

Line 3783: l_old_job_group_id per_job_groups.job_group_id%type;

3779: l_return_status VARCHAR2(1);
3780: l_resource_id NUMBER;
3781: l_resource_start_date DATE;
3782: l_resource_end_date DATE;
3783: l_old_job_group_id per_job_groups.job_group_id%type;
3784: l_new_job_group_id per_job_groups.job_group_id%type;
3785: l_old_job_level NUMBER;
3786: l_new_job_level NUMBER;
3787: l_old_job_billable pa_resources_denorm.billable_flag%type;

Line 3784: l_new_job_group_id per_job_groups.job_group_id%type;

3780: l_resource_id NUMBER;
3781: l_resource_start_date DATE;
3782: l_resource_end_date DATE;
3783: l_old_job_group_id per_job_groups.job_group_id%type;
3784: l_new_job_group_id per_job_groups.job_group_id%type;
3785: l_old_job_level NUMBER;
3786: l_new_job_level NUMBER;
3787: l_old_job_billable pa_resources_denorm.billable_flag%type;
3788: l_new_job_billable pa_resources_denorm.billable_flag%type;