DBA Data[Home] [Help]

APPS.FEM_CUST_STAT_PKG dependencies on FND_LOAD_UTIL

Line 302: f_luby := fnd_load_util.owner_id(x_owner);

298: begin
299:
300:
301: -- Translate owner to file_last_updated_by
302: f_luby := fnd_load_util.owner_id(x_owner);
303:
304: -- Translate char last_update_date to date
305: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
306: begin

Line 314: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

310: where CUSTOMER_STATUS_ID = x_CUSTOMER_STATUS_ID
311: and LANGUAGE = userenv('LANG');
312:
313: -- Test for customization and version
314: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
315: db_ludate, x_custom_mode)) then
316: -- Update translations for this language
317: update FEM_CUST_STAT_TL set
318: CUSTOMER_STATUS_NAME = decode(x_CUSTOMER_STATUS_NAME,

Line 319: fnd_load_util.null_value, null, -- Real null

315: db_ludate, x_custom_mode)) then
316: -- Update translations for this language
317: update FEM_CUST_STAT_TL set
318: CUSTOMER_STATUS_NAME = decode(x_CUSTOMER_STATUS_NAME,
319: fnd_load_util.null_value, null, -- Real null
320: null, x_CUSTOMER_STATUS_NAME, -- No change
321: x_CUSTOMER_STATUS_NAME),
322: DESCRIPTION = nvl(x_description, DESCRIPTION),
323: LAST_UPDATE_DATE = f_ludate,