APPS.IEU_SH_ACT_TYPES_PKG dependencies on IEU_SH_ACT_TYPES_TL

Line 44: insert into IEU_SH_ACT_TYPES_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into IEU_SH_ACT_TYPES_TL (
45: APPLICATION_ID,
46: NAME,
47: DESCRIPTION,
48: OBJECT_VERSION_NUMBER,

Line 74: from IEU_SH_ACT_TYPES_TL T

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

Line 109: from IEU_SH_ACT_TYPES_TL

105: cursor c1 is select
106: NAME,
107: DESCRIPTION,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from IEU_SH_ACT_TYPES_TL
110: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of ACTIVITY_TYPE_ID nowait;
113: begin

Line 172: update IEU_SH_ACT_TYPES_TL set

168: if (sql%notfound) then
169: raise no_data_found;
170: end if;
171:
172: update IEU_SH_ACT_TYPES_TL set
173: NAME = X_NAME,
174: DESCRIPTION = X_DESCRIPTION,
175: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
176: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 191: delete from IEU_SH_ACT_TYPES_TL

187: procedure DELETE_ROW (
188: X_ACTIVITY_TYPE_ID in NUMBER
189: ) is
190: begin
191: delete from IEU_SH_ACT_TYPES_TL
192: where ACTIVITY_TYPE_ID = X_ACTIVITY_TYPE_ID;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 209: delete from IEU_SH_ACT_TYPES_TL T

205:
206: procedure ADD_LANGUAGE
207: is
208: begin
209: delete from IEU_SH_ACT_TYPES_TL T
210: where not exists
211: (select NULL
212: from IEU_SH_ACT_TYPES_B B
213: where B.ACTIVITY_TYPE_ID = T.ACTIVITY_TYPE_ID

Line 216: update IEU_SH_ACT_TYPES_TL T set (

212: from IEU_SH_ACT_TYPES_B B
213: where B.ACTIVITY_TYPE_ID = T.ACTIVITY_TYPE_ID
214: );
215:
216: update IEU_SH_ACT_TYPES_TL T set (
217: NAME,
218: DESCRIPTION
219: ) = (select
220: B.NAME,

Line 222: from IEU_SH_ACT_TYPES_TL B

218: DESCRIPTION
219: ) = (select
220: B.NAME,
221: B.DESCRIPTION
222: from IEU_SH_ACT_TYPES_TL B
223: where B.ACTIVITY_TYPE_ID = T.ACTIVITY_TYPE_ID
224: and B.LANGUAGE = T.SOURCE_LANG)
225: where (
226: T.ACTIVITY_TYPE_ID,

Line 231: from IEU_SH_ACT_TYPES_TL SUBB, IEU_SH_ACT_TYPES_TL SUBT

227: T.LANGUAGE
228: ) in (select
229: SUBT.ACTIVITY_TYPE_ID,
230: SUBT.LANGUAGE
231: from IEU_SH_ACT_TYPES_TL SUBB, IEU_SH_ACT_TYPES_TL SUBT
232: where SUBB.ACTIVITY_TYPE_ID = SUBT.ACTIVITY_TYPE_ID
233: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
234: and (SUBB.NAME <> SUBT.NAME
235: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 238: insert into IEU_SH_ACT_TYPES_TL (

234: and (SUBB.NAME <> SUBT.NAME
235: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
236: ));
237:
238: insert into IEU_SH_ACT_TYPES_TL (
239: APPLICATION_ID,
240: NAME,
241: DESCRIPTION,
242: OBJECT_VERSION_NUMBER,

Line 264: from IEU_SH_ACT_TYPES_TL B, FND_LANGUAGES L

260: B.LAST_UPDATE_LOGIN,
261: B.ACTIVITY_TYPE_ID,
262: L.LANGUAGE_CODE,
263: B.SOURCE_LANG
264: from IEU_SH_ACT_TYPES_TL B, FND_LANGUAGES L
265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL

Line 269: from IEU_SH_ACT_TYPES_TL T

265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL
269: from IEU_SH_ACT_TYPES_TL T
270: where T.ACTIVITY_TYPE_ID = B.ACTIVITY_TYPE_ID
271: and T.LANGUAGE = L.LANGUAGE_CODE);
272: end ADD_LANGUAGE;
273:

Line 355: IEU_SH_ACT_TYPES_TL

351:
352: -- only UPDATE rows that have not been altered by user
353:
354: UPDATE
355: IEU_SH_ACT_TYPES_TL
356: SET
357: source_lang = userenv('LANG'),
358: name = x_name,
359: description = x_description,