APPS.EDR_PSIG_DOC_PARAMS_PKG dependencies on EDR_PSIG_DOC_PARAMS_TL

Line 43: insert into EDR_PSIG_DOC_PARAMS_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into EDR_PSIG_DOC_PARAMS_TL (
44: PARAMETER_ID,
45: DISPLAY_NAME,
46: LANGUAGE,
47: SOURCE_LANG

Line 57: from EDR_PSIG_DOC_PARAMS_TL T

53: from FND_LANGUAGES L
54: where L.INSTALLED_FLAG in ('I', 'B')
55: and not exists
56: (select NULL
57: from EDR_PSIG_DOC_PARAMS_TL T
58: where T.PARAMETER_ID = X_PARAMETER_ID
59: and T.LANGUAGE = L.LANGUAGE_CODE);
60:
61: open c;

Line 90: from EDR_PSIG_DOC_PARAMS_TL

86:
87: cursor c1 is select
88: DISPLAY_NAME,
89: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
90: from EDR_PSIG_DOC_PARAMS_TL
91: where PARAMETER_ID = X_PARAMETER_ID
92: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
93: for update of PARAMETER_ID nowait;
94: begin

Line 155: update EDR_PSIG_DOC_PARAMS_TL set

151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154:
155: update EDR_PSIG_DOC_PARAMS_TL set
156: DISPLAY_NAME = X_DISPLAY_NAME,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 173: delete from EDR_PSIG_DOC_PARAMS_TL

169: procedure DELETE_ROW (
170: X_PARAMETER_ID in NUMBER
171: ) is
172: begin
173: delete from EDR_PSIG_DOC_PARAMS_TL
174: where PARAMETER_ID = X_PARAMETER_ID;
175:
176: if (sql%notfound) then
177: raise no_data_found;

Line 191: delete from EDR_PSIG_DOC_PARAMS_TL T

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

Line 198: update EDR_PSIG_DOC_PARAMS_TL T set (

194: from EDR_PSIG_DOC_PARAMS_B B
195: where B.PARAMETER_ID = T.PARAMETER_ID
196: );
197:
198: update EDR_PSIG_DOC_PARAMS_TL T set (
199: DISPLAY_NAME
200: ) = (select
201: B.DISPLAY_NAME
202: from EDR_PSIG_DOC_PARAMS_TL B

Line 202: from EDR_PSIG_DOC_PARAMS_TL B

198: update EDR_PSIG_DOC_PARAMS_TL T set (
199: DISPLAY_NAME
200: ) = (select
201: B.DISPLAY_NAME
202: from EDR_PSIG_DOC_PARAMS_TL B
203: where B.PARAMETER_ID = T.PARAMETER_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.PARAMETER_ID,

Line 211: from EDR_PSIG_DOC_PARAMS_TL SUBB, EDR_PSIG_DOC_PARAMS_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.PARAMETER_ID,
210: SUBT.LANGUAGE
211: from EDR_PSIG_DOC_PARAMS_TL SUBB, EDR_PSIG_DOC_PARAMS_TL SUBT
212: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
215: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 219: insert into EDR_PSIG_DOC_PARAMS_TL (

215: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
216: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
217: ));
218:
219: insert into EDR_PSIG_DOC_PARAMS_TL (
220: PARAMETER_ID,
221: DISPLAY_NAME,
222: LANGUAGE,
223: SOURCE_LANG

Line 229: from EDR_PSIG_DOC_PARAMS_TL B, FND_LANGUAGES L

225: B.PARAMETER_ID,
226: B.DISPLAY_NAME,
227: L.LANGUAGE_CODE,
228: B.SOURCE_LANG
229: from EDR_PSIG_DOC_PARAMS_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 EDR_PSIG_DOC_PARAMS_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 EDR_PSIG_DOC_PARAMS_TL T
235: where T.PARAMETER_ID = B.PARAMETER_ID
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237: end ADD_LANGUAGE;
238: