APPS.GME_BATCH_GROUPS_PKG dependencies on GME_BATCH_GROUPS_TL

Line 39: insert into GME_BATCH_GROUPS_TL (

35: X_LAST_UPDATED_BY,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into GME_BATCH_GROUPS_TL (
40: LAST_UPDATE_LOGIN,
41: GROUP_ID,
42: GROUP_DESC,
43: CREATION_DATE,

Line 63: from GME_BATCH_GROUPS_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from GME_BATCH_GROUPS_TL T
64: where T.GROUP_ID = X_GROUP_ID
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:
67: open c;

Line 94: from GME_BATCH_GROUPS_TL

90:
91: cursor c1 is select
92: GROUP_DESC,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from GME_BATCH_GROUPS_TL
95: where GROUP_ID = X_GROUP_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of GROUP_ID nowait;
98: begin

Line 154: update GME_BATCH_GROUPS_TL set

150: if (sql%notfound) then
151: raise no_data_found;
152: end if;
153:
154: update GME_BATCH_GROUPS_TL set
155: GROUP_DESC = X_GROUP_DESC,
156: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
157: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
158: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 172: delete from GME_BATCH_GROUPS_TL

168: procedure DELETE_ROW (
169: X_GROUP_ID in NUMBER
170: ) is
171: begin
172: delete from GME_BATCH_GROUPS_TL
173: where GROUP_ID = X_GROUP_ID;
174:
175: if (sql%notfound) then
176: raise no_data_found;

Line 190: delete from GME_BATCH_GROUPS_TL T

186:
187: procedure ADD_LANGUAGE
188: is
189: begin
190: delete from GME_BATCH_GROUPS_TL T
191: where not exists
192: (select NULL
193: from GME_BATCH_GROUPS_B B
194: where B.GROUP_ID = T.GROUP_ID

Line 197: update GME_BATCH_GROUPS_TL T set (

193: from GME_BATCH_GROUPS_B B
194: where B.GROUP_ID = T.GROUP_ID
195: );
196:
197: update GME_BATCH_GROUPS_TL T set (
198: GROUP_DESC
199: ) = (select
200: B.GROUP_DESC
201: from GME_BATCH_GROUPS_TL B

Line 201: from GME_BATCH_GROUPS_TL B

197: update GME_BATCH_GROUPS_TL T set (
198: GROUP_DESC
199: ) = (select
200: B.GROUP_DESC
201: from GME_BATCH_GROUPS_TL B
202: where B.GROUP_ID = T.GROUP_ID
203: and B.LANGUAGE = T.SOURCE_LANG)
204: where (
205: T.GROUP_ID,

Line 210: from GME_BATCH_GROUPS_TL SUBB, GME_BATCH_GROUPS_TL SUBT

206: T.LANGUAGE
207: ) in (select
208: SUBT.GROUP_ID,
209: SUBT.LANGUAGE
210: from GME_BATCH_GROUPS_TL SUBB, GME_BATCH_GROUPS_TL SUBT
211: where SUBB.GROUP_ID = SUBT.GROUP_ID
212: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
213: and (SUBB.GROUP_DESC <> SUBT.GROUP_DESC
214: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)

Line 218: insert into GME_BATCH_GROUPS_TL (

214: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)
215: or (SUBB.GROUP_DESC is not null and SUBT.GROUP_DESC is null)
216: ));
217:
218: insert into GME_BATCH_GROUPS_TL (
219: LAST_UPDATE_LOGIN,
220: GROUP_ID,
221: GROUP_DESC,
222: CREATION_DATE,

Line 238: from GME_BATCH_GROUPS_TL B, FND_LANGUAGES L

234: B.LAST_UPDATE_DATE,
235: B.LAST_UPDATED_BY,
236: L.LANGUAGE_CODE,
237: B.SOURCE_LANG
238: from GME_BATCH_GROUPS_TL B, FND_LANGUAGES L
239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL

Line 243: from GME_BATCH_GROUPS_TL T

239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL
243: from GME_BATCH_GROUPS_TL T
244: where T.GROUP_ID = B.GROUP_ID
245: and T.LANGUAGE = L.LANGUAGE_CODE);
246: end ADD_LANGUAGE;
247: