162: BEGIN
163: if (p_site_use_id is null) then
164: update hz_customer_profiles
165: set credit_hold = p_credit_hold, LAST_UPDATE_DATE = sysdate,
166: last_updated_by = fnd_global.user_id,
167: last_update_login = fnd_global.login_id
168: where CUST_ACCOUNT_ID= p_customer_id
169: and site_use_id is null;
170: else
163: if (p_site_use_id is null) then
164: update hz_customer_profiles
165: set credit_hold = p_credit_hold, LAST_UPDATE_DATE = sysdate,
166: last_updated_by = fnd_global.user_id,
167: last_update_login = fnd_global.login_id
168: where CUST_ACCOUNT_ID= p_customer_id
169: and site_use_id is null;
170: else
171: update hz_customer_profiles
169: and site_use_id is null;
170: else
171: update hz_customer_profiles
172: set credit_hold = p_credit_hold, LAST_UPDATE_DATE = sysdate,
173: last_updated_by = fnd_global.user_id,
174: last_update_login = fnd_global.login_id
175: where CUST_ACCOUNT_ID = p_customer_id
176: and site_use_id = p_site_use_id;
177: end if;
170: else
171: update hz_customer_profiles
172: set credit_hold = p_credit_hold, LAST_UPDATE_DATE = sysdate,
173: last_updated_by = fnd_global.user_id,
174: last_update_login = fnd_global.login_id
175: where CUST_ACCOUNT_ID = p_customer_id
176: and site_use_id = p_site_use_id;
177: end if;
178: