APPS.CR_RSRC_MST_PKG dependencies on CR_RSRC_MST_TL

Line 72: insert into CR_RSRC_MST_TL (

68: X_UTILIZATION,
69: X_EFFICIENCY
70: );
71:
72: insert into CR_RSRC_MST_TL (
73: RESOURCES,
74: RESOURCE_DESC,
75: CREATION_DATE,
76: CREATED_BY,

Line 96: from CR_RSRC_MST_TL T

92: from FND_LANGUAGES L
93: where L.INSTALLED_FLAG in ('I', 'B')
94: and not exists
95: (select NULL
96: from CR_RSRC_MST_TL T
97: where T.RESOURCES = X_RESOURCES
98: and T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 149: from CR_RSRC_MST_TL

145:
146: cursor c1 is select
147: RESOURCE_DESC,
148: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
149: from CR_RSRC_MST_TL
150: where RESOURCES = X_RESOURCES
151: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
152: for update of RESOURCES nowait;
153: begin

Line 250: update CR_RSRC_MST_TL set

246: if (sql%notfound) then
247: raise no_data_found;
248: end if;
249:
250: update CR_RSRC_MST_TL set
251: RESOURCE_DESC = X_RESOURCE_DESC,
252: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
253: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
254: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 270: delete from CR_RSRC_MST_TL

266: ) is
267: begin
268: /******************
269:
270: delete from CR_RSRC_MST_TL
271: where RESOURCES = X_RESOURCES;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 289: delete from CR_RSRC_MST_TL T

285:
286: procedure ADD_LANGUAGE
287: is
288: begin
289: delete from CR_RSRC_MST_TL T
290: where not exists
291: (select NULL
292: from CR_RSRC_MST_B B
293: where B.RESOURCES = T.RESOURCES

Line 296: update CR_RSRC_MST_TL T set (

292: from CR_RSRC_MST_B B
293: where B.RESOURCES = T.RESOURCES
294: );
295:
296: update CR_RSRC_MST_TL T set (
297: RESOURCE_DESC
298: ) = (select
299: B.RESOURCE_DESC
300: from CR_RSRC_MST_TL B

Line 300: from CR_RSRC_MST_TL B

296: update CR_RSRC_MST_TL T set (
297: RESOURCE_DESC
298: ) = (select
299: B.RESOURCE_DESC
300: from CR_RSRC_MST_TL B
301: where B.RESOURCES = T.RESOURCES
302: and B.LANGUAGE = T.SOURCE_LANG)
303: where (
304: T.RESOURCES,

Line 309: from CR_RSRC_MST_TL SUBB, CR_RSRC_MST_TL SUBT

305: T.LANGUAGE
306: ) in (select
307: SUBT.RESOURCES,
308: SUBT.LANGUAGE
309: from CR_RSRC_MST_TL SUBB, CR_RSRC_MST_TL SUBT
310: where SUBB.RESOURCES = SUBT.RESOURCES
311: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
312: and (SUBB.RESOURCE_DESC <> SUBT.RESOURCE_DESC
313: ));

Line 315: insert into CR_RSRC_MST_TL (

311: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
312: and (SUBB.RESOURCE_DESC <> SUBT.RESOURCE_DESC
313: ));
314:
315: insert into CR_RSRC_MST_TL (
316: RESOURCES,
317: RESOURCE_DESC,
318: CREATION_DATE,
319: CREATED_BY,

Line 335: from CR_RSRC_MST_TL B, FND_LANGUAGES L

331: B.LAST_UPDATED_BY,
332: B.LAST_UPDATE_LOGIN,
333: L.LANGUAGE_CODE,
334: B.SOURCE_LANG
335: from CR_RSRC_MST_TL B, FND_LANGUAGES L
336: where L.INSTALLED_FLAG in ('I', 'B')
337: and B.LANGUAGE = userenv('LANG')
338: and not exists
339: (select NULL

Line 340: from CR_RSRC_MST_TL T

336: where L.INSTALLED_FLAG in ('I', 'B')
337: and B.LANGUAGE = userenv('LANG')
338: and not exists
339: (select NULL
340: from CR_RSRC_MST_TL T
341: where T.RESOURCES = B.RESOURCES
342: and T.LANGUAGE = L.LANGUAGE_CODE);
343: end ADD_LANGUAGE;
344: