[Home] [Help]
132: PROCEDURE CREATE_AVLBLTY_SUMMARY
133: /*******************************************************************************
134: ** CREATE_AVLBLTY_SUMMARY
135: **
136: ** Will create a new object in the CAC_AVLBLTY_SUMMARY_VARRAY collection.
137: *******************************************************************************/
138: ( p_blank_record IN BOOLEAN
139: , p_start_dt IN DATE
140: , p_end_dt IN DATE
141: , p_category_id IN NUMBER
142: , p_category_name IN VARCHAR2
143: , p_free_busy IN VARCHAR2
144: , p_display_color IN VARCHAR2
145: , x_avlblty_summary IN OUT NOCOPY CAC_AVLBLTY_SUMMARY_VARRAY
146: , x_index IN OUT NOCOPY NUMBER
147: ) IS
148:
149: l_summary_date DATE;
244: DISPLAY_COLOR => p_display_color,
245: DAY_TIMES => l_daytime_v
246: );
247: x_avlblty_summary.EXTEND(1);
248: x_avlblty_summary(x_index) := CAC_AVLBLTY_SUMMARY
249: (
250: SUMMARY_DATE => TRUNC(p_start_dt),
251: SUMMARY_LINES => l_detail_v
252: );
280: DISPLAY_COLOR => p_display_color,
281: DAY_TIMES => l_daytime_v
282: );
283: x_avlblty_summary.EXTEND(1);
284: x_avlblty_summary(x_index) := CAC_AVLBLTY_SUMMARY
285: (
286: SUMMARY_DATE => TRUNC(l_dt),
287: SUMMARY_LINES => l_detail_v
288: );
417: , p_return_type IN VARCHAR2 -- 'D': Detailed schedule
418: -- 'S': Schedule Summary
419: -- 'B': Both detailed and summary of schedule
420: , x_Schedule OUT NOCOPY CAC_AVLBLTY_TIME_VARRAY
421: , x_Schedule_Summary OUT NOCOPY CAC_AVLBLTY_SUMMARY_VARRAY
422: -- return schedule
423: )
424: IS
425:
556:
557: BEGIN
558:
559: x_Schedule := CAC_AVLBLTY_TIME_VARRAY();
560: x_Schedule_Summary := CAC_AVLBLTY_SUMMARY_VARRAY();
561: l_excp_recs := CAC_AVLBLTY_TIME_VARRAY();
562:
563: IF (NVL(p_Include_Exception,'T') = 'T')
564: THEN