APPS.CSF_ALERTS_PUB dependencies on CSF_RESOURCE_PUB

Line 26: -- l_shifts CSF_RESOURCE_PUB.shift_tbl_type;

22: l_scheduled_start_date date;
23: l_scheduled_end_date date;
24: l_resource_id number;
25: l_resource_type_code varchar2(20);
26: -- l_shifts CSF_RESOURCE_PUB.shift_tbl_type;
27: X_RETURN_STATUS VARCHAR2(200);
28: X_MSG_COUNT NUMBER;
29: X_MSG_DATA VARCHAR2(200);
30: l_shift_start_date date;

Line 1275: l_shifts CSF_RESOURCE_PUB.shift_tbl_type;

1271: p_scheduled_end_date date) return date is
1272: l_return_date date;
1273: l_profile_value varchar2(100);
1274: l_minutes_before number;
1275: l_shifts CSF_RESOURCE_PUB.shift_tbl_type;
1276: X_RETURN_STATUS VARCHAR2(200);
1277: X_MSG_COUNT NUMBER;
1278: X_MSG_DATA VARCHAR2(200);
1279: begin

Line 1291: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1287:
1288: if l_profile_value = 'SHIFT_DAY' then -- During Shift
1289:
1290: -- fetch shift start date time for the given schedule dates
1291: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1292: P_API_VERSION => 1.0,
1293: P_RESOURCE_ID => p_resource_id,
1294: P_RESOURCE_TYPE => p_resource_type_code,
1295: P_START_DATE => p_scheduled_start_date,

Line 1309: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1305:
1306: -- if shift start is less than current date time then send immediately
1307: if l_return_date > sysdate then
1308: -- fetch next shift start from today
1309: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1310: P_API_VERSION => 1.0,
1311: P_RESOURCE_ID => p_resource_id,
1312: P_RESOURCE_TYPE => p_resource_type_code,
1313: P_START_DATE => trunc(sysdate) + 1,

Line 1346: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1342:
1343: elsif l_profile_value = 'SCHEDULE_DAY' then -- Scheduled Day
1344:
1345: -- fetch shift start date time for the given schedule dates
1346: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1347: P_API_VERSION => 1.0,
1348: P_RESOURCE_ID => p_resource_id,
1349: P_RESOURCE_TYPE => p_resource_type_code,
1350: P_START_DATE => p_scheduled_start_date,