APPS.GMD_TEST_VALUES_PKG dependencies on GMD_TEST_VALUES_TL

Line 57: insert into GMD_TEST_VALUES_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into GMD_TEST_VALUES_TL (
58: QCASSY_VAL_ID,
59: QCASSY_TYP_ID,
60: VALUE_DESC,
61: CREATION_DATE,

Line 83: from GMD_TEST_VALUES_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from GMD_TEST_VALUES_TL T
84: where T.QCASSY_VAL_ID = X_QCASSY_VAL_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 126: from GMD_TEST_VALUES_TL

122:
123: cursor c1 is select
124: VALUE_DESC,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from GMD_TEST_VALUES_TL
127: where QCASSY_VAL_ID = X_QCASSY_VAL_ID
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of QCASSY_VAL_ID nowait;
130: begin

Line 208: update GMD_TEST_VALUES_TL set

204: if (sql%notfound) then
205: raise no_data_found;
206: end if;
207:
208: update GMD_TEST_VALUES_TL set
209: VALUE_DESC = X_VALUE_DESC,
210: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
211: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
212: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 226: delete from GMD_TEST_VALUES_TL

222: procedure DELETE_ROW (
223: X_QCASSY_VAL_ID in NUMBER
224: ) is
225: begin
226: delete from GMD_TEST_VALUES_TL
227: where QCASSY_VAL_ID = X_QCASSY_VAL_ID;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 244: delete from GMD_TEST_VALUES_TL T

240:
241: procedure ADD_LANGUAGE
242: is
243: begin
244: delete from GMD_TEST_VALUES_TL T
245: where not exists
246: (select NULL
247: from GMD_TEST_VALUES_B B
248: where B.QCASSY_VAL_ID = T.QCASSY_VAL_ID

Line 251: update GMD_TEST_VALUES_TL T set (

247: from GMD_TEST_VALUES_B B
248: where B.QCASSY_VAL_ID = T.QCASSY_VAL_ID
249: );
250:
251: update GMD_TEST_VALUES_TL T set (
252: VALUE_DESC
253: ) = (select
254: B.VALUE_DESC
255: from GMD_TEST_VALUES_TL B

Line 255: from GMD_TEST_VALUES_TL B

251: update GMD_TEST_VALUES_TL T set (
252: VALUE_DESC
253: ) = (select
254: B.VALUE_DESC
255: from GMD_TEST_VALUES_TL B
256: where B.QCASSY_VAL_ID = T.QCASSY_VAL_ID
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.QCASSY_VAL_ID,

Line 264: from GMD_TEST_VALUES_TL SUBB, GMD_TEST_VALUES_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.QCASSY_VAL_ID,
263: SUBT.LANGUAGE
264: from GMD_TEST_VALUES_TL SUBB, GMD_TEST_VALUES_TL SUBT
265: where SUBB.QCASSY_VAL_ID = SUBT.QCASSY_VAL_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.VALUE_DESC <> SUBT.VALUE_DESC
268: or (SUBB.VALUE_DESC is null and SUBT.VALUE_DESC is not null)

Line 272: insert into GMD_TEST_VALUES_TL (

268: or (SUBB.VALUE_DESC is null and SUBT.VALUE_DESC is not null)
269: or (SUBB.VALUE_DESC is not null and SUBT.VALUE_DESC is null)
270: ));
271:
272: insert into GMD_TEST_VALUES_TL (
273: QCASSY_VAL_ID,
274: QCASSY_TYP_ID,
275: VALUE_DESC,
276: CREATION_DATE,

Line 294: from GMD_TEST_VALUES_TL B, FND_LANGUAGES L

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

Line 299: from GMD_TEST_VALUES_TL T

295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL
299: from GMD_TEST_VALUES_TL T
300: where T.QCASSY_VAL_ID = B.QCASSY_VAL_ID
301: and T.LANGUAGE = L.LANGUAGE_CODE);
302: end ADD_LANGUAGE;
303: