APPS.CSR_COSTS_PKG dependencies on CSR_COSTS_ALL_TL

Line 16: - translation table CSR_COSTS_ALL_TL.

12: Purpose
13: -------
14: Insert, update, delete or lock tables belonging to view CSR_COSTS_VL:
15: - base table CSR_COSTS_ALL_B, and
16: - translation table CSR_COSTS_ALL_TL.
17: Restore data integrity to a corrupted base/translation pair.
18:
19: History
20: -------

Line 150: insert into csr_costs_all_tl

146: , p_attribute_category
147: , p_org_id
148: );
149:
150: insert into csr_costs_all_tl
151: (
152: cost_id
153: , description
154: , created_by

Line 175: from csr_costs_all_tl t

171: from fnd_languages l
172: where l.installed_flag in ('I','B')
173: and not exists
174: ( select ''
175: from csr_costs_all_tl t
176: where t.cost_id = p_cost_id
177: and t.language = l.language_code );
178:
179: open c_cost ( p_cost_id );

Line 330: update csr_costs_all_tl

326: then
327: raise NO_DATA_FOUND;
328: end if;
329:
330: update csr_costs_all_tl
331: set description = p_description
332: , last_update_date = p_last_update_date
333: , last_updated_by = p_last_updated_by
334: , last_update_login = p_last_update_login

Line 351: delete from csr_costs_all_tl

347: p_cost_id IN number
348: )
349: is
350: begin
351: delete from csr_costs_all_tl
352: where cost_id = p_cost_id;
353:
354: if sql%notfound
355: then

Line 371: delete from csr_costs_all_tl t

367:
368: procedure add_language
369: is
370: begin
371: delete from csr_costs_all_tl t
372: where not exists
373: ( select ''
374: from csr_costs_all_b b
375: where b.cost_id = t.cost_id );

Line 377: update csr_costs_all_tl t

373: ( select ''
374: from csr_costs_all_b b
375: where b.cost_id = t.cost_id );
376:
377: update csr_costs_all_tl t
378: set description =
379: ( select b.description
380: from csr_costs_all_tl b
381: where b.cost_id = t.cost_id

Line 380: from csr_costs_all_tl b

376:
377: update csr_costs_all_tl t
378: set description =
379: ( select b.description
380: from csr_costs_all_tl b
381: where b.cost_id = t.cost_id
382: and b.language = t.source_lang )
383: where ( t.cost_id, t.language ) in
384: ( select subt.cost_id

Line 386: from csr_costs_all_tl subb

382: and b.language = t.source_lang )
383: where ( t.cost_id, t.language ) in
384: ( select subt.cost_id
385: , subt.language
386: from csr_costs_all_tl subb
387: , csr_costs_all_tl subt
388: where subb.cost_id = subt.cost_id
389: and subb.language = subt.source_lang
390: and ( subb.description <> subt.description

Line 387: , csr_costs_all_tl subt

383: where ( t.cost_id, t.language ) in
384: ( select subt.cost_id
385: , subt.language
386: from csr_costs_all_tl subb
387: , csr_costs_all_tl subt
388: where subb.cost_id = subt.cost_id
389: and subb.language = subt.source_lang
390: and ( subb.description <> subt.description
391: or ( subb.description is null

Line 396: insert into csr_costs_all_tl

392: and subt.description is not null )
393: or ( subb.description is not null
394: and subt.description is null ) ) );
395:
396: insert into csr_costs_all_tl
397: ( cost_id
398: , description
399: , created_by
400: , creation_date

Line 416: from csr_costs_all_tl b

412: , b.last_update_date
413: , b.last_update_login
414: , l.language_code
415: , b.source_lang
416: from csr_costs_all_tl b
417: , fnd_languages l
418: where l.installed_flag in ('I', 'B')
419: and b.language = userenv('LANG')
420: and not exists

Line 422: from csr_costs_all_tl t

418: where l.installed_flag in ('I', 'B')
419: and b.language = userenv('LANG')
420: and not exists
421: ( select null
422: from csr_costs_all_tl t
423: where t.cost_id = b.cost_id
424: and t.language = l.language_code );
425: end add_language;
426:

Line 435: update CSR_COSTS_ALL_TL

431: , p_description IN varchar2
432: )
433: is
434: begin
435: update CSR_COSTS_ALL_TL
436: set description = p_description,
437: last_update_date = sysdate,
438: last_updated_by = decode(p_owner, 'SEED', 1, 0),
439: last_update_login = 0,