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 PA_JOB_RELATIONSHIPS

Line 536: FROM pa_job_relationships pjr

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

Line 543: FROM pa_job_relationships pjr

539: AND pjr.to_job_id = l_job_id
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;

Line 613: -- changes in job mappings in pa_job_relationships table

609:
610: END update_all_jobs;
611:
612: -- This Procedure updates all resource denorm records affected by the
613: -- changes in job mappings in pa_job_relationships table
614: -- It will update the job levels of the resource denorm records
615: PROCEDURE pa_job_relation_job_id
616: (P_calling_mode IN VARCHAR2
617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type

Line 617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type

613: -- changes in job mappings in pa_job_relationships table
614: -- It will update the job levels of the resource denorm records
615: PROCEDURE pa_job_relation_job_id
616: (P_calling_mode IN VARCHAR2
617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type
618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type

Line 618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type

614: -- It will update the job levels of the resource denorm records
615: PROCEDURE pa_job_relation_job_id
616: (P_calling_mode IN VARCHAR2
617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type
618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type
622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type

Line 619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type

615: PROCEDURE pa_job_relation_job_id
616: (P_calling_mode IN VARCHAR2
617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type
618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type
622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type
623: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type

616: (P_calling_mode IN VARCHAR2
617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type
618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type
622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type
623: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
624: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type

617: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type
618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type
622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type
623: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
624: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
625: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type

618: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type
619: ,P_to_job_id_old IN pa_job_relationships.from_job_id%type
620: ,P_to_job_id_new IN pa_job_relationships.from_job_id%type
621: ,P_from_job_group_id IN pa_job_relationships.from_job_id%type
622: ,P_to_job_group_id IN pa_job_relationships.from_job_id%type
623: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
624: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
625: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
626:

Line 947: FROM pa_job_relationships pjr

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
948: WHERE pjr.to_job_id = l_job_id
949: AND pjr.to_job_group_id = l_job_group_id
950: UNION
951: SELECT distinct pjr.to_job_id effected_job_id

Line 952: FROM pa_job_relationships pjr

948: WHERE pjr.to_job_id = l_job_id
949: AND pjr.to_job_group_id = l_job_group_id
950: UNION
951: SELECT distinct pjr.to_job_id effected_job_id
952: FROM pa_job_relationships pjr
953: WHERE pjr.from_job_id = l_job_id
954: AND pjr.from_job_group_id = l_job_group_id;
955:
956: BEGIN

Line 1185: FROM pa_job_relationships pjr

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

Line 1192: FROM pa_job_relationships pjr

1188: AND pjr.to_job_id = l_job_id
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

Line 1291: ,pa_job_relationships pjr

1287: AND pjg.job_group_id = get_job_group_id(pvg.job_id)
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

Line 1300: ,pa_job_relationships pjr

1296: AND pvg.grade_id = l_grade_id
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

Line 1379: -- Whenever job mapping columns in pa_job_relationships updated,workflow will kickoff

1375:
1376: -- This Procedure will get a list of all affected jobs due to change in the job mapping
1377: -- and then calls to PRM API GET_JOB_LEVEL in a loop which actually
1378: -- updates the levels in the resource denorm table.
1379: -- Whenever job mapping columns in pa_job_relationships updated,workflow will kickoff
1380: -- this api from the database trigger on table pa_job_relationships
1381: -- Pa_Job_Relationships Entity--
1382: -- IN Parameters
1383: -- P_calling_mode,P_from_job_id_new,P_to_job_id_new,P_from_job_group_id,P_to_job_group_id -- INSERT

Line 1380: -- this api from the database trigger on table pa_job_relationships

1376: -- This Procedure will get a list of all affected jobs due to change in the job mapping
1377: -- and then calls to PRM API GET_JOB_LEVEL in a loop which actually
1378: -- updates the levels in the resource denorm table.
1379: -- Whenever job mapping columns in pa_job_relationships updated,workflow will kickoff
1380: -- this api from the database trigger on table pa_job_relationships
1381: -- Pa_Job_Relationships Entity--
1382: -- IN Parameters
1383: -- P_calling_mode,P_from_job_id_new,P_to_job_id_new,P_from_job_group_id,P_to_job_group_id -- INSERT
1384: -- P_calling_mode,P_from_job_id_new,P_to_job_id_new,P_from_job_group_id,P_to_job_group_id,

Line 1381: -- Pa_Job_Relationships Entity--

1377: -- and then calls to PRM API GET_JOB_LEVEL in a loop which actually
1378: -- updates the levels in the resource denorm table.
1379: -- Whenever job mapping columns in pa_job_relationships updated,workflow will kickoff
1380: -- this api from the database trigger on table pa_job_relationships
1381: -- Pa_Job_Relationships Entity--
1382: -- IN Parameters
1383: -- P_calling_mode,P_from_job_id_new,P_to_job_id_new,P_from_job_group_id,P_to_job_group_id -- INSERT
1384: -- P_calling_mode,P_from_job_id_new,P_to_job_id_new,P_from_job_group_id,P_to_job_group_id,
1385: -- P_from_job_id_old,P_to_job_id_old -- UPDATE

Line 1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL

1391: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1392: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1393: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1394: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL

Line 1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL

1392: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1393: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1394: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL

Line 1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL

1393: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1394: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1401: ,x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL

1394: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1401: ,x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1402: ,x_msg_data IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL

1395: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1401: ,x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1402: ,x_msg_data IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1403: ,x_msg_count IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL

1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1397: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1398: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL
1399: ,P_from_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1400: ,P_to_job_group_id IN pa_job_relationships.to_job_id%type DEFAULT NULL
1401: ,x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1402: ,x_msg_data IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1403: ,x_msg_count IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1404: )IS