DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on FND_DATE

Line 26: p_start_date => fnd_date.canonical_to_date

22: (p_props,
23: 'TsPerAuditRequirementsAuditRequirements',
24: NULL,
25: NULL,
26: p_start_date => fnd_date.canonical_to_date
27: (p_blocks
28: (hxc_timecard_block_utils.find_active_timecard_index
29: (p_blocks)
30: ).start_time

Line 32: p_stop_date => fnd_date.canonical_to_date

28: (hxc_timecard_block_utils.find_active_timecard_index
29: (p_blocks)
30: ).start_time
31: ),
32: p_stop_date => fnd_date.canonical_to_date
33: (p_blocks
34: (hxc_timecard_block_utils.find_active_timecard_index
35: (p_blocks)
36: ).stop_time

Line 232: fnd_date.canonical_to_date

228: hxc_timecard_approval.is_timecard_resubmitted
229: (p_blocks (l_timecard_index).time_building_block_id,
230: p_blocks (l_timecard_index).object_version_number,
231: p_blocks (l_timecard_index).resource_id,
232: fnd_date.canonical_to_date
233: (p_blocks (l_timecard_index).start_time
234: ),
235: fnd_date.canonical_to_date
236: (p_blocks (l_timecard_index).stop_time

Line 235: fnd_date.canonical_to_date

231: p_blocks (l_timecard_index).resource_id,
232: fnd_date.canonical_to_date
233: (p_blocks (l_timecard_index).start_time
234: ),
235: fnd_date.canonical_to_date
236: (p_blocks (l_timecard_index).stop_time
237: )
238: );
239: ELSE

Line 369: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;

365: l_timecard_index :=
366: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
367:
368: l_timecard_start_time :=
369: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;
370:
371: l_timecard_stop_time :=
372: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;
373:

Line 372: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;

368: l_timecard_start_time :=
369: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;
370:
371: l_timecard_stop_time :=
372: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;
373:
374: -- Bug 14828613
375: -- Added these initializations to take care of correct absence summary processing.
376:

Line 657: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);

653: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SAVE_TIMECARD');
654: END IF;
655:
656: l_resource_id := p_blocks (l_timecard_index).resource_id;
657: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);
658: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);
659: l_tc_status := p_blocks (l_timecard_index).approval_status;
660:
661: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,

Line 658: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);

654: END IF;
655:
656: l_resource_id := p_blocks (l_timecard_index).resource_id;
657: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);
658: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);
659: l_tc_status := p_blocks (l_timecard_index).approval_status;
660:
661: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,
662: l_start_date,

Line 806: fnd_date.canonical_to_date

802: hxc_timecard_approval.is_timecard_resubmitted
803: (p_blocks (l_timecard_index).time_building_block_id,
804: p_blocks (l_timecard_index).object_version_number,
805: p_blocks (l_timecard_index).resource_id,
806: fnd_date.canonical_to_date
807: (p_blocks (l_timecard_index).start_time
808: ),
809: fnd_date.canonical_to_date
810: (p_blocks (l_timecard_index).stop_time

Line 809: fnd_date.canonical_to_date

805: p_blocks (l_timecard_index).resource_id,
806: fnd_date.canonical_to_date
807: (p_blocks (l_timecard_index).start_time
808: ),
809: fnd_date.canonical_to_date
810: (p_blocks (l_timecard_index).stop_time
811: )
812: );
813: ELSE

Line 819: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;

815: END IF;
816:
817:
818: l_timecard_start_time :=
819: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;
820:
821: l_timecard_stop_time :=
822: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;
823:

Line 822: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;

818: l_timecard_start_time :=
819: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;
820:
821: l_timecard_stop_time :=
822: fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time) ;
823:
824:
825: -- Bug 14828613
826: -- Added these initializations to take care of correct absence summary processing.

Line 1163: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);

1159: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SUBMIT_TIMECARD');
1160: END IF;
1161:
1162: l_resource_id := p_blocks (l_timecard_index).resource_id;
1163: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);
1164: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);
1165: l_tc_status := p_blocks (l_timecard_index).approval_status;
1166:
1167: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,

Line 1164: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);

1160: END IF;
1161:
1162: l_resource_id := p_blocks (l_timecard_index).resource_id;
1163: l_start_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time);
1164: l_stop_date := fnd_date.canonical_to_date(p_blocks (l_timecard_index).stop_time);
1165: l_tc_status := p_blocks (l_timecard_index).approval_status;
1166:
1167: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,
1168: l_start_date,

Line 1355: fnd_date.date_to_canonical (p_blocks (l_index).start_time),

1351: (p_blocks (l_index).time_building_block_id,
1352: p_blocks (l_index).TYPE,
1353: p_blocks (l_index).measure,
1354: p_blocks (l_index).unit_of_measure,
1355: fnd_date.date_to_canonical (p_blocks (l_index).start_time),
1356: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),
1357: p_blocks (l_index).parent_building_block_id,
1358: p_blocks (l_index).parent_is_new,
1359: p_blocks (l_index).SCOPE,

Line 1356: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),

1352: p_blocks (l_index).TYPE,
1353: p_blocks (l_index).measure,
1354: p_blocks (l_index).unit_of_measure,
1355: fnd_date.date_to_canonical (p_blocks (l_index).start_time),
1356: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),
1357: p_blocks (l_index).parent_building_block_id,
1358: p_blocks (l_index).parent_is_new,
1359: p_blocks (l_index).SCOPE,
1360: p_blocks (l_index).object_version_number,

Line 1365: fnd_date.date_to_canonical (p_blocks (l_index).date_from),

1361: p_blocks (l_index).approval_status,
1362: p_blocks (l_index).resource_id,
1363: p_blocks (l_index).resource_type,
1364: p_blocks (l_index).approval_style_id,
1365: fnd_date.date_to_canonical (p_blocks (l_index).date_from),
1366: fnd_date.date_to_canonical (p_blocks (l_index).date_to),
1367: p_blocks (l_index).comment_text,
1368: p_blocks (l_index).parent_building_block_ovn,
1369: p_blocks (l_index).NEW,

Line 1366: fnd_date.date_to_canonical (p_blocks (l_index).date_to),

1362: p_blocks (l_index).resource_id,
1363: p_blocks (l_index).resource_type,
1364: p_blocks (l_index).approval_style_id,
1365: fnd_date.date_to_canonical (p_blocks (l_index).date_from),
1366: fnd_date.date_to_canonical (p_blocks (l_index).date_to),
1367: p_blocks (l_index).comment_text,
1368: p_blocks (l_index).parent_building_block_ovn,
1369: p_blocks (l_index).NEW,
1370: p_blocks (l_index).changed,

Line 2200: BETWEEN fnd_date.canonical_to_date

2196: EXIT WHEN (NOT p_app_blocks.EXISTS (l_building_block_count))
2197: OR (p_timecard_bb_id IS NOT NULL);
2198:
2199: IF (p_start_time
2200: BETWEEN fnd_date.canonical_to_date
2201: (p_app_blocks (l_building_block_count).start_time
2202: )
2203: AND fnd_date.canonical_to_date
2204: (p_app_blocks (l_building_block_count).stop_time

Line 2203: AND fnd_date.canonical_to_date

2199: IF (p_start_time
2200: BETWEEN fnd_date.canonical_to_date
2201: (p_app_blocks (l_building_block_count).start_time
2202: )
2203: AND fnd_date.canonical_to_date
2204: (p_app_blocks (l_building_block_count).stop_time
2205: )
2206: )
2207: AND (p_resource_type =

Line 3236: p_start_time => fnd_date.canonical_to_date

3232: THEN
3233: hxc_lock_api.request_lock
3234: (p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,
3235: p_resource_id => p_app_blocks (l_tc_index).resource_id,
3236: p_start_time => fnd_date.canonical_to_date
3237: (p_app_blocks (l_tc_index).start_time
3238: ),
3239: p_stop_time => fnd_date.canonical_to_date
3240: (p_app_blocks (l_tc_index).stop_time

Line 3239: p_stop_time => fnd_date.canonical_to_date

3235: p_resource_id => p_app_blocks (l_tc_index).resource_id,
3236: p_start_time => fnd_date.canonical_to_date
3237: (p_app_blocks (l_tc_index).start_time
3238: ),
3239: p_stop_time => fnd_date.canonical_to_date
3240: (p_app_blocks (l_tc_index).stop_time
3241: ),
3242: p_time_building_block_id => NULL,
3243: p_time_building_block_ovn => NULL,

Line 3308: p_start_time => fnd_date.canonical_to_date

3304: hxc_lock_api.release_lock
3305: (p_row_lock_id => p_row_lock_id,
3306: p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,
3307: p_resource_id => p_app_blocks (l_tc_index).resource_id,
3308: p_start_time => fnd_date.canonical_to_date
3309: (p_app_blocks (l_tc_index).start_time
3310: ),
3311: p_stop_time => fnd_date.canonical_to_date
3312: (p_app_blocks (l_tc_index).stop_time

Line 3311: p_stop_time => fnd_date.canonical_to_date

3307: p_resource_id => p_app_blocks (l_tc_index).resource_id,
3308: p_start_time => fnd_date.canonical_to_date
3309: (p_app_blocks (l_tc_index).start_time
3310: ),
3311: p_stop_time => fnd_date.canonical_to_date
3312: (p_app_blocks (l_tc_index).stop_time
3313: ),
3314: p_time_building_block_id => NULL,
3315: p_time_building_block_ovn => NULL,