DBA Data[Home] [Help]

APPS.HZ_TRANS_ATTRIBUTES_PKG dependencies on HZ_TRANS_ATTRIBUTES_VL

Line 243: SELECT 1 INTO TMP FROM HZ_TRANS_ATTRIBUTES_VL

239: l_db_denorm_flag VARCHAR2(1);
240: TMP NUMBER;
241: begin
242:
243: SELECT 1 INTO TMP FROM HZ_TRANS_ATTRIBUTES_VL
244: where attribute_id=X_ATTRIBUTE_ID;
245:
246: l_object_version_number := NVL(X_object_version_number, 1) + 1;
247:

Line 251: from HZ_TRANS_ATTRIBUTES_VL

247:
248: select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME,
249: CUSTOM_ATTRIBUTE_PROCEDURE, LAST_UPDATED_BY, nvl(DENORM_FLAG,'N')
250: into l_db_atr_name, l_db_user_def_atr, l_db_cus_atr_proc, l_db_upd_by, l_db_denorm_flag
251: from HZ_TRANS_ATTRIBUTES_VL
252: where attribute_id=X_ATTRIBUTE_ID;
253:
254: IF (X_LAST_UPDATED_BY = 1 AND l_db_upd_by <> 1) THEN
255: -- coming from seed and data modified by user