APPS.CSD_RET_RULE_CONDITIONS_PKG dependencies on CSD_RET_RULE_CONDITIONS_TL

Line 87: insert into CSD_RET_RULE_CONDITIONS_TL (

83: X_LAST_UPDATED_BY,
84: X_LAST_UPDATE_LOGIN
85: );
86:
87: insert into CSD_RET_RULE_CONDITIONS_TL (
88: RULE_CONDITION_ID,
89: NAME,
90: CREATION_DATE,
91: CREATED_BY,

Line 111: from CSD_RET_RULE_CONDITIONS_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from CSD_RET_RULE_CONDITIONS_TL T
112: where T.RULE_CONDITION_ID = X_RULE_CONDITION_ID
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: open c;

Line 174: from CSD_RET_RULE_CONDITIONS_TL

170:
171: cursor c1 is select
172: NAME,
173: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
174: from CSD_RET_RULE_CONDITIONS_TL
175: where RULE_CONDITION_ID = X_RULE_CONDITION_ID
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: for update of RULE_CONDITION_ID nowait;
178: begin

Line 297: update CSD_RET_RULE_CONDITIONS_TL set

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: update CSD_RET_RULE_CONDITIONS_TL set
298: NAME = X_NAME,
299: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
300: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
301: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 315: delete from CSD_RET_RULE_CONDITIONS_TL

311: procedure DELETE_ROW (
312: X_RULE_CONDITION_ID in NUMBER
313: ) is
314: begin
315: delete from CSD_RET_RULE_CONDITIONS_TL
316: where RULE_CONDITION_ID = X_RULE_CONDITION_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 333: delete from CSD_RET_RULE_CONDITIONS_TL T

329:
330: procedure ADD_LANGUAGE
331: is
332: begin
333: delete from CSD_RET_RULE_CONDITIONS_TL T
334: where not exists
335: (select NULL
336: from CSD_RET_RULE_CONDITIONS_B B
337: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID

Line 340: update CSD_RET_RULE_CONDITIONS_TL T set (

336: from CSD_RET_RULE_CONDITIONS_B B
337: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
338: );
339:
340: update CSD_RET_RULE_CONDITIONS_TL T set (
341: NAME
342: ) = (select
343: B.NAME
344: from CSD_RET_RULE_CONDITIONS_TL B

Line 344: from CSD_RET_RULE_CONDITIONS_TL B

340: update CSD_RET_RULE_CONDITIONS_TL T set (
341: NAME
342: ) = (select
343: B.NAME
344: from CSD_RET_RULE_CONDITIONS_TL B
345: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
346: and B.LANGUAGE = T.SOURCE_LANG)
347: where (
348: T.RULE_CONDITION_ID,

Line 353: from CSD_RET_RULE_CONDITIONS_TL SUBB, CSD_RET_RULE_CONDITIONS_TL SUBT

349: T.LANGUAGE
350: ) in (select
351: SUBT.RULE_CONDITION_ID,
352: SUBT.LANGUAGE
353: from CSD_RET_RULE_CONDITIONS_TL SUBB, CSD_RET_RULE_CONDITIONS_TL SUBT
354: where SUBB.RULE_CONDITION_ID = SUBT.RULE_CONDITION_ID
355: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
356: and (SUBB.NAME <> SUBT.NAME
357: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 361: insert into CSD_RET_RULE_CONDITIONS_TL (

357: or (SUBB.NAME is null and SUBT.NAME is not null)
358: or (SUBB.NAME is not null and SUBT.NAME is null)
359: ));
360:
361: insert into CSD_RET_RULE_CONDITIONS_TL (
362: RULE_CONDITION_ID,
363: NAME,
364: CREATION_DATE,
365: CREATED_BY,

Line 381: from CSD_RET_RULE_CONDITIONS_TL B, FND_LANGUAGES L

377: B.LAST_UPDATE_DATE,
378: B.LAST_UPDATE_LOGIN,
379: L.LANGUAGE_CODE,
380: B.SOURCE_LANG
381: from CSD_RET_RULE_CONDITIONS_TL B, FND_LANGUAGES L
382: where L.INSTALLED_FLAG in ('I', 'B')
383: and B.LANGUAGE = userenv('LANG')
384: and not exists
385: (select NULL

Line 386: from CSD_RET_RULE_CONDITIONS_TL T

382: where L.INSTALLED_FLAG in ('I', 'B')
383: and B.LANGUAGE = userenv('LANG')
384: and not exists
385: (select NULL
386: from CSD_RET_RULE_CONDITIONS_TL T
387: where T.RULE_CONDITION_ID = B.RULE_CONDITION_ID
388: and T.LANGUAGE = L.LANGUAGE_CODE);
389: end ADD_LANGUAGE;
390: