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.

[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PER_VALID_GRADES

Line 1157: PROCEDURE per_valid_grades_job_id

1153:
1154:
1155: -- This Procedure gets list of all the jobs which are afftected due to changes in
1156: -- grade_id in per_valid_grade entity
1157: PROCEDURE per_valid_grades_job_id
1158: (P_job_id IN per_jobs.job_id%type
1159: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1160: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1161: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 1209: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');

1205: );
1206: BEGIN
1207:
1208: -- Initialize the Error stack
1209: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');
1210: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1211:
1212: -- if the grade id changes then update all the jobs which are affected and
1213: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

Line 1251: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_valid_grades_job_id'

1247: -- 4537865 : RESET x_msg_count and x_msg_data also
1248: x_msg_count := 1 ;
1249: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1250: -- Set the exception Message and the stack
1251: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_valid_grades_job_id'
1252: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254: raise;
1255:

Line 1257: END per_valid_grades_job_id;

1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254: raise;
1255:
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

Line 1279: FROM per_valid_grades pvg

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
1282: pvg.grade_id = l_grade_id
1283: AND pjg.master_flag = 'Y'

Line 1287: FROM per_valid_grades pvg

1283: AND pjg.master_flag = 'Y'
1284: AND pjg.job_group_id = get_job_group_id(pvg.job_id)
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

Line 1296: FROM per_valid_grades pvg

1292: AND pjr.to_job_group_id = pjg.job_group_id
1293: AND pvg.grade_id = l_grade_id
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

Line 1305: FROM per_valid_grades pvg

1301: AND pjr.from_job_group_id = pjg.job_group_id
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

Line 1389: ,P_per_valid_grade_job_id IN per_valid_grades.valid_grade_id%type DEFAULT NULL

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
1393: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL

Line 2482: P_table_name = 'PER_VALID_GRADES' or

2478: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
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: