APPS.GMP_PARAMETER_VALUES_PKG dependencies on GMP_PARAMETER_VALUES_TL

Line 36: insert into GMP_PARAMETER_VALUES_TL (

32: X_LAST_UPDATED_BY,
33: X_LAST_UPDATE_LOGIN
34: );
35:
36: insert into GMP_PARAMETER_VALUES_TL (
37: LAST_UPDATE_LOGIN,
38: PARAMETER_ID,
39: PARAMETER_VALUE,
40: PARAMETER_VALUE_DESCRIPTION,

Line 62: from GMP_PARAMETER_VALUES_TL T

58: from FND_LANGUAGES L
59: where L.INSTALLED_FLAG in ('I', 'B')
60: and not exists
61: (select NULL
62: from GMP_PARAMETER_VALUES_TL T
63: where T.PARAMETER_ID = X_PARAMETER_ID
64: and T.PARAMETER_VALUE = X_PARAMETER_VALUE
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:

Line 93: from GMP_PARAMETER_VALUES_TL

89:
90: cursor c1 is select
91: PARAMETER_VALUE_DESCRIPTION,
92: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
93: from GMP_PARAMETER_VALUES_TL
94: where PARAMETER_ID = X_PARAMETER_ID
95: and PARAMETER_VALUE = X_PARAMETER_VALUE
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of PARAMETER_ID nowait;

Line 152: update GMP_PARAMETER_VALUES_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update GMP_PARAMETER_VALUES_TL set
153: PARAMETER_VALUE_DESCRIPTION = X_PARAMETER_VALUE_DESCRIPTION,
154: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
155: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
156: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 172: delete from GMP_PARAMETER_VALUES_TL

168: X_PARAMETER_ID in NUMBER,
169: X_PARAMETER_VALUE in VARCHAR2
170: ) is
171: begin
172: delete from GMP_PARAMETER_VALUES_TL
173: where PARAMETER_ID = X_PARAMETER_ID
174: and PARAMETER_VALUE = X_PARAMETER_VALUE;
175:
176: if (sql%notfound) then

Line 192: delete from GMP_PARAMETER_VALUES_TL T

188:
189: procedure ADD_LANGUAGE
190: is
191: begin
192: delete from GMP_PARAMETER_VALUES_TL T
193: where not exists
194: (select NULL
195: from GMP_PARAMETER_VALUES_B B
196: where B.PARAMETER_ID = T.PARAMETER_ID

Line 200: update GMP_PARAMETER_VALUES_TL T set (

196: where B.PARAMETER_ID = T.PARAMETER_ID
197: and B.PARAMETER_VALUE = T.PARAMETER_VALUE
198: );
199:
200: update GMP_PARAMETER_VALUES_TL T set (
201: PARAMETER_VALUE_DESCRIPTION
202: ) = (select
203: B.PARAMETER_VALUE_DESCRIPTION
204: from GMP_PARAMETER_VALUES_TL B

Line 204: from GMP_PARAMETER_VALUES_TL B

200: update GMP_PARAMETER_VALUES_TL T set (
201: PARAMETER_VALUE_DESCRIPTION
202: ) = (select
203: B.PARAMETER_VALUE_DESCRIPTION
204: from GMP_PARAMETER_VALUES_TL B
205: where B.PARAMETER_ID = T.PARAMETER_ID
206: and B.PARAMETER_VALUE = T.PARAMETER_VALUE
207: and B.LANGUAGE = T.SOURCE_LANG)
208: where (

Line 214: from GMP_PARAMETER_VALUES_TL SUBB, GMP_PARAMETER_VALUES_TL SUBT

210: T.LANGUAGE
211: ) in (select
212: SUBT.PARAMETER_ID,
213: SUBT.LANGUAGE
214: from GMP_PARAMETER_VALUES_TL SUBB, GMP_PARAMETER_VALUES_TL SUBT
215: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
216: and SUBB.PARAMETER_VALUE = SUBT.PARAMETER_VALUE
217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.PARAMETER_VALUE_DESCRIPTION <> SUBT.PARAMETER_VALUE_DESCRIPTION

Line 223: insert into GMP_PARAMETER_VALUES_TL (

219: or (SUBB.PARAMETER_VALUE_DESCRIPTION is null and SUBT.PARAMETER_VALUE_DESCRIPTION is not null)
220: or (SUBB.PARAMETER_VALUE_DESCRIPTION is not null and SUBT.PARAMETER_VALUE_DESCRIPTION is null)
221: ));
222:
223: insert into GMP_PARAMETER_VALUES_TL (
224: LAST_UPDATE_LOGIN,
225: PARAMETER_ID,
226: PARAMETER_VALUE,
227: PARAMETER_VALUE_DESCRIPTION,

Line 245: from GMP_PARAMETER_VALUES_TL B, FND_LANGUAGES L

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

Line 250: from GMP_PARAMETER_VALUES_TL T

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