APPS.CAC_AVLBLTY_PVT dependencies on CAC_SR_SCHDL_DETAILS

Line 449: CAC_SR_SCHDL_DETAILS CSSD,

445: DECODE(CSPCVL.FREE_BUSY_TYPE,'FREE','FREE','BUSY','BUSY',NVL(b_busy_tentative,'TENTATIVE')) FREE_BUSY_TYPE,
446: CSPCVL.DISPLAY_COLOR
447: FROM CAC_SR_SCHDL_OBJECTS CSSO,
448: CAC_SR_SCHEDULES_B CSSB,
449: CAC_SR_SCHDL_DETAILS CSSD,
450: CAC_SR_PERIODS_VL CSPVL,
451: CAC_SR_PERIOD_CATS_VL CSPCVL,
452: FND_LOOKUPS FL
453: WHERE CSSO.OBJECT_TYPE = b_object_type

Line 1271: INSERT INTO CAC_SR_SCHDL_DETAILS

1267: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1268:
1269: FOR i IN p_Schedule_Details.FIRST..p_Schedule_Details.LAST
1270: LOOP
1271: INSERT INTO CAC_SR_SCHDL_DETAILS
1272: (
1273: SCHEDULE_DETAIL_ID,
1274: SCHEDULE_ID,
1275: SCHEDULE_OBJECT_ID,

Line 1287: CAC_SR_SCHDL_DETAILS_S.NEXTVAL,

1283: LAST_UPDATE_LOGIN
1284: )
1285: VALUES
1286: (
1287: CAC_SR_SCHDL_DETAILS_S.NEXTVAL,
1288: p_schedule_id,
1289: p_schedule_object_id,
1290: p_Schedule_Details(i).period_id,
1291: p_Schedule_Details(i).start_date_time,

Line 2152: DELETE FROM CAC_SR_SCHDL_DETAILS

2148: l_Schdl_End_Date DATE;
2149:
2150: BEGIN
2151:
2152: DELETE FROM CAC_SR_SCHDL_DETAILS
2153: WHERE SCHEDULE_OBJECT_ID = p_schedule_object_id;
2154:
2155: OPEN c_get_schdl(p_Schedule_Id);
2156: FETCH c_get_schdl

Line 2295: FROM CAC_SR_SCHDL_DETAILS

2291: , CSSO.END_DATE_ACTIVE
2292: , CSSD.SCHEDULE_OBJECT_ID
2293: FROM CAC_SR_SCHDL_OBJECTS CSSO,
2294: (SELECT SCHEDULE_OBJECT_ID, MIN(START_DATE_TIME)
2295: FROM CAC_SR_SCHDL_DETAILS
2296: WHERE SCHEDULE_ID = b_schedule_id
2297: ) CSSD
2298: WHERE CSSO.SCHEDULE_ID = b_schedule_id
2299: AND CSSD.SCHEDULE_OBJECT_ID(+) = CSSO.SCHEDULE_OBJECT_ID;

Line 2303: DELETE FROM CAC_SR_SCHDL_DETAILS

2299: AND CSSD.SCHEDULE_OBJECT_ID(+) = CSSO.SCHEDULE_OBJECT_ID;
2300:
2301: BEGIN
2302:
2303: DELETE FROM CAC_SR_SCHDL_DETAILS
2304: WHERE SCHEDULE_ID = p_schedule_id;
2305:
2306: POPULATE_SCHEDULE_DETAILS
2307: (