APPS.GMP_PROCESS_PARAMETER_SET_PKG dependencies on GMP_PROCESS_PARAMETER_SET_TL

Line 36: insert into GMP_PROCESS_PARAMETER_SET_TL (

32: X_LAST_UPDATED_BY,
33: X_LAST_UPDATE_LOGIN
34: );
35:
36: insert into GMP_PROCESS_PARAMETER_SET_TL (
37: CREATION_DATE,
38: CREATED_BY,
39: LAST_UPDATE_DATE,
40: LAST_UPDATED_BY,

Line 60: from GMP_PROCESS_PARAMETER_SET_TL T

56: from FND_LANGUAGES L
57: where L.INSTALLED_FLAG in ('I', 'B')
58: and not exists
59: (select NULL
60: from GMP_PROCESS_PARAMETER_SET_TL T
61: where T.PARAMETER_SET_ID = X_PARAMETER_SET_ID
62: and T.LANGUAGE = L.LANGUAGE_CODE);
63:
64: open c;

Line 89: from GMP_PROCESS_PARAMETER_SET_TL

85:
86: cursor c1 is select
87: SET_DESCRIPTION,
88: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
89: from GMP_PROCESS_PARAMETER_SET_TL
90: where PARAMETER_SET_ID = X_PARAMETER_SET_ID
91: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
92: for update of PARAMETER_SET_ID nowait;
93: begin

Line 145: update GMP_PROCESS_PARAMETER_SET_TL set

141: if (sql%notfound) then
142: raise no_data_found;
143: end if;
144:
145: update GMP_PROCESS_PARAMETER_SET_TL set
146: SET_DESCRIPTION = X_SET_DESCRIPTION,
147: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
148: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
149: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 163: delete from GMP_PROCESS_PARAMETER_SET_TL

159: procedure DELETE_ROW (
160: X_PARAMETER_SET_ID in NUMBER
161: ) is
162: begin
163: delete from GMP_PROCESS_PARAMETER_SET_TL
164: where PARAMETER_SET_ID = X_PARAMETER_SET_ID;
165:
166: if (sql%notfound) then
167: raise no_data_found;

Line 181: delete from GMP_PROCESS_PARAMETER_SET_TL T

177:
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from GMP_PROCESS_PARAMETER_SET_TL T
182: where not exists
183: (select NULL
184: from GMP_PROCESS_PARAMETER_SET_B B
185: where B.PARAMETER_SET_ID = T.PARAMETER_SET_ID

Line 188: update GMP_PROCESS_PARAMETER_SET_TL T set (

184: from GMP_PROCESS_PARAMETER_SET_B B
185: where B.PARAMETER_SET_ID = T.PARAMETER_SET_ID
186: );
187:
188: update GMP_PROCESS_PARAMETER_SET_TL T set (
189: SET_DESCRIPTION
190: ) = (select
191: B.SET_DESCRIPTION
192: from GMP_PROCESS_PARAMETER_SET_TL B

Line 192: from GMP_PROCESS_PARAMETER_SET_TL B

188: update GMP_PROCESS_PARAMETER_SET_TL T set (
189: SET_DESCRIPTION
190: ) = (select
191: B.SET_DESCRIPTION
192: from GMP_PROCESS_PARAMETER_SET_TL B
193: where B.PARAMETER_SET_ID = T.PARAMETER_SET_ID
194: and B.LANGUAGE = T.SOURCE_LANG)
195: where (
196: T.PARAMETER_SET_ID,

Line 201: from GMP_PROCESS_PARAMETER_SET_TL SUBB, GMP_PROCESS_PARAMETER_SET_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.PARAMETER_SET_ID,
200: SUBT.LANGUAGE
201: from GMP_PROCESS_PARAMETER_SET_TL SUBB, GMP_PROCESS_PARAMETER_SET_TL SUBT
202: where SUBB.PARAMETER_SET_ID = SUBT.PARAMETER_SET_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.SET_DESCRIPTION <> SUBT.SET_DESCRIPTION
205: or (SUBB.SET_DESCRIPTION is null and SUBT.SET_DESCRIPTION is not null)

Line 209: insert into GMP_PROCESS_PARAMETER_SET_TL (

205: or (SUBB.SET_DESCRIPTION is null and SUBT.SET_DESCRIPTION is not null)
206: or (SUBB.SET_DESCRIPTION is not null and SUBT.SET_DESCRIPTION is null)
207: ));
208:
209: insert into GMP_PROCESS_PARAMETER_SET_TL (
210: CREATION_DATE,
211: CREATED_BY,
212: LAST_UPDATE_DATE,
213: LAST_UPDATED_BY,

Line 229: from GMP_PROCESS_PARAMETER_SET_TL B, FND_LANGUAGES L

225: B.PARAMETER_SET_ID,
226: B.SET_DESCRIPTION,
227: L.LANGUAGE_CODE,
228: B.SOURCE_LANG
229: from GMP_PROCESS_PARAMETER_SET_TL B, FND_LANGUAGES L
230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL

Line 234: from GMP_PROCESS_PARAMETER_SET_TL T

230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL
234: from GMP_PROCESS_PARAMETER_SET_TL T
235: where T.PARAMETER_SET_ID = B.PARAMETER_SET_ID
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237: end ADD_LANGUAGE;
238: