355: ,p_entry_information30 => p_entry_information30
356: ,p_override_user_ent_chk => p_override_user_ent_chk
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'CREATE_ELEMENT_ENTRY'
362: ,p_hook_type => 'BP'
363: );
356: ,p_override_user_ent_chk => p_override_user_ent_chk
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'CREATE_ELEMENT_ENTRY'
362: ,p_hook_type => 'BP'
363: );
364: end;
837: ,p_object_version_number => l_object_version_number
838: ,p_create_warning => l_create_warning
839: );
840: exception
841: when hr_api.cannot_find_prog_unit then
842: hr_api.cannot_find_prog_unit_error
843: (p_module_name => 'CREATE_ELEMENT_ENTRY'
844: ,p_hook_type => 'AP'
845: );
838: ,p_create_warning => l_create_warning
839: );
840: exception
841: when hr_api.cannot_find_prog_unit then
842: hr_api.cannot_find_prog_unit_error
843: (p_module_name => 'CREATE_ELEMENT_ENTRY'
844: ,p_hook_type => 'AP'
845: );
846: end;
845: );
846: end;
847: --
848: IF p_validate THEN
849: RAISE hr_api.validate_enabled;
850: END IF;
851: --
852: -- Set all output arguments
853: --
861: hr_utility.set_location(' Leaving:'||l_proc, 11);
862: end if;
863: --
864: EXCEPTION
865: WHEN hr_api.validate_enabled THEN
866: --
867: -- As the Validate_Enabled exception has been raised
868: -- we must rollback to the savepoint
869: --
966: ,p_element_entry_id => p_element_entry_id
967: ,p_object_version_number => p_object_version_number
968: );
969: exception
970: when hr_api.cannot_find_prog_unit then
971: hr_api.cannot_find_prog_unit_error
972: (p_module_name => 'DELETE_ELEMENT_ENTRY'
973: ,p_hook_type => 'BP'
974: );
967: ,p_object_version_number => p_object_version_number
968: );
969: exception
970: when hr_api.cannot_find_prog_unit then
971: hr_api.cannot_find_prog_unit_error
972: (p_module_name => 'DELETE_ELEMENT_ENTRY'
973: ,p_hook_type => 'BP'
974: );
975: end;
1026: ,p_effective_end_date => l_effective_end_date
1027: ,p_delete_warning => p_delete_warning
1028: );
1029: exception
1030: when hr_api.cannot_find_prog_unit then
1031: hr_api.cannot_find_prog_unit_error
1032: (p_module_name => 'DELETE_ELEMENT_ENTRY'
1033: ,p_hook_type => 'AP'
1034: );
1027: ,p_delete_warning => p_delete_warning
1028: );
1029: exception
1030: when hr_api.cannot_find_prog_unit then
1031: hr_api.cannot_find_prog_unit_error
1032: (p_module_name => 'DELETE_ELEMENT_ENTRY'
1033: ,p_hook_type => 'AP'
1034: );
1035: end;
1036: --
1037: -- When in validation only mode raise the Validate_Enabled exception
1038: --
1039: IF p_validate THEN
1040: RAISE hr_api.validate_enabled;
1041: END IF;
1042: --
1043: -- Set all output arguments
1044: --
1050: if g_debug then
1051: hr_utility.set_location(' Leaving:'||l_proc, 11);
1052: end if;
1053: EXCEPTION
1054: WHEN hr_api.validate_enabled THEN
1055: --
1056: -- As the Validate_Enabled exception has been raised
1057: -- we must rollback to the savepoint
1058: --
1080: -- allowed for update and those fields are checked here
1081: procedure update_validate(
1082: p_element_entry_id in number
1083: ,p_effective_date in date
1084: ,p_creator_type in varchar2 default hr_api.g_varchar2
1085: ,p_creator_id in number default hr_api.g_number
1086: ,p_personal_payment_method_id in number default hr_api.g_number
1087: ,p_input_value_id1 in number default null
1088: ,p_input_value_id2 in number default null
1081: procedure update_validate(
1082: p_element_entry_id in number
1083: ,p_effective_date in date
1084: ,p_creator_type in varchar2 default hr_api.g_varchar2
1085: ,p_creator_id in number default hr_api.g_number
1086: ,p_personal_payment_method_id in number default hr_api.g_number
1087: ,p_input_value_id1 in number default null
1088: ,p_input_value_id2 in number default null
1089: ,p_input_value_id3 in number default null
1082: p_element_entry_id in number
1083: ,p_effective_date in date
1084: ,p_creator_type in varchar2 default hr_api.g_varchar2
1085: ,p_creator_id in number default hr_api.g_number
1086: ,p_personal_payment_method_id in number default hr_api.g_number
1087: ,p_input_value_id1 in number default null
1088: ,p_input_value_id2 in number default null
1089: ,p_input_value_id3 in number default null
1090: ,p_input_value_id4 in number default null
1133: select count(creator_type)
1134: from pay_element_entries_f
1135: where element_entry_id = c_element_entry_id
1136: and c_effective_date between effective_start_date and effective_end_date
1137: and ( (c_creator_type <> hr_api.g_varchar2
1138: and creator_type <> c_creator_type)
1139: or (c_creator_id <> hr_api.g_number
1140: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1141: )
1135: where element_entry_id = c_element_entry_id
1136: and c_effective_date between effective_start_date and effective_end_date
1137: and ( (c_creator_type <> hr_api.g_varchar2
1138: and creator_type <> c_creator_type)
1139: or (c_creator_id <> hr_api.g_number
1140: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1141: )
1142: )
1143: or (c_personal_payment_method_id <> hr_api.g_number
1139: or (c_creator_id <> hr_api.g_number
1140: and ( nvl(creator_id, -1) <> nvl(c_creator_id, -1)
1141: )
1142: )
1143: or (c_personal_payment_method_id <> hr_api.g_number
1144: and (nvl(personal_payment_method_id, -1) <> nvl(c_personal_payment_method_id, -1)
1145: )
1146: )
1147: );
1297: ,p_effective_date in date
1298: ,p_business_group_id in number
1299: ,p_element_entry_id in number
1300: ,p_object_version_number in out nocopy number
1301: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1298: ,p_business_group_id in number
1299: ,p_element_entry_id in number
1300: ,p_object_version_number in out nocopy number
1301: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1299: ,p_element_entry_id in number
1300: ,p_object_version_number in out nocopy number
1301: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1300: ,p_object_version_number in out nocopy number
1301: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1301: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1302: ,p_updating_action_id in number default hr_api.g_number
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1303: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1304: ,p_original_entry_id in number default hr_api.g_number
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1305: ,p_creator_type in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1306: ,p_comment_id in number default hr_api.g_number
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1307: ,p_creator_id in number default hr_api.g_number
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1308: ,p_reason in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1309: ,p_subpriority in number default hr_api.g_number
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1310: ,p_date_earned in date default hr_api.g_date
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1311: ,p_personal_payment_method_id in number default hr_api.g_number
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1320: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1321: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1322: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1323: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1324: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1332: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1325: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1332: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1333: ,p_input_value_id1 in number default null
1326: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1332: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1333: ,p_input_value_id1 in number default null
1334: ,p_input_value_id2 in number default null
1327: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1332: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1333: ,p_input_value_id1 in number default null
1334: ,p_input_value_id2 in number default null
1335: ,p_input_value_id3 in number default null
1328: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1329: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1330: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1331: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1332: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1333: ,p_input_value_id1 in number default null
1334: ,p_input_value_id2 in number default null
1335: ,p_input_value_id3 in number default null
1336: ,p_input_value_id4 in number default null
1359: ,p_entry_value12 in varchar2 default null
1360: ,p_entry_value13 in varchar2 default null
1361: ,p_entry_value14 in varchar2 default null
1362: ,p_entry_value15 in varchar2 default null
1363: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_entry_value13 in varchar2 default null
1361: ,p_entry_value14 in varchar2 default null
1362: ,p_entry_value15 in varchar2 default null
1363: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_entry_value14 in varchar2 default null
1362: ,p_entry_value15 in varchar2 default null
1363: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_entry_value15 in varchar2 default null
1363: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_entry_information_category in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_entry_information1 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_entry_information2 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_entry_information3 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_entry_information4 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_entry_information5 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_entry_information6 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_entry_information7 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_entry_information8 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1372: ,p_entry_information9 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1373: ,p_entry_information10 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1374: ,p_entry_information11 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1375: ,p_entry_information12 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1376: ,p_entry_information13 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1377: ,p_entry_information14 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1378: ,p_entry_information15 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1379: ,p_entry_information16 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1380: ,p_entry_information17 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1381: ,p_entry_information18 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1382: ,p_entry_information19 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1383: ,p_entry_information20 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1384: ,p_entry_information21 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1385: ,p_entry_information22 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1386: ,p_entry_information23 in varchar2 default hr_api.g_varchar2
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1394: ,p_override_user_ent_chk in varchar2 default 'N'
1387: ,p_entry_information24 in varchar2 default hr_api.g_varchar2
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1394: ,p_override_user_ent_chk in varchar2 default 'N'
1395: ,p_effective_start_date out nocopy date
1388: ,p_entry_information25 in varchar2 default hr_api.g_varchar2
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1394: ,p_override_user_ent_chk in varchar2 default 'N'
1395: ,p_effective_start_date out nocopy date
1396: ,p_effective_end_date out nocopy date
1389: ,p_entry_information26 in varchar2 default hr_api.g_varchar2
1390: ,p_entry_information27 in varchar2 default hr_api.g_varchar2
1391: ,p_entry_information28 in varchar2 default hr_api.g_varchar2
1392: ,p_entry_information29 in varchar2 default hr_api.g_varchar2
1393: ,p_entry_information30 in varchar2 default hr_api.g_varchar2
1394: ,p_override_user_ent_chk in varchar2 default 'N'
1395: ,p_effective_start_date out nocopy date
1396: ,p_effective_end_date out nocopy date
1397: ,p_update_warning out nocopy boolean
1594: ,p_entry_information30 => p_entry_information30
1595: ,p_override_user_ent_chk => p_override_user_ent_chk
1596: );
1597: exception
1598: when hr_api.cannot_find_prog_unit then
1599: hr_api.cannot_find_prog_unit_error
1600: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1601: ,p_hook_type => 'BP'
1602: );
1595: ,p_override_user_ent_chk => p_override_user_ent_chk
1596: );
1597: exception
1598: when hr_api.cannot_find_prog_unit then
1599: hr_api.cannot_find_prog_unit_error
1600: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1601: ,p_hook_type => 'BP'
1602: );
1603: end;
1616: CLOSE c_link_details;
1617: --
1618: IF l_costable_type = 'N'
1619: AND p_cost_allocation_keyflex_id IS NOT NULL
1620: AND p_cost_allocation_keyflex_id <> hr_api.g_number THEN
1621: --
1622: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');
1623: hr_utility.set_warning;
1624: --
1640: CLOSE c_entry_details;
1641:
1642: IF l_creator_type = 'H' THEN
1643: l_creator_type := 'F';
1644: IF p_creator_id = hr_api.g_number THEN
1645: l_creator_id := NULL;
1646: END IF;
1647: END IF;
1648:
1980: ,p_effective_end_date => l_effective_end_date
1981: ,p_update_warning => p_update_warning
1982: );
1983: exception
1984: when hr_api.cannot_find_prog_unit then
1985: hr_api.cannot_find_prog_unit_error
1986: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1987: ,p_hook_type => 'AP'
1988: );
1981: ,p_update_warning => p_update_warning
1982: );
1983: exception
1984: when hr_api.cannot_find_prog_unit then
1985: hr_api.cannot_find_prog_unit_error
1986: (p_module_name => 'UPDATE_ELEMENT_ENTRY'
1987: ,p_hook_type => 'AP'
1988: );
1989: end;
1990: --
1991: -- When in validation only mode raise the Validate_Enabled exception
1992: --
1993: IF p_validate THEN
1994: RAISE hr_api.validate_enabled;
1995: END IF;
1996: --
1997: -- Set all output arguments
1998: --
2005: if g_debug then
2006: hr_utility.set_location(' Leaving:'||l_proc, 11);
2007: end if;
2008: EXCEPTION
2009: WHEN hr_api.validate_enabled THEN
2010: --
2011: -- As the Validate_Enabled exception has been raised
2012: -- we must rollback to the savepoint
2013: --