[Home] [Help]
3600: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
3601: * be inserted into HZ_PERSON_PROFILES table.
3602: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
3603: * to the position of the decimal point, replace this with
3604: * the correct value from fnd_lookup_values provided that the
3605: * actual_content_source for this record is not 'USER_ENTERED'.
3606: * 31-DEC-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
3607: * Call HZ_MIXNM_UTILITY.create_exceptions if actual_content_source
3608: * is some third party content source and no prior profile exists..
3745: p_organization_rec.local_activity_code IS NOT NULL
3746: THEN
3747: SELECT lookup_code
3748: INTO p_organization_rec.local_activity_code
3749: FROM FND_LOOKUP_VALUES
3750: WHERE lookup_type = 'NACE'
3751: AND replace (lookup_code,'.','') = replace (p_organization_rec.local_activity_code,'.','')
3752: AND rownum = 1;
3753: -- No need to handle no_data_found as this validation is already done in HZ_REGISTRY_VALIDATE_V2PUB.
4316: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
4317: * be updated into HZ_PERSON_PROFILES table.
4318: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
4319: * to the position of the decimal point, replace this with
4320: * the correct value from fnd_lookup_values provided that the
4321: * actual_content_source for this record is not 'USER_ENTERED'.
4322: */
4323:
4324: PROCEDURE do_update_party (
4476: p_organization_rec.local_activity_code IS NOT NULL
4477: THEN
4478: SELECT lookup_code
4479: INTO p_organization_rec.local_activity_code
4480: FROM FND_LOOKUP_VALUES
4481: WHERE lookup_type = 'NACE'
4482: AND replace (lookup_code,'.','') = replace (p_organization_rec.local_activity_code,'.','')
4483: AND rownum = 1;
4484: -- No need to handle no_data_found as this validation is already done in HZ_REGISTRY_VALIDATE_V2PUB.