eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_TIME

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 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 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 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 340: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME

336: THEN
337: l_start_dt := x_avlblty_time(x_index).end_date_time;
338: x_index := x_index + 1;
339: x_avlblty_time.EXTEND(1);
340: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME
341: (
342: PERIOD_NAME => NULL,
343: START_DATE_TIME => l_start_dt,
344: END_DATE_TIME => p_start_dt,

Line 362: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME

358: x_avlblty_time.EXTEND(1);
359:
360: IF (p_blank_record)
361: THEN
362: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME
363: (
364: PERIOD_NAME => NULL,
365: START_DATE_TIME => p_start_dt,
366: END_DATE_TIME => p_end_dt,

Line 377: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME

373: SHIFT_BANDS => NULL,
374: NEXT_OBJECT_INDEX => NULL
375: );
376: ELSE
377: x_avlblty_time(x_index) := CAC_AVLBLTY_TIME
378: (
379: PERIOD_NAME => p_period_name,
380: START_DATE_TIME => p_start_dt,
381: END_DATE_TIME => p_end_dt,

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 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);

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 553: l_temp_excp_rec CAC_AVLBLTY_TIME;

549: l_excp_idx NUMBER;
550: l_hr_cal_events CAC_HR_CAL_EVENTS_PVT.HR_CAL_EVENT_TBL_TYPE;
551: l_idx NUMBER;
552: l_excp_duration NUMBER;
553: l_temp_excp_rec CAC_AVLBLTY_TIME;
554: l_temp_temp_excp_rec CAC_AVLBLTY_TIME;
555: k NUMBER;
556:
557: BEGIN

Line 554: l_temp_temp_excp_rec CAC_AVLBLTY_TIME;

550: l_hr_cal_events CAC_HR_CAL_EVENTS_PVT.HR_CAL_EVENT_TBL_TYPE;
551: l_idx NUMBER;
552: l_excp_duration NUMBER;
553: l_temp_excp_rec CAC_AVLBLTY_TIME;
554: l_temp_temp_excp_rec CAC_AVLBLTY_TIME;
555: k NUMBER;
556:
557: BEGIN
558:

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;

Line 611: l_excp_recs(1) := CAC_AVLBLTY_TIME

607: IF (l_excp_idx = 0)
608: THEN
609: l_excp_recs.EXTEND(1);
610: l_excp_idx := 1;
611: l_excp_recs(1) := CAC_AVLBLTY_TIME
612: (
613: PERIOD_NAME => ref_excp.EXCEPTION_NAME,
614: START_DATE_TIME => l_hr_cal_events(i).START_DATE_TIME,
615: END_DATE_TIME => l_hr_cal_events(i).END_DATE_TIME,

Line 633: l_excp_recs(j) := CAC_AVLBLTY_TIME

629: IF (l_hr_cal_events(i).START_DATE_TIME <= l_excp_recs(j).START_DATE_TIME)
630: THEN
631: -- move all the items
632: l_temp_excp_rec := l_excp_recs(j);
633: l_excp_recs(j) := CAC_AVLBLTY_TIME
634: (
635: PERIOD_NAME => ref_excp.EXCEPTION_NAME,
636: START_DATE_TIME => l_hr_cal_events(i).START_DATE_TIME,
637: END_DATE_TIME => l_hr_cal_events(i).END_DATE_TIME,

Line 696: l_excp_recs(l_excp_idx) := CAC_AVLBLTY_TIME

692: IF (l_hr_cal_events(i).END_DATE_TIME > l_hr_cal_events(i).START_DATE_TIME)
693: THEN
694: l_excp_recs.EXTEND(1);
695: l_excp_idx := l_excp_idx + 1;
696: l_excp_recs(l_excp_idx) := CAC_AVLBLTY_TIME
697: (
698: PERIOD_NAME => ref_excp.EXCEPTION_NAME,
699: START_DATE_TIME => l_hr_cal_events(i).START_DATE_TIME,
700: END_DATE_TIME => l_hr_cal_events(i).END_DATE_TIME,