[Home] [Help]
121: --
122: hr_utility.set_location('Leaving:'|| l_proc, 30);
123: --
124: Exception
125: When HR_Api.Object_Locked then
126: --
127: -- This autonomous transaction was unable to lock the row.
128: -- It can be assumed that another transaction has locked the
129: -- row and is performing the update. Hence the error can
233: --
234: --
235: PROCEDURE create_organization_internal
236: ( p_effective_date in date
237: ,p_language_code in varchar2 default hr_api.userenv_lang
238: ,p_business_group_id in number
239: ,p_date_from in date
240: ,p_name in varchar2
241: ,p_cost_allocation_keyflex_id in number default null
307: -- instead of p_language_code from now on, to allow an IN OUT parameter to
308: -- be passed through.
309: --
310: l_language_code := p_language_code;
311: hr_api.validate_language_code(p_language_code => l_language_code);
312: --
313: hr_utility.set_location(l_proc, 20);
314: --
315: -- Process Logic
408: ,p_effective_date in date
409: ,p_business_group_id in number
410: ,p_name in varchar2
411: ,p_date_from in date
412: ,p_language_code in varchar2 default hr_api.userenv_Lang
413: ,p_location_id in number default null
414: ,p_date_to in date default null
415: ,p_internal_external_flag in varchar2 default null
416: ,p_internal_address_line in varchar2 default null
533: ,p_segment30 => p_segment30
534: ,p_concat_segments => p_concat_segments
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'create_hr_organization'
540: ,p_hook_type => 'BP'
541: );
534: ,p_concat_segments => p_concat_segments
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'create_hr_organization'
540: ,p_hook_type => 'BP'
541: );
542: end;
764: ,p_org_information_id => p_org_information_id
765: ,p_duplicate_org_warning => p_duplicate_org_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'create_hr_organization'
771: ,p_hook_type => 'AP'
772: );
765: ,p_duplicate_org_warning => p_duplicate_org_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'create_hr_organization'
771: ,p_hook_type => 'AP'
772: );
773: end;
776: --
777: -- When in validation only mode raise the Validate_Enabled exception
778: --
779: if p_validate then
780: raise hr_api.validate_enabled;
781: end if;
782: --
783: hr_utility.set_location(' Leaving:'||l_proc, 99);
784: --
783: hr_utility.set_location(' Leaving:'||l_proc, 99);
784: --
785: EXCEPTION
786:
787: WHEN hr_api.validate_enabled THEN
788: --
789: -- As the Validate_Enabled exception has been raised
790: -- we must rollback to the savepoint
791: --
829: --
830: PROCEDURE create_organization
831: ( p_validate IN BOOLEAN DEFAULT false
832: ,p_effective_date IN DATE
833: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
834: ,p_business_group_id IN NUMBER
835: ,p_date_from IN DATE
836: ,p_name IN VARCHAR2
837: ,p_location_id in number default null
938: --
939: PROCEDURE create_organization
940: ( p_validate IN BOOLEAN DEFAULT false
941: ,p_effective_date IN DATE
942: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
943: ,p_business_group_id IN NUMBER
944: ,p_date_from IN DATE
945: ,p_name IN VARCHAR2
946: ,p_location_id in number default null
1053: ,p_attribute30 => p_attribute30
1054: --End Enhancement 4040086
1055: );
1056: exception
1057: when hr_api.cannot_find_prog_unit then
1058: hr_api.cannot_find_prog_unit_error
1059: (p_module_name => 'create_organization'
1060: ,p_hook_type => 'BP'
1061: );
1054: --End Enhancement 4040086
1055: );
1056: exception
1057: when hr_api.cannot_find_prog_unit then
1058: hr_api.cannot_find_prog_unit_error
1059: (p_module_name => 'create_organization'
1060: ,p_hook_type => 'BP'
1061: );
1062: end;
1166: ,p_duplicate_org_warning => p_duplicate_org_warning
1167: );
1168:
1169: exception
1170: when hr_api.cannot_find_prog_unit then
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'create_organization'
1173: ,p_hook_type => 'AP'
1174: );
1167: );
1168:
1169: exception
1170: when hr_api.cannot_find_prog_unit then
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'create_organization'
1173: ,p_hook_type => 'AP'
1174: );
1175: end;
1176: --
1177: -- When in validation only mode raise the Validate_Enabled exception
1178: --
1179: if p_validate then
1180: raise hr_api.validate_enabled;
1181: end if;
1182: --
1183: hr_utility.set_location(' Leaving:'||l_proc, 30);
1184: --
1184: --
1185:
1186: EXCEPTION
1187: --
1188: WHEN hr_api.validate_enabled THEN
1189: --
1190: -- As the Validate_Enabled exception has been raised
1191: -- we must rollback to the savepoint
1192: --
1222: --
1223: PROCEDURE update_organization
1224: ( p_validate IN BOOLEAN DEFAULT false
1225: ,p_effective_date IN DATE
1226: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1227: --
1228: ,p_organization_id IN NUMBER
1229: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1225: ,p_effective_date IN DATE
1226: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1227: --
1228: ,p_organization_id IN NUMBER
1229: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1226: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1227: --
1228: ,p_organization_id IN NUMBER
1229: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1228: ,p_organization_id IN NUMBER
1229: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1229: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1230: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1231: --Bug 3040119
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1232: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1233: ,p_date_from IN DATE DEFAULT hr_api.g_date
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1234: ,p_date_to IN DATE DEFAULT hr_api.g_date
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1235: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1236: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1237: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1238: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1239: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1240: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1241: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1242: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1243: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1244: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1245: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1246: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1247: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1248: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1249: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1250: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1251: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1252: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1253: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1254: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1255: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1256: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1257: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1258: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1259: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1260: --Enhancement 4040086
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1261: --Begin of Add 10 additional segments
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1262: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1263: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1264: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1265: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1266: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1267: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: --End of Enhancement 4040086
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: -- Bug 3039046
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: --
1298: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: --
1306: ,p_object_version_number IN OUT NOCOPY NUMBER
1299: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: --
1306: ,p_object_version_number IN OUT NOCOPY NUMBER
1307: )
1300: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: --
1306: ,p_object_version_number IN OUT NOCOPY NUMBER
1307: )
1308: IS
1308: IS
1309: l_duplicate_org_warning boolean;
1310:
1311: -- Bug fix 3224918.
1312: -- l_name is assgned the default value hr_api.g_varchar2.
1313: -- This will ensure that the old database value for name
1314: -- will be assigned to l_name while updating.
1315: l_name varchar2(500) := hr_api.g_varchar2;
1316:
1311: -- Bug fix 3224918.
1312: -- l_name is assgned the default value hr_api.g_varchar2.
1313: -- This will ensure that the old database value for name
1314: -- will be assigned to l_name while updating.
1315: l_name varchar2(500) := hr_api.g_varchar2;
1316:
1317: begin
1318: update_organization
1319: ( p_effective_date => p_effective_date
1406: --
1407: PROCEDURE update_organization
1408: ( p_validate IN BOOLEAN DEFAULT false
1409: ,p_effective_date IN DATE
1410: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1411: --
1412: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1413: ,p_organization_id IN NUMBER
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1408: ( p_validate IN BOOLEAN DEFAULT false
1409: ,p_effective_date IN DATE
1410: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1411: --
1412: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1413: ,p_organization_id IN NUMBER
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1410: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1411: --
1412: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1413: ,p_organization_id IN NUMBER
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1411: --
1412: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1413: ,p_organization_id IN NUMBER
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1413: ,p_organization_id IN NUMBER
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1414: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: -- Bug 3040119
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_date_from IN DATE DEFAULT hr_api.g_date
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_date_to IN DATE DEFAULT hr_api.g_date
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1438: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1439: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: --Enhancement 4040086
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: --Begin of Add 10 additional segments
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1450: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1451: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: --End of Add 10 additional segments
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1458: -- Bug 3039046
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1459: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1460: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1461: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1462: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1463: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1464: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1465: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1466: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1467: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1468: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1469: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1470: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1471: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1472: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1473: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1474: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1475: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1476: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1477: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1478: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1479: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1480: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: --
1483: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: --
1491: ,p_object_version_number IN OUT NOCOPY NUMBER
1484: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: --
1491: ,p_object_version_number IN OUT NOCOPY NUMBER
1492: ,p_duplicate_org_warning out nocopy boolean
1485: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1486: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: --
1491: ,p_object_version_number IN OUT NOCOPY NUMBER
1492: ,p_duplicate_org_warning out nocopy boolean
1493: ) IS
1601: hr_utility.set_location(l_proc, 1);
1602:
1603: l_old_cost_name := p_concat_segments;
1604: --
1605: if nvl(l_cost_alloc_key_id, hr_api.g_number) = hr_api.g_number then -- Bug 3187772
1606: l_cost_null_ind := 0;
1607: else
1608: -- get segment values
1609: open c_cost_segments;
1734: ,p_object_version_number => l_object_version_number
1735: );
1736:
1737: exception
1738: when hr_api.cannot_find_prog_unit then
1739: hr_api.cannot_find_prog_unit_error
1740: (p_module_name => 'update_organization'
1741: ,p_hook_type => 'BP'
1742: );
1735: );
1736:
1737: exception
1738: when hr_api.cannot_find_prog_unit then
1739: hr_api.cannot_find_prog_unit_error
1740: (p_module_name => 'update_organization'
1741: ,p_hook_type => 'BP'
1742: );
1743: end;
1751: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
1752: -- passed through.
1753: --
1754: l_language_code := p_language_code;
1755: hr_api.validate_language_code(p_language_code => l_language_code);
1756: hr_utility.set_location(l_proc, 20);
1757: --
1758: --
1759: -- Process Logic
1810: fetch c_cost_segments into l_old_cost_segments;
1811: close c_cost_segments;
1812: end if;
1813: --
1814: if nvl(l_cost_segment1, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment1, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1811: close c_cost_segments;
1812: end if;
1813: --
1814: if nvl(l_cost_segment1, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment1, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1812: end if;
1813: --
1814: if nvl(l_cost_segment1, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment1, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1813: --
1814: if nvl(l_cost_segment1, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment1, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1814: if nvl(l_cost_segment1, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment1, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1815: or nvl(l_cost_segment2, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment2, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1816: or nvl(l_cost_segment3, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment3, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1817: or nvl(l_cost_segment4, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment4, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1818: or nvl(l_cost_segment5, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment5, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1819: or nvl(l_cost_segment6, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment6, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1820: or nvl(l_cost_segment7, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment7, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1821: or nvl(l_cost_segment8, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment8, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1822: or nvl(l_cost_segment9, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment9, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1823: or nvl(l_cost_segment10, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment10, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1824: or nvl(l_cost_segment11, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment11, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1825: or nvl(l_cost_segment12, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment12, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1826: or nvl(l_cost_segment13, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment13, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1827: or nvl(l_cost_segment14, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment14, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1828: or nvl(l_cost_segment15, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment15, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1829: or nvl(l_cost_segment16, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment16, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1830: or nvl(l_cost_segment17, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment17, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1831: or nvl(l_cost_segment18, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment18, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1832: or nvl(l_cost_segment19, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment19, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1833: or nvl(l_cost_segment20, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment20, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1834: or nvl(l_cost_segment21, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment21, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1835: or nvl(l_cost_segment22, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment22, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1836: or nvl(l_cost_segment23, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment23, hr_api.g_varchar2)
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1844: or nvl(l_old_cost_name, hr_api.g_varchar2) <> nvl(l_old_cost_segments.concatenated_segments, hr_api.g_varchar2) then
1837: or nvl(l_cost_segment24, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment24, hr_api.g_varchar2)
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1844: or nvl(l_old_cost_name, hr_api.g_varchar2) <> nvl(l_old_cost_segments.concatenated_segments, hr_api.g_varchar2) then
1845: -- End of 3187772
1838: or nvl(l_cost_segment25, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment25, hr_api.g_varchar2)
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1844: or nvl(l_old_cost_name, hr_api.g_varchar2) <> nvl(l_old_cost_segments.concatenated_segments, hr_api.g_varchar2) then
1845: -- End of 3187772
1846: hr_kflex_utility.upd_or_sel_keyflex_comb
1839: or nvl(l_cost_segment26, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment26, hr_api.g_varchar2)
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1844: or nvl(l_old_cost_name, hr_api.g_varchar2) <> nvl(l_old_cost_segments.concatenated_segments, hr_api.g_varchar2) then
1845: -- End of 3187772
1846: hr_kflex_utility.upd_or_sel_keyflex_comb
1847: (p_appl_short_name => 'PAY'
1840: or nvl(l_cost_segment27, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment27, hr_api.g_varchar2)
1841: or nvl(l_cost_segment28, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment28, hr_api.g_varchar2)
1842: or nvl(l_cost_segment29, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment29, hr_api.g_varchar2)
1843: or nvl(l_cost_segment30, hr_api.g_varchar2) <> nvl(l_old_cost_segments.segment30, hr_api.g_varchar2)
1844: or nvl(l_old_cost_name, hr_api.g_varchar2) <> nvl(l_old_cost_segments.concatenated_segments, hr_api.g_varchar2) then
1845: -- End of 3187772
1846: hr_kflex_utility.upd_or_sel_keyflex_comb
1847: (p_appl_short_name => 'PAY'
1848: ,p_flex_code => 'COST'
1963: --
1964: -- When in validation only mode raise the Validate_Enabled exception
1965: --
1966: IF p_validate THEN
1967: RAISE hr_api.validate_enabled;
1968: END IF;
1969: --
1970: -- Set all output arguments. If p_validate was TRUE, this bit is
1971: -- never reached, so p_object_version_number is passed back unchanged.
2061: ,p_duplicate_org_warning => p_duplicate_org_warning
2062: );
2063:
2064: exception
2065: when hr_api.cannot_find_prog_unit then
2066: hr_api.cannot_find_prog_unit_error
2067: (p_module_name => 'update_organization'
2068: ,p_hook_type => 'AP'
2069: );
2062: );
2063:
2064: exception
2065: when hr_api.cannot_find_prog_unit then
2066: hr_api.cannot_find_prog_unit_error
2067: (p_module_name => 'update_organization'
2068: ,p_hook_type => 'AP'
2069: );
2070: end;
2070: end;
2071:
2072: EXCEPTION
2073: --
2074: WHEN hr_api.validate_enabled THEN
2075: --
2076: -- As the Validate_Enabled exception has been raised
2077: -- we must rollback to the savepoint
2078: --
2126: ,p_object_version_number => p_object_version_number
2127: );
2128:
2129: exception
2130: when hr_api.cannot_find_prog_unit then
2131: hr_api.cannot_find_prog_unit_error
2132: (p_module_name => 'delete_organization'
2133: ,p_hook_type => 'BP'
2134: );
2127: );
2128:
2129: exception
2130: when hr_api.cannot_find_prog_unit then
2131: hr_api.cannot_find_prog_unit_error
2132: (p_module_name => 'delete_organization'
2133: ,p_hook_type => 'BP'
2134: );
2135: end;
2171: --
2172: -- When in validation only mode raise the Validate_Enabled exception
2173: --
2174: IF p_validate THEN
2175: RAISE hr_api.validate_enabled;
2176: END IF;
2177: --
2178: --
2179: begin
2182: ,p_object_version_number => p_object_version_number
2183: );
2184:
2185: exception
2186: when hr_api.cannot_find_prog_unit then
2187: hr_api.cannot_find_prog_unit_error
2188: (p_module_name => 'delete_organization'
2189: ,p_hook_type => 'AP'
2190: );
2183: );
2184:
2185: exception
2186: when hr_api.cannot_find_prog_unit then
2187: hr_api.cannot_find_prog_unit_error
2188: (p_module_name => 'delete_organization'
2189: ,p_hook_type => 'AP'
2190: );
2191: end;
2192:
2193:
2194: EXCEPTION
2195: --
2196: WHEN hr_api.validate_enabled THEN
2197: --
2198: -- As the Validate_Enabled exception has been raised
2199: -- we must rollback to the savepoint
2200: --
2354: ,p_organization_id => p_organization_id
2355: ,p_org_classif_code =>p_org_classif_code);
2356:
2357: exception
2358: when hr_api.cannot_find_prog_unit then
2359: hr_api.cannot_find_prog_unit_error
2360: (p_module_name => 'create_org_classification'
2361: ,p_hook_type => 'BP'
2362: );
2355: ,p_org_classif_code =>p_org_classif_code);
2356:
2357: exception
2358: when hr_api.cannot_find_prog_unit then
2359: hr_api.cannot_find_prog_unit_error
2360: (p_module_name => 'create_org_classification'
2361: ,p_hook_type => 'BP'
2362: );
2363: end;
2361: ,p_hook_type => 'BP'
2362: );
2363: end;
2364:
2365: hr_api.mandatory_arg_error
2366: (p_api_name => l_proc
2367: ,p_argument => 'ORGANIZATION_ID'
2368: ,p_argument_value => p_organization_id );
2369:
2396: --
2397: -- When in validation only mode raise the Validate_Enabled exception
2398: --
2399: IF p_validate THEN
2400: RAISE hr_api.validate_enabled;
2401: END IF;
2402: --
2403: -- Set all output arguments
2404: --
2415: ,p_org_classif_code => p_org_classif_code
2416: );
2417:
2418: exception
2419: when hr_api.cannot_find_prog_unit then
2420: hr_api.cannot_find_prog_unit_error
2421: (p_module_name => 'create_org_classification'
2422: ,p_hook_type => 'AP'
2423: );
2416: );
2417:
2418: exception
2419: when hr_api.cannot_find_prog_unit then
2420: hr_api.cannot_find_prog_unit_error
2421: (p_module_name => 'create_org_classification'
2422: ,p_hook_type => 'AP'
2423: );
2424: end;
2423: );
2424: end;
2425: EXCEPTION
2426: --
2427: WHEN hr_api.validate_enabled THEN
2428: --
2429: -- As the Validate_Enabled exception has been raised
2430: -- we must rollback to the savepoint
2431: --
2573: --
2574: -- When in validation only mode raise the Validate_Enabled exception
2575: --
2576: IF p_validate THEN
2577: RAISE hr_api.validate_enabled;
2578: END IF;
2579: --
2580: -- Set all output arguments. If p_validate was TRUE, this bit is
2581: -- never reached, so p_object_version_number is passed back unchanged.
2585: hr_utility.set_location(' Leaving:'||l_proc, 70);
2586: --
2587: EXCEPTION
2588: --
2589: WHEN hr_api.validate_enabled THEN
2590: --
2591: -- As the Validate_Enabled exception has been raised
2592: -- we must rollback to the savepoint
2593: --
2667: --
2668: -- When in validation only mode raise the Validate_Enabled exception
2669: --
2670: IF p_validate THEN
2671: RAISE hr_api.validate_enabled;
2672: END IF;
2673: --
2674: -- Set all output arguments. If p_validate was TRUE, this bit is
2675: -- never reached, so p_object_version_number is passed back unchanged.
2679: hr_utility.set_location(' Leaving:'||l_proc, 70);
2680: --
2681: EXCEPTION
2682: --
2683: WHEN hr_api.validate_enabled THEN
2684: --
2685: -- As the Validate_Enabled exception has been raised
2686: -- we must rollback to the savepoint
2687: --
2830: ,p_attribute19 => p_attribute19
2831: ,p_attribute20 => p_attribute20
2832: );
2833: exception
2834: when hr_api.cannot_find_prog_unit then
2835: hr_api.cannot_find_prog_unit_error
2836: (p_module_name => 'create_org_information'
2837: ,p_hook_type => 'BP'
2838: );
2831: ,p_attribute20 => p_attribute20
2832: );
2833: exception
2834: when hr_api.cannot_find_prog_unit then
2835: hr_api.cannot_find_prog_unit_error
2836: (p_module_name => 'create_org_information'
2837: ,p_hook_type => 'BP'
2838: );
2839: end;
2950: ,p_attribute20 => p_attribute20
2951: ,p_org_information_id => l_org_information_id
2952: ,p_object_version_number => l_object_version_number);
2953: exception
2954: when hr_api.cannot_find_prog_unit then
2955: hr_api.cannot_find_prog_unit_error
2956: (p_module_name => 'create_org_information'
2957: ,p_hook_type => 'AP'
2958: );
2951: ,p_org_information_id => l_org_information_id
2952: ,p_object_version_number => l_object_version_number);
2953: exception
2954: when hr_api.cannot_find_prog_unit then
2955: hr_api.cannot_find_prog_unit_error
2956: (p_module_name => 'create_org_information'
2957: ,p_hook_type => 'AP'
2958: );
2959: end;
2962: --
2963: -- When in validation only mode raise the Validate_Enabled exception
2964: --
2965: IF p_validate THEN
2966: RAISE hr_api.validate_enabled;
2967: END IF;
2968: --
2969: hr_utility.set_location(l_proc, 60);
2970: --
2982: hr_utility.set_location(' Leaving:'||l_proc, 70);
2983: --
2984: EXCEPTION
2985: --
2986: WHEN hr_api.validate_enabled THEN
2987: --
2988: -- As the Validate_Enabled exception has been raised
2989: -- we must rollback to the savepoint
2990: --
3152: );
3153: --
3154: exception
3155: --
3156: when hr_api.cannot_find_prog_unit then
3157: hr_api.cannot_find_prog_unit_error
3158: (p_module_name => 'create_org_information'
3159: ,p_hook_type => 'BP');
3160: --
3153: --
3154: exception
3155: --
3156: when hr_api.cannot_find_prog_unit then
3157: hr_api.cannot_find_prog_unit_error
3158: (p_module_name => 'create_org_information'
3159: ,p_hook_type => 'BP');
3160: --
3161: end;
3306: ,p_object_version_number => l_object_version_number);
3307: --
3308: exception
3309: --
3310: when hr_api.cannot_find_prog_unit then
3311: hr_api.cannot_find_prog_unit_error
3312: (p_module_name => 'create_org_information'
3313: ,p_hook_type => 'AP');
3314: --
3307: --
3308: exception
3309: --
3310: when hr_api.cannot_find_prog_unit then
3311: hr_api.cannot_find_prog_unit_error
3312: (p_module_name => 'create_org_information'
3313: ,p_hook_type => 'AP');
3314: --
3315: end;
3318: --
3319: -- When in validation only mode raise the Validate_Enabled exception
3320: --
3321: IF p_validate THEN
3322: RAISE hr_api.validate_enabled;
3323: END IF;
3324: --
3325: hr_utility.set_location(l_proc, 60);
3326: --
3333: hr_utility.set_location(' Leaving:'||l_proc, 70);
3334: --
3335: EXCEPTION
3336: --
3337: WHEN hr_api.validate_enabled THEN
3338: --
3339: -- As the Validate_Enabled exception has been raised
3340: -- we must rollback to the savepoint
3341: --
3371: (p_validate IN BOOLEAN DEFAULT false
3372: ,p_effective_date IN DATE
3373: ,p_org_information_id IN NUMBER
3374: ,p_org_info_type_code IN VARCHAR2
3375: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3372: ,p_effective_date IN DATE
3373: ,p_org_information_id IN NUMBER
3374: ,p_org_info_type_code IN VARCHAR2
3375: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3373: ,p_org_information_id IN NUMBER
3374: ,p_org_info_type_code IN VARCHAR2
3375: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3374: ,p_org_info_type_code IN VARCHAR2
3375: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3375: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3376: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3377: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3378: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3379: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3380: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3381: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3382: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3383: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3384: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3385: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3386: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3387: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3388: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3389: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3390: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3391: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3392: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3393: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3394: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3395: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3396: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3397: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3398: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3399: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3400: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3401: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3402: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3403: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3404: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3405: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3406: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3407: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3415: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3408: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3415: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3416: ,p_object_version_number IN OUT NOCOPY NUMBER
3409: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3415: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3416: ,p_object_version_number IN OUT NOCOPY NUMBER
3417: ) IS
3410: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3415: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3416: ,p_object_version_number IN OUT NOCOPY NUMBER
3417: ) IS
3418: --
3411: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3412: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3413: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3414: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3415: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3416: ,p_object_version_number IN OUT NOCOPY NUMBER
3417: ) IS
3418: --
3419: -- Declare cursors and local variables
3518: ,p_attribute19 => p_attribute19
3519: ,p_attribute20 => p_attribute20
3520: ,p_object_version_number => l_object_version_number);
3521: exception
3522: when hr_api.cannot_find_prog_unit then
3523: hr_api.cannot_find_prog_unit_error
3524: (p_module_name => 'update_org_information'
3525: ,p_hook_type => 'BP'
3526: );
3519: ,p_attribute20 => p_attribute20
3520: ,p_object_version_number => l_object_version_number);
3521: exception
3522: when hr_api.cannot_find_prog_unit then
3523: hr_api.cannot_find_prog_unit_error
3524: (p_module_name => 'update_org_information'
3525: ,p_hook_type => 'BP'
3526: );
3527: end;
3629: ,p_attribute19 => p_attribute19
3630: ,p_attribute20 => p_attribute20
3631: ,p_object_version_number => l_object_version_number);
3632: exception
3633: when hr_api.cannot_find_prog_unit then
3634: hr_api.cannot_find_prog_unit_error
3635: (p_module_name => 'update_org_information'
3636: ,p_hook_type => 'AP'
3637: );
3630: ,p_attribute20 => p_attribute20
3631: ,p_object_version_number => l_object_version_number);
3632: exception
3633: when hr_api.cannot_find_prog_unit then
3634: hr_api.cannot_find_prog_unit_error
3635: (p_module_name => 'update_org_information'
3636: ,p_hook_type => 'AP'
3637: );
3638: end;
3641: --
3642: -- When in validation only mode raise the Validate_Enabled exception
3643: --
3644: IF p_validate THEN
3645: RAISE hr_api.validate_enabled;
3646: END IF;
3647: --
3648: hr_utility.set_location(l_proc, 70);
3649: --
3660: hr_utility.set_location(' Leaving:'||l_proc, 80);
3661: --
3662: EXCEPTION
3663: --
3664: WHEN hr_api.validate_enabled THEN
3665: --
3666: -- As the Validate_Enabled exception has been raised
3667: -- we must rollback to the savepoint
3668: --
3695: ,p_effective_date IN DATE
3696: ,p_organization_id IN NUMBER
3697: ,p_org_information_id IN NUMBER
3698: ,p_org_info_type_code IN VARCHAR2
3699: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_organization_id IN NUMBER
3697: ,p_org_information_id IN NUMBER
3698: ,p_org_info_type_code IN VARCHAR2
3699: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information_id IN NUMBER
3698: ,p_org_info_type_code IN VARCHAR2
3699: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_info_type_code IN VARCHAR2
3699: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3725: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3726: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3727: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3728: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3729: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3730: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3731: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3739: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3732: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3739: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3740: ,p_object_version_number IN OUT NOCOPY NUMBER
3733: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3739: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3740: ,p_object_version_number IN OUT NOCOPY NUMBER
3741: ,p_warning OUT NOCOPY BOOLEAN
3734: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3739: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3740: ,p_object_version_number IN OUT NOCOPY NUMBER
3741: ,p_warning OUT NOCOPY BOOLEAN
3742: ) IS
3735: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3736: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3737: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3738: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3739: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3740: ,p_object_version_number IN OUT NOCOPY NUMBER
3741: ,p_warning OUT NOCOPY BOOLEAN
3742: ) IS
3743: --
3828: ,p_object_version_number => l_object_version_number);
3829: --
3830: exception
3831: --
3832: when hr_api.cannot_find_prog_unit then
3833: --
3834: hr_api.cannot_find_prog_unit_error
3835: (p_module_name => 'update_org_information'
3836: ,p_hook_type => 'BP'
3830: exception
3831: --
3832: when hr_api.cannot_find_prog_unit then
3833: --
3834: hr_api.cannot_find_prog_unit_error
3835: (p_module_name => 'update_org_information'
3836: ,p_hook_type => 'BP'
3837: );
3838: end;
3965: ,p_object_version_number => l_object_version_number);
3966: --
3967: exception
3968: --
3969: when hr_api.cannot_find_prog_unit then
3970: --
3971: hr_api.cannot_find_prog_unit_error
3972: (p_module_name => 'update_org_information'
3973: ,p_hook_type => 'AP');
3967: exception
3968: --
3969: when hr_api.cannot_find_prog_unit then
3970: --
3971: hr_api.cannot_find_prog_unit_error
3972: (p_module_name => 'update_org_information'
3973: ,p_hook_type => 'AP');
3974: --
3975: end;
3978: --
3979: -- When in validation only mode raise the Validate_Enabled exception
3980: --
3981: IF p_validate THEN
3982: RAISE hr_api.validate_enabled;
3983: END IF;
3984: --
3985: hr_utility.set_location(l_proc, 70);
3986: --
3993: hr_utility.set_location(' Leaving:'||l_proc, 80);
3994: --
3995: EXCEPTION
3996: --
3997: WHEN hr_api.validate_enabled THEN
3998: --
3999: -- As the Validate_Enabled exception has been raised
4000: -- we must rollback to the savepoint
4001: --
4057: ,p_object_version_number => p_object_version_number);
4058: --
4059: exception
4060: --
4061: when hr_api.cannot_find_prog_unit then
4062: --
4063: hr_api.cannot_find_prog_unit_error
4064: (p_module_name => 'delete_org_manager'
4065: ,p_hook_type => 'BP');
4059: exception
4060: --
4061: when hr_api.cannot_find_prog_unit then
4062: --
4063: hr_api.cannot_find_prog_unit_error
4064: (p_module_name => 'delete_org_manager'
4065: ,p_hook_type => 'BP');
4066: --
4067: -- End of API User Hook for the before hook of delete_org_manager
4081: ,p_object_version_number => l_object_version_number);
4082: --
4083: exception
4084: --
4085: when hr_api.cannot_find_prog_unit then
4086: --
4087: hr_api.cannot_find_prog_unit_error
4088: (p_module_name => 'delete_org_manager'
4089: ,p_hook_type => 'AP');
4083: exception
4084: --
4085: when hr_api.cannot_find_prog_unit then
4086: --
4087: hr_api.cannot_find_prog_unit_error
4088: (p_module_name => 'delete_org_manager'
4089: ,p_hook_type => 'AP');
4090: --
4091: -- End of API User Hook for the after hook of delete_org_manager
4096: --
4097: -- When in validation only mode raise the Validate_Enabled exception
4098: --
4099: if p_validate then
4100: raise hr_api.validate_enabled;
4101: end if;
4102: --
4103: hr_utility.set_location(' Leaving:'||l_proc, 70);
4104: --
4103: hr_utility.set_location(' Leaving:'||l_proc, 70);
4104: --
4105: exception
4106: --
4107: when hr_api.validate_enabled then
4108: --
4109: -- As the Validate_Enabled exception has been raised
4110: -- we must rollback to the savepoint
4111: --
4168: ,p_org_information_id => p_org_information_id
4169: ,p_object_version_number => p_object_version_number);
4170:
4171: exception
4172: when hr_api.cannot_find_prog_unit then
4173: hr_api.cannot_find_prog_unit_error
4174: (p_module_name => 'create_org_class_internal'
4175: ,p_hook_type => 'BP'
4176: );
4169: ,p_object_version_number => p_object_version_number);
4170:
4171: exception
4172: when hr_api.cannot_find_prog_unit then
4173: hr_api.cannot_find_prog_unit_error
4174: (p_module_name => 'create_org_class_internal'
4175: ,p_hook_type => 'BP'
4176: );
4177: end;
4204: --
4205: -- When in validation only mode raise the Validate_Enabled exception
4206: --
4207: IF p_validate THEN
4208: RAISE hr_api.validate_enabled;
4209: END IF;
4210: --
4211: -- Set all output arguments
4212: --
4225: ,p_org_information_id => l_org_information_id
4226: ,p_object_version_number => l_object_version_number);
4227:
4228: exception
4229: when hr_api.cannot_find_prog_unit then
4230: hr_api.cannot_find_prog_unit_error
4231: (p_module_name => 'create_org_class_internal'
4232: ,p_hook_type => 'AP'
4233: );
4226: ,p_object_version_number => l_object_version_number);
4227:
4228: exception
4229: when hr_api.cannot_find_prog_unit then
4230: hr_api.cannot_find_prog_unit_error
4231: (p_module_name => 'create_org_class_internal'
4232: ,p_hook_type => 'AP'
4233: );
4234: end;
4237: hr_utility.set_location(' Leaving:'||l_proc, 80);
4238: --
4239: EXCEPTION
4240: --
4241: WHEN hr_api.validate_enabled THEN
4242: --
4243: -- As the Validate_Enabled exception has been raised
4244: -- we must rollback to the savepoint
4245: --
4267: --
4268: PROCEDURE create_business_group
4269: ( p_validate IN BOOLEAN DEFAULT false
4270: ,p_effective_date IN DATE
4271: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4272: --
4273: ,p_date_from IN DATE
4274: ,p_name IN VARCHAR2
4275: ,p_type IN VARCHAR2
4325: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4326: -- be passed through.
4327: --
4328: l_language_code := p_language_code;
4329: hr_api.validate_language_code(p_language_code => l_language_code);
4330: --
4331: hr_utility.set_location(l_proc, 20);
4332: --
4333: -- Process Logic
4398: --
4399: -- When in validation only mode raise the Validate_Enabled exception
4400: --
4401: IF p_validate THEN
4402: RAISE hr_api.validate_enabled;
4403: END IF;
4404: --
4405: -- Set all output arguments
4406: --
4410: hr_utility.set_location(' Leaving:'||l_proc, 80);
4411: --
4412: EXCEPTION
4413: --
4414: WHEN hr_api.validate_enabled THEN
4415: --
4416: -- As the Validate_Enabled exception has been raised
4417: -- we must rollback to the savepoint
4418: --
4591: --
4592: PROCEDURE create_operating_unit
4593: ( p_validate IN BOOLEAN DEFAULT false
4594: ,p_effective_date IN DATE
4595: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4596: --
4597: ,p_business_group_id IN NUMBER
4598: ,p_date_from IN DATE
4599: ,p_name IN VARCHAR2
4638: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4639: -- be passed through.
4640: --
4641: l_language_code := p_language_code;
4642: hr_api.validate_language_code(p_language_code => l_language_code);
4643: --
4644: hr_utility.set_location(l_proc, 20);
4645: --
4646: -- Process Logic
4718: --
4719: -- When in validation only mode raise the Validate_Enabled exception
4720: --
4721: IF p_validate THEN
4722: RAISE hr_api.validate_enabled;
4723: END IF;
4724: --
4725: -- Set all output arguments
4726: --
4732: hr_utility.set_location(' Leaving:'||l_proc, 80);
4733: --
4734: EXCEPTION
4735: --
4736: WHEN hr_api.validate_enabled THEN
4737: --
4738: -- As the Validate_Enabled exception has been raised
4739: -- we must rollback to the savepoint
4740: --
4768: (
4769: p_validate IN BOOLEAN DEFAULT false
4770: ,p_organization_id IN NUMBER
4771: ,p_effective_date IN DATE
4772: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4769: p_validate IN BOOLEAN DEFAULT false
4770: ,p_organization_id IN NUMBER
4771: ,p_effective_date IN DATE
4772: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4770: ,p_organization_id IN NUMBER
4771: ,p_effective_date IN DATE
4772: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4771: ,p_effective_date IN DATE
4772: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4772: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4773: ,p_date_from IN DATE DEFAULT hr_api.g_date
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4781: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4774: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4781: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4782: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4775: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4776: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4781: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4782: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4783: ,p_object_version_number IN OUT NOCOPY NUMBER
4777: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4781: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4782: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4783: ,p_object_version_number IN OUT NOCOPY NUMBER
4784: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
4785: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
4778: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4779: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4780: -- Added p_short_code for bug 4526439
4781: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4782: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4783: ,p_object_version_number IN OUT NOCOPY NUMBER
4784: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
4785: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
4786: ) IS
4882: --
4883: -- When in validation only mode raise the Validate_Enabled exception
4884: --
4885: IF p_validate THEN
4886: RAISE hr_api.validate_enabled;
4887: END IF;
4888: --
4889: -- Set all output arguments
4890: --
4899: hr_utility.set_location(' Leaving:'||l_proc, 30);
4900: --
4901: EXCEPTION
4902: --
4903: WHEN hr_api.validate_enabled THEN
4904: --
4905: -- As the Validate_Enabled exception has been raised
4906: -- we must rollback to the savepoint
4907: --
4936: --
4937: PROCEDURE create_legal_entity
4938: ( p_validate IN BOOLEAN DEFAULT false
4939: ,p_effective_date IN DATE
4940: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4941: --
4942: ,p_business_group_id IN NUMBER
4943: ,p_date_from IN DATE
4944: ,p_name IN VARCHAR2
4983: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4984: -- be passed through.
4985: --
4986: l_language_code := p_language_code;
4987: hr_api.validate_language_code(p_language_code => l_language_code);
4988: --
4989: hr_utility.set_location(l_proc, 20);
4990: --
4991: -- Process Logic
5034: --
5035: -- When in validation only mode raise the Validate_Enabled exception
5036: --
5037: IF p_validate THEN
5038: RAISE hr_api.validate_enabled;
5039: END IF;
5040: --
5041: -- Set all output arguments
5042: --
5046: hr_utility.set_location(' Leaving:'||l_proc, 80);
5047: --
5048: EXCEPTION
5049: --
5050: WHEN hr_api.validate_enabled THEN
5051: --
5052: -- As the Validate_Enabled exception has been raised
5053: -- we must rollback to the savepoint
5054: --
5221: --
5222: -- When in validation only mode raise the Validate_Enabled exception
5223: --
5224: IF p_validate THEN
5225: RAISE hr_api.validate_enabled;
5226: END IF;
5227: --
5228: --
5229: hr_utility.set_location(' Leaving:'||l_proc, 80);
5229: hr_utility.set_location(' Leaving:'||l_proc, 80);
5230: --
5231: EXCEPTION
5232: --
5233: WHEN hr_api.validate_enabled THEN
5234: --
5235: -- As the Validate_Enabled exception has been raised
5236: -- we must rollback to the savepoint
5237: --
5378: --
5379: -- When in validation only mode raise the Validate_Enabled exception
5380: --
5381: IF p_validate THEN
5382: RAISE hr_api.validate_enabled;
5383: END IF;
5384: --
5385: --
5386: hr_utility.set_location(' Leaving:'||l_proc, 80);
5386: hr_utility.set_location(' Leaving:'||l_proc, 80);
5387: --
5388: EXCEPTION
5389: --
5390: WHEN hr_api.validate_enabled THEN
5391: --
5392: -- As the Validate_Enabled exception has been raised
5393: -- we must rollback to the savepoint
5394: --
5472: --
5473: -- When in validation only mode raise the Validate_Enabled exception
5474: --
5475: IF p_validate THEN
5476: RAISE hr_api.validate_enabled;
5477: END IF;
5478: --
5479: --
5480: hr_utility.set_location(' Leaving:'||l_proc, 80);
5480: hr_utility.set_location(' Leaving:'||l_proc, 80);
5481: --
5482: EXCEPTION
5483: --
5484: WHEN hr_api.validate_enabled THEN
5485: --
5486: -- As the Validate_Enabled exception has been raised
5487: -- we must rollback to the savepoint
5488: --
5510: --
5511: PROCEDURE trans_org_name
5512: ( p_validate IN BOOLEAN DEFAULT false
5513: ,p_effective_date IN DATE
5514: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
5515: --
5516: ,p_organization_id IN NUMBER
5517: ,p_name IN VARCHAR2
5518: ) IS
5538: -- instead of p_language_code from now on, to allow an IN OUT parameter to
5539: -- be passed through.
5540: --
5541: l_language_code := p_language_code;
5542: hr_api.validate_language_code(p_language_code => l_language_code);
5543: --
5544: hr_utility.set_location(l_proc, 20);
5545: --
5546: --
5544: hr_utility.set_location(l_proc, 20);
5545: --
5546: --
5547: --
5548: hr_api.mandatory_arg_error
5549: (p_api_name => l_proc
5550: ,p_argument => 'LANGUAGE'
5551: ,p_argument_value => p_language_code
5552: );
5551: ,p_argument_value => p_language_code
5552: );
5553: --
5554: --
5555: hr_api.mandatory_arg_error
5556: (p_api_name => l_proc
5557: ,p_argument => 'ORGANIZATION_ID'
5558: ,p_argument_value => p_organization_id
5559: );
5558: ,p_argument_value => p_organization_id
5559: );
5560: --
5561: --
5562: hr_api.mandatory_arg_error
5563: (p_api_name => l_proc
5564: ,p_argument => 'NAME'
5565: ,p_argument_value => p_name
5566: );
5580: --
5581: -- When in validation only mode raise the Validate_Enabled exception
5582: --
5583: IF p_validate THEN
5584: RAISE hr_api.validate_enabled;
5585: END IF;
5586: --
5587: -- Set all output arguments
5588: --
5590: hr_utility.set_location(' Leaving:'||l_proc, 70);
5591: --
5592: EXCEPTION
5593: --
5594: WHEN hr_api.validate_enabled THEN
5595: --
5596: -- As the Validate_Enabled exception has been raised
5597: -- we must rollback to the savepoint
5598: --
5662: ,p_costcenter => p_costcenter
5663: );
5664:
5665: exception
5666: when hr_api.cannot_find_prog_unit then
5667: hr_api.cannot_find_prog_unit_error
5668: (p_module_name => 'create_company_cost_center'
5669: ,p_hook_type => 'BP'
5670: );
5663: );
5664:
5665: exception
5666: when hr_api.cannot_find_prog_unit then
5667: hr_api.cannot_find_prog_unit_error
5668: (p_module_name => 'create_company_cost_center'
5669: ,p_hook_type => 'BP'
5670: );
5671: end;
5722: ,p_object_version_number => p_object_version_number
5723: );
5724:
5725: exception
5726: when hr_api.cannot_find_prog_unit then
5727: hr_api.cannot_find_prog_unit_error
5728: (p_module_name => 'create_company_cost_center'
5729: ,p_hook_type => 'AP'
5730: );
5723: );
5724:
5725: exception
5726: when hr_api.cannot_find_prog_unit then
5727: hr_api.cannot_find_prog_unit_error
5728: (p_module_name => 'create_company_cost_center'
5729: ,p_hook_type => 'AP'
5730: );
5731: end;
5735: --
5736: -- When in validation only mode raise the Validate_Enabled exception
5737: --
5738: IF p_validate THEN
5739: RAISE hr_api.validate_enabled;
5740: END IF;
5741: --
5742: --
5743: hr_utility.set_location(' Leaving:'||l_proc, 70);
5743: hr_utility.set_location(' Leaving:'||l_proc, 70);
5744: --
5745: EXCEPTION
5746: --
5747: WHEN hr_api.validate_enabled THEN
5748: --
5749: -- As the Validate_Enabled exception has been raised
5750: -- we must rollback to the savepoint
5751: --
5791: --
5792: PROCEDURE create_not_usable_ou_internal
5793: (p_validate IN BOOLEAN DEFAULT FALSE
5794: ,p_effective_date IN DATE
5795: ,p_language_code IN VARCHAR2 DEFAULT HR_API.userenv_lang
5796: ,p_business_group_id IN NUMBER
5797: ,p_date_from IN DATE
5798: ,p_name IN VARCHAR2
5799: ,p_type IN VARCHAR2
5831: -- Validate language parameter. l_language_code should be passed to functions
5832: -- instead of p_language_code from now on to allow IN OUT param to be passed.
5833: --
5834: l_language_code := p_language_code;
5835: hr_api.validate_language_code(p_language_code => l_language_code);
5836: --
5837: hr_utility.set_location(l_proc, 20);
5838: --
5839: -- Process Logic
5875: --
5876: -- When in validation only mode raise the Validate_Enabled exception
5877: --
5878: IF p_validate THEN
5879: RAISE hr_api.validate_enabled;
5880: END IF;
5881: --
5882: -- Set all output arguments
5883: --
5887: hr_utility.set_location(' Leaving:'||l_proc, 80);
5888: --
5889: EXCEPTION
5890: --
5891: WHEN hr_api.validate_enabled THEN
5892: --
5893: -- As the Validate_Enabled exception has been raised
5894: -- we must rollback to the savepoint
5895: --