APPS.CR_RSRC_CLS_PKG dependencies on CR_RSRC_CLS_TL

Line 42: insert into CR_RSRC_CLS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into CR_RSRC_CLS_TL (
43: RESOURCE_CLASS,
44: RESOURCE_CLASS_DESC,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from CR_RSRC_CLS_TL T

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

Line 99: from CR_RSRC_CLS_TL

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

Line 162: update CR_RSRC_CLS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update CR_RSRC_CLS_TL set
163: RESOURCE_CLASS_DESC = X_RESOURCE_CLASS_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 181: delete from CR_RSRC_CLS_TL

177: X_RESOURCE_CLASS in VARCHAR2
178: ) is
179: begin
180: /*****************
181: delete from CR_RSRC_CLS_TL
182: where RESOURCE_CLASS = X_RESOURCE_CLASS;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 200: delete from CR_RSRC_CLS_TL T

196:
197: procedure ADD_LANGUAGE
198: is
199: begin
200: delete from CR_RSRC_CLS_TL T
201: where not exists
202: (select NULL
203: from CR_RSRC_CLS_B B
204: where B.RESOURCE_CLASS = T.RESOURCE_CLASS

Line 207: update CR_RSRC_CLS_TL T set (

203: from CR_RSRC_CLS_B B
204: where B.RESOURCE_CLASS = T.RESOURCE_CLASS
205: );
206:
207: update CR_RSRC_CLS_TL T set (
208: RESOURCE_CLASS_DESC
209: ) = (select
210: B.RESOURCE_CLASS_DESC
211: from CR_RSRC_CLS_TL B

Line 211: from CR_RSRC_CLS_TL B

207: update CR_RSRC_CLS_TL T set (
208: RESOURCE_CLASS_DESC
209: ) = (select
210: B.RESOURCE_CLASS_DESC
211: from CR_RSRC_CLS_TL B
212: where B.RESOURCE_CLASS = T.RESOURCE_CLASS
213: and B.LANGUAGE = T.SOURCE_LANG)
214: where (
215: T.RESOURCE_CLASS,

Line 220: from CR_RSRC_CLS_TL SUBB, CR_RSRC_CLS_TL SUBT

216: T.LANGUAGE
217: ) in (select
218: SUBT.RESOURCE_CLASS,
219: SUBT.LANGUAGE
220: from CR_RSRC_CLS_TL SUBB, CR_RSRC_CLS_TL SUBT
221: where SUBB.RESOURCE_CLASS = SUBT.RESOURCE_CLASS
222: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
223: and (SUBB.RESOURCE_CLASS_DESC <> SUBT.RESOURCE_CLASS_DESC
224: ));

Line 226: insert into CR_RSRC_CLS_TL (

222: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
223: and (SUBB.RESOURCE_CLASS_DESC <> SUBT.RESOURCE_CLASS_DESC
224: ));
225:
226: insert into CR_RSRC_CLS_TL (
227: RESOURCE_CLASS,
228: RESOURCE_CLASS_DESC,
229: CREATION_DATE,
230: CREATED_BY,

Line 246: from CR_RSRC_CLS_TL B, FND_LANGUAGES L

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

Line 251: from CR_RSRC_CLS_TL T

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