APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_DETAIL

Line 150: l_detail_v CAC_AVLBLTY_DETAIL_VARRAY;

146: , x_index IN OUT NOCOPY NUMBER
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;

Line 216: l_detail_v(l_last_index+1) := CAC_AVLBLTY_DETAIL

212: START_DATE_TIME => p_start_dt,
213: END_DATE_TIME => l_end_dt
214: );
215: l_detail_v.EXTEND(1);
216: l_detail_v(l_last_index+1) := CAC_AVLBLTY_DETAIL
217: (
218: TOTAL_TIME_MS => (l_end_dt-p_start_dt)*24*3600*1000,
219: PERIOD_CATEGORY_ID => p_category_id,
220: PERIOD_CATEGORY_NAME => p_category_name,

Line 236: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();

232: (
233: START_DATE_TIME => p_start_dt,
234: END_DATE_TIME => l_end_dt
235: );
236: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();
237: l_detail_v.EXTEND(1);
238: l_detail_v(1) := CAC_AVLBLTY_DETAIL
239: (
240: TOTAL_TIME_MS => (l_end_dt-p_start_dt)*24*3600*1000,

Line 238: l_detail_v(1) := CAC_AVLBLTY_DETAIL

234: END_DATE_TIME => l_end_dt
235: );
236: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();
237: l_detail_v.EXTEND(1);
238: l_detail_v(1) := CAC_AVLBLTY_DETAIL
239: (
240: TOTAL_TIME_MS => (l_end_dt-p_start_dt)*24*3600*1000,
241: PERIOD_CATEGORY_ID => p_category_id,
242: PERIOD_CATEGORY_NAME => p_category_name,

Line 272: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();

268: (
269: START_DATE_TIME => l_dt,
270: END_DATE_TIME => l_end_dt
271: );
272: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();
273: l_detail_v.EXTEND(1);
274: l_detail_v(1) := CAC_AVLBLTY_DETAIL
275: (
276: TOTAL_TIME_MS => (l_end_dt-l_dt)*24*3600*1000,

Line 274: l_detail_v(1) := CAC_AVLBLTY_DETAIL

270: END_DATE_TIME => l_end_dt
271: );
272: l_detail_v := CAC_AVLBLTY_DETAIL_VARRAY();
273: l_detail_v.EXTEND(1);
274: l_detail_v(1) := CAC_AVLBLTY_DETAIL
275: (
276: TOTAL_TIME_MS => (l_end_dt-l_dt)*24*3600*1000,
277: PERIOD_CATEGORY_ID => p_category_id,
278: PERIOD_CATEGORY_NAME => p_category_name,