APPS.AR_CMGT_DNB_TABLE_HANDLER dependencies on AR_CMGT_DNB_ELEMENTS_TL

Line 45: INSERT INTO AR_CMGT_DNB_ELEMENTS_TL

41: p_return_data_type,
42: p_return_date_format
43: );
44:
45: INSERT INTO AR_CMGT_DNB_ELEMENTS_TL
46: ( data_element_id,
47: data_element_name,
48: LANGUAGE,
49: source_lang,

Line 67: from ar_cmgt_dnb_elements_TL t

63: p_last_update_login
64: from fnd_languages l
65: where l.installed_flag in ('B','I')
66: and not exists (select NULL
67: from ar_cmgt_dnb_elements_TL t
68: where T.data_element_id = p_data_element_id
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71:

Line 104: update ar_cmgt_dnb_elements_tl

100:
101: if (sql%notfound) then
102: raise no_data_found;
103: end if;
104: update ar_cmgt_dnb_elements_tl
105: set data_element_name = p_data_element_name,
106: last_update_date = sysdate,
107: last_updated_by = p_last_updated_by,
108: last_update_login = p_last_update_login,

Line 132: delete from ar_cmgt_dnb_elements_tl

128: if (sql%notfound) then
129: raise no_data_found;
130: end if;
131:
132: delete from ar_cmgt_dnb_elements_tl
133: where data_element_id = p_data_element_id;
134:
135: if (sql%notfound) then
136: raise no_data_found;

Line 143: delete from ar_cmgt_dnb_elements_TL T

139:
140: procedure ADD_LANGUAGE
141: is
142: begin
143: delete from ar_cmgt_dnb_elements_TL T
144: where not exists
145: (select NULL
146: from ar_cmgt_dnb_elements_B B
147: where B.data_element_id = T.data_element_id

Line 150: update ar_cmgt_dnb_elements_TL T set (

146: from ar_cmgt_dnb_elements_B B
147: where B.data_element_id = T.data_element_id
148: );
149:
150: update ar_cmgt_dnb_elements_TL T set (
151: data_element_name
152: ) = (select
153: B.data_element_NAME
154: from ar_cmgt_dnb_elements_TL B

Line 154: from ar_cmgt_dnb_elements_TL B

150: update ar_cmgt_dnb_elements_TL T set (
151: data_element_name
152: ) = (select
153: B.data_element_NAME
154: from ar_cmgt_dnb_elements_TL B
155: where B.data_element_id = T.data_element_id
156: and B.LANGUAGE = T.SOURCE_LANG)
157: where (
158: T.data_element_id,

Line 163: from ar_cmgt_dnb_elements_TL SUBB, ar_cmgt_dnb_elements_TL SUBT

159: T.LANGUAGE
160: ) in (select
161: SUBT.data_element_id,
162: SUBT.LANGUAGE
163: from ar_cmgt_dnb_elements_TL SUBB, ar_cmgt_dnb_elements_TL SUBT
164: where SUBB.data_element_ID = SUBT.data_element_ID
165: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
166: and SUBB.data_element_name <> SUBT.data_element_name
167:

Line 170: INSERT INTO ar_cmgt_dnb_elements_TL

166: and SUBB.data_element_name <> SUBT.data_element_name
167:
168: );
169:
170: INSERT INTO ar_cmgt_dnb_elements_TL
171: ( data_element_id,
172: data_element_name,
173: LANGUAGE,
174: source_lang,

Line 189: FROM ar_cmgt_dnb_elements_tl t, fnd_languages l

185: t.last_update_date,
186: t.created_by,
187: t.creation_date,
188: t.last_update_login
189: FROM ar_cmgt_dnb_elements_tl t, fnd_languages l
190: WHERE l.installed_flag in ( 'I', 'B')
191: AND t.language = userenv('LANG')
192: AND not exists ( select NULL FROM
193: ar_cmgt_dnb_elements_tl t1

Line 193: ar_cmgt_dnb_elements_tl t1

189: FROM ar_cmgt_dnb_elements_tl t, fnd_languages l
190: WHERE l.installed_flag in ( 'I', 'B')
191: AND t.language = userenv('LANG')
192: AND not exists ( select NULL FROM
193: ar_cmgt_dnb_elements_tl t1
194: where t1.data_element_id = t.data_element_id
195: and t1.language = l.language_code);
196: end ADD_LANGUAGE;
197:

Line 206: update ar_cmgt_dnb_elements_TL

202: begin
203:
204: -- only update rows that have not been altered by user
205:
206: update ar_cmgt_dnb_elements_TL
207: set data_element_name = p_data_element_name,
208: source_lang = userenv('LANG'),
209: last_update_date = sysdate,
210: last_updated_by = decode(P_OWNER, 'SEED', 1, 0)