[Home] [Help]
49: IF p_job_id IS NOT NULL AND p_job_id<>FND_API.G_MISS_NUM THEN
50: IF p_check_id_flag = 'Y' THEN
51: SELECT job_id
52: INTO x_job_id
53: FROM per_jobs
54: WHERE job_id = p_job_id
55: AND job_group_id = nvl(p_job_group_id, job_group_id) -- 5130421
56: ;
57: ELSE
59: END IF;
60: ELSE
61: SELECT job_id
62: INTO x_job_id
63: FROM per_jobs
64: WHERE name = p_job_name
65: AND job_group_id = nvl(p_job_group_id, job_group_id) -- 5130421
66: ;
67: END IF;
243: -- job_group_id
244: --
245: --
246: PROCEDURE validate_job_relationship
247: ( p_job_id IN per_jobs.job_id%type
248: ,p_job_group_id IN per_jobs.job_group_id%type
249: ,x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
250: ,x_error_message_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
251: ) IS
244: --
245: --
246: PROCEDURE validate_job_relationship
247: ( p_job_id IN per_jobs.job_id%type
248: ,p_job_group_id IN per_jobs.job_group_id%type
249: ,x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
250: ,x_error_message_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
251: ) IS
252:
252:
253: v_return_status VARCHAR2(2000);
254: v_error_message_code VARCHAR2(2000):='PA_INVALID_JOB_RELATION';
255: --'This Job Not Belongs to Valid Job Group';
256: v_job_group_id per_jobs.job_group_id%type ;
257:
258:
259: BEGIN
260: -- Initialize the Error stack
261: PA_DEBUG.init_err_stack('PA_JOB_UTILS.validate_job_relationship');
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263: SELECT job_group_id
264: INTO v_job_group_id
265: FROM per_jobs
266: WHERE job_id = p_job_id
267: AND job_group_id = p_job_group_id;
268:
269: If v_job_group_id is NOT NULL then
328: log_message('Get business group id using job id');
329: -- Get the business group of the job id
330: SELECT BUSINESS_GROUP_ID
331: INTO l_business_group_id
332: FROM PER_JOBS
333: WHERE job_id = p_job_id;
334:
335: END IF;
336:
537: -- If there is mappping, return the job level associated to the job in PRJG.
538: --------------------------------------------------------------------------------
539:
540: FUNCTION get_job_level
541: (P_job_id IN per_jobs.job_id%type,
542: P_job_group_id IN per_job_groups.job_group_id%type)
543: RETURN NUMBER
544: IS
545: l_job_level per_job_extra_info.jei_information4%type;
544: IS
545: l_job_level per_job_extra_info.jei_information4%type;
546: l_job_info_type VARCHAR2(20) := 'Job Category';
547: l_master_job_id pa_job_relationships.to_job_id%type;
548: l_job_id per_jobs.job_id%type;
549: l_job_mapping NUMBER;
550: c_job_group_id NUMBER;
551:
552:
597: END get_job_level;
598:
599: -- This Function returns boolean value of true if a job is master job otherwise
600: -- it returns false -- IN parameter will be job_id
601: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)
602: RETURN boolean
603: IS
604: v_job_group_id per_jobs.job_group_id%type;
605: v_master_flag per_job_groups.master_flag%type;
600: -- it returns false -- IN parameter will be job_id
601: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)
602: RETURN boolean
603: IS
604: v_job_group_id per_jobs.job_group_id%type;
605: v_master_flag per_job_groups.master_flag%type;
606:
607: BEGIN
608: v_job_group_id := get_job_group_id(P_job_id);
626: END check_master_job;
627:
628: -- This API returns the job group id for the corresponding Job
629: FUNCTION get_job_group_id(
630: P_job_id IN per_jobs.job_id%type
631: ) RETURN per_job_groups.job_group_id%type
632: IS
633: v_job_grp_id per_job_groups.job_group_id%type;
634:
636: -- Bug 4350734 - Removed max sine it is not needed.
637:
638: SELECT job_group_id
639: INTO v_job_grp_id
640: FROM per_jobs
641: WHERE job_id = P_job_id;
642:
643: return (v_job_grp_id);
644:
657: -- If there is mappping, return the job level associated to the job in PRJG.
658: --------------------------------------------------------------------------------
659:
660: FUNCTION get_job_name
661: (P_job_id IN per_jobs.job_id%type,
662: P_job_group_id IN per_job_groups.job_group_id%type)
663: RETURN VARCHAR2
664: IS
665: l_mapped_job_id NUMBER;