APPS.CSF_DC_QUERIES_PKG dependencies on CSF_DC_QUERIES_TL

Line 86: insert into csf_dc_queries_tl

82: , p_start_date_active
83: , p_end_date_active
84: );
85:
86: insert into csf_dc_queries_tl
87: ( query_id
88: , language
89: , source_lang
90: , created_by

Line 113: from csf_dc_queries_tl t

109: from fnd_languages l
110: where l.installed_flag in ('I','B')
111: and not exists
112: ( select ''
113: from csf_dc_queries_tl t
114: where t.query_id = p_query_id
115: and t.language = l.language_code );
116:
117: open c_rowid ( p_query_id );

Line 176: update csf_dc_queries_tl

172: then
173: raise NO_DATA_FOUND;
174: end if;
175:
176: update csf_dc_queries_tl
177: set source_lang = userenv('LANG')
178: , last_updated_by = p_last_updated_by
179: , last_update_date = p_last_update_date
180: , last_update_login = p_last_update_login

Line 197: update csf_dc_queries_tl

193: , p_description IN varchar2
194: )
195: is
196: begin
197: update csf_dc_queries_tl
198: set description = p_description,
199: name = p_name,
200: last_update_date = sysdate,
201: last_updated_by = decode(p_owner, 'SEED', 1, 0),

Line 280: DELETE FROM csf_dc_queries_tl t

276: PROCEDURE add_language
277: IS
278: BEGIN
279:
280: DELETE FROM csf_dc_queries_tl t
281: WHERE NOT EXISTS
282: (SELECT ''
283: FROM csf_dc_queries_tl tl
284: WHERE tl.query_id = t.query_id

Line 283: FROM csf_dc_queries_tl tl

279:
280: DELETE FROM csf_dc_queries_tl t
281: WHERE NOT EXISTS
282: (SELECT ''
283: FROM csf_dc_queries_tl tl
284: WHERE tl.query_id = t.query_id
285: );
286:
287: UPDATE csf_dc_queries_tl t SET ( name , description) =

Line 287: UPDATE csf_dc_queries_tl t SET ( name , description) =

283: FROM csf_dc_queries_tl tl
284: WHERE tl.query_id = t.query_id
285: );
286:
287: UPDATE csf_dc_queries_tl t SET ( name , description) =
288: ( SELECT tl.name, tl.description
289: FROM csf_dc_queries_tl tl
290: WHERE tl.query_id = t.query_id
291: AND tl.language = t.source_lang)

Line 289: FROM csf_dc_queries_tl tl

285: );
286:
287: UPDATE csf_dc_queries_tl t SET ( name , description) =
288: ( SELECT tl.name, tl.description
289: FROM csf_dc_queries_tl tl
290: WHERE tl.query_id = t.query_id
291: AND tl.language = t.source_lang)
292: WHERE (t.query_id, t.language) IN
293: (SELECT subt.query_id, subt.language

Line 294: FROM csf_dc_queries_tl subb, csf_dc_queries_tl subt

290: WHERE tl.query_id = t.query_id
291: AND tl.language = t.source_lang)
292: WHERE (t.query_id, t.language) IN
293: (SELECT subt.query_id, subt.language
294: FROM csf_dc_queries_tl subb, csf_dc_queries_tl subt
295: WHERE subb.query_id = subt.query_id
296: AND subb.language = subt.source_lang
297: AND (subb.name <> subt.name
298: OR subb.description <> subt.description

Line 303: INSERT INTO csf_dc_queries_tl

299: OR (subb.description is null and subt.description is not null)
300: OR (subb.description is not null and subt.description is null))
301: );
302:
303: INSERT INTO csf_dc_queries_tl
304: ( query_id
305: , description
306: , name
307: , created_by

Line 325: FROM csf_dc_queries_tl b

321: , b.last_update_date
322: , b.last_update_login
323: , l.language_code
324: , b.source_lang
325: FROM csf_dc_queries_tl b
326: , fnd_languages l
327: WHERE l.installed_flag in ('I', 'B')
328: AND b.language = userenv('LANG')
329: AND NOT EXISTS

Line 331: FROM csf_dc_queries_tl t

327: WHERE l.installed_flag in ('I', 'B')
328: AND b.language = userenv('LANG')
329: AND NOT EXISTS
330: ( SELECT NULL
331: FROM csf_dc_queries_tl t
332: WHERE t.query_id = b.query_id
333: AND t.language = l.language_code );
334: END add_language;
335: