eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_RULES_ALL_PKG dependencies on AMS_LIST_RULES_ALL

Line 1: package body AMS_LIST_RULES_ALL_PKG as

1: package body AMS_LIST_RULES_ALL_PKG as
2: /* $Header: amstlsrb.pls 120.1 2005/06/27 05:40:31 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_LIST_RULE_ID in NUMBER,

Line 22: cursor C is select ROWID from AMS_LIST_RULES_ALL

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
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_SOURCE_TYPE,
28: ENABLED_FLAG,
29: SEEDED_FLAG,
30: LIST_RULE_ID,

Line 60: insert into AMS_LIST_RULES_ALL_TL (

56: X_LAST_UPDATE_LOGIN,
57: X_LIST_RULE_NAME
58: );
59:
60: insert into AMS_LIST_RULES_ALL_TL (
61: LIST_RULE_ID,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,
64: CREATION_DATE,

Line 86: from AMS_LIST_RULES_ALL_TL T

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

Line 122: from AMS_LIST_RULES_ALL

118: WEIGHTAGE_FOR_DEDUPE,
119: ACTIVE_FROM_DATE,
120: ACTIVE_TO_DATE,
121: LIST_RULE_TYPE
122: from AMS_LIST_RULES_ALL
123: where LIST_RULE_ID = X_LIST_RULE_ID
124: for update of LIST_RULE_ID nowait;
125: recinfo c%rowtype;
126:

Line 131: from AMS_LIST_RULES_ALL_TL

127: cursor c1 is select
128: LIST_RULE_NAME,
129: DESCRIPTION,
130: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
131: from AMS_LIST_RULES_ALL_TL
132: where LIST_RULE_ID = X_LIST_RULE_ID
133: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
134: for update of LIST_RULE_ID nowait;
135: begin

Line 199: update AMS_LIST_RULES_ALL set

195: X_LAST_UPDATED_BY in NUMBER,
196: X_LAST_UPDATE_LOGIN in NUMBER
197: ) is
198: begin
199: update AMS_LIST_RULES_ALL set
200: LIST_SOURCE_TYPE = X_LIST_SOURCE_TYPE,
201: ENABLED_FLAG = X_ENABLED_FLAG,
202: SEEDED_FLAG = X_SEEDED_FLAG,
203: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 217: update AMS_LIST_RULES_ALL_TL set

213: if (sql%notfound) then
214: raise no_data_found;
215: end if;
216:
217: update AMS_LIST_RULES_ALL_TL set
218: LIST_RULE_NAME = X_LIST_RULE_NAME,
219: DESCRIPTION = X_DESCRIPTION,
220: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
221: LAST_UPDATED_BY = X_LAST_UPDATED_BY, -- igoswami :: manually changed here

Line 236: delete from AMS_LIST_RULES_ALL_TL

232: procedure DELETE_ROW (
233: X_LIST_RULE_ID in NUMBER
234: ) is
235: begin
236: delete from AMS_LIST_RULES_ALL_TL
237: where LIST_RULE_ID = X_LIST_RULE_ID;
238:
239: if (sql%notfound) then
240: raise no_data_found;

Line 243: delete from AMS_LIST_RULES_ALL

239: if (sql%notfound) then
240: raise no_data_found;
241: end if;
242:
243: delete from AMS_LIST_RULES_ALL
244: where LIST_RULE_ID = X_LIST_RULE_ID;
245:
246: if (sql%notfound) then
247: raise no_data_found;

Line 254: delete from AMS_LIST_RULES_ALL_TL T

250:
251: procedure ADD_LANGUAGE
252: is
253: begin
254: delete from AMS_LIST_RULES_ALL_TL T
255: where not exists
256: (select NULL
257: from AMS_LIST_RULES_ALL B
258: where B.LIST_RULE_ID = T.LIST_RULE_ID

Line 257: from AMS_LIST_RULES_ALL B

253: begin
254: delete from AMS_LIST_RULES_ALL_TL T
255: where not exists
256: (select NULL
257: from AMS_LIST_RULES_ALL B
258: where B.LIST_RULE_ID = T.LIST_RULE_ID
259: );
260:
261: update AMS_LIST_RULES_ALL_TL T set (

Line 261: update AMS_LIST_RULES_ALL_TL T set (

257: from AMS_LIST_RULES_ALL B
258: where B.LIST_RULE_ID = T.LIST_RULE_ID
259: );
260:
261: update AMS_LIST_RULES_ALL_TL T set (
262: LIST_RULE_NAME,
263: DESCRIPTION
264: ) = (select
265: B.LIST_RULE_NAME,

Line 267: from AMS_LIST_RULES_ALL_TL B

263: DESCRIPTION
264: ) = (select
265: B.LIST_RULE_NAME,
266: B.DESCRIPTION
267: from AMS_LIST_RULES_ALL_TL B
268: where B.LIST_RULE_ID = T.LIST_RULE_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (
271: T.LIST_RULE_ID,

Line 276: from AMS_LIST_RULES_ALL_TL SUBB, AMS_LIST_RULES_ALL_TL SUBT

272: T.LANGUAGE
273: ) in (select
274: SUBT.LIST_RULE_ID,
275: SUBT.LANGUAGE
276: from AMS_LIST_RULES_ALL_TL SUBB, AMS_LIST_RULES_ALL_TL SUBT
277: where SUBB.LIST_RULE_ID = SUBT.LIST_RULE_ID
278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.LIST_RULE_NAME <> SUBT.LIST_RULE_NAME
280: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 285: insert into AMS_LIST_RULES_ALL_TL (

281: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
282: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
283: ));
284:
285: insert into AMS_LIST_RULES_ALL_TL (
286: LIST_RULE_ID,
287: LAST_UPDATE_DATE,
288: LAST_UPDATED_BY,
289: CREATION_DATE,

Line 307: from AMS_LIST_RULES_ALL_TL B, FND_LANGUAGES L

303: B.LIST_RULE_NAME,
304: B.DESCRIPTION,
305: L.LANGUAGE_CODE,
306: B.SOURCE_LANG
307: from AMS_LIST_RULES_ALL_TL B, FND_LANGUAGES L
308: where L.INSTALLED_FLAG in ('I', 'B')
309: and B.LANGUAGE = userenv('LANG')
310: and not exists
311: (select NULL

Line 312: from AMS_LIST_RULES_ALL_TL T

308: where L.INSTALLED_FLAG in ('I', 'B')
309: and B.LANGUAGE = userenv('LANG')
310: and not exists
311: (select NULL
312: from AMS_LIST_RULES_ALL_TL T
313: where T.LIST_RULE_ID = B.LIST_RULE_ID
314: and T.LANGUAGE = L.LANGUAGE_CODE);
315: end ADD_LANGUAGE;
316:

Line 317: end AMS_LIST_RULES_ALL_PKG;

313: where T.LIST_RULE_ID = B.LIST_RULE_ID
314: and T.LANGUAGE = L.LANGUAGE_CODE);
315: end ADD_LANGUAGE;
316:
317: end AMS_LIST_RULES_ALL_PKG;