eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PARAMETERS_PKG dependencies on CSD_PARAMETERS

Line 1: package body CSD_PARAMETERS_PKG as

1: package body CSD_PARAMETERS_PKG as
2: /* $Header: csdtprmb.pls 120.0 2011/07/06 09:25:35 subhat noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_PARAMETER_ID in NUMBER,

Line 19: cursor C is select ROWID from CSD_PARAMETERS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from CSD_PARAMETERS
20: where PARAMETER_ID = X_PARAMETER_ID
21: ;
22: begin
23: insert into CSD_PARAMETERS (

Line 23: insert into CSD_PARAMETERS (

19: cursor C is select ROWID from CSD_PARAMETERS
20: where PARAMETER_ID = X_PARAMETER_ID
21: ;
22: begin
23: insert into CSD_PARAMETERS (
24: ENTITY,
25: VALUE_TYPE,
26: OBJECT_VERSION_NUMBER,
27: SQL_CLAUSE,

Line 49: insert into CSD_PARAMETERS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into CSD_PARAMETERS_TL (
50: PARAMETER_ID,
51: NAME,
52: DESCRIPTION,
53: CREATION_DATE,

Line 75: from CSD_PARAMETERS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from CSD_PARAMETERS_TL T
76: where T.PARAMETER_ID = X_PARAMETER_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 105: from CSD_PARAMETERS

101: VALUE_TYPE,
102: OBJECT_VERSION_NUMBER,
103: SQL_CLAUSE,
104: PARAM_CODE
105: from CSD_PARAMETERS
106: where PARAMETER_ID = X_PARAMETER_ID
107: for update of PARAMETER_ID nowait;
108: recinfo c%rowtype;
109:

Line 114: from CSD_PARAMETERS_TL

110: cursor c1 is select
111: NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from CSD_PARAMETERS_TL
115: where PARAMETER_ID = X_PARAMETER_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of PARAMETER_ID nowait;
118: begin

Line 170: update CSD_PARAMETERS set

166: X_LAST_UPDATED_BY in NUMBER,
167: X_LAST_UPDATE_LOGIN in NUMBER
168: ) is
169: begin
170: update CSD_PARAMETERS set
171: ENTITY = X_ENTITY,
172: VALUE_TYPE = X_VALUE_TYPE,
173: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
174: SQL_CLAUSE = X_SQL_CLAUSE,

Line 185: update CSD_PARAMETERS_TL set

181: if (sql%notfound) then
182: raise no_data_found;
183: end if;
184:
185: update CSD_PARAMETERS_TL set
186: NAME = X_NAME,
187: DESCRIPTION = X_DESCRIPTION,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 204: delete from CSD_PARAMETERS_TL

200: procedure DELETE_ROW (
201: X_PARAMETER_ID in NUMBER
202: ) is
203: begin
204: delete from CSD_PARAMETERS_TL
205: where PARAMETER_ID = X_PARAMETER_ID;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 211: delete from CSD_PARAMETERS

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: delete from CSD_PARAMETERS
212: where PARAMETER_ID = X_PARAMETER_ID;
213:
214: if (sql%notfound) then
215: raise no_data_found;

Line 222: delete from CSD_PARAMETERS_TL T

218:
219: procedure ADD_LANGUAGE
220: is
221: begin
222: delete from CSD_PARAMETERS_TL T
223: where not exists
224: (select NULL
225: from CSD_PARAMETERS B
226: where B.PARAMETER_ID = T.PARAMETER_ID

Line 225: from CSD_PARAMETERS B

221: begin
222: delete from CSD_PARAMETERS_TL T
223: where not exists
224: (select NULL
225: from CSD_PARAMETERS B
226: where B.PARAMETER_ID = T.PARAMETER_ID
227: );
228:
229: update CSD_PARAMETERS_TL T set (

Line 229: update CSD_PARAMETERS_TL T set (

225: from CSD_PARAMETERS B
226: where B.PARAMETER_ID = T.PARAMETER_ID
227: );
228:
229: update CSD_PARAMETERS_TL T set (
230: NAME,
231: DESCRIPTION
232: ) = (select
233: B.NAME,

Line 235: from CSD_PARAMETERS_TL B

231: DESCRIPTION
232: ) = (select
233: B.NAME,
234: B.DESCRIPTION
235: from CSD_PARAMETERS_TL B
236: where B.PARAMETER_ID = T.PARAMETER_ID
237: and B.LANGUAGE = T.SOURCE_LANG)
238: where (
239: T.PARAMETER_ID,

Line 244: from CSD_PARAMETERS_TL SUBB, CSD_PARAMETERS_TL SUBT

240: T.LANGUAGE
241: ) in (select
242: SUBT.PARAMETER_ID,
243: SUBT.LANGUAGE
244: from CSD_PARAMETERS_TL SUBB, CSD_PARAMETERS_TL SUBT
245: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
246: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
247: and (SUBB.NAME <> SUBT.NAME
248: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 253: insert into CSD_PARAMETERS_TL (

249: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
250: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
251: ));
252:
253: insert into CSD_PARAMETERS_TL (
254: PARAMETER_ID,
255: NAME,
256: DESCRIPTION,
257: CREATION_DATE,

Line 275: from CSD_PARAMETERS_TL B, FND_LANGUAGES L

271: B.LAST_UPDATE_DATE,
272: B.LAST_UPDATE_LOGIN,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from CSD_PARAMETERS_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL

Line 280: from CSD_PARAMETERS_TL T

276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from CSD_PARAMETERS_TL T
281: where T.PARAMETER_ID = B.PARAMETER_ID
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;
284:

Line 285: end CSD_PARAMETERS_PKG;

281: where T.PARAMETER_ID = B.PARAMETER_ID
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;
284:
285: end CSD_PARAMETERS_PKG;