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_RETRIEVE_ABSENCES dependencies on FND_DATE

Line 81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)

77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;
81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)
82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)
83: THEN
84: IF g_debug
85: THEN

Line 82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)

78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;
81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)
82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)
83: THEN
84: IF g_debug
85: THEN
86: hr_utility.trace('ABS : Spans outside the timecard ');

Line 93: p_abs_tab(l_ind).abs_date :=TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) ;

89: END IF;
90:
91:
92: p_abs_tab(l_ind).abs_type_id :=l_abs_org_tab(i).absence_type_id ;
93: p_abs_tab(l_ind).abs_date :=TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) ;
94: p_abs_tab(l_ind).element_type_id := l_abs_org_tab(i).element_type_ID ;
95: p_abs_tab(l_ind).abs_attendance_id := l_abs_org_tab(i).absence_attendance_id ;
96: p_abs_tab(l_ind).prg_appl_id := l_abs_org_tab(i).program_application_id ;
97: p_abs_tab(l_ind).rec_start_date := l_abs_org_tab(i).rec_start_date ;

Line 117: (fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) -

113: p_abs_tab(l_ind).duration := 1 ;
114: ELSE
115: p_abs_tab(l_ind).uom := 'H';
116: p_abs_tab(l_ind).duration := NVL(l_abs_org_tab(i).rec_duration,
117: (fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) -
118: fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)
119: )*24);
120: END IF;
121:

Line 118: fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)

114: ELSE
115: p_abs_tab(l_ind).uom := 'H';
116: p_abs_tab(l_ind).duration := NVL(l_abs_org_tab(i).rec_duration,
117: (fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) -
118: fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)
119: )*24);
120: END IF;
121:
122: IF l_abs_org_tab(i).days_or_hours = 'H'

Line 124: p_abs_tab(l_ind).abs_start := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate) ;

120: END IF;
121:
122: IF l_abs_org_tab(i).days_or_hours = 'H'
123: THEN
124: p_abs_tab(l_ind).abs_start := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate) ;
125: p_abs_tab(l_ind).abs_end := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) ;
126: END IF;
127:
128:

Line 125: p_abs_tab(l_ind).abs_end := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) ;

121:
122: IF l_abs_org_tab(i).days_or_hours = 'H'
123: THEN
124: p_abs_tab(l_ind).abs_start := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate) ;
125: p_abs_tab(l_ind).abs_end := fnd_date.canonical_to_date(l_abs_org_tab(i).abs_enddate) ;
126: END IF;
127:
128:
129:

Line 476: p_block_array(l_block_ind).START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_date);

472: p_block_array(l_block_ind).TIME_BUILDING_BLOCK_ID := (-3 - (p_iteration_count*30000)); -- SVG added
473: p_block_array(l_block_ind).TYPE := 'RANGE';
474: p_block_array(l_block_ind).MEASURE := NULL;
475: p_block_array(l_block_ind).UNIT_OF_MEASURE := 'HOURS';
476: p_block_array(l_block_ind).START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_date);
477: p_block_array(l_block_ind).STOP_TIME := TO_CHAR(p_end_date,'YYYY/MM/DD ')||'23:59:59';
478: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_ID := NULL;
479: p_block_array(l_block_ind).PARENT_IS_NEW := NULL;
480: p_block_array(l_block_ind).SCOPE := 'TIMECARD';

Line 486: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);

482: p_block_array(l_block_ind).APPROVAL_STATUS := NULL;
483: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
484: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
485: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
486: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
487: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
488: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
489: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
490: p_block_array(l_block_ind).NEW := 'Y';

Line 487: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

483: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
484: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
485: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
486: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
487: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
488: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
489: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
490: p_block_array(l_block_ind).NEW := 'Y';
491: p_block_array(l_block_ind).CHANGED := 'Y';

Line 721: p_block_array(l_block_ind).START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_date);

717: p_block_array(l_block_ind).TIME_BUILDING_BLOCK_ID := -2;
718: p_block_array(l_block_ind).TYPE := 'RANGE';
719: p_block_array(l_block_ind).MEASURE := NULL;
720: p_block_array(l_block_ind).UNIT_OF_MEASURE := 'HOURS';
721: p_block_array(l_block_ind).START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_date);
722: p_block_array(l_block_ind).STOP_TIME := TO_CHAR(p_end_date,'YYYY/MM/DD ')||'23:59:59';
723: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_ID := NULL;
724: p_block_array(l_block_ind).PARENT_IS_NEW := NULL;
725: p_block_array(l_block_ind).SCOPE := 'TIMECARD';

Line 731: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);

727: p_block_array(l_block_ind).APPROVAL_STATUS := NULL;
728: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
729: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
730: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
731: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
732: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
733: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
734: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
735: p_block_array(l_block_ind).NEW := 'Y';

Line 732: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

728: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
729: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
730: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
731: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
732: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
733: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
734: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
735: p_block_array(l_block_ind).NEW := 'Y';
736: p_block_array(l_block_ind).CHANGED := 'Y';

Line 954: l_block_type.START_TIME := FND_DATE.DATE_TO_CANONICAL(p_date);

950:
951: l_block_type.TIME_BUILDING_BLOCK_ID := p_bb_id;
952: l_block_type.TYPE := 'RANGE';
953: l_block_type.UNIT_OF_MEASURE := 'HOURS';
954: l_block_type.START_TIME := FND_DATE.DATE_TO_CANONICAL(p_date);
955: l_block_type.STOP_TIME := TO_CHAR(p_date,'YYYY/MM/DD ')||'23:59:59';
956: l_block_type.PARENT_BUILDING_BLOCK_ID := p_timecard_id;
957: l_block_type.SCOPE := 'DAY';
958: l_block_type.OBJECT_VERSION_NUMBER := 1;

Line 962: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);

958: l_block_type.OBJECT_VERSION_NUMBER := 1;
959: l_block_type.RESOURCE_ID := p_person_id;
960: l_block_type.RESOURCE_TYPE := 'PERSON';
961: l_block_type.APPROVAL_STYLE_ID := p_approval_style_id;
962: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
963: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
964: l_block_type.PARENT_BUILDING_BLOCK_OVN := 1;
965: l_block_type.NEW := 'Y';
966: l_block_type.CHANGED := 'Y';

Line 963: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

959: l_block_type.RESOURCE_ID := p_person_id;
960: l_block_type.RESOURCE_TYPE := 'PERSON';
961: l_block_type.APPROVAL_STYLE_ID := p_approval_style_id;
962: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
963: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
964: l_block_type.PARENT_BUILDING_BLOCK_OVN := 1;
965: l_block_type.NEW := 'Y';
966: l_block_type.CHANGED := 'Y';
967: l_block_type.PROCESS := NULL;

Line 1009: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);

1005: l_block_type.OBJECT_VERSION_NUMBER := p_bb_ovn;
1006: l_block_type.RESOURCE_ID := p_person_id;
1007: l_block_type.RESOURCE_TYPE := 'PERSON';
1008: l_block_type.APPROVAL_STYLE_ID := p_approval_style_id;
1009: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
1010: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(p_date_to);
1011: l_block_type.PARENT_BUILDING_BLOCK_OVN := 1;
1012: l_block_type.NEW := 'Y';
1013: l_block_type.CHANGED := 'Y';

Line 1010: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(p_date_to);

1006: l_block_type.RESOURCE_ID := p_person_id;
1007: l_block_type.RESOURCE_TYPE := 'PERSON';
1008: l_block_type.APPROVAL_STYLE_ID := p_approval_style_id;
1009: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
1010: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(p_date_to);
1011: l_block_type.PARENT_BUILDING_BLOCK_OVN := 1;
1012: l_block_type.NEW := 'Y';
1013: l_block_type.CHANGED := 'Y';
1014: l_block_type.PROCESS := NULL;

Line 1025: l_block_type.START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_time);

1021: IF p_start_time IS NOT NULL
1022: THEN
1023: l_block_type.TYPE := 'RANGE';
1024: l_block_type.MEASURE := NULL;
1025: l_block_type.START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_time);
1026: l_block_type.STOP_TIME := FND_DATE.DATE_TO_CANONICAL(p_stop_time);
1027: ELSE
1028: l_block_type.TYPE := 'MEASURE';
1029: l_block_type.MEASURE := p_measure;

Line 1026: l_block_type.STOP_TIME := FND_DATE.DATE_TO_CANONICAL(p_stop_time);

1022: THEN
1023: l_block_type.TYPE := 'RANGE';
1024: l_block_type.MEASURE := NULL;
1025: l_block_type.START_TIME := FND_DATE.DATE_TO_CANONICAL(p_start_time);
1026: l_block_type.STOP_TIME := FND_DATE.DATE_TO_CANONICAL(p_stop_time);
1027: ELSE
1028: l_block_type.TYPE := 'MEASURE';
1029: l_block_type.MEASURE := p_measure;
1030: l_block_type.START_TIME := NULL;

Line 1325: fnd_date.canonical_to_date(p_start_date), --TO_DATE(p_start_date,'yyyy/mm/dd'),

1321:
1322: BEGIN
1323:
1324: get_abs_statuses( p_person_id,
1325: fnd_date.canonical_to_date(p_start_date), --TO_DATE(p_start_date,'yyyy/mm/dd'),
1326: fnd_date.canonical_to_date(p_end_date), --TO_DATE(p_end_date,'yyyy/mm/dd'),
1327: l_abs_status_tab);
1328:
1329: p_abs_status_tab := HXC_ABS_STATUS_TABLE();

Line 1326: fnd_date.canonical_to_date(p_end_date), --TO_DATE(p_end_date,'yyyy/mm/dd'),

1322: BEGIN
1323:
1324: get_abs_statuses( p_person_id,
1325: fnd_date.canonical_to_date(p_start_date), --TO_DATE(p_start_date,'yyyy/mm/dd'),
1326: fnd_date.canonical_to_date(p_end_date), --TO_DATE(p_end_date,'yyyy/mm/dd'),
1327: l_abs_status_tab);
1328:
1329: p_abs_status_tab := HXC_ABS_STATUS_TABLE();
1330:

Line 1701: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);

1697: p_blocks(l_index).TIME_BUILDING_BLOCK_ID := l_block_array(l_index).TIME_BUILDING_BLOCK_ID;
1698: p_blocks(l_index).TYPE := l_block_array(l_index).TYPE;
1699: p_blocks(l_index).measure := l_block_array(l_index).measure;
1700: p_blocks(l_index).unit_of_measure := l_block_array(l_index).unit_of_measure;
1701: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);
1702: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);
1703: p_blocks(l_index).parent_building_block_id := l_block_array(l_index).parent_building_block_id;
1704: p_blocks(l_index).parent_is_new := l_block_array(l_index).parent_is_new;
1705: p_blocks(l_index).SCOPE := l_block_array(l_index).SCOPE;

Line 1702: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);

1698: p_blocks(l_index).TYPE := l_block_array(l_index).TYPE;
1699: p_blocks(l_index).measure := l_block_array(l_index).measure;
1700: p_blocks(l_index).unit_of_measure := l_block_array(l_index).unit_of_measure;
1701: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);
1702: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);
1703: p_blocks(l_index).parent_building_block_id := l_block_array(l_index).parent_building_block_id;
1704: p_blocks(l_index).parent_is_new := l_block_array(l_index).parent_is_new;
1705: p_blocks(l_index).SCOPE := l_block_array(l_index).SCOPE;
1706: p_blocks(l_index).object_version_number := l_block_array(l_index).object_version_number;

Line 1711: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);

1707: p_blocks(l_index).approval_status := l_block_array(l_index).approval_status;
1708: p_blocks(l_index).resource_id := l_block_array(l_index).resource_id;
1709: p_blocks(l_index).resource_type := l_block_array(l_index).resource_type;
1710: p_blocks(l_index).approval_style_id := l_block_array(l_index).approval_style_id;
1711: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);
1712: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);
1713: p_blocks(l_index).comment_text := l_block_array(l_index).comment_text;
1714: p_blocks(l_index).parent_building_block_ovn := l_block_array(l_index).parent_building_block_ovn;
1715: p_blocks(l_index).NEW := l_block_array(l_index).NEW;

Line 1712: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);

1708: p_blocks(l_index).resource_id := l_block_array(l_index).resource_id;
1709: p_blocks(l_index).resource_type := l_block_array(l_index).resource_type;
1710: p_blocks(l_index).approval_style_id := l_block_array(l_index).approval_style_id;
1711: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);
1712: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);
1713: p_blocks(l_index).comment_text := l_block_array(l_index).comment_text;
1714: p_blocks(l_index).parent_building_block_ovn := l_block_array(l_index).parent_building_block_ovn;
1715: p_blocks(l_index).NEW := l_block_array(l_index).NEW;
1716: p_blocks(l_index).changed := l_block_array(l_index).changed;

Line 1852: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);

1848: p_blocks(l_index).TIME_BUILDING_BLOCK_ID := l_block_array(l_index).TIME_BUILDING_BLOCK_ID;
1849: p_blocks(l_index).TYPE := l_block_array(l_index).TYPE;
1850: p_blocks(l_index).measure := l_block_array(l_index).measure;
1851: p_blocks(l_index).unit_of_measure := l_block_array(l_index).unit_of_measure;
1852: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);
1853: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);
1854: p_blocks(l_index).parent_building_block_id := l_block_array(l_index).parent_building_block_id;
1855: p_blocks(l_index).parent_is_new := l_block_array(l_index).parent_is_new;
1856: p_blocks(l_index).SCOPE := l_block_array(l_index).SCOPE;

Line 1853: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);

1849: p_blocks(l_index).TYPE := l_block_array(l_index).TYPE;
1850: p_blocks(l_index).measure := l_block_array(l_index).measure;
1851: p_blocks(l_index).unit_of_measure := l_block_array(l_index).unit_of_measure;
1852: p_blocks(l_index).start_time := fnd_date.canonical_to_date(l_block_array(l_index).start_time);
1853: p_blocks(l_index).stop_time := fnd_date.canonical_to_date(l_block_array(l_index).stop_time);
1854: p_blocks(l_index).parent_building_block_id := l_block_array(l_index).parent_building_block_id;
1855: p_blocks(l_index).parent_is_new := l_block_array(l_index).parent_is_new;
1856: p_blocks(l_index).SCOPE := l_block_array(l_index).SCOPE;
1857: p_blocks(l_index).object_version_number := l_block_array(l_index).object_version_number;

Line 1862: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);

1858: p_blocks(l_index).approval_status := l_block_array(l_index).approval_status;
1859: p_blocks(l_index).resource_id := l_block_array(l_index).resource_id;
1860: p_blocks(l_index).resource_type := l_block_array(l_index).resource_type;
1861: p_blocks(l_index).approval_style_id := l_block_array(l_index).approval_style_id;
1862: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);
1863: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);
1864: p_blocks(l_index).comment_text := l_block_array(l_index).comment_text;
1865: p_blocks(l_index).parent_building_block_ovn := l_block_array(l_index).parent_building_block_ovn;
1866: p_blocks(l_index).NEW := l_block_array(l_index).NEW;

Line 1863: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);

1859: p_blocks(l_index).resource_id := l_block_array(l_index).resource_id;
1860: p_blocks(l_index).resource_type := l_block_array(l_index).resource_type;
1861: p_blocks(l_index).approval_style_id := l_block_array(l_index).approval_style_id;
1862: p_blocks(l_index).date_from := fnd_date.canonical_to_date(l_block_array(l_index).date_from);
1863: p_blocks(l_index).date_to := fnd_date.canonical_to_date(l_block_array(l_index).date_to);
1864: p_blocks(l_index).comment_text := l_block_array(l_index).comment_text;
1865: p_blocks(l_index).parent_building_block_ovn := l_block_array(l_index).parent_building_block_ovn;
1866: p_blocks(l_index).NEW := l_block_array(l_index).NEW;
1867: p_blocks(l_index).changed := l_block_array(l_index).changed;

Line 2034: l_day_id_tab(FND_DATE.DATE_TO_CANONICAL(l_abs_tab(l_index).abs_date)),

2030: l_abs_tab(l_index).abs_end,
2031: l_abs_tab(l_index).duration,
2032: p_person_id,
2033: p_approval_style_id,
2034: l_day_id_tab(FND_DATE.DATE_TO_CANONICAL(l_abs_tab(l_index).abs_date)),
2035: l_det_id,
2036: 1,
2037: TRUNC(hr_general.end_of_time));
2038: p_attribute_array(l_att_ind) := get_attribute_for_detail(l_det_id,

Line 2601: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,

2597: IS
2598: SELECT time_building_block_id,
2599: element_type_id,
2600: DECODE(uom,'D',measure,NULL) measure,
2601: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2602: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2603: TRUNC(start_date) abs_date,
2604: 'N' validated
2605: FROM hxc_abs_co_details

Line 2602: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,

2598: SELECT time_building_block_id,
2599: element_type_id,
2600: DECODE(uom,'D',measure,NULL) measure,
2601: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2602: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2603: TRUNC(start_date) abs_date,
2604: 'N' validated
2605: FROM hxc_abs_co_details
2606: WHERE start_time = p_start_time

Line 2658: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,

2654: p_stop_time IN DATE)
2655: IS SELECT time_building_block_id,
2656: element_type_id,
2657: DECODE(uom,'D',measure,NULL) measure,
2658: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2659: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2660: TRUNC(start_date) abs_date,
2661: 'N' validated
2662: FROM hxc_abs_co_details

Line 2659: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,

2655: IS SELECT time_building_block_id,
2656: element_type_id,
2657: DECODE(uom,'D',measure,NULL) measure,
2658: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2659: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2660: TRUNC(start_date) abs_date,
2661: 'N' validated
2662: FROM hxc_abs_co_details
2663: WHERE resource_id = p_resource_id

Line 3088: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)

3084: EXIT WHEN NOT p_usertab.EXISTS(i);
3085: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3086: THEN
3087: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3088: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3089: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3090: ELSE
3091: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3092: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +

Line 3089: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);

3085: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3086: THEN
3087: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3088: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3089: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3090: ELSE
3091: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3092: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3093: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

Line 3093: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

3089: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3090: ELSE
3091: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3092: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3093: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3094: )
3095: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3096: )
3097: )*24

Line 3095: - FND_DATE.canonical_to_date(p_usertab(i).start_time

3091: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3092: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3093: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3094: )
3095: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3096: )
3097: )*24
3098: );
3099:

Line 3119: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)

3115: EXIT WHEN NOT p_pendtab.EXISTS(i);
3116: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3117: THEN
3118: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3119: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3120: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3121: ELSE
3122: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3123: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +

Line 3120: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);

3116: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3117: THEN
3118: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3119: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3120: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3121: ELSE
3122: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3123: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3124: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

Line 3124: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

3120: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3121: ELSE
3122: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3123: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3124: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3125: )
3126: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3127: )
3128: )*24

Line 3126: - FND_DATE.canonical_to_date(p_pendtab(i).start_time

3122: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3123: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3124: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3125: )
3126: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3127: )
3128: )*24
3129: );
3130:

Line 3204: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)

3200: THEN
3201: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3202: THEN
3203: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3204: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3205: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3206: ELSE
3207: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3208: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +

Line 3205: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);

3201: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3202: THEN
3203: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3204: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3205: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3206: ELSE
3207: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3208: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3209: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

Line 3209: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

3205: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3206: ELSE
3207: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3208: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3209: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3210: )
3211: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3212: )
3213: )*24

Line 3211: - FND_DATE.canonical_to_date(p_usertab(i).start_time

3207: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3208: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3209: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3210: )
3211: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3212: )
3213: )*24
3214: );
3215:

Line 3230: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)

3226:
3227: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3228: THEN
3229: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3230: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3231: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3232: ELSE
3233: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3234: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +

Line 3231: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);

3227: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3228: THEN
3229: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3230: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3231: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3232: ELSE
3233: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3234: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3235: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

Line 3235: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

3231: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3232: ELSE
3233: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3234: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3235: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3236: )
3237: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3238: )
3239: )*24

Line 3237: - FND_DATE.canonical_to_date(p_pendtab(i).start_time

3233: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3234: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3235: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3236: )
3237: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3238: )
3239: )*24
3240: );
3241:

Line 3302: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)

3298: THEN
3299: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3300: THEN
3301: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3302: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3303: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3304: ELSE
3305: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3306: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +

Line 3303: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);

3299: IF NOT l_tottab.EXISTS(get_absence_id(p_usertab(i).element_type_id))
3300: THEN
3301: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3302: := NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time)
3303: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3304: ELSE
3305: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3306: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3307: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

Line 3307: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time

3303: -FND_DATE.canonical_to_date(p_usertab(i).start_time))*24);
3304: ELSE
3305: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3306: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3307: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3308: )
3309: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3310: )
3311: )*24

Line 3309: - FND_DATE.canonical_to_date(p_usertab(i).start_time

3305: l_tottab(get_absence_id(p_usertab(i).element_type_id))
3306: := l_tottab(get_absence_id(p_usertab(i).element_type_id)) +
3307: NVL(p_usertab(i).measure,(FND_DATE.canonical_to_date(p_usertab(i).stop_time
3308: )
3309: - FND_DATE.canonical_to_date(p_usertab(i).start_time
3310: )
3311: )*24
3312: );
3313:

Line 3328: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)

3324:
3325: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3326: THEN
3327: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3328: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3329: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3330: ELSE
3331: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3332: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +

Line 3329: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);

3325: IF NOT l_tottab.EXISTS(get_absence_id(p_pendtab(i).element_type_id))
3326: THEN
3327: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3328: := NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time)
3329: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3330: ELSE
3331: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3332: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3333: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

Line 3333: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time

3329: -FND_DATE.canonical_to_date(p_pendtab(i).start_time))*24);
3330: ELSE
3331: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3332: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3333: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3334: )
3335: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3336: )
3337: )*24

Line 3335: - FND_DATE.canonical_to_date(p_pendtab(i).start_time

3331: l_tottab(get_absence_id(p_pendtab(i).element_type_id))
3332: := l_tottab(get_absence_id(p_pendtab(i).element_type_id)) +
3333: NVL(p_pendtab(i).measure,(FND_DATE.canonical_to_date(p_pendtab(i).stop_time
3334: )
3335: - FND_DATE.canonical_to_date(p_pendtab(i).start_time
3336: )
3337: )*24
3338: );
3339:

Line 3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time

3454: LOOP
3455: IF p_blocks(i).scope = 'TIMECARD'
3456: -- Bug 8858587
3457: -- Dont do any of these in case the timecard is going to be deleted.
3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time
3459: THEN
3460: hxc_preference_evaluation.resource_preferences(p_blocks(i).resource_id,
3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),

Line 3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),

3457: -- Dont do any of these in case the timecard is going to be deleted.
3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time
3459: THEN
3460: hxc_preference_evaluation.resource_preferences(p_blocks(i).resource_id,
3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3463: l_pref_table);
3464: l_start_time := FND_DATE.canonical_to_date(p_blocks(i).start_time);
3465: l_stop_time := FND_DATE.canonical_to_date(p_blocks(i).stop_time);

Line 3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),

3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time
3459: THEN
3460: hxc_preference_evaluation.resource_preferences(p_blocks(i).resource_id,
3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3463: l_pref_table);
3464: l_start_time := FND_DATE.canonical_to_date(p_blocks(i).start_time);
3465: l_stop_time := FND_DATE.canonical_to_date(p_blocks(i).stop_time);
3466: l_resource_id := p_blocks(i).resource_id;

Line 3464: l_start_time := FND_DATE.canonical_to_date(p_blocks(i).start_time);

3460: hxc_preference_evaluation.resource_preferences(p_blocks(i).resource_id,
3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3463: l_pref_table);
3464: l_start_time := FND_DATE.canonical_to_date(p_blocks(i).start_time);
3465: l_stop_time := FND_DATE.canonical_to_date(p_blocks(i).stop_time);
3466: l_resource_id := p_blocks(i).resource_id;
3467: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3468: END IF;

Line 3465: l_stop_time := FND_DATE.canonical_to_date(p_blocks(i).stop_time);

3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3463: l_pref_table);
3464: l_start_time := FND_DATE.canonical_to_date(p_blocks(i).start_time);
3465: l_stop_time := FND_DATE.canonical_to_date(p_blocks(i).stop_time);
3466: l_resource_id := p_blocks(i).resource_id;
3467: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3468: END IF;
3469: IF g_debug

Line 3478: l_daytab(p_blocks(i).time_building_block_id) := TRUNC(fnd_date.canonical_to_date(p_blocks(i).start_time));

3474: END IF;
3475:
3476: IF p_blocks(i).scope = 'DAY'
3477: THEN
3478: l_daytab(p_blocks(i).time_building_block_id) := TRUNC(fnd_date.canonical_to_date(p_blocks(i).start_time));
3479: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3480: END IF;
3481:
3482: IF p_blocks(i).SCOPE <> 'DETAIL'

Line 3483: OR FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) <> hr_general.end_of_time

3479: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3480: END IF;
3481:
3482: IF p_blocks(i).SCOPE <> 'DETAIL'
3483: OR FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) <> hr_general.end_of_time
3484: THEN
3485: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3486: END IF;
3487: bb_index := p_blocks(i).time_building_block_id;

Line 4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'

4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;

Line 4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));

4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;
4067:

Line 4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'

4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;
4067:
4068: l_abs_hours := l_abs_hours +

Line 4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));

4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;
4067:
4068: l_abs_hours := l_abs_hours +
4069: hxc_find_notify_aprs_pkg.apply_round_rule(

Line 4072: nvl((FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) -

4068: l_abs_hours := l_abs_hours +
4069: hxc_find_notify_aprs_pkg.apply_round_rule(
4070: l_rounding_rule,
4071: l_precision,
4072: nvl((FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) -
4073: FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time))*24,0)
4074: );
4075: END IF;
4076:

Line 4073: FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time))*24,0)

4069: hxc_find_notify_aprs_pkg.apply_round_rule(
4070: l_rounding_rule,
4071: l_precision,
4072: nvl((FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) -
4073: FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time))*24,0)
4074: );
4075: END IF;
4076:
4077: j := l_abs_tot_tab.NEXT(j);