APPS.MSD_CS_IDEN_LOAD_DATA dependencies on MSD_CS_CLMN_IDENTIFIERS

Line 53: update msd_cs_clmn_identifiers set

49: else
50: l_user := 0;
51: end if;
52:
53: update msd_cs_clmn_identifiers set
54: identifier_type = p_identifier_type,
55: system_flag = p_system_flag,
56: last_update_date = sysdate,
57: last_updated_by = l_user,

Line 66: update msd_cs_clmn_identifiers_TL set

62: if (sql%notfound) then
63: raise no_data_found;
64: end if;
65:
66: update msd_cs_clmn_identifiers_TL set
67: description = p_description,
68: user_prompt = p_user_prompt,
69: LAST_UPDATE_DATE = sysdate,
70: LAST_UPDATED_BY = l_user,

Line 79: insert into msd_cs_clmn_identifiers_TL(

75: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
76:
77: if (sql%notfound) then
78:
79: insert into msd_cs_clmn_identifiers_TL(
80: column_identifier,
81: description,
82: user_prompt,
83: language,

Line 132: insert into msd_cs_clmn_identifiers(

128: l_user := 0;
129: end if;
130:
131:
132: insert into msd_cs_clmn_identifiers(
133: column_identifier,
134: system_flag,
135: identifier_type,
136: created_by,

Line 154: insert into msd_cs_clmn_identifiers_TL(

150: sysdate,
151: fnd_global.login_id
152: );
153:
154: insert into msd_cs_clmn_identifiers_TL(
155: column_identifier,
156: description,
157: user_prompt,
158: language,

Line 195: update msd_cs_clmn_identifiers_TL set

191: else
192: l_user := 0;
193: end if;
194:
195: update msd_cs_clmn_identifiers_TL set
196: description = p_description,
197: user_prompt = p_user_prompt,
198: LAST_UPDATE_DATE = sysdate,
199: LAST_UPDATED_BY = l_user,

Line 211: delete from msd_cs_clmn_identifiers_TL T

207:
208: Procedure ADD_LANGUAGE
209: is
210: begin
211: delete from msd_cs_clmn_identifiers_TL T
212: where not exists
213: (select NULL
214: from msd_cs_clmn_identifiers B
215: where B.column_identifier = T.column_identifier

Line 214: from msd_cs_clmn_identifiers B

210: begin
211: delete from msd_cs_clmn_identifiers_TL T
212: where not exists
213: (select NULL
214: from msd_cs_clmn_identifiers B
215: where B.column_identifier = T.column_identifier
216: );
217:
218: update msd_cs_clmn_identifiers_TL T set (

Line 218: update msd_cs_clmn_identifiers_TL T set (

214: from msd_cs_clmn_identifiers B
215: where B.column_identifier = T.column_identifier
216: );
217:
218: update msd_cs_clmn_identifiers_TL T set (
219: DESCRIPTION,user_prompt
220: ) = (select
221: B.DESCRIPTION, b.user_prompt
222: from msd_cs_clmn_identifiers_TL B

Line 222: from msd_cs_clmn_identifiers_TL B

218: update msd_cs_clmn_identifiers_TL T set (
219: DESCRIPTION,user_prompt
220: ) = (select
221: B.DESCRIPTION, b.user_prompt
222: from msd_cs_clmn_identifiers_TL B
223: where B.column_identifier = T.column_identifier
224: and B.LANGUAGE = T.SOURCE_LANG)
225: where (
226: T.column_identifier,

Line 231: from msd_cs_clmn_identifiers_TL SUBB, msd_cs_clmn_identifiers_TL SUBT

227: T.LANGUAGE
228: ) in (select
229: SUBT.column_identifier,
230: SUBT.LANGUAGE
231: from msd_cs_clmn_identifiers_TL SUBB, msd_cs_clmn_identifiers_TL SUBT
232: where SUBB.column_identifier = SUBT.column_identifier
233: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
234: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
235: OR SUBB.USER_PROMPT <> SUBT.USER_PROMPT -- sudekuma bug # 3845894

Line 238: insert into msd_cs_clmn_identifiers_TL (

234: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
235: OR SUBB.USER_PROMPT <> SUBT.USER_PROMPT -- sudekuma bug # 3845894
236: ));
237:
238: insert into msd_cs_clmn_identifiers_TL (
239: column_identifier,
240: description,
241: user_prompt,
242: CREATION_DATE,

Line 268: from msd_cs_clmn_identifiers_TL B, FND_LANGUAGES L

264: B.PROGRAM_ID,
265: B.PROGRAM_UPDATE_DATE,
266: L.LANGUAGE_CODE,
267: B.SOURCE_LANG
268: from msd_cs_clmn_identifiers_TL B, FND_LANGUAGES L
269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL

Line 273: from msd_cs_clmn_identifiers_TL T

269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL
273: from msd_cs_clmn_identifiers_TL T
274: where T.column_identifier = B.column_identifier
275: and T.LANGUAGE = L.LANGUAGE_CODE);
276:
277: End ADD_LANGUAGE;