APPS.XLE_JURISDICTIONS_F_PKG dependencies on XLE_JURISDICTIONS_TL

Line 29: DELETE FROM xle_jurisdictions_tl T

25: IS
26:
27: BEGIN
28:
29: DELETE FROM xle_jurisdictions_tl T
30: WHERE NOT EXISTS
31: (SELECT NULL
32: FROM xle_jurisdictions_b b
33: WHERE b.jurisdiction_id = t.jurisdiction_id);

Line 36: UPDATE xle_jurisdictions_tl t

32: FROM xle_jurisdictions_b b
33: WHERE b.jurisdiction_id = t.jurisdiction_id);
34:
35:
36: UPDATE xle_jurisdictions_tl t
37: SET (name)
38: = (SELECT b.name
39: FROM xle_jurisdictions_tl b
40: WHERE b.jurisdiction_id = t.jurisdiction_id

Line 39: FROM xle_jurisdictions_tl b

35:
36: UPDATE xle_jurisdictions_tl t
37: SET (name)
38: = (SELECT b.name
39: FROM xle_jurisdictions_tl b
40: WHERE b.jurisdiction_id = t.jurisdiction_id
41: AND b.language = t.source_lang)
42: WHERE (t.jurisdiction_id
43: ,t.language)

Line 46: FROM xle_jurisdictions_tl subb

42: WHERE (t.jurisdiction_id
43: ,t.language)
44: IN (SELECT subt.jurisdiction_id
45: ,subt.language
46: FROM xle_jurisdictions_tl subb
47: ,xle_jurisdictions_tl subt
48: WHERE subb.jurisdiction_id = subt.jurisdiction_id
49: AND subb.language = subt.source_lang
50: AND (SUBB.name <> SUBT.name

Line 47: ,xle_jurisdictions_tl subt

43: ,t.language)
44: IN (SELECT subt.jurisdiction_id
45: ,subt.language
46: FROM xle_jurisdictions_tl subb
47: ,xle_jurisdictions_tl subt
48: WHERE subb.jurisdiction_id = subt.jurisdiction_id
49: AND subb.language = subt.source_lang
50: AND (SUBB.name <> SUBT.name
51: ))

Line 54: INSERT INTO xle_jurisdictions_tl

50: AND (SUBB.name <> SUBT.name
51: ))
52: ;
53:
54: INSERT INTO xle_jurisdictions_tl
55: (jurisdiction_id
56: ,name
57: ,last_updated_by
58: ,creation_date

Line 74: FROM xle_jurisdictions_tl b

70: ,b.last_update_date
71: ,b.created_by
72: ,l.language_code
73: ,b.source_lang
74: FROM xle_jurisdictions_tl b
75: ,fnd_languages l
76: WHERE l.installed_flag IN ('I', 'B')
77: AND b.language = userenv('LANG')
78: AND NOT EXISTS

Line 80: FROM xle_jurisdictions_tl t

76: WHERE l.installed_flag IN ('I', 'B')
77: AND b.language = userenv('LANG')
78: AND NOT EXISTS
79: (SELECT NULL
80: FROM xle_jurisdictions_tl t
81: WHERE t.jurisdiction_id = b.jurisdiction_id
82: AND t.language = l.language_code);
83:
84: