APPS.GMA_ACTCOL_WF_PKG dependencies on GMA_ACTCOL_WF_TL

Line 50: insert into GMA_ACTCOL_WF_TL (

46: X_LAST_UPDATED_BY,
47: X_LAST_UPDATE_LOGIN
48: );
49:
50: insert into GMA_ACTCOL_WF_TL (
51: ACTIVITY_ID,
52: COLUMN_HIERARCHY,
53: TABLE_NAME,
54: COLUMN_NAME,

Line 80: from GMA_ACTCOL_WF_TL T

76: from FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and not exists
79: (select NULL
80: from GMA_ACTCOL_WF_TL T
81: where T.ACTIVITY_ID = X_ACTIVITY_ID
82: and T.TABLE_NAME = X_TABLE_NAME
83: and T.COLUMN_NAME = X_COLUMN_NAME
84: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 119: from GMA_ACTCOL_WF_TL

115:
116: cursor c1 is select
117: COLUMN_PROMPT,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from GMA_ACTCOL_WF_TL
120: where ACTIVITY_ID = X_ACTIVITY_ID
121: and TABLE_NAME = X_TABLE_NAME
122: and COLUMN_NAME = X_COLUMN_NAME
123: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 187: update GMA_ACTCOL_WF_TL set

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: update GMA_ACTCOL_WF_TL set
188: COLUMN_PROMPT = X_COLUMN_PROMPT,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
191: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 209: delete from GMA_ACTCOL_WF_TL

205: X_TABLE_NAME in VARCHAR2,
206: X_COLUMN_NAME in VARCHAR2
207: ) is
208: begin
209: delete from GMA_ACTCOL_WF_TL
210: where ACTIVITY_ID = X_ACTIVITY_ID
211: and TABLE_NAME = X_TABLE_NAME
212: and COLUMN_NAME = X_COLUMN_NAME;
213:

Line 231: delete from GMA_ACTCOL_WF_TL T

227:
228: procedure ADD_LANGUAGE
229: is
230: begin
231: delete from GMA_ACTCOL_WF_TL T
232: where not exists
233: (select NULL
234: from GMA_ACTCOL_WF_B B
235: where B.ACTIVITY_ID = T.ACTIVITY_ID

Line 240: update GMA_ACTCOL_WF_TL T set (

236: and B.TABLE_NAME = T.TABLE_NAME
237: and B.COLUMN_NAME = T.COLUMN_NAME
238: );
239:
240: update GMA_ACTCOL_WF_TL T set (
241: COLUMN_PROMPT
242: ) = (select
243: B.COLUMN_PROMPT
244: from GMA_ACTCOL_WF_TL B

Line 244: from GMA_ACTCOL_WF_TL B

240: update GMA_ACTCOL_WF_TL T set (
241: COLUMN_PROMPT
242: ) = (select
243: B.COLUMN_PROMPT
244: from GMA_ACTCOL_WF_TL B
245: where B.ACTIVITY_ID = T.ACTIVITY_ID
246: and B.TABLE_NAME = T.TABLE_NAME
247: and B.COLUMN_NAME = T.COLUMN_NAME
248: and B.LANGUAGE = T.SOURCE_LANG)

Line 259: from GMA_ACTCOL_WF_TL SUBB, GMA_ACTCOL_WF_TL SUBT

255: SUBT.ACTIVITY_ID,
256: SUBT.TABLE_NAME,
257: SUBT.COLUMN_NAME,
258: SUBT.LANGUAGE
259: from GMA_ACTCOL_WF_TL SUBB, GMA_ACTCOL_WF_TL SUBT
260: where SUBB.ACTIVITY_ID = SUBT.ACTIVITY_ID
261: and SUBB.TABLE_NAME = SUBT.TABLE_NAME
262: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 267: insert into GMA_ACTCOL_WF_TL (

263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.COLUMN_PROMPT <> SUBT.COLUMN_PROMPT
265: ));
266:
267: insert into GMA_ACTCOL_WF_TL (
268: ACTIVITY_ID,
269: COLUMN_HIERARCHY,
270: TABLE_NAME,
271: COLUMN_NAME,

Line 293: from GMA_ACTCOL_WF_TL B, FND_LANGUAGES L

289: B.LAST_UPDATE_DATE,
290: B.LAST_UPDATE_LOGIN,
291: L.LANGUAGE_CODE,
292: B.SOURCE_LANG
293: from GMA_ACTCOL_WF_TL B, FND_LANGUAGES L
294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL

Line 298: from GMA_ACTCOL_WF_TL T

294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL
298: from GMA_ACTCOL_WF_TL T
299: where T.ACTIVITY_ID = B.ACTIVITY_ID
300: and T.TABLE_NAME = B.TABLE_NAME
301: and T.COLUMN_NAME = B.COLUMN_NAME
302: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 314: update GMA_ACTCOL_WF_TL set

310: X_COLUMN_PROMPT in VARCHAR2,
311: X_OWNER in VARCHAR2
312: ) IS
313: BEGIN
314: update GMA_ACTCOL_WF_TL set
315: COLUMN_PROMPT = X_COLUMN_PROMPT,
316: SOURCE_LANG = userenv('LANG'),
317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(X_OWNER,'SEED',1,0),