APPS.XDP_ACTION_CODES_PKG dependencies on XDP_ACTION_CODES_TL

Line 38: insert into XDP_ACTION_CODES_TL (

34: X_LAST_UPDATED_BY,
35: X_LAST_UPDATE_LOGIN
36: );
37:
38: insert into XDP_ACTION_CODES_TL (
39: ACTION_CODE_ID,
40: DISPLAY_NAME,
41: DESCRIPTION,
42: CREATED_BY,

Line 64: from XDP_ACTION_CODES_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from XDP_ACTION_CODES_TL T
65: where T.ACTION_CODE_ID = X_ACTION_CODE_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 95: from XDP_ACTION_CODES_TL

91: cursor c1 is select
92: DISPLAY_NAME,
93: DESCRIPTION,
94: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
95: from XDP_ACTION_CODES_TL
96: where ACTION_CODE_ID = X_ACTION_CODE_ID
97: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
98: for update of ACTION_CODE_ID nowait;
99: begin

Line 153: update XDP_ACTION_CODES_TL set

149: if (sql%notfound) then
150: raise no_data_found;
151: end if;
152:
153: update XDP_ACTION_CODES_TL set
154: DISPLAY_NAME = X_DISPLAY_NAME,
155: DESCRIPTION = X_DESCRIPTION,
156: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
157: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 172: delete from XDP_ACTION_CODES_TL

168: procedure DELETE_ROW (
169: X_ACTION_CODE_ID in NUMBER
170: ) is
171: begin
172: delete from XDP_ACTION_CODES_TL
173: where ACTION_CODE_ID = X_ACTION_CODE_ID;
174:
175: if (sql%notfound) then
176: raise no_data_found;

Line 190: delete from XDP_ACTION_CODES_TL T

186:
187: procedure ADD_LANGUAGE
188: is
189: begin
190: delete from XDP_ACTION_CODES_TL T
191: where not exists
192: (select NULL
193: from XDP_ACTION_CODES B
194: where B.ACTION_CODE_ID = T.ACTION_CODE_ID

Line 197: update XDP_ACTION_CODES_TL T set (

193: from XDP_ACTION_CODES B
194: where B.ACTION_CODE_ID = T.ACTION_CODE_ID
195: );
196:
197: update XDP_ACTION_CODES_TL T set (
198: DISPLAY_NAME,
199: DESCRIPTION
200: ) = (select
201: B.DISPLAY_NAME,

Line 203: from XDP_ACTION_CODES_TL B

199: DESCRIPTION
200: ) = (select
201: B.DISPLAY_NAME,
202: B.DESCRIPTION
203: from XDP_ACTION_CODES_TL B
204: where B.ACTION_CODE_ID = T.ACTION_CODE_ID
205: and B.LANGUAGE = T.SOURCE_LANG)
206: where (
207: T.ACTION_CODE_ID,

Line 212: from XDP_ACTION_CODES_TL SUBB, XDP_ACTION_CODES_TL SUBT

208: T.LANGUAGE
209: ) in (select
210: SUBT.ACTION_CODE_ID,
211: SUBT.LANGUAGE
212: from XDP_ACTION_CODES_TL SUBB, XDP_ACTION_CODES_TL SUBT
213: where SUBB.ACTION_CODE_ID = SUBT.ACTION_CODE_ID
214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
216: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 221: insert into XDP_ACTION_CODES_TL (

217: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
218: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
219: ));
220:
221: insert into XDP_ACTION_CODES_TL (
222: ACTION_CODE_ID,
223: DISPLAY_NAME,
224: DESCRIPTION,
225: CREATED_BY,

Line 243: from XDP_ACTION_CODES_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from XDP_ACTION_CODES_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from XDP_ACTION_CODES_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from XDP_ACTION_CODES_TL T
249: where T.ACTION_CODE_ID = B.ACTION_CODE_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252:

Line 307: update XDP_ACTION_CODES_TL

303: begin
304:
305: -- only update rows that have not been altered by user
306:
307: update XDP_ACTION_CODES_TL
308: set display_name = X_DISPLAY_NAME,
309: description = X_DESCRIPTION,
310: source_lang = userenv('LANG'),
311: last_update_date = sysdate,