[Home] [Help]
3651: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
3652: * be inserted into HZ_PERSON_PROFILES table.
3653: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
3654: * to the position of the decimal point, replace this with
3655: * the correct value from fnd_lookup_values provided that the
3656: * actual_content_source for this record is not 'USER_ENTERED'.
3657: * 31-DEC-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
3658: * Call HZ_MIXNM_UTILITY.create_exceptions if actual_content_source
3659: * is some third party content source and no prior profile exists..
3799: p_organization_rec.local_activity_code IS NOT NULL
3800: THEN
3801: SELECT lookup_code
3802: INTO p_organization_rec.local_activity_code
3803: FROM FND_LOOKUP_VALUES
3804: WHERE lookup_type = 'NACE'
3805: AND replace (lookup_code,'.','') = replace (p_organization_rec.local_activity_code,'.','')
3806: AND rownum = 1;
3807: -- No need to handle no_data_found as this validation is already done in HZ_REGISTRY_VALIDATE_V2PUB.
4375: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
4376: * be updated into HZ_PERSON_PROFILES table.
4377: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
4378: * to the position of the decimal point, replace this with
4379: * the correct value from fnd_lookup_values provided that the
4380: * actual_content_source for this record is not 'USER_ENTERED'.
4381: */
4382:
4383: PROCEDURE do_update_party (
4536: AND p_organization_rec.local_activity_code <> fnd_api.g_miss_char
4537: THEN
4538: SELECT lookup_code
4539: INTO p_organization_rec.local_activity_code
4540: FROM FND_LOOKUP_VALUES
4541: WHERE lookup_type = 'NACE'
4542: AND replace (lookup_code,'.','') = replace (p_organization_rec.local_activity_code,'.','')
4543: AND rownum = 1;
4544: -- No need to handle no_data_found as this validation is already done in HZ_REGISTRY_VALIDATE_V2PUB.