DBA Data[Home] [Help]

APPS.AMS_QUERY_ALIAS_PKG dependencies on AMS_QUERY_ALIAS_PKG

Line 1: package body AMS_QUERY_ALIAS_PKG as

1: package body AMS_QUERY_ALIAS_PKG as
2: /* $Header: amstqalb.pls 120.0 2005/06/01 23:39:11 appldev noship $ */
3: procedure INSERT_ROW (
4: X_QUERY_ALIAS_ID in NUMBER,
5: X_OBJECT_VERSION_NUMBER in NUMBER,

Line 189: AMS_QUERY_ALIAS_PKG.insert_row (

185: l_QUERY_ALIAS_ID := x_QUERY_ALIAS_ID;
186: END IF;
187: l_obj_verno := 1;
188:
189: AMS_QUERY_ALIAS_PKG.insert_row (
190: x_QUERY_ALIAS_ID => l_QUERY_ALIAS_ID,
191: X_OBJECT_NAME => X_OBJECT_NAME,
192: x_last_update_date => SYSDATE,
193: x_last_updated_by => l_user_id,

Line 215: AMS_QUERY_ALIAS_PKG.update_row (

211:
212: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
213: then
214:
215: AMS_QUERY_ALIAS_PKG.update_row (
216: x_QUERY_ALIAS_ID => x_QUERY_ALIAS_ID,
217: X_OBJECT_NAME => X_OBJECT_NAME,
218: x_last_update_date => SYSDATE,
219: x_last_updated_by => l_user_id,

Line 235: end AMS_QUERY_ALIAS_PKG;

231: END load_row;
232:
233:
234:
235: end AMS_QUERY_ALIAS_PKG;