APPS.CSD_RULES_PKG dependencies on CSD_RULES_TL

Line 108: insert into CSD_RULES_TL (

104: P_ATTRIBUTE14,
105: P_ATTRIBUTE15
106: );
107:
108: insert into CSD_RULES_TL (
109: RULE_ID,
110: NAME,
111: DESCRIPTION,
112: CREATED_BY,

Line 134: from CSD_RULES_TL T

130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from CSD_RULES_TL T
135: where T.RULE_ID = PX_RULE_ID
136: and T.LANGUAGE = L.LANGUAGE_CODE);
137:
138: open c;

Line 264: update CSD_RULES_TL set

260: if (sql%notfound) then
261: raise no_data_found;
262: end if;
263:
264: update CSD_RULES_TL set
265: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
266: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
267: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
268: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 286: delete from CSD_RULES_TL

282: procedure DELETE_ROW (
283: P_RULE_ID in NUMBER
284: ) is
285: begin
286: delete from CSD_RULES_TL
287: where RULE_ID = P_RULE_ID;
288:
289: if (sql%notfound) then
290: raise no_data_found;

Line 304: delete from CSD_RULES_TL T

300:
301: procedure ADD_LANGUAGE
302: is
303: begin
304: delete from CSD_RULES_TL T
305: where not exists
306: (select NULL
307: from CSD_RULES_B B
308: where B.RULE_ID = T.RULE_ID

Line 311: update CSD_RULES_TL T set (

307: from CSD_RULES_B B
308: where B.RULE_ID = T.RULE_ID
309: );
310:
311: update CSD_RULES_TL T set (
312: NAME,
313: DESCRIPTION
314: ) = (select
315: B.NAME,

Line 317: from CSD_RULES_TL B

313: DESCRIPTION
314: ) = (select
315: B.NAME,
316: B.DESCRIPTION
317: from CSD_RULES_TL B
318: where B.RULE_ID = T.RULE_ID
319: and B.LANGUAGE = T.SOURCE_LANG)
320: where (
321: T.RULE_ID,

Line 326: from CSD_RULES_TL SUBB, CSD_RULES_TL SUBT

322: T.LANGUAGE
323: ) in (select
324: SUBT.RULE_ID,
325: SUBT.LANGUAGE
326: from CSD_RULES_TL SUBB, CSD_RULES_TL SUBT
327: where SUBB.RULE_ID = SUBT.RULE_ID
328: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
329: and (SUBB.NAME <> SUBT.NAME
330: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 335: insert into CSD_RULES_TL (

331: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
332: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
333: ));
334:
335: insert into CSD_RULES_TL (
336: RULE_ID,
337: CREATED_BY,
338: CREATION_DATE,
339: LAST_UPDATED_BY,

Line 357: from CSD_RULES_TL B, FND_LANGUAGES L

353: B.NAME,
354: B.DESCRIPTION,
355: L.LANGUAGE_CODE,
356: B.SOURCE_LANG
357: from CSD_RULES_TL B, FND_LANGUAGES L
358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL

Line 362: from CSD_RULES_TL T

358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL
362: from CSD_RULES_TL T
363: where T.RULE_ID = B.RULE_ID
364: and T.LANGUAGE = L.LANGUAGE_CODE);
365: end ADD_LANGUAGE;
366: