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_GRADES

Line 1263: -- sequence(job level) in per grades entity

1259:
1260: END per_valid_grades_job_id;
1261:
1262: -- This Procedure gets list of all the jobs which are afftected due to changes in
1263: -- sequence(job level) in per grades entity
1264: PROCEDURE per_grades_job_id
1265: (P_grade_id IN per_grades.grade_id%type
1266: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1267: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1264: PROCEDURE per_grades_job_id

1260: END per_valid_grades_job_id;
1261:
1262: -- This Procedure gets list of all the jobs which are afftected due to changes in
1263: -- sequence(job level) in per grades entity
1264: PROCEDURE per_grades_job_id
1265: (P_grade_id IN per_grades.grade_id%type
1266: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1267: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1268: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1265: (P_grade_id IN per_grades.grade_id%type

1261:
1262: -- This Procedure gets list of all the jobs which are afftected due to changes in
1263: -- sequence(job level) in per grades entity
1264: PROCEDURE per_grades_job_id
1265: (P_grade_id IN per_grades.grade_id%type
1266: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1267: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1268: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1269: ) IS

Line 1280: CURSOR get_job_ids(l_grade_id per_grades.grade_id%type) is

1276: v_job_id PER_JOBS.JOB_ID%type;
1277: v_row_num NUMBER := 0;
1278: v_msg_data VARCHAR2(2000);
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

Line 1325: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_grades_job_id');

1321: BEGIN
1322:
1323:
1324: -- Initialize the Error stack
1325: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_grades_job_id');
1326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1327:
1328: -- if the sequence is changes then update all the jobs which are affected due to
1329: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

Line 1365: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_grades_job_id'

1361: -- 4537865 : RESET x_msg_count and x_msg_data also
1362: x_msg_count := 1 ;
1363: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1364: -- Set the exception Message and the stack
1365: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_grades_job_id'
1366: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: raise;
1369:

Line 1372: END per_grades_job_id;

1368: raise;
1369:
1370:
1371:
1372: END per_grades_job_id;
1373:
1374:
1375:
1376: -- This Procedure will get a list of all affected jobs due to change in the job mapping

Line 1389: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL

1385: -- P_from_job_id_old,P_to_job_id_old -- UPDATE
1386: -- P_calling_mode,P_from_job_id_old,P_to_job_id_old,P_from_job_group_id,P_to_job_group_id -- DELETE
1387: PROCEDURE update_job_levels
1388: ( P_calling_mode IN VARCHAR2
1389: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1390: ,P_per_grades_sequence_old IN NUMBER 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

Line 1390: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL

1386: -- P_calling_mode,P_from_job_id_old,P_to_job_id_old,P_from_job_group_id,P_to_job_group_id -- DELETE
1387: PROCEDURE update_job_levels
1388: ( P_calling_mode IN VARCHAR2
1389: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1390: ,P_per_grades_sequence_old IN NUMBER 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

Line 1391: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL

1387: PROCEDURE update_job_levels
1388: ( P_calling_mode IN VARCHAR2
1389: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1390: ,P_per_grades_sequence_old IN NUMBER 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

Line 1393: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL

1389: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1390: ,P_per_grades_sequence_old IN NUMBER 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

Line 1394: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL

1390: ,P_per_grades_sequence_old IN NUMBER 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

Line 1408: v_grade_id per_grades.grade_id%type;

1404: )IS
1405:
1406: v_return_status VARCHAR2(2000);
1407: v_error_message_code VARCHAR2(2000);
1408: v_grade_id per_grades.grade_id%type;
1409: v_msg_data VARCHAR2(2000);
1410: v_msg_count NUMBER;
1411:
1412: BEGIN

Line 2490: P_table_name = 'PER_GRADES' or

2486: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2487:
2488: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2489: P_table_name = 'PER_VALID_GRADES' or
2490: P_table_name = 'PER_GRADES' or
2491: P_table_name = 'PA_ALL_ORGANIZATIONS') and
2492: (P_job_id is NOT NULL) then
2493:
2494: -- get all the persons belongs to this job Id and

Line 4349: FROM per_grades

4345:
4346: BEGIN
4347: SELECT name
4348: INTO l_grade_name
4349: FROM per_grades
4350: WHERE grade_id = P_grade_id;
4351:
4352: RETURN (l_grade_name) ;
4353: EXCEPTION