43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into CSD_RETURN_TYPES_TL (
48: NAME,
49: DESCRIPTION,
50: RETURN_TYPE_ID,
51: LAST_UPDATE_LOGIN,
71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from CSD_RETURN_TYPES_TL T
76: where T.RETURN_TYPE_ID = X_RETURN_TYPE_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;
110: NAME,
111: DESCRIPTION,
112: TERMS_AND_CONDITIONS,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from CSD_RETURN_TYPES_TL
115: where RETURN_TYPE_ID = X_RETURN_TYPE_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of RETURN_TYPE_ID nowait;
118: begin
182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update CSD_RETURN_TYPES_TL set
187: NAME = X_NAME,
188: DESCRIPTION = X_DESCRIPTION,
189: TERMS_AND_CONDITIONS = X_TERMS_AND_CONDITIONS,
190: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: procedure DELETE_ROW (
203: X_RETURN_TYPE_ID in NUMBER
204: ) is
205: begin
206: delete from CSD_RETURN_TYPES_TL
207: where RETURN_TYPE_ID = X_RETURN_TYPE_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;
220:
221: procedure ADD_LANGUAGE
222: is
223: begin
224: delete from CSD_RETURN_TYPES_TL T
225: where not exists
226: (select NULL
227: from CSD_RETURN_TYPES_B B
228: where B.RETURN_TYPE_ID = T.RETURN_TYPE_ID
227: from CSD_RETURN_TYPES_B B
228: where B.RETURN_TYPE_ID = T.RETURN_TYPE_ID
229: );
230:
231: update CSD_RETURN_TYPES_TL T set (
232: NAME,
233: DESCRIPTION,
234: TERMS_AND_CONDITIONS
235: ) = (select
235: ) = (select
236: B.NAME,
237: B.DESCRIPTION,
238: B.TERMS_AND_CONDITIONS
239: from CSD_RETURN_TYPES_TL B
240: where B.RETURN_TYPE_ID = T.RETURN_TYPE_ID
241: and B.LANGUAGE = T.SOURCE_LANG)
242: where (
243: T.RETURN_TYPE_ID,
244: T.LANGUAGE
245: ) in (select
246: SUBT.RETURN_TYPE_ID,
247: SUBT.LANGUAGE
248: from CSD_RETURN_TYPES_TL SUBB, CSD_RETURN_TYPES_TL SUBT
249: where SUBB.RETURN_TYPE_ID = SUBT.RETURN_TYPE_ID
250: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
251: and (SUBB.NAME <> SUBT.NAME
252: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
256: or (SUBB.TERMS_AND_CONDITIONS is null and SUBT.TERMS_AND_CONDITIONS is not null)
257: or (SUBB.TERMS_AND_CONDITIONS is not null and SUBT.TERMS_AND_CONDITIONS is null)
258: ));
259:
260: insert into CSD_RETURN_TYPES_TL (
261: NAME,
262: DESCRIPTION,
263: RETURN_TYPE_ID,
264: LAST_UPDATE_LOGIN,
280: B.LAST_UPDATED_BY,
281: B.LAST_UPDATE_DATE,
282: L.LANGUAGE_CODE,
283: B.SOURCE_LANG
284: from CSD_RETURN_TYPES_TL B, FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL
289: from CSD_RETURN_TYPES_TL T
290: where T.RETURN_TYPE_ID = B.RETURN_TYPE_ID
291: and T.LANGUAGE = L.LANGUAGE_CODE);
292: end ADD_LANGUAGE;
293: