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 1260: -- sequence(job level) in per grades entity

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

Line 1261: PROCEDURE per_grades_job_id

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

Line 1262: (P_grade_id IN per_grades.grade_id%type

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

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

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

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

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

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

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

Line 1369: END per_grades_job_id;

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

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

1382: -- P_from_job_id_old,P_to_job_id_old -- UPDATE
1383: -- P_calling_mode,P_from_job_id_old,P_to_job_id_old,P_from_job_group_id,P_to_job_group_id -- DELETE
1384: PROCEDURE update_job_levels
1385: ( P_calling_mode IN VARCHAR2
1386: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1390: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL

Line 1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL

1383: -- P_calling_mode,P_from_job_id_old,P_to_job_id_old,P_from_job_group_id,P_to_job_group_id -- DELETE
1384: PROCEDURE update_job_levels
1385: ( P_calling_mode IN VARCHAR2
1386: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1390: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1391: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL

Line 1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL

1384: PROCEDURE update_job_levels
1385: ( P_calling_mode IN VARCHAR2
1386: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1390: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1391: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1392: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL

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

1386: ,P_per_grades_grade_id IN per_grades.grade_id%type DEFAULT NULL
1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1390: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1391: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1392: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1393: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1394: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL

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

1387: ,P_per_grades_sequence_old IN NUMBER DEFAULT NULL
1388: ,P_per_grades_sequence_new IN NUMBER DEFAULT NULL
1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL
1390: ,P_per_valid_grade_id_old IN per_grades.grade_id%type DEFAULT NULL
1391: ,P_per_valid_grade_id_new IN per_grades.grade_id%type DEFAULT NULL
1392: ,P_from_job_id_old IN pa_job_relationships.from_job_id%type DEFAULT NULL
1393: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
1394: ,P_to_job_id_old IN pa_job_relationships.to_job_id%type DEFAULT NULL
1395: ,P_to_job_id_new IN pa_job_relationships.to_job_id%type DEFAULT NULL

Line 1405: v_grade_id per_grades.grade_id%type;

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

Line 2483: P_table_name = 'PER_GRADES' or

2479: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2480:
2481: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2482: P_table_name = 'PER_VALID_GRADES' or
2483: P_table_name = 'PER_GRADES' or
2484: P_table_name = 'PA_ALL_ORGANIZATIONS') and
2485: (P_job_id is NOT NULL) then
2486:
2487: -- get all the persons belongs to this job Id and

Line 4210: FROM per_grades

4206:
4207: BEGIN
4208: SELECT name
4209: INTO l_grade_name
4210: FROM per_grades
4211: WHERE grade_id = P_grade_id;
4212:
4213: RETURN (l_grade_name) ;
4214: EXCEPTION