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_JOB_UTILS dependencies on PA_JOB_RELATIONSHIPS

Line 242: -- the pa_job_relationships entity.the IN parameters will be job_id and

238: --
239: -- Procedure
240: -- created by Ranga Iyengar : 05-DEC-2000
241: -- This Api validates the given job_id and job_group_id is a part of
242: -- the pa_job_relationships entity.the IN parameters will be job_id and
243: -- job_group_id
244: --
245: --
246: PROCEDURE validate_job_relationship

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 422: FROM pa_job_relationships

418: AND pjg.master_flag = 'Y';
419:
420: CURSOR get_prjg_job_to IS
421: SELECT to_job_id
422: FROM pa_job_relationships
423: WHERE from_job_id = l_master_job_id
424: AND from_job_group_id = l_master_job_group_id
425: AND to_job_group_id = l_prjg_id;
426:

Line 429: FROM pa_job_relationships

425: AND to_job_group_id = l_prjg_id;
426:
427: CURSOR get_prjg_job_from IS
428: SELECT from_job_id
429: FROM pa_job_relationships
430: WHERE to_job_id = l_master_job_id
431: AND to_job_group_id = l_master_job_group_id
432: AND from_job_group_id = l_prjg_id;
433: BEGIN

Line 547: l_master_job_id pa_job_relationships.to_job_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';
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:

Line 706: l_job_relationship PA_JOB_RELATIONSHIPS%ROWTYPE;

702: -----------------------------------------------------------------------------
703:
704: PROCEDURE check_job_relationships (p_job_id IN number)
705: IS
706: l_job_relationship PA_JOB_RELATIONSHIPS%ROWTYPE;
707: Cursor C1 IS Select * from PA_JOB_RELATIONSHIPS where
708: FROM_JOB_ID = p_job_id OR TO_JOB_ID = p_job_id;
709: begin
710:

Line 707: Cursor C1 IS Select * from PA_JOB_RELATIONSHIPS where

703:
704: PROCEDURE check_job_relationships (p_job_id IN number)
705: IS
706: l_job_relationship PA_JOB_RELATIONSHIPS%ROWTYPE;
707: Cursor C1 IS Select * from PA_JOB_RELATIONSHIPS where
708: FROM_JOB_ID = p_job_id OR TO_JOB_ID = p_job_id;
709: begin
710:
711: Open C1;