APPS.GMD_UNITS_PKG dependencies on GMD_UNITS_TL

Line 42: insert into GMD_UNITS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMD_UNITS_TL (
43: QCUNIT_CODE,
44: QCUNIT_DESC,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from GMD_UNITS_TL T

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

Line 99: from GMD_UNITS_TL

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

Line 162: update GMD_UNITS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update GMD_UNITS_TL set
163: QCUNIT_DESC = X_QCUNIT_DESC,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 180: delete from GMD_UNITS_TL

176: procedure DELETE_ROW (
177: X_QCUNIT_CODE in VARCHAR2
178: ) is
179: begin
180: delete from GMD_UNITS_TL
181: where QCUNIT_CODE = X_QCUNIT_CODE;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 198: delete from GMD_UNITS_TL T

194:
195: procedure ADD_LANGUAGE
196: is
197: begin
198: delete from GMD_UNITS_TL T
199: where not exists
200: (select NULL
201: from GMD_UNITS_B B
202: where B.QCUNIT_CODE = T.QCUNIT_CODE

Line 205: update GMD_UNITS_TL T set (

201: from GMD_UNITS_B B
202: where B.QCUNIT_CODE = T.QCUNIT_CODE
203: );
204:
205: update GMD_UNITS_TL T set (
206: QCUNIT_DESC
207: ) = (select
208: B.QCUNIT_DESC
209: from GMD_UNITS_TL B

Line 209: from GMD_UNITS_TL B

205: update GMD_UNITS_TL T set (
206: QCUNIT_DESC
207: ) = (select
208: B.QCUNIT_DESC
209: from GMD_UNITS_TL B
210: where B.QCUNIT_CODE = T.QCUNIT_CODE
211: and B.LANGUAGE = T.SOURCE_LANG)
212: where (
213: T.QCUNIT_CODE,

Line 218: from GMD_UNITS_TL SUBB, GMD_UNITS_TL SUBT

214: T.LANGUAGE
215: ) in (select
216: SUBT.QCUNIT_CODE,
217: SUBT.LANGUAGE
218: from GMD_UNITS_TL SUBB, GMD_UNITS_TL SUBT
219: where SUBB.QCUNIT_CODE = SUBT.QCUNIT_CODE
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.QCUNIT_DESC <> SUBT.QCUNIT_DESC
222: ));

Line 224: insert into GMD_UNITS_TL (

220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.QCUNIT_DESC <> SUBT.QCUNIT_DESC
222: ));
223:
224: insert into GMD_UNITS_TL (
225: QCUNIT_CODE,
226: QCUNIT_DESC,
227: CREATION_DATE,
228: CREATED_BY,

Line 244: from GMD_UNITS_TL B, FND_LANGUAGES L

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

Line 249: from GMD_UNITS_TL T

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