APPS.IEU_WP_SECTIONS_PKG dependencies on IEU_WP_SECTIONS_TL

Line 43: insert into IEU_WP_SECTIONS_TL (

39: P_LAST_UPDATED_BY,
40: P_LAST_UPDATE_LOGIN
41: );
42:
43: insert into IEU_WP_SECTIONS_TL (
44: SECTION_ID,
45: OBJECT_VERSION_NUMBER,
46: CREATED_BY,
47: CREATION_DATE,

Line 73: from IEU_WP_SECTIONS_TL T

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

Line 108: from IEU_WP_SECTIONS_TL

104: cursor c1 is select
105: SECTION_LABEL,
106: SECTION_DESCRIPTION,
107: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
108: from IEU_WP_SECTIONS_TL
109: where SECTION_ID = P_SECTION_ID
110: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
111: for update of SECTION_ID nowait;
112: begin

Line 173: update IEU_WP_SECTIONS_TL set

169: if (sql%notfound) then
170: raise no_data_found;
171: end if;
172:
173: update IEU_WP_SECTIONS_TL set
174: SECTION_LABEL = P_SECTION_LABEL,
175: SECTION_DESCRIPTION = P_SECTION_DESCRIPTION,
176: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 192: delete from IEU_WP_SECTIONS_TL

188: procedure DELETE_ROW (
189: P_SECTION_ID in NUMBER
190: ) is
191: begin
192: delete from IEU_WP_SECTIONS_TL
193: where SECTION_ID = P_SECTION_ID;
194:
195: if (sql%notfound) then
196: raise no_data_found;

Line 210: delete from IEU_WP_SECTIONS_TL T

206:
207: procedure ADD_LANGUAGE
208: is
209: begin
210: delete from IEU_WP_SECTIONS_TL T
211: where not exists
212: (select NULL
213: from IEU_WP_SECTIONS_B B
214: where B.SECTION_ID = T.SECTION_ID

Line 217: update IEU_WP_SECTIONS_TL T set (

213: from IEU_WP_SECTIONS_B B
214: where B.SECTION_ID = T.SECTION_ID
215: );
216:
217: update IEU_WP_SECTIONS_TL T set (
218: SECTION_LABEL,
219: SECTION_DESCRIPTION
220: ) = (select
221: B.SECTION_LABEL,

Line 223: from IEU_WP_SECTIONS_TL B

219: SECTION_DESCRIPTION
220: ) = (select
221: B.SECTION_LABEL,
222: B.SECTION_DESCRIPTION
223: from IEU_WP_SECTIONS_TL B
224: where B.SECTION_ID = T.SECTION_ID
225: and B.LANGUAGE = T.SOURCE_LANG)
226: where (
227: T.SECTION_ID,

Line 232: from IEU_WP_SECTIONS_TL SUBB, IEU_WP_SECTIONS_TL SUBT

228: T.LANGUAGE
229: ) in (select
230: SUBT.SECTION_ID,
231: SUBT.LANGUAGE
232: from IEU_WP_SECTIONS_TL SUBB, IEU_WP_SECTIONS_TL SUBT
233: where SUBB.SECTION_ID = SUBT.SECTION_ID
234: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
235: and (SUBB.SECTION_LABEL <> SUBT.SECTION_LABEL
236: or SUBB.SECTION_DESCRIPTION <> SUBT.SECTION_DESCRIPTION

Line 241: insert into IEU_WP_SECTIONS_TL (

237: or (SUBB.SECTION_DESCRIPTION is null and SUBT.SECTION_DESCRIPTION is not null)
238: or (SUBB.SECTION_DESCRIPTION is not null and SUBT.SECTION_DESCRIPTION is null)
239: ));
240:
241: insert into IEU_WP_SECTIONS_TL (
242: SECTION_ID,
243: OBJECT_VERSION_NUMBER,
244: CREATED_BY,
245: CREATION_DATE,

Line 267: from IEU_WP_SECTIONS_TL B, FND_LANGUAGES L

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

Line 272: from IEU_WP_SECTIONS_TL T

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