2811: SET person_party_id = l_person_party_id,
2812: object_version_number = object_version_number +
2813: 1,
2814: last_update_date = SYSDATE,
2815: last_updated_by = fnd_global.user_id,
2816: last_update_login = fnd_global.login_id
2817: WHERE chr_id = p_contract_id;
2818:
2819: -- bump up the minor version number
2812: object_version_number = object_version_number +
2813: 1,
2814: last_update_date = SYSDATE,
2815: last_updated_by = fnd_global.user_id,
2816: last_update_login = fnd_global.login_id
2817: WHERE chr_id = p_contract_id;
2818:
2819: -- bump up the minor version number
2820: UPDATE okc_k_vers_numbers
2822: 1,
2823: object_version_number = object_version_number +
2824: 1,
2825: last_update_date = SYSDATE,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id
2828: WHERE chr_id = p_contract_id;
2829: END IF; -- l_person_party_id is null in oks_k_headers_b
2830:
2823: object_version_number = object_version_number +
2824: 1,
2825: last_update_date = SYSDATE,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id
2828: WHERE chr_id = p_contract_id;
2829: END IF; -- l_person_party_id is null in oks_k_headers_b
2830:
2831: -- Check if record exists in fnd_user for the above person_party_id