APPS.CSD_RULE_CONDITIONS_PKG dependencies on CSD_RULE_CONDITIONS_TL

Line 107: insert into CSD_RULE_CONDITIONS_TL (

103: P_SOO_ATTRIBUTE2,
104: P_SOO_ATTRIBUTE3
105: );
106:
107: insert into CSD_RULE_CONDITIONS_TL (
108: RULE_CONDITION_ID,
109: NAME,
110: CREATED_BY,
111: CREATION_DATE,

Line 131: from CSD_RULE_CONDITIONS_TL T

127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from CSD_RULE_CONDITIONS_TL T
132: where T.RULE_CONDITION_ID = PX_RULE_CONDITION_ID
133: and T.LANGUAGE = L.LANGUAGE_CODE);
134:
135: open c;

Line 260: update CSD_RULE_CONDITIONS_TL set

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: update CSD_RULE_CONDITIONS_TL set
261: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
262: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
263: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
264: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 281: delete from CSD_RULE_CONDITIONS_TL

277: procedure DELETE_ROW (
278: P_RULE_CONDITION_ID in NUMBER
279: ) is
280: begin
281: delete from CSD_RULE_CONDITIONS_TL
282: where RULE_CONDITION_ID = P_RULE_CONDITION_ID;
283:
284: if (sql%notfound) then
285: raise no_data_found;

Line 299: delete from CSD_RULE_CONDITIONS_TL T

295:
296: procedure ADD_LANGUAGE
297: is
298: begin
299: delete from CSD_RULE_CONDITIONS_TL T
300: where not exists
301: (select NULL
302: from CSD_RULE_CONDITIONS_B B
303: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID

Line 306: update CSD_RULE_CONDITIONS_TL T set (

302: from CSD_RULE_CONDITIONS_B B
303: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
304: );
305:
306: update CSD_RULE_CONDITIONS_TL T set (
307: NAME
308: ) = (select
309: B.NAME
310: from CSD_RULE_CONDITIONS_TL B

Line 310: from CSD_RULE_CONDITIONS_TL B

306: update CSD_RULE_CONDITIONS_TL T set (
307: NAME
308: ) = (select
309: B.NAME
310: from CSD_RULE_CONDITIONS_TL B
311: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
312: and B.LANGUAGE = T.SOURCE_LANG)
313: where (
314: T.RULE_CONDITION_ID,

Line 319: from CSD_RULE_CONDITIONS_TL SUBB, CSD_RULE_CONDITIONS_TL SUBT

315: T.LANGUAGE
316: ) in (select
317: SUBT.RULE_CONDITION_ID,
318: SUBT.LANGUAGE
319: from CSD_RULE_CONDITIONS_TL SUBB, CSD_RULE_CONDITIONS_TL SUBT
320: where SUBB.RULE_CONDITION_ID = SUBT.RULE_CONDITION_ID
321: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
322: and (SUBB.NAME <> SUBT.NAME
323: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 327: insert into CSD_RULE_CONDITIONS_TL (

323: or (SUBB.NAME is null and SUBT.NAME is not null)
324: or (SUBB.NAME is not null and SUBT.NAME is null)
325: ));
326:
327: insert into CSD_RULE_CONDITIONS_TL (
328: RULE_CONDITION_ID,
329: CREATED_BY,
330: CREATION_DATE,
331: LAST_UPDATED_BY,

Line 347: from CSD_RULE_CONDITIONS_TL B, FND_LANGUAGES L

343: B.LAST_UPDATE_LOGIN,
344: B.NAME,
345: L.LANGUAGE_CODE,
346: B.SOURCE_LANG
347: from CSD_RULE_CONDITIONS_TL B, FND_LANGUAGES L
348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL

Line 352: from CSD_RULE_CONDITIONS_TL T

348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL
352: from CSD_RULE_CONDITIONS_TL T
353: where T.RULE_CONDITION_ID = B.RULE_CONDITION_ID
354: and T.LANGUAGE = L.LANGUAGE_CODE);
355: end ADD_LANGUAGE;
356: