APPS.XDP_WI_FA_MAPPING_PKG dependencies on XDP_WI_FA_MAPPING_TL

Line 42: insert into XDP_WI_FA_MAPPING_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into XDP_WI_FA_MAPPING_TL (
43: WI_FA_MAPPING_ID,
44: DESCRIPTION,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from XDP_WI_FA_MAPPING_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from XDP_WI_FA_MAPPING_TL T
67: where T.WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from XDP_WI_FA_MAPPING_TL

95:
96: cursor c1 is select
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from XDP_WI_FA_MAPPING_TL
100: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of WI_FA_MAPPING_ID nowait;
103: begin

Line 161: update XDP_WI_FA_MAPPING_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update XDP_WI_FA_MAPPING_TL set
162: DESCRIPTION = X_DESCRIPTION,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 179: delete from XDP_WI_FA_MAPPING_TL

175: procedure DELETE_ROW (
176: X_WI_FA_MAPPING_ID in NUMBER
177: ) is
178: begin
179: delete from XDP_WI_FA_MAPPING_TL
180: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 197: delete from XDP_WI_FA_MAPPING_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from XDP_WI_FA_MAPPING_TL T
198: where not exists
199: (select NULL
200: from XDP_WI_FA_MAPPING B
201: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID

Line 204: update XDP_WI_FA_MAPPING_TL T set (

200: from XDP_WI_FA_MAPPING B
201: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID
202: );
203:
204: update XDP_WI_FA_MAPPING_TL T set (
205: DESCRIPTION
206: ) = (select
207: B.DESCRIPTION
208: from XDP_WI_FA_MAPPING_TL B

Line 208: from XDP_WI_FA_MAPPING_TL B

204: update XDP_WI_FA_MAPPING_TL T set (
205: DESCRIPTION
206: ) = (select
207: B.DESCRIPTION
208: from XDP_WI_FA_MAPPING_TL B
209: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.WI_FA_MAPPING_ID,

Line 217: from XDP_WI_FA_MAPPING_TL SUBB, XDP_WI_FA_MAPPING_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.WI_FA_MAPPING_ID,
216: SUBT.LANGUAGE
217: from XDP_WI_FA_MAPPING_TL SUBB, XDP_WI_FA_MAPPING_TL SUBT
218: where SUBB.WI_FA_MAPPING_ID = SUBT.WI_FA_MAPPING_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
221: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 225: insert into XDP_WI_FA_MAPPING_TL (

221: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
222: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
223: ));
224:
225: insert into XDP_WI_FA_MAPPING_TL (
226: WI_FA_MAPPING_ID,
227: DESCRIPTION,
228: CREATED_BY,
229: CREATION_DATE,

Line 245: from XDP_WI_FA_MAPPING_TL B, FND_LANGUAGES L

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

Line 250: from XDP_WI_FA_MAPPING_TL T

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

Line 312: update XDP_WI_FA_MAPPING_TL

308: begin
309:
310: -- only update rows that have not been altered by user
311:
312: update XDP_WI_FA_MAPPING_TL
313: set description = X_DESCRIPTION,
314: source_lang = userenv('LANG'),
315: last_update_date = sysdate,
316: --last_updated_by = decode(X_OWNER, 'SEED', 1, 0), /*dputhiye 15-JUL-2005. DECODE replaced with FND API.*/