DBA Data[Home] [Help]

APPS.IEC_HZ_PHONE_AREA_CODES_PKG dependencies on FND_LOAD_UTIL

Line 147: USER_ID := fnd_load_util.owner_id(x_owner);

143: USER_ID NUMBER := 0;
144: ROW_ID VARCHAR2(500);
145: begin
146:
147: USER_ID := fnd_load_util.owner_id(x_owner);
148:
149: UPDATE_ROW (X_TERRITORY_CODE, X_PHONE_COUNTRY_CODE, X_AREA_CODE, X_DESCRIPTION, USER_ID, SYSDATE, USER_ID, 0);
150:
151: exception

Line 197: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),

193: update HZ_PHONE_AREA_CODES
194: set PHONE_COUNTRY_CODE = X_PHONE_COUNTRY_CODE,
195: DESCRIPTION = X_DESCRIPTION,
196: LAST_UPDATE_DATE = SYSDATE,
197: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
198: LAST_UPDATE_LOGIN = 0
199: where TERRITORY_CODE = X_TERRITORY_CODE
200: and AREA_CODE = X_AREA_CODE
201: and userenv('LANG') = ( select LANGUAGE_CODE from FND_LANGUAGES