APPS.GMD_ACTIVITIES_PKG dependencies on GMD_ACTIVITIES_TL

Line 45: insert into GMD_ACTIVITIES_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into GMD_ACTIVITIES_TL (
46: ACTIVITY,
47: ACTIVITY_DESC,
48: LAST_UPDATE_DATE,
49: CREATED_BY,

Line 69: from GMD_ACTIVITIES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from GMD_ACTIVITIES_TL T
70: where T.ACTIVITY = X_ACTIVITY
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from GMD_ACTIVITIES_TL

100:
101: cursor c1 is select
102: ACTIVITY_DESC,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from GMD_ACTIVITIES_TL
105: where ACTIVITY = X_ACTIVITY
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of ACTIVITY nowait;
108: begin

Line 170: update GMD_ACTIVITIES_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update GMD_ACTIVITIES_TL set
171: ACTIVITY_DESC = X_ACTIVITY_DESC,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
174: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 189: /* delete from GMD_ACTIVITIES_TL

185: X_ACTIVITY in VARCHAR2
186: ) is
187: begin
188:
189: /* delete from GMD_ACTIVITIES_TL
190: where ACTIVITY = X_ACTIVITY;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 208: delete from GMD_ACTIVITIES_TL T

204:
205: procedure ADD_LANGUAGE
206: is
207: begin
208: delete from GMD_ACTIVITIES_TL T
209: where not exists
210: (select NULL
211: from GMD_ACTIVITIES_B B
212: where B.ACTIVITY = T.ACTIVITY

Line 215: update GMD_ACTIVITIES_TL T set (

211: from GMD_ACTIVITIES_B B
212: where B.ACTIVITY = T.ACTIVITY
213: );
214:
215: update GMD_ACTIVITIES_TL T set (
216: ACTIVITY_DESC
217: ) = (select
218: B.ACTIVITY_DESC
219: from GMD_ACTIVITIES_TL B

Line 219: from GMD_ACTIVITIES_TL B

215: update GMD_ACTIVITIES_TL T set (
216: ACTIVITY_DESC
217: ) = (select
218: B.ACTIVITY_DESC
219: from GMD_ACTIVITIES_TL B
220: where B.ACTIVITY = T.ACTIVITY
221: and B.LANGUAGE = T.SOURCE_LANG)
222: where (
223: T.ACTIVITY,

Line 228: from GMD_ACTIVITIES_TL SUBB, GMD_ACTIVITIES_TL SUBT

224: T.LANGUAGE
225: ) in (select
226: SUBT.ACTIVITY,
227: SUBT.LANGUAGE
228: from GMD_ACTIVITIES_TL SUBB, GMD_ACTIVITIES_TL SUBT
229: where SUBB.ACTIVITY = SUBT.ACTIVITY
230: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
231: and (SUBB.ACTIVITY_DESC <> SUBT.ACTIVITY_DESC
232: ));

Line 234: insert into GMD_ACTIVITIES_TL (

230: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
231: and (SUBB.ACTIVITY_DESC <> SUBT.ACTIVITY_DESC
232: ));
233:
234: insert into GMD_ACTIVITIES_TL (
235: ACTIVITY,
236: ACTIVITY_DESC,
237: LAST_UPDATE_DATE,
238: CREATED_BY,

Line 254: from GMD_ACTIVITIES_TL B, FND_LANGUAGES L

250: B.CREATION_DATE,
251: B.LAST_UPDATE_LOGIN,
252: L.LANGUAGE_CODE,
253: B.SOURCE_LANG
254: from GMD_ACTIVITIES_TL B, FND_LANGUAGES L
255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL

Line 259: from GMD_ACTIVITIES_TL T

255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL
259: from GMD_ACTIVITIES_TL T
260: where T.ACTIVITY = B.ACTIVITY
261: and T.LANGUAGE = L.LANGUAGE_CODE);
262: end ADD_LANGUAGE;
263: