DBA Data[Home] [Help]

APPS.AMS_COND_STRUCT_RESTR_VAL_PKG dependencies on AMS_COND_STRUCT_RESTR_VAL_PKG

Line 1: package body AMS_COND_STRUCT_RESTR_VAL_PKG as

1: package body AMS_COND_STRUCT_RESTR_VAL_PKG as
2: /* $Header: amstqcrb.pls 120.0 2005/05/31 22:42:36 appldev noship $ */
3: procedure INSERT_ROW (
4: X_COND_STRUCT_RESTRICT_ID in NUMBER,
5: X_QUERY_COND_DISP_STRUCT_ID in NUMBER,

Line 187: AMS_COND_STRUCT_RESTR_VAL_PKG.insert_row (

183: l_COND_STRUCT_RESTRICT_ID := x_COND_STRUCT_RESTRICT_ID;
184: END IF;
185: l_obj_verno := 1;
186:
187: AMS_COND_STRUCT_RESTR_VAL_PKG.insert_row (
188: x_COND_STRUCT_RESTRICT_ID => l_COND_STRUCT_RESTRICT_ID,
189: x_last_update_date => SYSDATE,
190: x_last_updated_by => l_user_id,
191: x_creation_date => SYSDATE,

Line 212: AMS_COND_STRUCT_RESTR_VAL_PKG.update_row (

208:
209: if (l_db_luby_id IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
210: then
211:
212: AMS_COND_STRUCT_RESTR_VAL_PKG.update_row (
213: x_COND_STRUCT_RESTRICT_ID => x_COND_STRUCT_RESTRICT_ID,
214: x_last_update_date => SYSDATE,
215: x_last_updated_by => l_user_id,
216: x_last_update_login => 0,

Line 230: end AMS_COND_STRUCT_RESTR_VAL_PKG;

226: END IF;
227: END load_row;
228:
229:
230: end AMS_COND_STRUCT_RESTR_VAL_PKG;