APPS.PA_JOB_UTILS dependencies on PER_JOB_GROUPS

Line 166: FROM per_job_groups

162: l_id_found_flag VARCHAR(1) := 'N';
163:
164: CURSOR j_ids IS
165: SELECT job_group_id
166: FROM per_job_groups
167: WHERE displayed_name = p_job_group_name;
168: BEGIN
169:
170: IF p_job_group_id IS NOT NULL AND p_job_group_id<>FND_API.G_MISS_NUM THEN

Line 174: FROM per_job_groups

170: IF p_job_group_id IS NOT NULL AND p_job_group_id<>FND_API.G_MISS_NUM THEN
171: IF p_check_id_flag = 'Y' THEN
172: SELECT job_group_id
173: INTO x_job_group_id
174: FROM per_job_groups
175: WHERE job_group_id = p_job_group_id;
176: ELSIF p_check_id_flag = 'N' THEN
177: x_job_group_id := p_job_group_id;
178: ELSIF (p_check_id_flag = 'A') THEN

Line 213: FROM per_job_groups

209: ELSE
210: IF (p_job_group_name IS NOT NULL) THEN
211: SELECT job_group_id
212: INTO x_job_group_id
213: FROM per_job_groups
214: WHERE displayed_name = p_job_group_name;
215: ELSE
216: x_job_group_id := NULL;
217: END IF;

Line 406: FROM pa_job_relationships, per_job_groups pjg

402: l_prjg_id NUMBER;
403:
404: CURSOR get_master_job_to IS
405: SELECT to_job_id,to_job_group_id
406: FROM pa_job_relationships, per_job_groups pjg
407: WHERE from_job_id = P_job_id
408: AND from_job_group_id = P_job_group_id
409: AND to_job_group_id = pjg.job_group_id
410: AND pjg.master_flag = 'Y';

Line 414: FROM pa_job_relationships, per_job_groups pjg

410: AND pjg.master_flag = 'Y';
411:
412: CURSOR get_master_job_from IS
413: SELECT from_job_id,from_job_group_id
414: FROM pa_job_relationships, per_job_groups pjg
415: WHERE to_job_id = P_job_id
416: AND to_job_group_id = P_job_group_id
417: AND from_job_group_id = pjg.job_group_id
418: AND pjg.master_flag = 'Y';

Line 542: P_job_group_id IN per_job_groups.job_group_id%type)

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;
546: l_job_info_type VARCHAR2(20) := 'Job Category';

Line 605: v_master_flag per_job_groups.master_flag%type;

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);
609:

Line 610: -- Bug 4350734 - Changed to base table from per_job_groups_v

606:
607: BEGIN
608: v_job_group_id := get_job_group_id(P_job_id);
609:
610: -- Bug 4350734 - Changed to base table from per_job_groups_v
611: SELECT master_flag
612: INTO v_master_flag
613: FROM per_job_groups
614: WHERE job_group_id = v_job_group_id;

Line 613: FROM per_job_groups

609:
610: -- Bug 4350734 - Changed to base table from per_job_groups_v
611: SELECT master_flag
612: INTO v_master_flag
613: FROM per_job_groups
614: WHERE job_group_id = v_job_group_id;
615:
616: if v_master_flag = 'Y' then
617: return TRUE;

Line 631: ) RETURN per_job_groups.job_group_id%type

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:
635: BEGIN

Line 633: v_job_grp_id per_job_groups.job_group_id%type;

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:
635: BEGIN
636: -- Bug 4350734 - Removed max sine it is not needed.
637:

Line 662: P_job_group_id IN per_job_groups.job_group_id%type)

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;
666: BEGIN