APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_TIME_BAND_VARRAY

Line 117: ** Will create a new CAC_AVLBLTY_TIME_BAND_VARRAY collection.

113: FUNCTION GET_SHIFT_BANDS
114: /*******************************************************************************
115: ** GET_SHIFT_BANDS
116: **
117: ** Will create a new CAC_AVLBLTY_TIME_BAND_VARRAY collection.
118: *******************************************************************************/
119: ( p_period_id IN NUMBER
120: ) RETURN CAC_AVLBLTY_TIME_BAND_VARRAY IS
121:

Line 120: ) RETURN CAC_AVLBLTY_TIME_BAND_VARRAY IS

116: **
117: ** Will create a new CAC_AVLBLTY_TIME_BAND_VARRAY collection.
118: *******************************************************************************/
119: ( p_period_id IN NUMBER
120: ) RETURN CAC_AVLBLTY_TIME_BAND_VARRAY IS
121:
122: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;
123:
124: BEGIN

Line 122: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;

118: *******************************************************************************/
119: ( p_period_id IN NUMBER
120: ) RETURN CAC_AVLBLTY_TIME_BAND_VARRAY IS
121:
122: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;
123:
124: BEGIN
125:
126: l_shift_bands := CAC_AVLBLTY_TIME_BAND_VARRAY();

Line 126: l_shift_bands := CAC_AVLBLTY_TIME_BAND_VARRAY();

122: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;
123:
124: BEGIN
125:
126: l_shift_bands := CAC_AVLBLTY_TIME_BAND_VARRAY();
127:
128: RETURN l_shift_bands;
129:
130: END GET_SHIFT_BANDS;

Line 310: , p_shift_bands IN CAC_AVLBLTY_TIME_BAND_VARRAY

306: , p_category_name IN VARCHAR2
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:

Line 537: l_shift_bands CAC_AVLBLTY_TIME_BAND_VARRAY;

533: l_duration_uom VARCHAR2(30);
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);