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_HR_UPDATE_API dependencies on PA_JOB_UTILS

Line 36: v_job_grp_id := PA_JOB_UTILS.get_job_group_id(P_job_id);

32: IS
33: v_job_grp_id per_job_groups.job_group_id%type;
34:
35: BEGIN
36: v_job_grp_id := PA_JOB_UTILS.get_job_group_id(P_job_id);
37:
38: return (v_job_grp_id);
39:
40: END get_job_group_id;

Line 70: -- 24-Dec: Move the logic of the code to PA_JOB_UTILS and call the function here

66:
67:
68:
69: -- This Function returns the job level DFF based on the job_id and Job_group_id
70: -- 24-Dec: Move the logic of the code to PA_JOB_UTILS and call the function here
71: FUNCTION get_job_level(
72: P_job_id IN per_jobs.job_id%type
73: ,P_job_group_id IN per_job_groups.job_group_id%type
74: ) RETURN NUMBER

Line 79: l_job_level := PA_JOB_UTILS.get_job_level (

75: IS
76: l_job_level NUMBER;
77:
78: BEGIN
79: l_job_level := PA_JOB_UTILS.get_job_level (
80: P_job_id => P_job_id
81: ,P_job_group_id => P_job_group_id
82: );
83:

Line 113: l_flag := PA_JOB_UTILS.check_master_job(P_job_id);

109: IS
110: l_flag BOOLEAN;
111:
112: BEGIN
113: l_flag := PA_JOB_UTILS.check_master_job(P_job_id);
114: return l_flag;
115:
116: END check_master_job;
117:

Line 660: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'Y' AND

656: -- If it is a PRJG job, we need to check that the to_job_id is a master job
657: -- and update the resource denorm records with the job level of the PRJG job
658: -----------------------------------------------------------------------------
659:
660: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'Y' AND
661: PA_JOB_UTILS.check_master_job(P_to_job_id_new)) then
662:
663: IF P_DEBUG_MODE = 'Y' THEN
664: log_message('From is PRJG, To is Master');

Line 661: PA_JOB_UTILS.check_master_job(P_to_job_id_new)) then

657: -- and update the resource denorm records with the job level of the PRJG job
658: -----------------------------------------------------------------------------
659:
660: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'Y' AND
661: PA_JOB_UTILS.check_master_job(P_to_job_id_new)) then
662:
663: IF P_DEBUG_MODE = 'Y' THEN
664: log_message('From is PRJG, To is Master');
665: END IF;

Line 667: l_job_level_new := PA_JOB_UTILS.get_job_level(P_from_job_id_new,P_from_job_group_id);

663: IF P_DEBUG_MODE = 'Y' THEN
664: log_message('From is PRJG, To is Master');
665: END IF;
666:
667: l_job_level_new := PA_JOB_UTILS.get_job_level(P_from_job_id_new,P_from_job_group_id);
668:
669: l_PRJG_job_id := P_from_job_id_new;
670: l_master_job_id := P_to_job_id_new;
671: l_condition := 'PM';

Line 682: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'Y' AND

678: -- If it is a PRJG job, we need to check that the from_job_id is a master job
679: -- and update the resource denorm records with the job level of the PRJG job
680: -----------------------------------------------------------------------------
681:
682: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'Y' AND
683: PA_JOB_UTILS.check_master_job(P_from_job_id_new)) then
684:
685: IF P_DEBUG_MODE = 'Y' THEN
686: log_message('From is Master, To is PRJG');

Line 683: PA_JOB_UTILS.check_master_job(P_from_job_id_new)) then

679: -- and update the resource denorm records with the job level of the PRJG job
680: -----------------------------------------------------------------------------
681:
682: If (PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'Y' AND
683: PA_JOB_UTILS.check_master_job(P_from_job_id_new)) then
684:
685: IF P_DEBUG_MODE = 'Y' THEN
686: log_message('From is Master, To is PRJG');
687: END IF;

Line 688: l_job_level_new := PA_JOB_UTILS.get_job_level(P_to_job_id_new,P_to_job_group_id);

684:
685: IF P_DEBUG_MODE = 'Y' THEN
686: log_message('From is Master, To is PRJG');
687: END IF;
688: l_job_level_new := PA_JOB_UTILS.get_job_level(P_to_job_id_new,P_to_job_group_id);
689:
690: l_PRJG_job_id := P_to_job_id_new;
691: l_master_job_id := P_from_job_id_new;
692: l_condition := 'PM';

Line 704: If (PA_JOB_UTILS.check_master_job(P_from_job_id_new) AND

700: -- with the job level of the Master, PRJG job id
701: -- Case: from_job_id is Master and to_job_id is Normal job
702: ------------------------------------------------------------------------------
703:
704: If (PA_JOB_UTILS.check_master_job(P_from_job_id_new) AND
705: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'N' AND
706: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_new)) THEN
707:
708: IF P_DEBUG_MODE = 'Y' THEN

Line 705: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'N' AND

701: -- Case: from_job_id is Master and to_job_id is Normal job
702: ------------------------------------------------------------------------------
703:
704: If (PA_JOB_UTILS.check_master_job(P_from_job_id_new) AND
705: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'N' AND
706: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_new)) THEN
707:
708: IF P_DEBUG_MODE = 'Y' THEN
709: log_message('From is Master, To is Normal');

Line 706: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_new)) THEN

702: ------------------------------------------------------------------------------
703:
704: If (PA_JOB_UTILS.check_master_job(P_from_job_id_new) AND
705: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_new, P_to_job_group_id) = 'N' AND
706: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_new)) THEN
707:
708: IF P_DEBUG_MODE = 'Y' THEN
709: log_message('From is Master, To is Normal');
710: END IF;

Line 711: l_job_level_new := PA_JOB_UTILS.get_job_level(P_from_job_id_new, P_from_job_group_id);

707:
708: IF P_DEBUG_MODE = 'Y' THEN
709: log_message('From is Master, To is Normal');
710: END IF;
711: l_job_level_new := PA_JOB_UTILS.get_job_level(P_from_job_id_new, P_from_job_group_id);
712:
713: l_job_id := P_to_job_id_new;
714: l_condition := 'MN';
715:

Line 721: If (PA_JOB_UTILS.check_master_job(P_to_job_id_new) AND

717:
718: ----------------------------------------------------------------------------
719: -- Same as previous, but to_job_id is Master and from_job_id is normal job
720: ----------------------------------------------------------------------------
721: If (PA_JOB_UTILS.check_master_job(P_to_job_id_new) AND
722: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'N' AND
723: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_new)) THEN
724:
725: IF P_DEBUG_MODE = 'Y' THEN

Line 722: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'N' AND

718: ----------------------------------------------------------------------------
719: -- Same as previous, but to_job_id is Master and from_job_id is normal job
720: ----------------------------------------------------------------------------
721: If (PA_JOB_UTILS.check_master_job(P_to_job_id_new) AND
722: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'N' AND
723: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_new)) THEN
724:
725: IF P_DEBUG_MODE = 'Y' THEN
726: log_message('From is Normal, To is Master');

Line 723: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_new)) THEN

719: -- Same as previous, but to_job_id is Master and from_job_id is normal job
720: ----------------------------------------------------------------------------
721: If (PA_JOB_UTILS.check_master_job(P_to_job_id_new) AND
722: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_new, P_from_job_group_id) = 'N' AND
723: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_new)) THEN
724:
725: IF P_DEBUG_MODE = 'Y' THEN
726: log_message('From is Normal, To is Master');
727: END IF;

Line 728: l_job_level_new := PA_JOB_UTILS.get_job_level(P_to_job_id_new, P_to_job_group_id);

724:
725: IF P_DEBUG_MODE = 'Y' THEN
726: log_message('From is Normal, To is Master');
727: END IF;
728: l_job_level_new := PA_JOB_UTILS.get_job_level(P_to_job_id_new, P_to_job_group_id);
729:
730: l_job_id := P_from_job_id_new;
731: l_condition := 'MN';
732:

Line 805: IF ((PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND

801: -- Sets the appropriate value for the job ids and the condition to update the
802: -- resource denorm records
803: ------------------------------------------------------------------------------
804:
805: IF ((PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND
806: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'Y')) THEN
807:
808: IF P_DEBUG_MODE = 'Y' THEN
809: log_message('From is Master, To is PRJG');

Line 806: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'Y')) THEN

802: -- resource denorm records
803: ------------------------------------------------------------------------------
804:
805: IF ((PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND
806: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'Y')) THEN
807:
808: IF P_DEBUG_MODE = 'Y' THEN
809: log_message('From is Master, To is PRJG');
810: END IF;

Line 815: ELSIF ((PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND

811: l_master_job_id := P_from_job_id_old;
812: l_PRJG_job_id := P_to_job_id_old;
813: l_condition := 'PM';
814:
815: ELSIF ((PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND
816: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'Y')) THEN
817:
818: IF P_DEBUG_MODE = 'Y' THEN
819: log_message('From is PRJG, To is Master');

Line 816: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'Y')) THEN

812: l_PRJG_job_id := P_to_job_id_old;
813: l_condition := 'PM';
814:
815: ELSIF ((PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND
816: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'Y')) THEN
817:
818: IF P_DEBUG_MODE = 'Y' THEN
819: log_message('From is PRJG, To is Master');
820: END IF;

Line 825: ELSIF ( PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND

821: l_master_job_id := P_to_job_id_old;
822: l_PRJG_job_id := P_from_job_id_old;
823: l_condition := 'PM';
824:
825: ELSIF ( PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND
826: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'N' AND
827: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_old)) THEN
828:
829: IF P_DEBUG_MODE = 'Y' THEN

Line 826: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'N' AND

822: l_PRJG_job_id := P_from_job_id_old;
823: l_condition := 'PM';
824:
825: ELSIF ( PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND
826: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'N' AND
827: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_old)) THEN
828:
829: IF P_DEBUG_MODE = 'Y' THEN
830: log_message('From is Master, To is Normal');

Line 827: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_old)) THEN

823: l_condition := 'PM';
824:
825: ELSIF ( PA_JOB_UTILS.check_master_job(P_from_job_id_old) AND
826: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_to_job_id_old, P_to_job_group_id) = 'N' AND
827: NOT PA_JOB_UTILS.check_master_job(P_to_job_id_old)) THEN
828:
829: IF P_DEBUG_MODE = 'Y' THEN
830: log_message('From is Master, To is Normal');
831: END IF;

Line 836: ELSIF ( PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND

832: l_master_job_id := P_from_job_id_old;
833: l_job_id := P_to_job_id_old;
834: l_condition := 'MN';
835:
836: ELSIF ( PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND
837: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'N'AND
838: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_old)) THEN
839:
840: IF P_DEBUG_MODE = 'Y' THEN

Line 837: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'N'AND

833: l_job_id := P_to_job_id_old;
834: l_condition := 'MN';
835:
836: ELSIF ( PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND
837: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'N'AND
838: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_old)) THEN
839:
840: IF P_DEBUG_MODE = 'Y' THEN
841: log_message('From is Normal, To is Master');

Line 838: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_old)) THEN

834: l_condition := 'MN';
835:
836: ELSIF ( PA_JOB_UTILS.check_master_job(P_to_job_id_old) AND
837: PA_JOB_UTILS.Is_Proj_Res_Job_Group(P_from_job_id_old, P_from_job_group_id) = 'N'AND
838: NOT PA_JOB_UTILS.check_master_job(P_from_job_id_old)) THEN
839:
840: IF P_DEBUG_MODE = 'Y' THEN
841: log_message('From is Normal, To is Master');
842: END IF;

Line 988: If (PA_JOB_UTILS.check_master_job(l_job_id) = FALSE) Then

984: -- next get the master job id and then updates all jobs
985: -- belonging to that master job id if the job id is NOT
986: -- a master job
987:
988: If (PA_JOB_UTILS.check_master_job(l_job_id) = FALSE) Then
989:
990: OPEN get_master_job(l_job_id, l_job_group_id);
991: LOOP
992: FETCH get_master_job INTO l_master_job_id;

Line 1075: IF PA_JOB_UTILS.Proj_Res_Job_Group_Exists(p_job_id => l_job_id) = 'N' THEN

1071:
1072: -- When Project Resource Job Group does not exist, we just use
1073: -- the job id and job level passed in and update the resource
1074: -- denorm records affected by this change
1075: IF PA_JOB_UTILS.Proj_Res_Job_Group_Exists(p_job_id => l_job_id) = 'N' THEN
1076: IF P_DEBUG_MODE = 'Y' THEN
1077: log_message('Proj_Res_Job_Group does not exist');
1078: log_message('Update Denorm for the Job Id and Job Level');
1079: END IF;

Line 1099: l_job_group_id := PA_JOB_UTILS.get_job_group_id(l_job_id);

1095: log_message('Proj_Res_Job_Group Exist');
1096: END IF;
1097:
1098: -- get the job group id of the job id passed in
1099: l_job_group_id := PA_JOB_UTILS.get_job_group_id(l_job_id);
1100: IF P_DEBUG_MODE = 'Y' THEN
1101: log_message('Job Group Id = ' || l_job_group_id );
1102: END IF;
1103:

Line 1105: l_isPRJG := PA_JOB_UTILS.Is_Proj_Res_Job_Group

1101: log_message('Job Group Id = ' || l_job_group_id );
1102: END IF;
1103:
1104: -- check whether the job group is the Proj_Res_Job_Group
1105: l_isPRJG := PA_JOB_UTILS.Is_Proj_Res_Job_Group
1106: ( p_job_id => l_job_id
1107: ,p_job_group_id => l_job_group_id);
1108:
1109: -------------------------------------------------------------

Line 1930: l_job_level := PA_JOB_UTILS.get_job_level(l_job_id);

1926:
1927: FETCH get_new_job_ids INTO l_job_id;
1928: Exit when get_new_job_ids%NOTFOUND;
1929:
1930: l_job_level := PA_JOB_UTILS.get_job_level(l_job_id);
1931: IF P_DEBUG_MODE = 'Y' THEN
1932: log_message('Job id to set level ' || l_job_level || ' = ' || l_job_id);
1933: END IF;
1934:

Line 1962: l_job_group_id := PA_JOB_UTILS.get_job_group_id(l_job_id);

1958: IF P_DEBUG_MODE = 'Y' THEN
1959: log_message('Job id to set level Null = ' || l_job_id);
1960: END IF;
1961:
1962: l_job_group_id := PA_JOB_UTILS.get_job_group_id(l_job_id);
1963:
1964: perform_job_updates
1965: (P_job_id => l_job_id
1966: ,P_job_level_old => NULL

Line 1987: l_job_level := PA_JOB_UTILS.get_job_level(l_job_id);

1983:
1984: FETCH get_new_job_ids INTO l_job_id;
1985: Exit when get_new_job_ids%NOTFOUND;
1986:
1987: l_job_level := PA_JOB_UTILS.get_job_level(l_job_id);
1988: IF P_DEBUG_MODE = 'Y' THEN
1989: log_message('Job id to set level ' || l_job_level || ' = ' || l_job_id);
1990: END IF;
1991: