2956: SET person_party_id = l_person_party_id,
2957: object_version_number = object_version_number +
2958: 1,
2959: last_update_date = SYSDATE,
2960: last_updated_by = fnd_global.user_id,
2961: last_update_login = fnd_global.login_id
2962: WHERE chr_id = p_contract_id;
2963:
2964: -- bump up the minor version number
2957: object_version_number = object_version_number +
2958: 1,
2959: last_update_date = SYSDATE,
2960: last_updated_by = fnd_global.user_id,
2961: last_update_login = fnd_global.login_id
2962: WHERE chr_id = p_contract_id;
2963:
2964: -- bump up the minor version number
2965: UPDATE okc_k_vers_numbers
2967: 1,
2968: object_version_number = object_version_number +
2969: 1,
2970: last_update_date = SYSDATE,
2971: last_updated_by = fnd_global.user_id,
2972: last_update_login = fnd_global.login_id
2973: WHERE chr_id = p_contract_id;
2974: END IF; -- l_person_party_id is null in oks_k_headers_b
2975:
2968: object_version_number = object_version_number +
2969: 1,
2970: last_update_date = SYSDATE,
2971: last_updated_by = fnd_global.user_id,
2972: last_update_login = fnd_global.login_id
2973: WHERE chr_id = p_contract_id;
2974: END IF; -- l_person_party_id is null in oks_k_headers_b
2975:
2976: -- Check if record exists in fnd_user for the above person_party_id