[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
3507: ,p_attribute19 => p_attribute19
3508: ,p_attribute20 => p_attribute20
3509: ,p_object_version_number => l_object_version_number);
3510: exception
3511: when hr_api.cannot_find_prog_unit then
3512: hr_api.cannot_find_prog_unit_error
3513: (p_module_name => 'update_org_information'
3514: ,p_hook_type => 'BP'
3515: );
3508: ,p_attribute20 => p_attribute20
3509: ,p_object_version_number => l_object_version_number);
3510: exception
3511: when hr_api.cannot_find_prog_unit then
3512: hr_api.cannot_find_prog_unit_error
3513: (p_module_name => 'update_org_information'
3514: ,p_hook_type => 'BP'
3515: );
3516: end;
3618: ,p_attribute19 => p_attribute19
3619: ,p_attribute20 => p_attribute20
3620: ,p_object_version_number => l_object_version_number);
3621: exception
3622: when hr_api.cannot_find_prog_unit then
3623: hr_api.cannot_find_prog_unit_error
3624: (p_module_name => 'update_org_information'
3625: ,p_hook_type => 'AP'
3626: );
3619: ,p_attribute20 => p_attribute20
3620: ,p_object_version_number => l_object_version_number);
3621: exception
3622: when hr_api.cannot_find_prog_unit then
3623: hr_api.cannot_find_prog_unit_error
3624: (p_module_name => 'update_org_information'
3625: ,p_hook_type => 'AP'
3626: );
3627: end;
3630: --
3631: -- When in validation only mode raise the Validate_Enabled exception
3632: --
3633: IF p_validate THEN
3634: RAISE hr_api.validate_enabled;
3635: END IF;
3636: --
3637: hr_utility.set_location(l_proc, 70);
3638: --
3644: hr_utility.set_location(' Leaving:'||l_proc, 80);
3645: --
3646: EXCEPTION
3647: --
3648: WHEN hr_api.validate_enabled THEN
3649: --
3650: -- As the Validate_Enabled exception has been raised
3651: -- we must rollback to the savepoint
3652: --
3679: ,p_effective_date IN DATE
3680: ,p_organization_id IN NUMBER
3681: ,p_org_information_id IN NUMBER
3682: ,p_org_info_type_code IN VARCHAR2
3683: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3680: ,p_organization_id IN NUMBER
3681: ,p_org_information_id IN NUMBER
3682: ,p_org_info_type_code IN VARCHAR2
3683: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3681: ,p_org_information_id IN NUMBER
3682: ,p_org_info_type_code IN VARCHAR2
3683: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3682: ,p_org_info_type_code IN VARCHAR2
3683: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3683: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3684: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3685: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3686: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3687: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3688: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3689: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3690: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3691: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3692: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3693: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3694: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3695: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3696: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3697: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3698: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3699: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3700: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3701: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3702: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3703: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3704: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3705: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3706: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3707: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3708: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3709: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3710: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3711: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3712: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3713: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3714: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3715: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3716: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_object_version_number IN OUT NOCOPY NUMBER
3717: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_object_version_number IN OUT NOCOPY NUMBER
3725: ,p_warning OUT NOCOPY BOOLEAN
3718: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_object_version_number IN OUT NOCOPY NUMBER
3725: ,p_warning OUT NOCOPY BOOLEAN
3726: ) IS
3719: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3720: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3721: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3722: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3723: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
3724: ,p_object_version_number IN OUT NOCOPY NUMBER
3725: ,p_warning OUT NOCOPY BOOLEAN
3726: ) IS
3727: --
3812: ,p_object_version_number => l_object_version_number);
3813: --
3814: exception
3815: --
3816: when hr_api.cannot_find_prog_unit then
3817: --
3818: hr_api.cannot_find_prog_unit_error
3819: (p_module_name => 'update_org_information'
3820: ,p_hook_type => 'BP'
3814: exception
3815: --
3816: when hr_api.cannot_find_prog_unit then
3817: --
3818: hr_api.cannot_find_prog_unit_error
3819: (p_module_name => 'update_org_information'
3820: ,p_hook_type => 'BP'
3821: );
3822: end;
3949: ,p_object_version_number => l_object_version_number);
3950: --
3951: exception
3952: --
3953: when hr_api.cannot_find_prog_unit then
3954: --
3955: hr_api.cannot_find_prog_unit_error
3956: (p_module_name => 'update_org_information'
3957: ,p_hook_type => 'AP');
3951: exception
3952: --
3953: when hr_api.cannot_find_prog_unit then
3954: --
3955: hr_api.cannot_find_prog_unit_error
3956: (p_module_name => 'update_org_information'
3957: ,p_hook_type => 'AP');
3958: --
3959: end;
3962: --
3963: -- When in validation only mode raise the Validate_Enabled exception
3964: --
3965: IF p_validate THEN
3966: RAISE hr_api.validate_enabled;
3967: END IF;
3968: --
3969: hr_utility.set_location(l_proc, 70);
3970: --
3977: hr_utility.set_location(' Leaving:'||l_proc, 80);
3978: --
3979: EXCEPTION
3980: --
3981: WHEN hr_api.validate_enabled THEN
3982: --
3983: -- As the Validate_Enabled exception has been raised
3984: -- we must rollback to the savepoint
3985: --
4041: ,p_object_version_number => p_object_version_number);
4042: --
4043: exception
4044: --
4045: when hr_api.cannot_find_prog_unit then
4046: --
4047: hr_api.cannot_find_prog_unit_error
4048: (p_module_name => 'delete_org_manager'
4049: ,p_hook_type => 'BP');
4043: exception
4044: --
4045: when hr_api.cannot_find_prog_unit then
4046: --
4047: hr_api.cannot_find_prog_unit_error
4048: (p_module_name => 'delete_org_manager'
4049: ,p_hook_type => 'BP');
4050: --
4051: -- End of API User Hook for the before hook of delete_org_manager
4065: ,p_object_version_number => l_object_version_number);
4066: --
4067: exception
4068: --
4069: when hr_api.cannot_find_prog_unit then
4070: --
4071: hr_api.cannot_find_prog_unit_error
4072: (p_module_name => 'delete_org_manager'
4073: ,p_hook_type => 'AP');
4067: exception
4068: --
4069: when hr_api.cannot_find_prog_unit then
4070: --
4071: hr_api.cannot_find_prog_unit_error
4072: (p_module_name => 'delete_org_manager'
4073: ,p_hook_type => 'AP');
4074: --
4075: -- End of API User Hook for the after hook of delete_org_manager
4080: --
4081: -- When in validation only mode raise the Validate_Enabled exception
4082: --
4083: if p_validate then
4084: raise hr_api.validate_enabled;
4085: end if;
4086: --
4087: hr_utility.set_location(' Leaving:'||l_proc, 70);
4088: --
4087: hr_utility.set_location(' Leaving:'||l_proc, 70);
4088: --
4089: exception
4090: --
4091: when hr_api.validate_enabled then
4092: --
4093: -- As the Validate_Enabled exception has been raised
4094: -- we must rollback to the savepoint
4095: --
4171: --
4172: -- When in validation only mode raise the Validate_Enabled exception
4173: --
4174: IF p_validate THEN
4175: RAISE hr_api.validate_enabled;
4176: END IF;
4177: --
4178: -- Set all output arguments
4179: --
4183: hr_utility.set_location(' Leaving:'||l_proc, 70);
4184: --
4185: EXCEPTION
4186: --
4187: WHEN hr_api.validate_enabled THEN
4188: --
4189: -- As the Validate_Enabled exception has been raised
4190: -- we must rollback to the savepoint
4191: --
4213: --
4214: PROCEDURE create_business_group
4215: ( p_validate IN BOOLEAN DEFAULT false
4216: ,p_effective_date IN DATE
4217: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4218: --
4219: ,p_date_from IN DATE
4220: ,p_name IN VARCHAR2
4221: ,p_type IN VARCHAR2
4271: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4272: -- be passed through.
4273: --
4274: l_language_code := p_language_code;
4275: hr_api.validate_language_code(p_language_code => l_language_code);
4276: --
4277: hr_utility.set_location(l_proc, 20);
4278: --
4279: -- Process Logic
4344: --
4345: -- When in validation only mode raise the Validate_Enabled exception
4346: --
4347: IF p_validate THEN
4348: RAISE hr_api.validate_enabled;
4349: END IF;
4350: --
4351: -- Set all output arguments
4352: --
4356: hr_utility.set_location(' Leaving:'||l_proc, 80);
4357: --
4358: EXCEPTION
4359: --
4360: WHEN hr_api.validate_enabled THEN
4361: --
4362: -- As the Validate_Enabled exception has been raised
4363: -- we must rollback to the savepoint
4364: --
4537: --
4538: PROCEDURE create_operating_unit
4539: ( p_validate IN BOOLEAN DEFAULT false
4540: ,p_effective_date IN DATE
4541: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4542: --
4543: ,p_business_group_id IN NUMBER
4544: ,p_date_from IN DATE
4545: ,p_name IN VARCHAR2
4584: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4585: -- be passed through.
4586: --
4587: l_language_code := p_language_code;
4588: hr_api.validate_language_code(p_language_code => l_language_code);
4589: --
4590: hr_utility.set_location(l_proc, 20);
4591: --
4592: -- Process Logic
4664: --
4665: -- When in validation only mode raise the Validate_Enabled exception
4666: --
4667: IF p_validate THEN
4668: RAISE hr_api.validate_enabled;
4669: END IF;
4670: --
4671: -- Set all output arguments
4672: --
4678: hr_utility.set_location(' Leaving:'||l_proc, 80);
4679: --
4680: EXCEPTION
4681: --
4682: WHEN hr_api.validate_enabled THEN
4683: --
4684: -- As the Validate_Enabled exception has been raised
4685: -- we must rollback to the savepoint
4686: --
4714: (
4715: p_validate IN BOOLEAN DEFAULT false
4716: ,p_organization_id IN NUMBER
4717: ,p_effective_date IN DATE
4718: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4715: p_validate IN BOOLEAN DEFAULT false
4716: ,p_organization_id IN NUMBER
4717: ,p_effective_date IN DATE
4718: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4716: ,p_organization_id IN NUMBER
4717: ,p_effective_date IN DATE
4718: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4717: ,p_effective_date IN DATE
4718: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4718: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4719: ,p_date_from IN DATE DEFAULT hr_api.g_date
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4727: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4720: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4727: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4728: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4721: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
4722: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4727: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4728: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4729: ,p_object_version_number IN OUT NOCOPY NUMBER
4723: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4727: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4728: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4729: ,p_object_version_number IN OUT NOCOPY NUMBER
4730: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
4731: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
4724: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4725: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
4726: -- Added p_short_code for bug 4526439
4727: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
4728: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
4729: ,p_object_version_number IN OUT NOCOPY NUMBER
4730: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
4731: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
4732: ) IS
4828: --
4829: -- When in validation only mode raise the Validate_Enabled exception
4830: --
4831: IF p_validate THEN
4832: RAISE hr_api.validate_enabled;
4833: END IF;
4834: --
4835: -- Set all output arguments
4836: --
4845: hr_utility.set_location(' Leaving:'||l_proc, 30);
4846: --
4847: EXCEPTION
4848: --
4849: WHEN hr_api.validate_enabled THEN
4850: --
4851: -- As the Validate_Enabled exception has been raised
4852: -- we must rollback to the savepoint
4853: --
4882: --
4883: PROCEDURE create_legal_entity
4884: ( p_validate IN BOOLEAN DEFAULT false
4885: ,p_effective_date IN DATE
4886: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
4887: --
4888: ,p_business_group_id IN NUMBER
4889: ,p_date_from IN DATE
4890: ,p_name IN VARCHAR2
4929: -- instead of p_language_code from now on, to allow an IN OUT parameter to
4930: -- be passed through.
4931: --
4932: l_language_code := p_language_code;
4933: hr_api.validate_language_code(p_language_code => l_language_code);
4934: --
4935: hr_utility.set_location(l_proc, 20);
4936: --
4937: -- Process Logic
4980: --
4981: -- When in validation only mode raise the Validate_Enabled exception
4982: --
4983: IF p_validate THEN
4984: RAISE hr_api.validate_enabled;
4985: END IF;
4986: --
4987: -- Set all output arguments
4988: --
4992: hr_utility.set_location(' Leaving:'||l_proc, 80);
4993: --
4994: EXCEPTION
4995: --
4996: WHEN hr_api.validate_enabled THEN
4997: --
4998: -- As the Validate_Enabled exception has been raised
4999: -- we must rollback to the savepoint
5000: --
5167: --
5168: -- When in validation only mode raise the Validate_Enabled exception
5169: --
5170: IF p_validate THEN
5171: RAISE hr_api.validate_enabled;
5172: END IF;
5173: --
5174: --
5175: hr_utility.set_location(' Leaving:'||l_proc, 80);
5175: hr_utility.set_location(' Leaving:'||l_proc, 80);
5176: --
5177: EXCEPTION
5178: --
5179: WHEN hr_api.validate_enabled THEN
5180: --
5181: -- As the Validate_Enabled exception has been raised
5182: -- we must rollback to the savepoint
5183: --
5324: --
5325: -- When in validation only mode raise the Validate_Enabled exception
5326: --
5327: IF p_validate THEN
5328: RAISE hr_api.validate_enabled;
5329: END IF;
5330: --
5331: --
5332: hr_utility.set_location(' Leaving:'||l_proc, 80);
5332: hr_utility.set_location(' Leaving:'||l_proc, 80);
5333: --
5334: EXCEPTION
5335: --
5336: WHEN hr_api.validate_enabled THEN
5337: --
5338: -- As the Validate_Enabled exception has been raised
5339: -- we must rollback to the savepoint
5340: --
5418: --
5419: -- When in validation only mode raise the Validate_Enabled exception
5420: --
5421: IF p_validate THEN
5422: RAISE hr_api.validate_enabled;
5423: END IF;
5424: --
5425: --
5426: hr_utility.set_location(' Leaving:'||l_proc, 80);
5426: hr_utility.set_location(' Leaving:'||l_proc, 80);
5427: --
5428: EXCEPTION
5429: --
5430: WHEN hr_api.validate_enabled THEN
5431: --
5432: -- As the Validate_Enabled exception has been raised
5433: -- we must rollback to the savepoint
5434: --
5456: --
5457: PROCEDURE trans_org_name
5458: ( p_validate IN BOOLEAN DEFAULT false
5459: ,p_effective_date IN DATE
5460: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
5461: --
5462: ,p_organization_id IN NUMBER
5463: ,p_name IN VARCHAR2
5464: ) IS
5484: -- instead of p_language_code from now on, to allow an IN OUT parameter to
5485: -- be passed through.
5486: --
5487: l_language_code := p_language_code;
5488: hr_api.validate_language_code(p_language_code => l_language_code);
5489: --
5490: hr_utility.set_location(l_proc, 20);
5491: --
5492: --
5490: hr_utility.set_location(l_proc, 20);
5491: --
5492: --
5493: --
5494: hr_api.mandatory_arg_error
5495: (p_api_name => l_proc
5496: ,p_argument => 'LANGUAGE'
5497: ,p_argument_value => p_language_code
5498: );
5497: ,p_argument_value => p_language_code
5498: );
5499: --
5500: --
5501: hr_api.mandatory_arg_error
5502: (p_api_name => l_proc
5503: ,p_argument => 'ORGANIZATION_ID'
5504: ,p_argument_value => p_organization_id
5505: );
5504: ,p_argument_value => p_organization_id
5505: );
5506: --
5507: --
5508: hr_api.mandatory_arg_error
5509: (p_api_name => l_proc
5510: ,p_argument => 'NAME'
5511: ,p_argument_value => p_name
5512: );
5526: --
5527: -- When in validation only mode raise the Validate_Enabled exception
5528: --
5529: IF p_validate THEN
5530: RAISE hr_api.validate_enabled;
5531: END IF;
5532: --
5533: -- Set all output arguments
5534: --
5536: hr_utility.set_location(' Leaving:'||l_proc, 70);
5537: --
5538: EXCEPTION
5539: --
5540: WHEN hr_api.validate_enabled THEN
5541: --
5542: -- As the Validate_Enabled exception has been raised
5543: -- we must rollback to the savepoint
5544: --
5608: ,p_costcenter => p_costcenter
5609: );
5610:
5611: exception
5612: when hr_api.cannot_find_prog_unit then
5613: hr_api.cannot_find_prog_unit_error
5614: (p_module_name => 'create_company_cost_center'
5615: ,p_hook_type => 'BP'
5616: );
5609: );
5610:
5611: exception
5612: when hr_api.cannot_find_prog_unit then
5613: hr_api.cannot_find_prog_unit_error
5614: (p_module_name => 'create_company_cost_center'
5615: ,p_hook_type => 'BP'
5616: );
5617: end;
5668: ,p_object_version_number => p_object_version_number
5669: );
5670:
5671: exception
5672: when hr_api.cannot_find_prog_unit then
5673: hr_api.cannot_find_prog_unit_error
5674: (p_module_name => 'create_company_cost_center'
5675: ,p_hook_type => 'AP'
5676: );
5669: );
5670:
5671: exception
5672: when hr_api.cannot_find_prog_unit then
5673: hr_api.cannot_find_prog_unit_error
5674: (p_module_name => 'create_company_cost_center'
5675: ,p_hook_type => 'AP'
5676: );
5677: end;
5681: --
5682: -- When in validation only mode raise the Validate_Enabled exception
5683: --
5684: IF p_validate THEN
5685: RAISE hr_api.validate_enabled;
5686: END IF;
5687: --
5688: --
5689: hr_utility.set_location(' Leaving:'||l_proc, 70);
5689: hr_utility.set_location(' Leaving:'||l_proc, 70);
5690: --
5691: EXCEPTION
5692: --
5693: WHEN hr_api.validate_enabled THEN
5694: --
5695: -- As the Validate_Enabled exception has been raised
5696: -- we must rollback to the savepoint
5697: --
5737: --
5738: PROCEDURE create_not_usable_ou_internal
5739: (p_validate IN BOOLEAN DEFAULT FALSE
5740: ,p_effective_date IN DATE
5741: ,p_language_code IN VARCHAR2 DEFAULT HR_API.userenv_lang
5742: ,p_business_group_id IN NUMBER
5743: ,p_date_from IN DATE
5744: ,p_name IN VARCHAR2
5745: ,p_type IN VARCHAR2
5777: -- Validate language parameter. l_language_code should be passed to functions
5778: -- instead of p_language_code from now on to allow IN OUT param to be passed.
5779: --
5780: l_language_code := p_language_code;
5781: hr_api.validate_language_code(p_language_code => l_language_code);
5782: --
5783: hr_utility.set_location(l_proc, 20);
5784: --
5785: -- Process Logic
5821: --
5822: -- When in validation only mode raise the Validate_Enabled exception
5823: --
5824: IF p_validate THEN
5825: RAISE hr_api.validate_enabled;
5826: END IF;
5827: --
5828: -- Set all output arguments
5829: --
5833: hr_utility.set_location(' Leaving:'||l_proc, 80);
5834: --
5835: EXCEPTION
5836: --
5837: WHEN hr_api.validate_enabled THEN
5838: --
5839: -- As the Validate_Enabled exception has been raised
5840: -- we must rollback to the savepoint
5841: --