DBA Data[Home] [Help]

APPS.ARP_CPROF1_PKG dependencies on FND_GLOBAL

Line 166: last_updated_by = fnd_global.user_id,

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

Line 167: last_update_login = fnd_global.login_id

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

Line 173: last_updated_by = fnd_global.user_id,

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;

Line 174: last_update_login = fnd_global.login_id

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: