DBA Data[Home] [Help]

APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_DAY_TIME

Line 151: l_daytime_v CAC_AVLBLTY_DAY_TIME_VARRAY;

147: ) IS
148:
149: l_summary_date DATE;
150: l_detail_v CAC_AVLBLTY_DETAIL_VARRAY;
151: l_daytime_v CAC_AVLBLTY_DAY_TIME_VARRAY;
152: l_found_index BOOLEAN;
153: l_last_index NUMBER;
154: l_end_dt DATE;
155: l_dt DATE;

Line 194: l_daytime_v(l_last_index+1) := CAC_AVLBLTY_DAY_TIME

190: THEN
191: l_daytime_v(l_last_index).END_DATE_TIME := l_end_dt;
192: ELSE
193: l_daytime_v.EXTEND(1);
194: l_daytime_v(l_last_index+1) := CAC_AVLBLTY_DAY_TIME
195: (
196: START_DATE_TIME => p_start_dt,
197: END_DATE_TIME => l_end_dt
198: );

Line 208: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();

204: END LOOP;
205: IF (NOT l_found_index)
206: THEN
207: l_last_index := l_detail_v.COUNT;
208: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
209: l_daytime_v.EXTEND(1);
210: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
211: (
212: START_DATE_TIME => p_start_dt,

Line 210: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME

206: THEN
207: l_last_index := l_detail_v.COUNT;
208: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
209: l_daytime_v.EXTEND(1);
210: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
211: (
212: START_DATE_TIME => p_start_dt,
213: END_DATE_TIME => l_end_dt
214: );

Line 229: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();

225: END IF;
226: x_avlblty_summary(x_index).SUMMARY_LINES := l_detail_v;
227: ELSE
228: x_index := x_index + 1;
229: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
230: l_daytime_v.EXTEND(1);
231: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
232: (
233: START_DATE_TIME => p_start_dt,

Line 231: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME

227: ELSE
228: x_index := x_index + 1;
229: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
230: l_daytime_v.EXTEND(1);
231: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
232: (
233: START_DATE_TIME => p_start_dt,
234: END_DATE_TIME => l_end_dt
235: );

Line 265: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();

261: THEN
262: l_end_dt := p_end_dt;
263: END IF;
264: x_index := x_index + 1;
265: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
266: l_daytime_v.EXTEND(1);
267: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
268: (
269: START_DATE_TIME => l_dt,

Line 267: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME

263: END IF;
264: x_index := x_index + 1;
265: l_daytime_v := CAC_AVLBLTY_DAY_TIME_VARRAY();
266: l_daytime_v.EXTEND(1);
267: l_daytime_v(1) := CAC_AVLBLTY_DAY_TIME
268: (
269: START_DATE_TIME => l_dt,
270: END_DATE_TIME => l_end_dt
271: );