APPS.CSD_RT_TRANS_PKG dependencies on CSD_RT_TRANS_TL

Line 64: insert into CSD_RT_TRANS_TL (

60: P_LAST_UPDATED_BY,
61: P_LAST_UPDATE_LOGIN
62: );
63:
64: insert into CSD_RT_TRANS_TL (
65: RT_TRAN_ID,
66: DESCRIPTION,
67: CREATED_BY,
68: CREATION_DATE,

Line 88: from CSD_RT_TRANS_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from CSD_RT_TRANS_TL T
89: where T.RT_TRAN_ID = PX_RT_TRAN_ID
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: open c;

Line 182: update CSD_RT_TRANS_TL set

178: if (sql%notfound) then
179: raise no_data_found;
180: end if;
181:
182: update CSD_RT_TRANS_TL set
183: DESCRIPTION = P_DESCRIPTION,
184: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
185: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
186: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 200: delete from CSD_RT_TRANS_TL

196: procedure DELETE_ROW (
197: P_RT_TRAN_ID in NUMBER
198: ) is
199: begin
200: delete from CSD_RT_TRANS_TL
201: where RT_TRAN_ID = P_RT_TRAN_ID;
202:
203: if (sql%notfound) then
204: raise no_data_found;

Line 218: delete from CSD_RT_TRANS_TL T

214:
215: procedure ADD_LANGUAGE
216: is
217: begin
218: delete from CSD_RT_TRANS_TL T
219: where not exists
220: (select NULL
221: from CSD_RT_TRANS_B B
222: where B.RT_TRAN_ID = T.RT_TRAN_ID

Line 225: update CSD_RT_TRANS_TL T set (

221: from CSD_RT_TRANS_B B
222: where B.RT_TRAN_ID = T.RT_TRAN_ID
223: );
224:
225: update CSD_RT_TRANS_TL T set (
226: DESCRIPTION
227: ) = (select
228: B.DESCRIPTION
229: from CSD_RT_TRANS_TL B

Line 229: from CSD_RT_TRANS_TL B

225: update CSD_RT_TRANS_TL T set (
226: DESCRIPTION
227: ) = (select
228: B.DESCRIPTION
229: from CSD_RT_TRANS_TL B
230: where B.RT_TRAN_ID = T.RT_TRAN_ID
231: and B.LANGUAGE = T.SOURCE_LANG)
232: where (
233: T.RT_TRAN_ID,

Line 238: from CSD_RT_TRANS_TL SUBB, CSD_RT_TRANS_TL SUBT

234: T.LANGUAGE
235: ) in (select
236: SUBT.RT_TRAN_ID,
237: SUBT.LANGUAGE
238: from CSD_RT_TRANS_TL SUBB, CSD_RT_TRANS_TL SUBT
239: where SUBB.RT_TRAN_ID = SUBT.RT_TRAN_ID
240: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
241: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
242: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 246: insert into CSD_RT_TRANS_TL (

242: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
243: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
244: ));
245:
246: insert into CSD_RT_TRANS_TL (
247: RT_TRAN_ID,
248: DESCRIPTION,
249: CREATED_BY,
250: CREATION_DATE,

Line 266: from CSD_RT_TRANS_TL B, FND_LANGUAGES L

262: B.LAST_UPDATE_DATE,
263: B.LAST_UPDATE_LOGIN,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from CSD_RT_TRANS_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from CSD_RT_TRANS_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from CSD_RT_TRANS_TL T
272: where T.RT_TRAN_ID = B.RT_TRAN_ID
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275: