DBA Data[Home] [Help]

APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_SUMMARY_VARRAY

Line 136: ** Will create a new object in the CAC_AVLBLTY_SUMMARY_VARRAY collection.

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

Line 145: , x_avlblty_summary IN OUT NOCOPY CAC_AVLBLTY_SUMMARY_VARRAY

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;

Line 421: , x_Schedule_Summary OUT NOCOPY CAC_AVLBLTY_SUMMARY_VARRAY

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:

Line 560: x_Schedule_Summary := CAC_AVLBLTY_SUMMARY_VARRAY();

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