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_SCHEDULE_UTILS dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 792: FROM jtf_cal_resource_assign jtf_res

788: -- since resource_id is not unique. Also, added calendar_id > 0
789: -- condition so that calendar_id, resource_id index would be used.
790:
791: CURSOR C1 IS SELECT calendar_id
792: FROM jtf_cal_resource_assign jtf_res
793: WHERE jtf_res.resource_id = l_jtf_res_id
794: AND jtf_res.resource_type_code = 'RS_EMPLOYEE'
795: AND jtf_res.primary_calendar_flag = 'Y'
796: AND jtf_res.calendar_id > 0

Line 821: -- calendar instead of going to the jtf_cal_resource_assign table.

817: PA_SCHEDULE_UTILS.log_message(1,'status ... '||x_return_status);
818:
819: -- 1965288: Work around for CRM bug (cannot create future dated resources).
820: -- If the jtf_resource_id is null, then we need to use the default
821: -- calendar instead of going to the jtf_cal_resource_assign table.
822:
823: -- Start 1965288 bugfix.
824: if (l_jtf_res_id is null) then
825:

Line 862: FROM jtf_cal_resource_assign

858:
859: IF (p_start_date IS NULL OR p_end_date IS NULL) THEN
860: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
861: INTO l_temp_start_date,l_temp_end_date
862: FROM jtf_cal_resource_assign
863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id
864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';

Line 863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id

859: IF (p_start_date IS NULL OR p_end_date IS NULL) THEN
860: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
861: INTO l_temp_start_date,l_temp_end_date
862: FROM jtf_cal_resource_assign
863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id
864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;

Line 864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'

860: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
861: INTO l_temp_start_date,l_temp_end_date
862: FROM jtf_cal_resource_assign
863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id
864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;
868:

Line 865: AND jtf_cal_resource_assign.calendar_id > 0

861: INTO l_temp_start_date,l_temp_end_date
862: FROM jtf_cal_resource_assign
863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id
864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;
868:
869: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));

Line 866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';

862: FROM jtf_cal_resource_assign
863: WHERE jtf_cal_resource_assign.resource_id = l_jtf_res_id
864: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;
868:
869: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));
870: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));

Line 929: FROM jtf_cal_resource_assign jtf_cal_res,

925: END IF;
926:
927: SELECT jtf_cal.calendar_name
928: INTO l_calendar_name
929: FROM jtf_cal_resource_assign jtf_cal_res,
930: jtf_calendars_vl jtf_cal,
931: pa_resources res
932: WHERE res.resource_id = l_resource_id
933: AND jtf_cal_res.resource_id = res.jtf_resource_id

Line 1040: FROM jtf_cal_resource_assign jtf_res, pa_resources pa_res

1036: FROM (
1037: SELECT jtf_res.calendar_id calendar_id,
1038: NVL(jtf_res.start_date_time, l_start_date) start_date_time,
1039: NVL(jtf_res.end_date_time, l_end_date) end_date_time
1040: FROM jtf_cal_resource_assign jtf_res, pa_resources pa_res
1041: WHERE pa_res.resource_id = p_resource_id
1042: and jtf_res.resource_id = pa_res.jtf_resource_id
1043: and jtf_res.resource_type_code = 'RS_EMPLOYEE'
1044: and jtf_res.calendar_id > -1

Line 1053: FROM jtf_cal_resource_assign jtf_res

1049: UNION ALL
1050: SELECT jtf_res.calendar_id calendar_id,
1051: NVL(jtf_res.start_date_time, l_start_date) start_date_time,
1052: NVL(jtf_res.end_date_time, l_end_date) end_date_time
1053: FROM jtf_cal_resource_assign jtf_res
1054: WHERE jtf_res.resource_id = p_jtf_resource_id
1055: and jtf_res.resource_type_code = 'RS_EMPLOYEE'
1056: and jtf_res.calendar_id > -1
1057: and jtf_res.primary_calendar_flag = 'Y'