DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 971: FROM jtf_cal_resource_assign jtf_res

967: -- condition so that calendar_id, resource_id index would be used.
968:
969: CURSOR C1 IS SELECT calendar_id,trunc(start_date_time) start_date,
970: NVL(trunc(end_date_time),TO_DATE('01/01/2050','MM/DD/YYYY')) end_date
971: FROM jtf_cal_resource_assign jtf_res
972: WHERE jtf_res.resource_id = l_t_resource_id
973: AND jtf_res.primary_calendar_flag = 'Y'
974: AND jtf_res.calendar_id > 0
975: AND jtf_res.resource_type_code = 'RS_EMPLOYEE'

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

1076: PA_SCHEDULE_UTILS.log_message(1,'status ... '||l_x_return_status);
1077:
1078: -- 1965289: Work around for CRM bug (cannot create future dated resources).
1079: -- If the jtf_resource_id is null, then we need to use the default
1080: -- calendar instead of going to the jtf_cal_resource_assign table.
1081:
1082: -- Start 1965289 bugfix.
1083: IF (l_t_resource_id is null) THEN
1084: -- Find the start date for the first HR assignment.

Line 1276: FROM jtf_cal_resource_assign

1272: -- condition so that calendar_id, resource_id index would be used.
1273:
1274: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1275: INTO l_temp_start_date,l_temp_end_date
1276: FROM jtf_cal_resource_assign
1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1278: AND jtf_cal_resource_assign.calendar_id > 0
1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1280: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';

Line 1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id

1273:
1274: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1275: INTO l_temp_start_date,l_temp_end_date
1276: FROM jtf_cal_resource_assign
1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1278: AND jtf_cal_resource_assign.calendar_id > 0
1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1280: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1281: END IF;

Line 1278: AND jtf_cal_resource_assign.calendar_id > 0

1274: SELECT MIN(start_date_time),MAX(NVL(end_date_time,TO_DATE('01/01/2050','MM/DD/YYYY')))
1275: INTO l_temp_start_date,l_temp_end_date
1276: FROM jtf_cal_resource_assign
1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1278: AND jtf_cal_resource_assign.calendar_id > 0
1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1280: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1281: END IF;
1282:

Line 1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'

1275: INTO l_temp_start_date,l_temp_end_date
1276: FROM jtf_cal_resource_assign
1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1278: AND jtf_cal_resource_assign.calendar_id > 0
1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1280: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1281: END IF;
1282:
1283: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));

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

1276: FROM jtf_cal_resource_assign
1277: WHERE jtf_cal_resource_assign.resource_id = l_t_resource_id
1278: AND jtf_cal_resource_assign.calendar_id > 0
1279: AND jtf_cal_resource_assign.resource_type_code = 'RS_EMPLOYEE'
1280: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
1281: END IF;
1282:
1283: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));
1284: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));