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.HXC_BLOCK_COLLECTION_UTILS dependencies on FND_DATE

Line 137: fnd_date.date_to_canonical(start_time),

133: (time_building_block_id,
134: type,
135: measure,
136: unit_of_measure,
137: fnd_date.date_to_canonical(start_time),
138: fnd_date.date_to_canonical(stop_time),
139: parent_building_block_id,
140: 'N',
141: scope,

Line 138: fnd_date.date_to_canonical(stop_time),

134: type,
135: measure,
136: unit_of_measure,
137: fnd_date.date_to_canonical(start_time),
138: fnd_date.date_to_canonical(stop_time),
139: parent_building_block_id,
140: 'N',
141: scope,
142: object_version_number,

Line 147: fnd_date.date_to_canonical(date_from),

143: approval_status,
144: resource_id,
145: resource_type,
146: approval_style_id,
147: fnd_date.date_to_canonical(date_from),
148: fnd_date.date_to_canonical(date_to),
149: comment_text,
150: parent_building_block_ovn,
151: 'N',

Line 148: fnd_date.date_to_canonical(date_to),

144: resource_id,
145: resource_type,
146: approval_style_id,
147: fnd_date.date_to_canonical(date_from),
148: fnd_date.date_to_canonical(date_to),
149: comment_text,
150: parent_building_block_ovn,
151: 'N',
152: 'N',

Line 171: p_top_level_start_date := fnd_date.canonical_to_date(p_blocks(1).start_time);

167: fetch c_block_type_info into p_blocks(1);
168: if(c_block_type_info%notfound) then
169: p_blocks := null;
170: else
171: p_top_level_start_date := fnd_date.canonical_to_date(p_blocks(1).start_time);
172: p_top_level_stop_date := fnd_date.canonical_to_date(p_blocks(1).stop_time);
173: end if;
174: close c_block_type_info;
175: End load_top_level_block;

Line 172: p_top_level_stop_date := fnd_date.canonical_to_date(p_blocks(1).stop_time);

168: if(c_block_type_info%notfound) then
169: p_blocks := null;
170: else
171: p_top_level_start_date := fnd_date.canonical_to_date(p_blocks(1).start_time);
172: p_top_level_stop_date := fnd_date.canonical_to_date(p_blocks(1).stop_time);
173: end if;
174: close c_block_type_info;
175: End load_top_level_block;
176:

Line 194: fnd_date.date_to_canonical(days.start_time),

190: (days.time_building_block_id,
191: days.type,
192: days.measure,
193: days.unit_of_measure,
194: fnd_date.date_to_canonical(days.start_time),
195: fnd_date.date_to_canonical(days.stop_time),
196: p_top_level_block_id,
197: 'N',
198: days.scope,

Line 195: fnd_date.date_to_canonical(days.stop_time),

191: days.type,
192: days.measure,
193: days.unit_of_measure,
194: fnd_date.date_to_canonical(days.start_time),
195: fnd_date.date_to_canonical(days.stop_time),
196: p_top_level_block_id,
197: 'N',
198: days.scope,
199: days.object_version_number,

Line 204: fnd_date.date_to_canonical(days.date_from),

200: days.approval_status,
201: days.resource_id,
202: days.resource_type,
203: days.approval_style_id,
204: fnd_date.date_to_canonical(days.date_from),
205: fnd_date.date_to_canonical(days.date_to),
206: days.comment_text,
207: p_top_level_block_ovn,
208: 'N',

Line 205: fnd_date.date_to_canonical(days.date_to),

201: days.resource_id,
202: days.resource_type,
203: days.approval_style_id,
204: fnd_date.date_to_canonical(days.date_from),
205: fnd_date.date_to_canonical(days.date_to),
206: days.comment_text,
207: p_top_level_block_ovn,
208: 'N',
209: 'N',

Line 270: fnd_date.date_to_canonical(days.start_time),

266: (days.time_building_block_id,
267: days.type,
268: days.measure,
269: days.unit_of_measure,
270: fnd_date.date_to_canonical(days.start_time),
271: fnd_date.date_to_canonical(days.stop_time),
272: days.parent_building_block_id,
273: 'N',
274: days.scope,

Line 271: fnd_date.date_to_canonical(days.stop_time),

267: days.type,
268: days.measure,
269: days.unit_of_measure,
270: fnd_date.date_to_canonical(days.start_time),
271: fnd_date.date_to_canonical(days.stop_time),
272: days.parent_building_block_id,
273: 'N',
274: days.scope,
275: days.object_version_number,

Line 280: fnd_date.date_to_canonical(days.date_from),

276: days.approval_status,
277: days.resource_id,
278: days.resource_type,
279: days.approval_style_id,
280: fnd_date.date_to_canonical(days.date_from),
281: fnd_date.date_to_canonical(days.date_to),
282: days.comment_text,
283: days.parent_building_block_ovn,
284: 'N',

Line 281: fnd_date.date_to_canonical(days.date_to),

277: days.resource_id,
278: days.resource_type,
279: days.approval_style_id,
280: fnd_date.date_to_canonical(days.date_from),
281: fnd_date.date_to_canonical(days.date_to),
282: days.comment_text,
283: days.parent_building_block_ovn,
284: 'N',
285: 'N',

Line 336: l_day_diff := trunc(fnd_date.canonical_to_date(p_blocks(2).start_time)) - trunc(p_start_time);

332:
333: Begin
334: l_temp_blocks := hxc_block_table_type();
335: -- Check for days missing at the start
336: l_day_diff := trunc(fnd_date.canonical_to_date(p_blocks(2).start_time)) - trunc(p_start_time);
337: l_day := p_blocks(2);
338: if(l_day_diff > 0) then
339: l_curr_day := p_start_time;
340: -- Missing days from the front of the period. Add them, preserving the order.

Line 344: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);

340: -- Missing days from the front of the period. Add them, preserving the order.
341: l_temp_blocks.extend();
342: l_temp_blocks(1) := p_blocks(1);
343: For l_index in 2..(1+l_day_diff) Loop
344: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);
345: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));
346: l_day.time_building_block_id := -2-l_index;
347: l_temp_blocks.extend();
348: l_temp_blocks(l_index) := l_day;

Line 345: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));

341: l_temp_blocks.extend();
342: l_temp_blocks(1) := p_blocks(1);
343: For l_index in 2..(1+l_day_diff) Loop
344: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);
345: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));
346: l_day.time_building_block_id := -2-l_index;
347: l_temp_blocks.extend();
348: l_temp_blocks(l_index) := l_day;
349: l_curr_day := l_curr_day + 1;

Line 365: l_day_diff := trunc(p_stop_time) - trunc(fnd_date.canonical_to_date(p_blocks(p_blocks.last).stop_time));

361: p_blocks := l_temp_blocks;
362: end if;
363: -- Check for days missing at the end
364: l_temp_blocks := hxc_block_table_type();
365: l_day_diff := trunc(p_stop_time) - trunc(fnd_date.canonical_to_date(p_blocks(p_blocks.last).stop_time));
366: l_day := p_blocks(2);
367: if(l_day_diff > 0) then
368: -- preppend the existing days
369: l_index := p_blocks.first;

Line 376: l_curr_day := (fnd_date.canonical_to_date(p_blocks(p_blocks.last).start_time)+1);

372: l_temp_blocks.extend();
373: l_temp_blocks(l_temp_blocks.last) := p_blocks(l_index);
374: l_index := p_blocks.next(l_index);
375: End Loop;
376: l_curr_day := (fnd_date.canonical_to_date(p_blocks(p_blocks.last).start_time)+1);
377: For l_index in (l_temp_blocks.last+1) .. (l_temp_blocks.last+l_day_diff) Loop
378: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);
379: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));
380: l_day.time_building_block_id := -2-l_index;

Line 378: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);

374: l_index := p_blocks.next(l_index);
375: End Loop;
376: l_curr_day := (fnd_date.canonical_to_date(p_blocks(p_blocks.last).start_time)+1);
377: For l_index in (l_temp_blocks.last+1) .. (l_temp_blocks.last+l_day_diff) Loop
378: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);
379: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));
380: l_day.time_building_block_id := -2-l_index;
381: l_temp_blocks.extend();
382: l_temp_blocks(l_index) := l_day;

Line 379: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));

375: End Loop;
376: l_curr_day := (fnd_date.canonical_to_date(p_blocks(p_blocks.last).start_time)+1);
377: For l_index in (l_temp_blocks.last+1) .. (l_temp_blocks.last+l_day_diff) Loop
378: l_day.start_time := fnd_date.date_to_canonical(l_curr_day);
379: l_day.stop_time := fnd_date.date_to_canonical((l_curr_day + C_END_OF_DAY));
380: l_day.time_building_block_id := -2-l_index;
381: l_temp_blocks.extend();
382: l_temp_blocks(l_index) := l_day;
383: l_curr_day := l_curr_day + 1;

Line 410: fnd_date.date_to_canonical(details.start_time),

406: (details.time_building_block_id,
407: details.type,
408: details.measure,
409: details.unit_of_measure,
410: fnd_date.date_to_canonical(details.start_time),
411: fnd_date.date_to_canonical(details.stop_time),
412: details.parent_building_block_id,
413: 'N',
414: details.scope,

Line 411: fnd_date.date_to_canonical(details.stop_time),

407: details.type,
408: details.measure,
409: details.unit_of_measure,
410: fnd_date.date_to_canonical(details.start_time),
411: fnd_date.date_to_canonical(details.stop_time),
412: details.parent_building_block_id,
413: 'N',
414: details.scope,
415: details.object_version_number,

Line 420: fnd_date.date_to_canonical(details.date_from),

416: details.approval_status,
417: details.resource_id,
418: details.resource_type,
419: details.approval_style_id,
420: fnd_date.date_to_canonical(details.date_from),
421: fnd_date.date_to_canonical(details.date_to),
422: details.comment_text,
423: details.parent_building_block_ovn,
424: 'N',

Line 421: fnd_date.date_to_canonical(details.date_to),

417: details.resource_id,
418: details.resource_type,
419: details.approval_style_id,
420: fnd_date.date_to_canonical(details.date_from),
421: fnd_date.date_to_canonical(details.date_to),
422: details.comment_text,
423: details.parent_building_block_ovn,
424: 'N',
425: 'N',

Line 491: fnd_date.date_to_canonical(details.start_time),

487: (details.time_building_block_id,
488: details.type,
489: details.measure,
490: details.unit_of_measure,
491: fnd_date.date_to_canonical(details.start_time),
492: fnd_date.date_to_canonical(details.stop_time),
493: details.parent_building_block_id,
494: 'N',
495: details.scope,

Line 492: fnd_date.date_to_canonical(details.stop_time),

488: details.type,
489: details.measure,
490: details.unit_of_measure,
491: fnd_date.date_to_canonical(details.start_time),
492: fnd_date.date_to_canonical(details.stop_time),
493: details.parent_building_block_id,
494: 'N',
495: details.scope,
496: details.object_version_number,

Line 501: fnd_date.date_to_canonical(details.date_from),

497: details.approval_status,
498: details.resource_id,
499: details.resource_type,
500: details.approval_style_id,
501: fnd_date.date_to_canonical(details.date_from),
502: fnd_date.date_to_canonical(details.date_to),
503: details.comment_text,
504: details.parent_building_block_ovn,
505: 'N',

Line 502: fnd_date.date_to_canonical(details.date_to),

498: details.resource_id,
499: details.resource_type,
500: details.approval_style_id,
501: fnd_date.date_to_canonical(details.date_from),
502: fnd_date.date_to_canonical(details.date_to),
503: details.comment_text,
504: details.parent_building_block_ovn,
505: 'N',
506: 'N',

Line 775: p_blocks(1).start_time := fnd_date.date_to_canonical(p_start_time);

771: -- if different periods - we're only interested in the period associated with
772: -- the timecard anyway.
773: --
774: if(trunc(l_app_period_start_time) <> trunc(p_start_time)) then
775: p_blocks(1).start_time := fnd_date.date_to_canonical(p_start_time);
776: end if;
777: if(trunc(l_app_period_stop_time) <> trunc(p_stop_time)) then
778: p_blocks(1).stop_time := fnd_date.date_to_canonical(p_stop_time);
779: end if;

Line 778: p_blocks(1).stop_time := fnd_date.date_to_canonical(p_stop_time);

774: if(trunc(l_app_period_start_time) <> trunc(p_start_time)) then
775: p_blocks(1).start_time := fnd_date.date_to_canonical(p_start_time);
776: end if;
777: if(trunc(l_app_period_stop_time) <> trunc(p_stop_time)) then
778: p_blocks(1).stop_time := fnd_date.date_to_canonical(p_stop_time);
779: end if;
780: --
781: -- Ok, now add the dummy application attribute, still used in the fragment view
782: -- Since the block structure does not include the columns from the summary tables