498: application_id = p_application_id and
499: p_effective_date between start_date and
500: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
501: begin
502: hr_api.mandatory_arg_error
503: (p_api_name => l_proc
504: ,p_argument => 'application_id'
505: ,p_argument_value => p_application_id
506: );
1216: --
1217: -- {End Of Comments}
1218: -- ----------------------------------------------------------------------------
1219: Procedure dt_update_validate
1220: (p_attribute_id in number default hr_api.g_number
1221: ,p_datetrack_mode in varchar2
1222: ,p_validation_start_date in date
1223: ,p_validation_end_date in date
1224: ) Is
1228: Begin
1229: --
1230: -- Ensure that the p_datetrack_mode argument is not null
1231: --
1232: hr_api.mandatory_arg_error
1233: (p_api_name => l_proc
1234: ,p_argument => 'datetrack_mode'
1235: ,p_argument_value => p_datetrack_mode
1236: );
1238: -- Mode will be valid, as this is checked at the start of the upd.
1239: --
1240: -- Ensure the arguments are not null
1241: --
1242: hr_api.mandatory_arg_error
1243: (p_api_name => l_proc
1244: ,p_argument => 'validation_start_date'
1245: ,p_argument_value => p_validation_start_date
1246: );
1244: ,p_argument => 'validation_start_date'
1245: ,p_argument_value => p_validation_start_date
1246: );
1247: --
1248: /*hr_api.mandatory_arg_error
1249: (p_api_name => l_proc
1250: ,p_argument => 'validation_end_date'
1251: ,p_argument_value => p_validation_end_date
1252: );*/
1311: Begin
1312: --
1313: -- Ensure that the p_datetrack_mode argument is not null
1314: --
1315: hr_api.mandatory_arg_error
1316: (p_api_name => l_proc
1317: ,p_argument => 'datetrack_mode'
1318: ,p_argument_value => p_datetrack_mode
1319: );
1320: --
1321: -- Only perform the validation if the datetrack mode is either
1322: -- DELETE or ZAP
1323: --
1324: If (p_datetrack_mode = hr_api.g_delete or
1325: p_datetrack_mode = hr_api.g_zap) then
1326: --
1327: --
1328: -- Ensure the arguments are not null
1321: -- Only perform the validation if the datetrack mode is either
1322: -- DELETE or ZAP
1323: --
1324: If (p_datetrack_mode = hr_api.g_delete or
1325: p_datetrack_mode = hr_api.g_zap) then
1326: --
1327: --
1328: -- Ensure the arguments are not null
1329: --
1326: --
1327: --
1328: -- Ensure the arguments are not null
1329: --
1330: hr_api.mandatory_arg_error
1331: (p_api_name => l_proc
1332: ,p_argument => 'validation_start_date'
1333: ,p_argument_value => p_validation_start_date
1334: );
1332: ,p_argument => 'validation_start_date'
1333: ,p_argument_value => p_validation_start_date
1334: );
1335: --
1336: /*hr_api.mandatory_arg_error
1337: (p_api_name => l_proc
1338: ,p_argument => 'validation_end_date'
1339: ,p_argument_value => p_validation_end_date
1340: );*/
1338: ,p_argument => 'validation_end_date'
1339: ,p_argument_value => p_validation_end_date
1340: );*/
1341: --
1342: hr_api.mandatory_arg_error
1343: (p_api_name => l_proc
1344: ,p_argument => 'attribute_id'
1345: ,p_argument_value => p_attribute_id
1346: );