APPS.CSD_PARAMETERS_PKG dependencies on CSD_PARAMETERS_TL

Line 49: insert into CSD_PARAMETERS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into CSD_PARAMETERS_TL (
50: PARAMETER_ID,
51: NAME,
52: DESCRIPTION,
53: CREATION_DATE,

Line 75: from CSD_PARAMETERS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from CSD_PARAMETERS_TL T
76: where T.PARAMETER_ID = X_PARAMETER_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from CSD_PARAMETERS_TL

110: cursor c1 is select
111: NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from CSD_PARAMETERS_TL
115: where PARAMETER_ID = X_PARAMETER_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of PARAMETER_ID nowait;
118: begin

Line 185: update CSD_PARAMETERS_TL set

181: if (sql%notfound) then
182: raise no_data_found;
183: end if;
184:
185: update CSD_PARAMETERS_TL set
186: NAME = X_NAME,
187: DESCRIPTION = X_DESCRIPTION,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 204: delete from CSD_PARAMETERS_TL

200: procedure DELETE_ROW (
201: X_PARAMETER_ID in NUMBER
202: ) is
203: begin
204: delete from CSD_PARAMETERS_TL
205: where PARAMETER_ID = X_PARAMETER_ID;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 222: delete from CSD_PARAMETERS_TL T

218:
219: procedure ADD_LANGUAGE
220: is
221: begin
222: delete from CSD_PARAMETERS_TL T
223: where not exists
224: (select NULL
225: from CSD_PARAMETERS B
226: where B.PARAMETER_ID = T.PARAMETER_ID

Line 229: update CSD_PARAMETERS_TL T set (

225: from CSD_PARAMETERS B
226: where B.PARAMETER_ID = T.PARAMETER_ID
227: );
228:
229: update CSD_PARAMETERS_TL T set (
230: NAME,
231: DESCRIPTION
232: ) = (select
233: B.NAME,

Line 235: from CSD_PARAMETERS_TL B

231: DESCRIPTION
232: ) = (select
233: B.NAME,
234: B.DESCRIPTION
235: from CSD_PARAMETERS_TL B
236: where B.PARAMETER_ID = T.PARAMETER_ID
237: and B.LANGUAGE = T.SOURCE_LANG)
238: where (
239: T.PARAMETER_ID,

Line 244: from CSD_PARAMETERS_TL SUBB, CSD_PARAMETERS_TL SUBT

240: T.LANGUAGE
241: ) in (select
242: SUBT.PARAMETER_ID,
243: SUBT.LANGUAGE
244: from CSD_PARAMETERS_TL SUBB, CSD_PARAMETERS_TL SUBT
245: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
246: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
247: and (SUBB.NAME <> SUBT.NAME
248: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 253: insert into CSD_PARAMETERS_TL (

249: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
250: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
251: ));
252:
253: insert into CSD_PARAMETERS_TL (
254: PARAMETER_ID,
255: NAME,
256: DESCRIPTION,
257: CREATION_DATE,

Line 275: from CSD_PARAMETERS_TL B, FND_LANGUAGES L

271: B.LAST_UPDATE_DATE,
272: B.LAST_UPDATE_LOGIN,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from CSD_PARAMETERS_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL

Line 280: from CSD_PARAMETERS_TL T

276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from CSD_PARAMETERS_TL T
281: where T.PARAMETER_ID = B.PARAMETER_ID
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;
284: