APPS.ICX_POR_ITEM_SOURCES_PKG dependencies on ICX_POR_ITEM_SOURCES_TL

Line 48: insert into ICX_POR_ITEM_SOURCES_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into ICX_POR_ITEM_SOURCES_TL (
49: ITEM_SOURCE_ID,
50: ITEM_SOURCE_NAME,
51: DESCRIPTION,
52: CREATION_DATE,

Line 74: from ICX_POR_ITEM_SOURCES_TL T

70: from FND_LANGUAGES L
71: where L.INSTALLED_FLAG in ('I', 'B')
72: and not exists
73: (select NULL
74: from ICX_POR_ITEM_SOURCES_TL T
75: where T.ITEM_SOURCE_ID = X_ITEM_SOURCE_ID
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:
78: open c;

Line 101: update ICX_POR_ITEM_SOURCES_TL set

97: X_LAST_UPDATED_BY in NUMBER,
98: X_LAST_UPDATE_LOGIN in NUMBER
99: ) is
100: begin
101: update ICX_POR_ITEM_SOURCES_TL set
102: ITEM_SOURCE_NAME = X_ITEM_SOURCE_NAME,
103: DESCRIPTION = X_DESCRIPTION,
104: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
105: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 112: insert into ICX_POR_ITEM_SOURCES_TL (

108: where ITEM_SOURCE_ID = X_ITEM_SOURCE_ID
109: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
110:
111: if (sql%notfound) then
112: insert into ICX_POR_ITEM_SOURCES_TL (
113: ITEM_SOURCE_ID,
114: ITEM_SOURCE_NAME,
115: DESCRIPTION,
116: CREATION_DATE,

Line 157: from ICX_POR_ITEM_SOURCES_TL

153: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
154:
155: select LAST_UPDATED_BY, LAST_UPDATE_DATE
156: into db_luby, db_ludate
157: from ICX_POR_ITEM_SOURCES_TL
158: where LANGUAGE = userenv('LANG')
159: and ITEM_SOURCE_ID = to_number(X_ITEM_SOURCE_ID);
160:
161: -- Update record, honoring customization mode.

Line 173: update icx_por_item_sources_tl set

169: p_db_id => db_luby,
170: p_db_lud => db_ludate,
171: p_custom_mode => X_CUSTOM_MODE))
172: then
173: update icx_por_item_sources_tl set
174: item_source_name = nvl(X_ITEM_SOURCE_NAME, ITEM_SOURCE_NAME),
175: description = nvl(X_DESCRIPTION, DESCRIPTION),
176: last_update_date = sysdate,
177: last_updated_by = f_luby,

Line 215: from ICX_POR_ITEM_SOURCES_TL

211: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
212:
213: select LAST_UPDATED_BY, LAST_UPDATE_DATE
214: into db_luby, db_ludate
215: from ICX_POR_ITEM_SOURCES_TL
216: where LANGUAGE = userenv('LANG')
217: and ITEM_SOURCE_ID = to_number(X_ITEM_SOURCE_ID);
218:
219: -- Bug#3219138

Line 284: delete from ICX_POR_ITEM_SOURCES_TL T

280:
281: procedure ADD_LANGUAGE
282: is
283: begin
284: delete from ICX_POR_ITEM_SOURCES_TL T
285: where not exists
286: (select NULL
287: from ICX_POR_ITEM_SOURCES B
288: where B.ITEM_SOURCE_ID = T.ITEM_SOURCE_ID

Line 292: update ICX_POR_ITEM_SOURCES_TL T set (

288: where B.ITEM_SOURCE_ID = T.ITEM_SOURCE_ID
289: );
290:
291: /*
292: update ICX_POR_ITEM_SOURCES_TL T set (
293: ITEM_SOURCE_NAME,
294: DESCRIPTION
295: ) = (select
296: B.ITEM_SOURCE_NAME,

Line 298: from ICX_POR_ITEM_SOURCES_TL B

294: DESCRIPTION
295: ) = (select
296: B.ITEM_SOURCE_NAME,
297: B.DESCRIPTION
298: from ICX_POR_ITEM_SOURCES_TL B
299: where B.ITEM_SOURCE_ID = T.ITEM_SOURCE_ID
300: and B.LANGUAGE = T.SOURCE_LANG)
301: where (
302: T.ITEM_SOURCE_ID,

Line 307: from ICX_POR_ITEM_SOURCES_TL SUBB, ICX_POR_ITEM_SOURCES_TL SUBT

303: T.LANGUAGE
304: ) in (select
305: SUBT.ITEM_SOURCE_ID,
306: SUBT.LANGUAGE
307: from ICX_POR_ITEM_SOURCES_TL SUBB, ICX_POR_ITEM_SOURCES_TL SUBT
308: where SUBB.ITEM_SOURCE_ID = SUBT.ITEM_SOURCE_ID
309: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
310: and (SUBB.ITEM_SOURCE_NAME <> SUBT.ITEM_SOURCE_NAME
311: or (SUBB.ITEM_SOURCE_NAME is null and SUBT.ITEM_SOURCE_NAME is not null)

Line 319: insert into ICX_POR_ITEM_SOURCES_TL (

315: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
316: ));
317: */
318:
319: insert into ICX_POR_ITEM_SOURCES_TL (
320: LAST_UPDATE_LOGIN,
321: LAST_UPDATE_DATE,
322: LAST_UPDATED_BY,
323: CREATION_DATE,

Line 341: from ICX_POR_ITEM_SOURCES_TL B, FND_LANGUAGES L

337: B.ITEM_SOURCE_NAME,
338: B.DESCRIPTION,
339: L.LANGUAGE_CODE,
340: B.SOURCE_LANG
341: from ICX_POR_ITEM_SOURCES_TL B, FND_LANGUAGES L
342: where L.INSTALLED_FLAG in ('I', 'B')
343: and B.LANGUAGE = userenv('LANG')
344: and not exists
345: (select NULL

Line 346: from ICX_POR_ITEM_SOURCES_TL T

342: where L.INSTALLED_FLAG in ('I', 'B')
343: and B.LANGUAGE = userenv('LANG')
344: and not exists
345: (select NULL
346: from ICX_POR_ITEM_SOURCES_TL T
347: where T.ITEM_SOURCE_ID = B.ITEM_SOURCE_ID
348: and T.LANGUAGE = L.LANGUAGE_CODE);
349: end ADD_LANGUAGE;
350: