APPS.GMA_PROCCOL_WF_PKG dependencies on GMA_PROCCOL_WF_TL

Line 54: insert into GMA_PROCCOL_WF_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into GMA_PROCCOL_WF_TL (
55: WF_ITEM_TYPE,
56: PROCESS_NAME,
57: COLUMN_HIERARCHY,
58: TABLE_NAME,

Line 86: from GMA_PROCCOL_WF_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from GMA_PROCCOL_WF_TL T
87: where T.WF_ITEM_TYPE = X_WF_ITEM_TYPE
88: and T.TABLE_NAME = X_TABLE_NAME
89: and T.COLUMN_NAME = X_COLUMN_NAME
90: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 127: from GMA_PROCCOL_WF_TL

123:
124: cursor c1 is select
125: COLUMN_PROMPT,
126: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
127: from GMA_PROCCOL_WF_TL
128: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
129: and PROCESS_NAME = X_PROCESS_NAME
130: and TABLE_NAME = X_TABLE_NAME
131: and COLUMN_NAME = X_COLUMN_NAME

Line 198: update GMA_PROCCOL_WF_TL set

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: update GMA_PROCCOL_WF_TL set
199: COLUMN_PROMPT = X_COLUMN_PROMPT,
200: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
201: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
202: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 222: delete from GMA_PROCCOL_WF_TL

218: X_TABLE_NAME in VARCHAR2,
219: X_COLUMN_NAME in VARCHAR2
220: ) is
221: begin
222: delete from GMA_PROCCOL_WF_TL
223: where WF_ITEM_TYPE = X_WF_ITEM_TYPE
224: and PROCESS_NAME = X_PROCESS_NAME
225: and TABLE_NAME = X_TABLE_NAME
226: and COLUMN_NAME = X_COLUMN_NAME;

Line 246: delete from GMA_PROCCOL_WF_TL T

242:
243: procedure ADD_LANGUAGE
244: is
245: begin
246: delete from GMA_PROCCOL_WF_TL T
247: where not exists
248: (select NULL
249: from GMA_PROCCOL_WF_B B
250: where B.WF_ITEM_TYPE = T.WF_ITEM_TYPE

Line 256: update GMA_PROCCOL_WF_TL T set (

252: and B.TABLE_NAME = T.TABLE_NAME
253: and B.COLUMN_NAME = T.COLUMN_NAME
254: );
255:
256: update GMA_PROCCOL_WF_TL T set (
257: COLUMN_PROMPT
258: ) = (select
259: B.COLUMN_PROMPT
260: from GMA_PROCCOL_WF_TL B

Line 260: from GMA_PROCCOL_WF_TL B

256: update GMA_PROCCOL_WF_TL T set (
257: COLUMN_PROMPT
258: ) = (select
259: B.COLUMN_PROMPT
260: from GMA_PROCCOL_WF_TL B
261: where B.WF_ITEM_TYPE = T.WF_ITEM_TYPE
262: and B.PROCESS_NAME = T.PROCESS_NAME
263: and B.TABLE_NAME = T.TABLE_NAME
264: and B.COLUMN_NAME = T.COLUMN_NAME

Line 278: from GMA_PROCCOL_WF_TL SUBB, GMA_PROCCOL_WF_TL SUBT

274: SUBT.PROCESS_NAME,
275: SUBT.TABLE_NAME,
276: SUBT.COLUMN_NAME,
277: SUBT.LANGUAGE
278: from GMA_PROCCOL_WF_TL SUBB, GMA_PROCCOL_WF_TL SUBT
279: where SUBB.WF_ITEM_TYPE = SUBT.WF_ITEM_TYPE
280: and SUBB.PROCESS_NAME = SUBT.PROCESS_NAME
281: and SUBB.TABLE_NAME = SUBT.TABLE_NAME
282: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME

Line 287: insert into GMA_PROCCOL_WF_TL (

283: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
284: and (SUBB.COLUMN_PROMPT <> SUBT.COLUMN_PROMPT
285: ));
286:
287: insert into GMA_PROCCOL_WF_TL (
288: WF_ITEM_TYPE,
289: PROCESS_NAME,
290: COLUMN_HIERARCHY,
291: TABLE_NAME,

Line 315: from GMA_PROCCOL_WF_TL B, FND_LANGUAGES L

311: B.LAST_UPDATE_DATE,
312: B.LAST_UPDATE_LOGIN,
313: L.LANGUAGE_CODE,
314: B.SOURCE_LANG
315: from GMA_PROCCOL_WF_TL B, FND_LANGUAGES L
316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL

Line 320: from GMA_PROCCOL_WF_TL T

316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL
320: from GMA_PROCCOL_WF_TL T
321: where B.WF_ITEM_TYPE = T.WF_ITEM_TYPE
322: and B.PROCESS_NAME = T.PROCESS_NAME
323: and T.TABLE_NAME = B.TABLE_NAME
324: and T.COLUMN_NAME = B.COLUMN_NAME

Line 338: update GMA_PROCCOL_WF_TL set

334: X_COLUMN_PROMPT in VARCHAR2,
335: X_OWNER in VARCHAR2
336: ) IS
337: BEGIN
338: update GMA_PROCCOL_WF_TL set
339: COLUMN_PROMPT = X_COLUMN_PROMPT,
340: SOURCE_LANG = userenv('LANG'),
341: LAST_UPDATE_DATE = sysdate,
342: LAST_UPDATED_BY = decode(X_OWNER,'SEED',1,0),