DBA Data[Home] [Help]

APPS.AMS_QUERY_TEMP_INST_PKG dependencies on AMS_QUERY_TEMP_INST_PKG

Line 1: package body AMS_QUERY_TEMP_INST_PKG as

1: package body AMS_QUERY_TEMP_INST_PKG as
2: /* $Header: amstqieb.pls 120.0 2005/06/01 03:28:58 appldev noship $ */
3: procedure INSERT_ROW (
4: X_TEMPLATE_INSTANCE_ID in NUMBER,
5: X_TEMPLATE_ID in NUMBER,

Line 200: AMS_QUERY_TEMP_INST_PKG.insert_row (

196: l_TEMPLATE_INSTANCE_ID := x_TEMPLATE_INSTANCE_ID;
197: END IF;
198: l_obj_verno := 1;
199:
200: AMS_QUERY_TEMP_INST_PKG.insert_row (
201: x_TEMPLATE_INSTANCE_ID => l_TEMPLATE_INSTANCE_ID,
202: x_last_update_date => SYSDATE,
203: x_last_updated_by => l_user_id,
204: x_creation_date => SYSDATE,

Line 226: AMS_QUERY_TEMP_INST_PKG.update_row (

222:
223: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
224: then
225:
226: AMS_QUERY_TEMP_INST_PKG.update_row (
227: x_TEMPLATE_INSTANCE_ID => x_TEMPLATE_INSTANCE_ID,
228: x_last_update_date => SYSDATE,
229: x_last_updated_by => l_user_id,
230: x_last_update_login => 0,

Line 246: end AMS_QUERY_TEMP_INST_PKG;

242: END IF;
243: END load_row;
244:
245:
246: end AMS_QUERY_TEMP_INST_PKG;