APPS.CSD_RULE_CONDITIONS_PKG dependencies on CSD_RULE_CONDITIONS_TL

Line 95: insert into CSD_RULE_CONDITIONS_TL (

91: P_ATTRIBUTE14,
92: P_ATTRIBUTE15
93: );
94:
95: insert into CSD_RULE_CONDITIONS_TL (
96: RULE_CONDITION_ID,
97: NAME,
98: CREATED_BY,
99: CREATION_DATE,

Line 119: from CSD_RULE_CONDITIONS_TL T

115: from FND_LANGUAGES L
116: where L.INSTALLED_FLAG in ('I', 'B')
117: and not exists
118: (select NULL
119: from CSD_RULE_CONDITIONS_TL T
120: where T.RULE_CONDITION_ID = PX_RULE_CONDITION_ID
121: and T.LANGUAGE = L.LANGUAGE_CODE);
122:
123: open c;

Line 240: update CSD_RULE_CONDITIONS_TL set

236: if (sql%notfound) then
237: raise no_data_found;
238: end if;
239:
240: update CSD_RULE_CONDITIONS_TL set
241: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
242: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
243: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
244: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 261: delete from CSD_RULE_CONDITIONS_TL

257: procedure DELETE_ROW (
258: P_RULE_CONDITION_ID in NUMBER
259: ) is
260: begin
261: delete from CSD_RULE_CONDITIONS_TL
262: where RULE_CONDITION_ID = P_RULE_CONDITION_ID;
263:
264: if (sql%notfound) then
265: raise no_data_found;

Line 279: delete from CSD_RULE_CONDITIONS_TL T

275:
276: procedure ADD_LANGUAGE
277: is
278: begin
279: delete from CSD_RULE_CONDITIONS_TL T
280: where not exists
281: (select NULL
282: from CSD_RULE_CONDITIONS_B B
283: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID

Line 286: update CSD_RULE_CONDITIONS_TL T set (

282: from CSD_RULE_CONDITIONS_B B
283: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
284: );
285:
286: update CSD_RULE_CONDITIONS_TL T set (
287: NAME
288: ) = (select
289: B.NAME
290: from CSD_RULE_CONDITIONS_TL B

Line 290: from CSD_RULE_CONDITIONS_TL B

286: update CSD_RULE_CONDITIONS_TL T set (
287: NAME
288: ) = (select
289: B.NAME
290: from CSD_RULE_CONDITIONS_TL B
291: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
292: and B.LANGUAGE = T.SOURCE_LANG)
293: where (
294: T.RULE_CONDITION_ID,

Line 299: from CSD_RULE_CONDITIONS_TL SUBB, CSD_RULE_CONDITIONS_TL SUBT

295: T.LANGUAGE
296: ) in (select
297: SUBT.RULE_CONDITION_ID,
298: SUBT.LANGUAGE
299: from CSD_RULE_CONDITIONS_TL SUBB, CSD_RULE_CONDITIONS_TL SUBT
300: where SUBB.RULE_CONDITION_ID = SUBT.RULE_CONDITION_ID
301: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
302: and (SUBB.NAME <> SUBT.NAME
303: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 307: insert into CSD_RULE_CONDITIONS_TL (

303: or (SUBB.NAME is null and SUBT.NAME is not null)
304: or (SUBB.NAME is not null and SUBT.NAME is null)
305: ));
306:
307: insert into CSD_RULE_CONDITIONS_TL (
308: RULE_CONDITION_ID,
309: CREATED_BY,
310: CREATION_DATE,
311: LAST_UPDATED_BY,

Line 327: from CSD_RULE_CONDITIONS_TL B, FND_LANGUAGES L

323: B.LAST_UPDATE_LOGIN,
324: B.NAME,
325: L.LANGUAGE_CODE,
326: B.SOURCE_LANG
327: from CSD_RULE_CONDITIONS_TL B, FND_LANGUAGES L
328: where L.INSTALLED_FLAG in ('I', 'B')
329: and B.LANGUAGE = userenv('LANG')
330: and not exists
331: (select NULL

Line 332: from CSD_RULE_CONDITIONS_TL T

328: where L.INSTALLED_FLAG in ('I', 'B')
329: and B.LANGUAGE = userenv('LANG')
330: and not exists
331: (select NULL
332: from CSD_RULE_CONDITIONS_TL T
333: where T.RULE_CONDITION_ID = B.RULE_CONDITION_ID
334: and T.LANGUAGE = L.LANGUAGE_CODE);
335: end ADD_LANGUAGE;
336: