APPS.GMO_DISPENSE_AREA_PKG dependencies on GMO_DISPENSE_AREA_TL

Line 48: insert into GMO_DISPENSE_AREA_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into GMO_DISPENSE_AREA_TL (
49: CREATION_DATE,
50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN,

Line 72: from GMO_DISPENSE_AREA_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from GMO_DISPENSE_AREA_TL T
73: where T.DISPENSE_AREA_ID = X_DISPENSE_AREA_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from GMO_DISPENSE_AREA_TL

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

Line 181: update GMO_DISPENSE_AREA_TL set

177: if (sql%notfound) then
178: raise no_data_found;
179: end if;
180:
181: update GMO_DISPENSE_AREA_TL set
182: DISPENSE_AREA_DESC = X_DISPENSE_AREA_DESC,
183: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
184: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
185: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 199: delete from GMO_DISPENSE_AREA_TL

195: procedure DELETE_ROW (
196: X_DISPENSE_AREA_ID in NUMBER
197: ) is
198: begin
199: delete from GMO_DISPENSE_AREA_TL
200: where DISPENSE_AREA_ID = X_DISPENSE_AREA_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 217: delete from GMO_DISPENSE_AREA_TL T

213:
214: procedure ADD_LANGUAGE
215: is
216: begin
217: delete from GMO_DISPENSE_AREA_TL T
218: where not exists
219: (select NULL
220: from GMO_DISPENSE_AREA_B B
221: where B.DISPENSE_AREA_ID = T.DISPENSE_AREA_ID

Line 224: update GMO_DISPENSE_AREA_TL T set (

220: from GMO_DISPENSE_AREA_B B
221: where B.DISPENSE_AREA_ID = T.DISPENSE_AREA_ID
222: );
223:
224: update GMO_DISPENSE_AREA_TL T set (
225: DISPENSE_AREA_DESC
226: ) = (select
227: B.DISPENSE_AREA_DESC
228: from GMO_DISPENSE_AREA_TL B

Line 228: from GMO_DISPENSE_AREA_TL B

224: update GMO_DISPENSE_AREA_TL T set (
225: DISPENSE_AREA_DESC
226: ) = (select
227: B.DISPENSE_AREA_DESC
228: from GMO_DISPENSE_AREA_TL B
229: where B.DISPENSE_AREA_ID = T.DISPENSE_AREA_ID
230: and B.LANGUAGE = T.SOURCE_LANG)
231: where (
232: T.DISPENSE_AREA_ID,

Line 237: from GMO_DISPENSE_AREA_TL SUBB, GMO_DISPENSE_AREA_TL SUBT

233: T.LANGUAGE
234: ) in (select
235: SUBT.DISPENSE_AREA_ID,
236: SUBT.LANGUAGE
237: from GMO_DISPENSE_AREA_TL SUBB, GMO_DISPENSE_AREA_TL SUBT
238: where SUBB.DISPENSE_AREA_ID = SUBT.DISPENSE_AREA_ID
239: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
240: and (SUBB.DISPENSE_AREA_DESC <> SUBT.DISPENSE_AREA_DESC
241: ));

Line 243: insert into GMO_DISPENSE_AREA_TL (

239: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
240: and (SUBB.DISPENSE_AREA_DESC <> SUBT.DISPENSE_AREA_DESC
241: ));
242:
243: insert into GMO_DISPENSE_AREA_TL (
244: CREATION_DATE,
245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN,

Line 263: from GMO_DISPENSE_AREA_TL B, FND_LANGUAGES L

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

Line 268: from GMO_DISPENSE_AREA_TL T

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