APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_TIME_VARRAY

Line 298: ** Will create a new object in the CAC_AVLBLTY_TIME_VARRAY collection.

294: PROCEDURE CREATE_AVLBLTY_TIME
295: /*******************************************************************************
296: ** CREATE_AVLBLTY_TIME
297: **
298: ** Will create a new object in the CAC_AVLBLTY_TIME_VARRAY collection.
299: *******************************************************************************/
300: ( p_blank_record IN BOOLEAN
301: , p_period_name IN VARCHAR2
302: , p_start_dt IN DATE

Line 311: , x_avlblty_time IN OUT NOCOPY CAC_AVLBLTY_TIME_VARRAY

307: , p_free_busy IN VARCHAR2
308: , p_display_color IN VARCHAR2
309: , p_update_next IN BOOLEAN
310: , p_shift_bands IN CAC_AVLBLTY_TIME_BAND_VARRAY
311: , x_avlblty_time IN OUT NOCOPY CAC_AVLBLTY_TIME_VARRAY
312: , x_index IN OUT NOCOPY NUMBER
313: ) IS
314:
315: l_start_dt DATE;

Line 420: , x_Schedule OUT NOCOPY CAC_AVLBLTY_TIME_VARRAY

416: -- NULL: leave the interpretation to caller
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

Line 538: l_super_recs CAC_AVLBLTY_TIME_VARRAY;

534: l_fb VARCHAR2(30);
535: l_duration_ms NUMBER;
536: l_rec_processed BOOLEAN;
537: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;
538: l_super_recs CAC_AVLBLTY_TIME_VARRAY;
539: l_excp_recs CAC_AVLBLTY_TIME_VARRAY;
540: l_super_index NUMBER;
541: l_period_name VARCHAR2(2000);
542: l_category_id NUMBER;

Line 539: l_excp_recs CAC_AVLBLTY_TIME_VARRAY;

535: l_duration_ms NUMBER;
536: l_rec_processed BOOLEAN;
537: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;
538: l_super_recs CAC_AVLBLTY_TIME_VARRAY;
539: l_excp_recs CAC_AVLBLTY_TIME_VARRAY;
540: l_super_index NUMBER;
541: l_period_name VARCHAR2(2000);
542: l_category_id NUMBER;
543: l_category_name VARCHAR2(2000);

Line 559: x_Schedule := CAC_AVLBLTY_TIME_VARRAY();

555: k NUMBER;
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')

Line 561: l_excp_recs := CAC_AVLBLTY_TIME_VARRAY();

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
565: l_excp_idx := 0;