DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on FND_DATE

Line 3642: l_start_time DATE := fnd_date.canonical_to_date(P_START_TIME);

3638:
3639:
3640: l_building_block_id NUMBER := to_number(P_TIME_BUILDING_BLOCK_ID);
3641: l_measure NUMBER := to_number(P_MEASURE);
3642: l_start_time DATE := fnd_date.canonical_to_date(P_START_TIME);
3643: l_stop_time DATE := fnd_date.canonical_to_date(P_STOP_TIME);
3644: l_parent_building_block_id NUMBER := to_number(P_PARENT_BUILDING_BLOCK_ID);
3645: l_object_version_number NUMBER := to_number(P_OBJECT_VERSION_NUMBER);
3646: l_resource_id NUMBER := to_number(P_RESOURCE_ID);

Line 3643: l_stop_time DATE := fnd_date.canonical_to_date(P_STOP_TIME);

3639:
3640: l_building_block_id NUMBER := to_number(P_TIME_BUILDING_BLOCK_ID);
3641: l_measure NUMBER := to_number(P_MEASURE);
3642: l_start_time DATE := fnd_date.canonical_to_date(P_START_TIME);
3643: l_stop_time DATE := fnd_date.canonical_to_date(P_STOP_TIME);
3644: l_parent_building_block_id NUMBER := to_number(P_PARENT_BUILDING_BLOCK_ID);
3645: l_object_version_number NUMBER := to_number(P_OBJECT_VERSION_NUMBER);
3646: l_resource_id NUMBER := to_number(P_RESOURCE_ID);
3647: l_approval_style_id NUMBER := to_number(P_APPROVAL_STYLE_ID);

Line 3648: l_date_from DATE := fnd_date.canonical_to_date(P_DATE_FROM);

3644: l_parent_building_block_id NUMBER := to_number(P_PARENT_BUILDING_BLOCK_ID);
3645: l_object_version_number NUMBER := to_number(P_OBJECT_VERSION_NUMBER);
3646: l_resource_id NUMBER := to_number(P_RESOURCE_ID);
3647: l_approval_style_id NUMBER := to_number(P_APPROVAL_STYLE_ID);
3648: l_date_from DATE := fnd_date.canonical_to_date(P_DATE_FROM);
3649: l_date_to DATE := fnd_date.canonical_to_date(P_DATE_TO);
3650: l_parent_building_block_ovn NUMBER := to_number(P_PARENT_BUILDING_BLOCK_OVN);
3651: l_proc VARCHAR2(30):= 'CALL_BLOCK_DEPOSIT';
3652:

Line 3649: l_date_to DATE := fnd_date.canonical_to_date(P_DATE_TO);

3645: l_object_version_number NUMBER := to_number(P_OBJECT_VERSION_NUMBER);
3646: l_resource_id NUMBER := to_number(P_RESOURCE_ID);
3647: l_approval_style_id NUMBER := to_number(P_APPROVAL_STYLE_ID);
3648: l_date_from DATE := fnd_date.canonical_to_date(P_DATE_FROM);
3649: l_date_to DATE := fnd_date.canonical_to_date(P_DATE_TO);
3650: l_parent_building_block_ovn NUMBER := to_number(P_PARENT_BUILDING_BLOCK_OVN);
3651: l_proc VARCHAR2(30):= 'CALL_BLOCK_DEPOSIT';
3652:
3653: