APPS.AMS_LIST_RULES_PKG dependencies on AMS_LIST_RULES_ALL_TL

Line 62: insert into AMS_LIST_RULES_ALL_TL (

58: x_ENABLED_FLAG,
59: x_SEEDED_FLAG
60: );
61:
62: insert into AMS_LIST_RULES_ALL_TL (
63: LIST_RULE_ID,
64: LAST_UPDATE_DATE,
65: LAST_UPDATED_BY,
66: CREATION_DATE,

Line 88: from AMS_LIST_RULES_ALL_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from AMS_LIST_RULES_ALL_TL T
89: where T.LIST_RULE_ID = X_LIST_RULE_ID
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: open c;

Line 182: update AMS_LIST_RULES_ALL_TL set

178:
179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182: update AMS_LIST_RULES_ALL_TL set
183: LIST_RULE_NAME = X_LIST_RULE_NAME,
184: DESCRIPTION = X_DESCRIPTION,
185: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 201: delete from AMS_LIST_RULES_ALL_TL

197: procedure DELETE_ROW (
198: X_LIST_RULE_ID in NUMBER
199: ) is
200: begin
201: delete from AMS_LIST_RULES_ALL_TL
202: where LIST_RULE_ID = X_LIST_RULE_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 336: FROM AMS_LIST_RULES_ALL_TL

332: ) IS
333:
334: cursor c_last_updated_by is
335: select last_updated_by
336: FROM AMS_LIST_RULES_ALL_TL
337: where LIST_RULE_ID = X_LIST_RULE_ID
338: and USERENV('LANG') = LANGUAGE;
339:
340: l_last_updated_by number;

Line 353: UPDATE AMS_LIST_RULES_ALL_TL

349: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
350:
351:
352: -- only UPDATE rows that have not been altered by user
353: UPDATE AMS_LIST_RULES_ALL_TL
354: SET
355: LIST_RULE_NAME = NVL(X_LIST_RULE_NAME, LIST_RULE_NAME),
356: DESCRIPTION = NVL(X_DESCRIPTION, DESCRIPTION),
357: SOURCE_LANG = userenv('LANG'),