APPS.GMO_DISPENSE_BOOTH_PKG dependencies on GMO_DISPENSE_BOOTH_TL

Line 42: insert into GMO_DISPENSE_BOOTH_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMO_DISPENSE_BOOTH_TL (
43: DISPENSE_BOOTH_ID,
44: DISPENSE_BOOTH_DESC,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from GMO_DISPENSE_BOOTH_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from GMO_DISPENSE_BOOTH_TL T
67: where T.DISPENSE_BOOTH_ID = X_DISPENSE_BOOTH_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from GMO_DISPENSE_BOOTH_TL

95:
96: cursor c1 is select
97: DISPENSE_BOOTH_DESC,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from GMO_DISPENSE_BOOTH_TL
100: where DISPENSE_BOOTH_ID = X_DISPENSE_BOOTH_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of DISPENSE_BOOTH_ID nowait;
103: begin

Line 160: update GMO_DISPENSE_BOOTH_TL set

156: if (sql%notfound) then
157: raise no_data_found;
158: end if;
159:
160: update GMO_DISPENSE_BOOTH_TL set
161: DISPENSE_BOOTH_DESC = X_DISPENSE_BOOTH_DESC,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
164: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 178: delete from GMO_DISPENSE_BOOTH_TL

174: procedure DELETE_ROW (
175: X_DISPENSE_BOOTH_ID in NUMBER
176: ) is
177: begin
178: delete from GMO_DISPENSE_BOOTH_TL
179: where DISPENSE_BOOTH_ID = X_DISPENSE_BOOTH_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 196: delete from GMO_DISPENSE_BOOTH_TL T

192:
193: procedure ADD_LANGUAGE
194: is
195: begin
196: delete from GMO_DISPENSE_BOOTH_TL T
197: where not exists
198: (select NULL
199: from GMO_DISPENSE_BOOTH_B B
200: where B.DISPENSE_BOOTH_ID = T.DISPENSE_BOOTH_ID

Line 203: update GMO_DISPENSE_BOOTH_TL T set (

199: from GMO_DISPENSE_BOOTH_B B
200: where B.DISPENSE_BOOTH_ID = T.DISPENSE_BOOTH_ID
201: );
202:
203: update GMO_DISPENSE_BOOTH_TL T set (
204: DISPENSE_BOOTH_DESC
205: ) = (select
206: B.DISPENSE_BOOTH_DESC
207: from GMO_DISPENSE_BOOTH_TL B

Line 207: from GMO_DISPENSE_BOOTH_TL B

203: update GMO_DISPENSE_BOOTH_TL T set (
204: DISPENSE_BOOTH_DESC
205: ) = (select
206: B.DISPENSE_BOOTH_DESC
207: from GMO_DISPENSE_BOOTH_TL B
208: where B.DISPENSE_BOOTH_ID = T.DISPENSE_BOOTH_ID
209: and B.LANGUAGE = T.SOURCE_LANG)
210: where (
211: T.DISPENSE_BOOTH_ID,

Line 216: from GMO_DISPENSE_BOOTH_TL SUBB, GMO_DISPENSE_BOOTH_TL SUBT

212: T.LANGUAGE
213: ) in (select
214: SUBT.DISPENSE_BOOTH_ID,
215: SUBT.LANGUAGE
216: from GMO_DISPENSE_BOOTH_TL SUBB, GMO_DISPENSE_BOOTH_TL SUBT
217: where SUBB.DISPENSE_BOOTH_ID = SUBT.DISPENSE_BOOTH_ID
218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.DISPENSE_BOOTH_DESC <> SUBT.DISPENSE_BOOTH_DESC
220: ));

Line 222: insert into GMO_DISPENSE_BOOTH_TL (

218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.DISPENSE_BOOTH_DESC <> SUBT.DISPENSE_BOOTH_DESC
220: ));
221:
222: insert into GMO_DISPENSE_BOOTH_TL (
223: DISPENSE_BOOTH_ID,
224: DISPENSE_BOOTH_DESC,
225: CREATED_BY,
226: CREATION_DATE,

Line 242: from GMO_DISPENSE_BOOTH_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_DATE,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from GMO_DISPENSE_BOOTH_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from GMO_DISPENSE_BOOTH_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from GMO_DISPENSE_BOOTH_TL T
248: where T.DISPENSE_BOOTH_ID = B.DISPENSE_BOOTH_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251: