APPS.AMS_LIST_RULES_PKG dependencies on AMS_LIST_RULES_ALL

Line 22: cursor C is select ROWID from AMS_LIST_RULES_ALL

18: x_LIST_SOURCE_TYPE in VARCHAR2,
19: x_ENABLED_FLAG in VARCHAR2,
20: x_SEEDED_FLAG in VARCHAR2
21: ) is
22: cursor C is select ROWID from AMS_LIST_RULES_ALL
23: where LIST_RULE_ID = X_LIST_RULE_ID
24: ;
25: begin
26: insert into AMS_LIST_RULES_ALL (

Line 26: insert into AMS_LIST_RULES_ALL (

22: cursor C is select ROWID from AMS_LIST_RULES_ALL
23: where LIST_RULE_ID = X_LIST_RULE_ID
24: ;
25: begin
26: insert into AMS_LIST_RULES_ALL (
27: LIST_RULE_ID,
28: LAST_UPDATE_DATE,
29: LAST_UPDATED_BY,
30: CREATION_DATE,

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 120: from AMS_LIST_RULES_ALL

116: ACTIVE_FROM_DATE,
117: ACTIVE_TO_DATE,
118: LIST_RULE_TYPE,
119: DESCRIPTION
120: from AMS_LIST_RULES_ALL
121: where LIST_RULE_ID = X_LIST_RULE_ID
122: for update of LIST_RULE_ID nowait;
123: begin
124: for tlinfo in c1 loop

Line 163: update AMS_LIST_RULES_ALL set

159: x_ENABLED_FLAG in VARCHAR2,
160: x_SEEDED_FLAG in VARCHAR2
161: ) is
162: begin
163: update AMS_LIST_RULES_ALL set
164: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
165: LIST_RULE_NAME = X_LIST_RULE_NAME,
166: WEIGHTAGE_FOR_DEDUPE = X_WEIGHTAGE_FOR_DEDUPE,
167: ACTIVE_FROM_DATE = X_ACTIVE_FROM_DATE,

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 208: delete from AMS_LIST_RULES_ALL

204: if (sql%notfound) then
205: raise no_data_found;
206: end if;
207:
208: delete from AMS_LIST_RULES_ALL
209: where LIST_RULE_ID = X_LIST_RULE_ID;
210:
211: if (sql%notfound) then
212: raise no_data_found;

Line 242: FROM ams_list_rules_all

238: l_last_updated_by number;
239:
240: CURSOR c_obj_verno IS
241: SELECT object_version_number, last_updated_by
242: FROM ams_list_rules_all
243: WHERE list_rule_id = x_list_rule_id;
244:
245: CURSOR c_chk_exists is
246: SELECT 'x'

Line 247: FROM ams_list_rules_all

243: WHERE list_rule_id = x_list_rule_id;
244:
245: CURSOR c_chk_exists is
246: SELECT 'x'
247: FROM ams_list_rules_all
248: WHERE list_rule_id = x_list_rule_id;
249:
250: CURSOR c_get_id is
251: SELECT ams_list_rules_all_s.NEXTVAL

Line 251: SELECT ams_list_rules_all_s.NEXTVAL

247: FROM ams_list_rules_all
248: WHERE list_rule_id = x_list_rule_id;
249:
250: CURSOR c_get_id is
251: SELECT ams_list_rules_all_s.NEXTVAL
252: FROM DUAL;
253: BEGIN
254: if X_OWNER = 'SEED' then
255: l_user_id := 1;

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'),