DBA Data[Home] [Help]

APPS.HXC_ELP_UTILS dependencies on FND_DATE

Line 433: AND P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO = fnd_date.date_to_canonical(hr_general.end_of_time)

429: AND P_TIME_BUILDING_BLOCKS (l_index_det).parent_building_block_id =
430: P_TIME_BUILDING_BLOCKS (l_index_day).time_building_block_id
431: AND P_TIME_BUILDING_BLOCKS (l_index_det).parent_building_block_ovn =
432: P_TIME_BUILDING_BLOCKS (l_index_day).object_version_number
433: AND P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO = fnd_date.date_to_canonical(hr_general.end_of_time)
434: AND P_TIME_BUILDING_BLOCKS (l_index_det).OBJECT_VERSION_NUMBER <> -9999
435: )
436: THEN
437:

Line 1093: ,fnd_date.date_to_canonical(hr_general.end_of_time)

1089: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_ID
1090: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_TYPE
1091: ,P_TIME_BUILDING_BLOCKS (l_index_det).APPROVAL_STYLE_ID
1092: ,P_TIME_BUILDING_BLOCKS (l_index_det).DATE_FROM
1093: ,fnd_date.date_to_canonical(hr_general.end_of_time)
1094: ,P_TIME_BUILDING_BLOCKS (l_index_det).COMMENT_TEXT
1095: ,P_TIME_BUILDING_BLOCKS (l_index_det).PARENT_BUILDING_BLOCK_OVN
1096: ,'Y'
1097: ,'N'

Line 1121: ,fnd_date.date_to_canonical(hr_general.end_of_time)

1117: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_ID
1118: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_TYPE
1119: ,P_TIME_BUILDING_BLOCKS (l_index_det).APPROVAL_STYLE_ID
1120: ,P_TIME_BUILDING_BLOCKS (l_index_det).DATE_FROM
1121: ,fnd_date.date_to_canonical(hr_general.end_of_time)
1122: ,P_TIME_BUILDING_BLOCKS (l_index_det).COMMENT_TEXT
1123: ,P_TIME_BUILDING_BLOCKS (l_index_det).PARENT_BUILDING_BLOCK_OVN
1124: ,'Y'
1125: ,'N'

Line 1139: P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO := fnd_date.date_to_canonical(sysdate);

1135: -- with the application set id as the one for dropped time recipients.
1136: --
1137: l_next_blk_ovn := 1;
1138: P_TIME_BUILDING_BLOCKS (l_index_det).MEASURE := null;
1139: P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO := fnd_date.date_to_canonical(sysdate);
1140: -- ksethi fix for bug 3831067
1141: -- Comment the following line.
1142: -- P_TIME_BUILDING_BLOCKS (l_index_det).application_set_id := temp_app_set_drops(l_index_drops).application_set_id;
1143: l_rev_application_set_id := 'Y';