APPS.CSF_MAP_ACC_HRS_PKG dependencies on CSF_MAP_ACCESS_HOURS_TL

Line 227: insert into CSF_MAP_ACCESS_HOURS_TL (

223: P_LAST_UPDATE_LOGIN,
224: p_security_group_id
225: ) ;
226:
227: insert into CSF_MAP_ACCESS_HOURS_TL (
228: ACCESS_HOUR_MAP_ID,
229: DESCRIPTION,
230: CREATED_BY,
231: CREATION_DATE,

Line 253: from CSF_MAP_ACCESS_HOURS_TL T

249: from FND_LANGUAGES L
250: where L.INSTALLED_FLAG in ('I', 'B')
251: and not exists
252: (select NULL
253: from CSF_MAP_ACCESS_HOURS_TL T
254: where T.ACCESS_HOUR_MAP_ID = PX_ACCESS_HOUR_MAP_ID
255: and T.LANGUAGE = L.LANGUAGE_CODE);
256:
257: X_OBJECT_VERSION_NUMBER := l_object_Version_number;

Line 355: update CSF_MAP_ACCESS_HOURS_TL set

351: if (sql%notfound) then
352: raise no_data_found;
353: end if;
354:
355: update CSF_MAP_ACCESS_HOURS_TL set
356: DESCRIPTION = P_DESCRIPTION,
357: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
358: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
359: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 410: delete from CSF_MAP_ACCESS_HOURS_TL

406:
407: PROCEDURE Delete_Row(
408: p_ACCESS_HOUR_MAP_ID IN NUMBER) is
409: begin
410: delete from CSF_MAP_ACCESS_HOURS_TL
411: where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
412:
413: if (sql%notfound) then
414: raise no_data_found;

Line 429: delete from CSF_MAP_ACCESS_HOURS_TL T

425:
426:
427: PROCEDURE ADD_LANGUAGE is
428: begin
429: delete from CSF_MAP_ACCESS_HOURS_TL T
430: where not exists
431: (select NULL
432: from CSF_MAP_ACCESS_HOURS_B B
433: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID

Line 436: update CSF_MAP_ACCESS_HOURS_TL T set (

432: from CSF_MAP_ACCESS_HOURS_B B
433: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
434: );
435:
436: update CSF_MAP_ACCESS_HOURS_TL T set (
437: DESCRIPTION
438: ) = (select
439: B.DESCRIPTION
440: from CSF_MAP_ACCESS_HOURS_TL B

Line 440: from CSF_MAP_ACCESS_HOURS_TL B

436: update CSF_MAP_ACCESS_HOURS_TL T set (
437: DESCRIPTION
438: ) = (select
439: B.DESCRIPTION
440: from CSF_MAP_ACCESS_HOURS_TL B
441: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
442: and B.LANGUAGE = T.SOURCE_LANG)
443: where (
444: T.ACCESS_HOUR_MAP_ID,

Line 449: from CSF_MAP_ACCESS_HOURS_TL SUBB, CSF_MAP_ACCESS_HOURS_TL SUBT

445: T.LANGUAGE
446: ) in (select
447: SUBT.ACCESS_HOUR_MAP_ID,
448: SUBT.LANGUAGE
449: from CSF_MAP_ACCESS_HOURS_TL SUBB, CSF_MAP_ACCESS_HOURS_TL SUBT
450: where SUBB.ACCESS_HOUR_MAP_ID = SUBT.ACCESS_HOUR_MAP_ID
451: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
452: and (
453: SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 458: insert into CSF_MAP_ACCESS_HOURS_TL (

454: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
455: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
456: ));
457:
458: insert into CSF_MAP_ACCESS_HOURS_TL (
459: DESCRIPTION,
460: CREATION_DATE,
461: CREATED_BY,
462: LAST_UPDATE_DATE,

Line 480: from CSF_MAP_ACCESS_HOURS_TL B, FND_LANGUAGES L

476: B.ACCESS_HOUR_MAP_ID,
477: B.security_group_id,
478: L.LANGUAGE_CODE,
479: B.SOURCE_LANG
480: from CSF_MAP_ACCESS_HOURS_TL B, FND_LANGUAGES L
481: where L.INSTALLED_FLAG in ('I', 'B')
482: and B.LANGUAGE = userenv('LANG')
483: and not exists
484: (select NULL

Line 485: from CSF_MAP_ACCESS_HOURS_TL T

481: where L.INSTALLED_FLAG in ('I', 'B')
482: and B.LANGUAGE = userenv('LANG')
483: and not exists
484: (select NULL
485: from CSF_MAP_ACCESS_HOURS_TL T
486: where T.ACCESS_HOUR_MAP_ID = B.ACCESS_HOUR_MAP_ID
487: and T.LANGUAGE = L.LANGUAGE_CODE);
488: end ADD_LANGUAGE;
489:

Line 573: update CSF_MAP_ACCESS_HOURS_TL set

569: else
570: l_user_id := 0;
571: end if;
572:
573: update CSF_MAP_ACCESS_HOURS_TL set
574: description = nvl(x_description,'none'),
575: last_update_date = nvl(x_last_update_date,sysdate),
576: last_updated_by = l_user_id,
577: last_update_login = 0,