APPS.AMS_COLUMN_RULES_PKG dependencies on AMS_COLUMN_RULES

Line 1: PACKAGE BODY AMS_COLUMN_RULES_PKG as

1: PACKAGE BODY AMS_COLUMN_RULES_PKG as
2: /* $Header: amslclrb.pls 120.1 2005/06/27 05:38:12 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_COLUMN_RULE_ID in NUMBER,

Line 28: insert into AMS_COLUMN_RULES (

24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: )is
27: begin
28: insert into AMS_COLUMN_RULES (
29: COLUMN_RULE_ID,
30: COLUMNS_METADATA_ID,
31: OBJECT_TYPE,
32: OBJECT_ATTRIBUTE,

Line 111: from AMS_COLUMN_RULES

107: SECURITY_GROUP_ID,
108: OBJECT_VERSION_NUMBER,
109: APPLICATION_ID,
110: COLUMN_RULE_ID
111: from AMS_COLUMN_RULES
112: where COLUMN_RULE_ID = X_COLUMN_RULE_ID
113: for update of COLUMN_RULE_ID nowait;
114: begin
115: for tlinfo in c1 loop

Line 179: update AMS_COLUMN_RULES set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update AMS_COLUMN_RULES set
180: COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID,
181: OBJECT_TYPE = X_OBJECT_TYPE,
182: OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE,
183: AK_REGION_CODE = X_AK_REGION_CODE,

Line 210: delete from AMS_COLUMN_RULES

206: procedure DELETE_ROW (
207: X_COLUMN_RULE_ID in NUMBER
208: ) is
209: begin
210: delete from AMS_COLUMN_RULES
211: where COLUMN_RULE_ID = X_COLUMN_RULE_ID;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 248: from AMS_COLUMN_RULES

244:
245:
246: cursor c_obj_verno is
247: select object_version_number, column_rule_id
248: from AMS_COLUMN_RULES
249: where OBJECT_TYPE = X_OBJECT_TYPE
250: and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
251: and nvl(ACTIVITY_TYPE_CODE,0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
252: and HTML_FORM_PARAM = X_HTML_FORM_PARAM

Line 260: from AMS_COLUMN_RULES

256: and COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;
257:
258: cursor c_chk_colrule_exists is
259: select 'x'
260: from AMS_COLUMN_RULES
261: where OBJECT_TYPE = X_OBJECT_TYPE
262: and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
263: and nvl(ACTIVITY_TYPE_CODE, 0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
264: and HTML_FORM_PARAM = X_HTML_FORM_PARAM

Line 273: select AMS_COLUMN_RULES_S.nextval

269:
270: --where COLUMN_RULE_ID = X_COLUMN_RULE_ID;
271:
272: cursor c_get_colrule_id is
273: select AMS_COLUMN_RULES_S.nextval
274: from dual;
275:
276: cursor c_id_exists(id_in IN NUMBER) is
277: select 'x'

Line 278: from AMS_COLUMN_RULES

274: from dual;
275:
276: cursor c_id_exists(id_in IN NUMBER) is
277: select 'x'
278: from AMS_COLUMN_RULES
279: where COLUMN_RULE_ID = id_in;
280:
281: BEGIN
282: if X_OWNER = 'SEED' then

Line 314: AMS_COLUMN_RULES_PKG.INSERT_ROW (

310: exit;
311: end if;
312: END LOOP;
313:
314: AMS_COLUMN_RULES_PKG.INSERT_ROW (
315: X_ROWID => l_row_id,
316: X_COLUMN_RULE_ID => l_colrule_id,
317: X_COLUMNS_METADATA_ID => X_COLUMNS_METADATA_ID,
318: X_OBJECT_TYPE => X_OBJECT_TYPE,

Line 345: AMS_COLUMN_RULES_PKG.UPDATE_ROW(

341: fetch c_obj_verno into l_obj_verno,l_colrule_id;
342: close c_obj_verno;
343: -- assigning value for l_user_status_id
344: --l_colrule_id := X_COLUMN_RULE_ID := l_colrule_id;
345: AMS_COLUMN_RULES_PKG.UPDATE_ROW(
346: X_COLUMN_RULE_ID => l_colrule_id,
347: X_COLUMNS_METADATA_ID => X_COLUMNS_METADATA_ID,
348: X_OBJECT_TYPE => X_OBJECT_TYPE,
349: X_OBJECT_ATTRIBUTE => X_OBJECT_ATTRIBUTE,

Line 369: end AMS_COLUMN_RULES_PKG;

365: );
366: END IF;
367: end LOAD_ROW;
368:
369: end AMS_COLUMN_RULES_PKG;