DBA Data[Home] [Help]

APPS.PQH_ROLE_INFO_TYPES_PKG dependencies on FND_LOAD_UTIL

Line 252: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

248: Where INFORMATION_TYPE = X_INFORMATION_TYPE;
249: --
250: begin
251: -- Translate developer keys to internal parameters
252: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
253: l_created_by := fnd_load_util.owner_id(X_OWNER);
254: l_creation_date := nvl(to_date(x_last_update_date,'YYYY/MM/DD'),trunc(sysdate));
255: l_last_update_date := nvl(to_date(x_last_update_date,'YYYY/MM/DD'),trunc(sysdate));
256:

Line 253: l_created_by := fnd_load_util.owner_id(X_OWNER);

249: --
250: begin
251: -- Translate developer keys to internal parameters
252: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
253: l_created_by := fnd_load_util.owner_id(X_OWNER);
254: l_creation_date := nvl(to_date(x_last_update_date,'YYYY/MM/DD'),trunc(sysdate));
255: l_last_update_date := nvl(to_date(x_last_update_date,'YYYY/MM/DD'),trunc(sysdate));
256:
257: Open csr_info_typ_exists;

Line 344: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

340: )
341: is
342: l_last_updated_by PQH_ROLE_INFO_TYPES.last_updated_by%TYPE := 0;
343: begin
344: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
345: --
346: UPDATE PQH_ROLE_INFO_TYPES
347: SET description = X_DESCRIPTION
348: ,last_update_date = SYSDATE