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 1285: l_shifts CSF_RESOURCE_PUB.shift_tbl_type;

1281: p_scheduled_end_date date) return date is
1282: l_return_date date;
1283: l_profile_value varchar2(100);
1284: l_minutes_before number;
1285: l_shifts CSF_RESOURCE_PUB.shift_tbl_type;
1286: X_RETURN_STATUS VARCHAR2(200);
1287: X_MSG_COUNT NUMBER;
1288: X_MSG_DATA VARCHAR2(200);
1289: begin

Line 1301: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1297:
1298: if l_profile_value = 'SHIFT_DAY' then -- During Shift
1299:
1300: -- fetch shift start date time for the given schedule dates
1301: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1302: P_API_VERSION => 1.0,
1303: P_RESOURCE_ID => p_resource_id,
1304: P_RESOURCE_TYPE => p_resource_type_code,
1305: P_START_DATE => p_scheduled_start_date,

Line 1319: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1315:
1316: -- if shift start is less than current date time then send immediately
1317: if l_return_date > sysdate then
1318: -- fetch next shift start from today
1319: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1320: P_API_VERSION => 1.0,
1321: P_RESOURCE_ID => p_resource_id,
1322: P_RESOURCE_TYPE => p_resource_type_code,
1323: P_START_DATE => trunc(sysdate) + 1,

Line 1356: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(

1352:
1353: elsif l_profile_value = 'SCHEDULE_DAY' then -- Scheduled Day
1354:
1355: -- fetch shift start date time for the given schedule dates
1356: CSF_RESOURCE_PUB.GET_RESOURCE_SHIFTS(
1357: P_API_VERSION => 1.0,
1358: P_RESOURCE_ID => p_resource_id,
1359: P_RESOURCE_TYPE => p_resource_type_code,
1360: P_START_DATE => p_scheduled_start_date,