379: ,p_entry_information30 => p_entry_information30
380: ,p_override_user_ent_chk => p_override_user_ent_chk
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_ELEMENT_ENTRY'
386: ,p_hook_type => 'BP'
387: );
380: ,p_override_user_ent_chk => p_override_user_ent_chk
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_ELEMENT_ENTRY'
386: ,p_hook_type => 'BP'
387: );
388: end;
861: ,p_object_version_number => l_object_version_number
862: ,p_create_warning => l_create_warning
863: );
864: exception
865: when hr_api.cannot_find_prog_unit then
866: hr_api.cannot_find_prog_unit_error
867: (p_module_name => 'CREATE_ELEMENT_ENTRY'
868: ,p_hook_type => 'AP'
869: );
862: ,p_create_warning => l_create_warning
863: );
864: exception
865: when hr_api.cannot_find_prog_unit then
866: hr_api.cannot_find_prog_unit_error
867: (p_module_name => 'CREATE_ELEMENT_ENTRY'
868: ,p_hook_type => 'AP'
869: );
870: end;
869: );
870: end;
871: --
872: IF p_validate THEN
873: RAISE hr_api.validate_enabled;
874: END IF;
875: --
876: -- Set all output arguments
877: --
885: hr_utility.set_location(' Leaving:'||l_proc, 11);
886: end if;
887: --
888: EXCEPTION
889: WHEN hr_api.validate_enabled THEN
890: --
891: -- As the Validate_Enabled exception has been raised
892: -- we must rollback to the savepoint
893: --
990: ,p_element_entry_id => p_element_entry_id
991: ,p_object_version_number => p_object_version_number
992: );
993: exception
994: when hr_api.cannot_find_prog_unit then
995: hr_api.cannot_find_prog_unit_error
996: (p_module_name => 'DELETE_ELEMENT_ENTRY'
997: ,p_hook_type => 'BP'
998: );
991: ,p_object_version_number => p_object_version_number
992: );
993: exception
994: when hr_api.cannot_find_prog_unit then
995: hr_api.cannot_find_prog_unit_error
996: (p_module_name => 'DELETE_ELEMENT_ENTRY'
997: ,p_hook_type => 'BP'
998: );
999: end;
1050: ,p_effective_end_date => l_effective_end_date
1051: ,p_delete_warning => p_delete_warning
1052: );
1053: exception
1054: when hr_api.cannot_find_prog_unit then
1055: hr_api.cannot_find_prog_unit_error
1056: (p_module_name => 'DELETE_ELEMENT_ENTRY'
1057: ,p_hook_type => 'AP'
1058: );
1051: ,p_delete_warning => p_delete_warning
1052: );
1053: exception
1054: when hr_api.cannot_find_prog_unit then
1055: hr_api.cannot_find_prog_unit_error
1056: (p_module_name => 'DELETE_ELEMENT_ENTRY'
1057: ,p_hook_type => 'AP'
1058: );
1059: end;
1060: --
1061: -- When in validation only mode raise the Validate_Enabled exception
1062: --
1063: IF p_validate THEN
1064: RAISE hr_api.validate_enabled;
1065: END IF;
1066: --
1067: -- Set all output arguments
1068: --
1074: if g_debug then
1075: hr_utility.set_location(' Leaving:'||l_proc, 11);
1076: end if;
1077: EXCEPTION
1078: WHEN hr_api.validate_enabled THEN
1079: --
1080: -- As the Validate_Enabled exception has been raised
1081: -- we must rollback to the savepoint
1082: --
1104: -- allowed for update and those fields are checked here
1105: procedure update_validate(
1106: p_element_entry_id in number
1107: ,p_effective_date in date
1108: ,p_creator_type in varchar2 default hr_api.g_varchar2
1109: ,p_creator_id in number default hr_api.g_number
1110: ,p_personal_payment_method_id in number default hr_api.g_number
1111: ,p_input_value_id1 in number default null
1112: ,p_input_value_id2 in number default null
1105: procedure update_validate(
1106: p_element_entry_id in number
1107: ,p_effective_date in date
1108: ,p_creator_type in varchar2 default hr_api.g_varchar2
1109: ,p_creator_id in number default hr_api.g_number
1110: ,p_personal_payment_method_id in number default hr_api.g_number
1111: ,p_input_value_id1 in number default null
1112: ,p_input_value_id2 in number default null
1113: ,p_input_value_id3 in number default null
1106: p_element_entry_id in number
1107: ,p_effective_date in date
1108: ,p_creator_type in varchar2 default hr_api.g_varchar2
1109: ,p_creator_id in number default hr_api.g_number
1110: ,p_personal_payment_method_id in number default hr_api.g_number
1111: ,p_input_value_id1 in number default null
1112: ,p_input_value_id2 in number default null
1113: ,p_input_value_id3 in number default null
1114: ,p_input_value_id4 in number default null
1157: select count(creator_type)
1158: from pay_element_entries_f
1159: where element_entry_id = c_element_entry_id
1160: and c_effective_date between effective_start_date and effective_end_date
1161: and ( (c_creator_type <> hr_api.g_varchar2
1162: and creator_type <> c_creator_type)
1163: or (c_creator_id <> hr_api.g_number
1164: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1165: )
1159: where element_entry_id = c_element_entry_id
1160: and c_effective_date between effective_start_date and effective_end_date
1161: and ( (c_creator_type <> hr_api.g_varchar2
1162: and creator_type <> c_creator_type)
1163: or (c_creator_id <> hr_api.g_number
1164: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1165: )
1166: )
1167: or (c_personal_payment_method_id <> hr_api.g_number
1163: or (c_creator_id <> hr_api.g_number
1164: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1165: )
1166: )
1167: or (c_personal_payment_method_id <> hr_api.g_number
1168: and (nvl(personal_payment_method_id, -1) <> nvl(c_personal_payment_method_id, -1)
1169: )
1170: )
1171: );
1321: ,p_effective_date in date
1322: ,p_business_group_id in number
1323: ,p_element_entry_id in number
1324: ,p_object_version_number in out nocopy number
1325: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1322: ,p_business_group_id in number
1323: ,p_element_entry_id in number
1324: ,p_object_version_number in out nocopy number
1325: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1323: ,p_element_entry_id in number
1324: ,p_object_version_number in out nocopy number
1325: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1324: ,p_object_version_number in out nocopy number
1325: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1325: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1326: ,p_updating_action_id in number default hr_api.g_number
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1327: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1328: ,p_original_entry_id in number default hr_api.g_number
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1329: ,p_creator_type in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1330: ,p_comment_id in number default hr_api.g_number
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1331: ,p_creator_id in number default hr_api.g_number
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1332: ,p_reason in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1333: ,p_subpriority in number default hr_api.g_number
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1334: ,p_date_earned in date default hr_api.g_date
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1335: ,p_personal_payment_method_id in number default hr_api.g_number
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1357: ,p_input_value_id1 in number default null
1350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1357: ,p_input_value_id1 in number default null
1358: ,p_input_value_id2 in number default null
1351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1357: ,p_input_value_id1 in number default null
1358: ,p_input_value_id2 in number default null
1359: ,p_input_value_id3 in number default null
1352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1357: ,p_input_value_id1 in number default null
1358: ,p_input_value_id2 in number default null
1359: ,p_input_value_id3 in number default null
1360: ,p_input_value_id4 in number default null
1383: ,p_entry_value12 in varchar2 default null
1384: ,p_entry_value13 in varchar2 default null
1385: ,p_entry_value14 in varchar2 default null
1386: ,p_entry_value15 in varchar2 default null
1387: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_value13 in varchar2 default null
1385: ,p_entry_value14 in varchar2 default null
1386: ,p_entry_value15 in varchar2 default null
1387: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_value14 in varchar2 default null
1386: ,p_entry_value15 in varchar2 default null
1387: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_value15 in varchar2 default null
1387: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1394: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1395: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1396: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1397: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1398: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1399: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1400: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1401: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1402: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1403: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1404: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1405: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1406: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1407: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1408: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1409: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1417: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1410: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1417: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1418: ,p_override_user_ent_chk in varchar2 default 'N'
1411: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1417: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1418: ,p_override_user_ent_chk in varchar2 default 'N'
1419: ,p_effective_start_date out nocopy date
1412: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1417: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1418: ,p_override_user_ent_chk in varchar2 default 'N'
1419: ,p_effective_start_date out nocopy date
1420: ,p_effective_end_date out nocopy date
1413: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1414: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1415: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1416: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1417: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1418: ,p_override_user_ent_chk in varchar2 default 'N'
1419: ,p_effective_start_date out nocopy date
1420: ,p_effective_end_date out nocopy date
1421: ,p_update_warning out nocopy boolean
1621: ,p_entry_information30 => p_entry_information30
1622: ,p_override_user_ent_chk => p_override_user_ent_chk
1623: );
1624: exception
1625: when hr_api.cannot_find_prog_unit then
1626: hr_api.cannot_find_prog_unit_error
1627: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1628: ,p_hook_type => 'BP'
1629: );
1622: ,p_override_user_ent_chk => p_override_user_ent_chk
1623: );
1624: exception
1625: when hr_api.cannot_find_prog_unit then
1626: hr_api.cannot_find_prog_unit_error
1627: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1628: ,p_hook_type => 'BP'
1629: );
1630: end;
1643: CLOSE c_link_details;
1644: --
1645: IF l_costable_type = 'N'
1646: AND p_cost_allocation_keyflex_id IS NOT NULL
1647: AND p_cost_allocation_keyflex_id <> hr_api.g_number THEN
1648: --
1649: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');
1650: hr_utility.set_warning;
1651: --
1667: CLOSE c_entry_details;
1668:
1669: IF l_creator_type = 'H' THEN
1670: l_creator_type := 'F';
1671: IF p_creator_id = hr_api.g_number THEN
1672: l_creator_id := NULL;
1673: END IF;
1674: END IF;
1675:
2013: ,p_effective_end_date => l_effective_end_date
2014: ,p_update_warning => p_update_warning
2015: );
2016: exception
2017: when hr_api.cannot_find_prog_unit then
2018: hr_api.cannot_find_prog_unit_error
2019: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
2020: ,p_hook_type => 'AP'
2021: );
2014: ,p_update_warning => p_update_warning
2015: );
2016: exception
2017: when hr_api.cannot_find_prog_unit then
2018: hr_api.cannot_find_prog_unit_error
2019: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
2020: ,p_hook_type => 'AP'
2021: );
2022: end;
2023: --
2024: -- When in validation only mode raise the Validate_Enabled exception
2025: --
2026: IF p_validate THEN
2027: RAISE hr_api.validate_enabled;
2028: END IF;
2029: --
2030: -- Set all output arguments
2031: --
2038: if g_debug then
2039: hr_utility.set_location(' Leaving:'||l_proc, 11);
2040: end if;
2041: EXCEPTION
2042: WHEN hr_api.validate_enabled THEN
2043: --
2044: -- As the Validate_Enabled exception has been raised
2045: -- we must rollback to the savepoint
2046: --