APPS.SY_REAS_CDS_PKG dependencies on SY_REAS_CDS_TL

Line 54: insert into SY_REAS_CDS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into SY_REAS_CDS_TL (
55: REASON_CODE,
56: REASON_DESC1,
57: CREATION_DATE,
58: CREATED_BY,

Line 78: from SY_REAS_CDS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from SY_REAS_CDS_TL T
79: where T.REASON_CODE = X_REASON_CODE
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from SY_REAS_CDS_TL

115:
116: cursor c1 is select
117: REASON_DESC1,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from SY_REAS_CDS_TL
120: where REASON_CODE = X_REASON_CODE
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of REASON_CODE nowait;
123: begin

Line 196: update SY_REAS_CDS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update SY_REAS_CDS_TL set
197: REASON_DESC1 = X_REASON_DESC1,
198: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
199: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
200: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 215: delete from SY_REAS_CDS_TL

211: X_REASON_CODE in VARCHAR2
212: ) is
213: begin
214: /*****************
215: delete from SY_REAS_CDS_TL
216: where REASON_CODE = X_REASON_CODE;
217:
218: if (sql%notfound) then
219: raise no_data_found;

Line 234: delete from SY_REAS_CDS_TL T

230:
231: procedure ADD_LANGUAGE
232: is
233: begin
234: delete from SY_REAS_CDS_TL T
235: where not exists
236: (select NULL
237: from SY_REAS_CDS_B B
238: where B.REASON_CODE = T.REASON_CODE

Line 241: update SY_REAS_CDS_TL T set (

237: from SY_REAS_CDS_B B
238: where B.REASON_CODE = T.REASON_CODE
239: );
240:
241: update SY_REAS_CDS_TL T set (
242: REASON_DESC1
243: ) = (select
244: B.REASON_DESC1
245: from SY_REAS_CDS_TL B

Line 245: from SY_REAS_CDS_TL B

241: update SY_REAS_CDS_TL T set (
242: REASON_DESC1
243: ) = (select
244: B.REASON_DESC1
245: from SY_REAS_CDS_TL B
246: where B.REASON_CODE = T.REASON_CODE
247: and B.LANGUAGE = T.SOURCE_LANG)
248: where (
249: T.REASON_CODE,

Line 254: from SY_REAS_CDS_TL SUBB, SY_REAS_CDS_TL SUBT

250: T.LANGUAGE
251: ) in (select
252: SUBT.REASON_CODE,
253: SUBT.LANGUAGE
254: from SY_REAS_CDS_TL SUBB, SY_REAS_CDS_TL SUBT
255: where SUBB.REASON_CODE = SUBT.REASON_CODE
256: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
257: and (SUBB.REASON_DESC1 <> SUBT.REASON_DESC1
258: ));

Line 260: insert into SY_REAS_CDS_TL (

256: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
257: and (SUBB.REASON_DESC1 <> SUBT.REASON_DESC1
258: ));
259:
260: insert into SY_REAS_CDS_TL (
261: REASON_CODE,
262: REASON_DESC1,
263: CREATION_DATE,
264: CREATED_BY,

Line 280: from SY_REAS_CDS_TL B, FND_LANGUAGES L

276: B.LAST_UPDATED_BY,
277: B.LAST_UPDATE_LOGIN,
278: L.LANGUAGE_CODE,
279: B.SOURCE_LANG
280: from SY_REAS_CDS_TL B, FND_LANGUAGES L
281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL

Line 285: from SY_REAS_CDS_TL T

281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL
285: from SY_REAS_CDS_TL T
286: where T.REASON_CODE = B.REASON_CODE
287: and T.LANGUAGE = L.LANGUAGE_CODE);
288: end ADD_LANGUAGE;
289: