[Home] [Help]
1156:
1157:
1158: -- This Procedure gets list of all the jobs which are afftected due to changes in
1159: -- grade_id in per_valid_grade entity
1160: PROCEDURE per_valid_grades_job_id
1161: (P_job_id IN per_jobs.job_id%type
1162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1163: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1164: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
1208: );
1209: BEGIN
1210:
1211: -- Initialize the Error stack
1212: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');
1213: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1214:
1215: -- if the grade id changes then update all the jobs which are affected and
1216: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table
1250: -- 4537865 : RESET x_msg_count and x_msg_data also
1251: x_msg_count := 1 ;
1252: x_msg_data := SUBSTRB(SQLERRM ,1,240);
1253: -- Set the exception Message and the stack
1254: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_HR_UPDATE_API.per_valid_grades_job_id'
1255: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1257: raise;
1258:
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1257: raise;
1258:
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
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
1285: pvg.grade_id = l_grade_id
1286: AND pjg.master_flag = 'Y'
1286: AND pjg.master_flag = 'Y'
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
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
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
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
1396: ,P_from_job_id_new IN pa_job_relationships.from_job_id%type DEFAULT NULL
2485: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
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: