APPS.CSF_MAP_ACC_HRS_PKG dependencies on CSF_MAP_ACCESS_HOURS_TL

Line 139: insert into CSF_MAP_ACCESS_HOURS_TL (

135: P_LAST_UPDATE_LOGIN,
136: p_security_group_id
137: ) ;
138:
139: insert into CSF_MAP_ACCESS_HOURS_TL (
140: ACCESS_HOUR_MAP_ID,
141: DESCRIPTION,
142: CREATED_BY,
143: CREATION_DATE,

Line 165: from CSF_MAP_ACCESS_HOURS_TL T

161: from FND_LANGUAGES L
162: where L.INSTALLED_FLAG in ('I', 'B')
163: and not exists
164: (select NULL
165: from CSF_MAP_ACCESS_HOURS_TL T
166: where T.ACCESS_HOUR_MAP_ID = PX_ACCESS_HOUR_MAP_ID
167: and T.LANGUAGE = L.LANGUAGE_CODE);
168:
169: X_OBJECT_VERSION_NUMBER := l_object_Version_number;

Line 267: update CSF_MAP_ACCESS_HOURS_TL set

263: if (sql%notfound) then
264: raise no_data_found;
265: end if;
266:
267: update CSF_MAP_ACCESS_HOURS_TL set
268: DESCRIPTION = P_DESCRIPTION,
269: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
270: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
271: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 322: delete from CSF_MAP_ACCESS_HOURS_TL

318:
319: PROCEDURE Delete_Row(
320: p_ACCESS_HOUR_MAP_ID IN NUMBER) is
321: begin
322: delete from CSF_MAP_ACCESS_HOURS_TL
323: where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
324:
325: if (sql%notfound) then
326: raise no_data_found;

Line 341: delete from CSF_MAP_ACCESS_HOURS_TL T

337:
338:
339: PROCEDURE ADD_LANGUAGE is
340: begin
341: delete from CSF_MAP_ACCESS_HOURS_TL T
342: where not exists
343: (select NULL
344: from CSF_MAP_ACCESS_HOURS_B B
345: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID

Line 348: update CSF_MAP_ACCESS_HOURS_TL T set (

344: from CSF_MAP_ACCESS_HOURS_B B
345: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
346: );
347:
348: update CSF_MAP_ACCESS_HOURS_TL T set (
349: DESCRIPTION
350: ) = (select
351: B.DESCRIPTION
352: from CSF_MAP_ACCESS_HOURS_TL B

Line 352: from CSF_MAP_ACCESS_HOURS_TL B

348: update CSF_MAP_ACCESS_HOURS_TL T set (
349: DESCRIPTION
350: ) = (select
351: B.DESCRIPTION
352: from CSF_MAP_ACCESS_HOURS_TL B
353: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
354: and B.LANGUAGE = T.SOURCE_LANG)
355: where (
356: T.ACCESS_HOUR_MAP_ID,

Line 361: from CSF_MAP_ACCESS_HOURS_TL SUBB, CSF_MAP_ACCESS_HOURS_TL SUBT

357: T.LANGUAGE
358: ) in (select
359: SUBT.ACCESS_HOUR_MAP_ID,
360: SUBT.LANGUAGE
361: from CSF_MAP_ACCESS_HOURS_TL SUBB, CSF_MAP_ACCESS_HOURS_TL SUBT
362: where SUBB.ACCESS_HOUR_MAP_ID = SUBT.ACCESS_HOUR_MAP_ID
363: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
364: and (
365: SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 370: insert into CSF_MAP_ACCESS_HOURS_TL (

366: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
367: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
368: ));
369:
370: insert into CSF_MAP_ACCESS_HOURS_TL (
371: DESCRIPTION,
372: CREATION_DATE,
373: CREATED_BY,
374: LAST_UPDATE_DATE,

Line 392: from CSF_MAP_ACCESS_HOURS_TL B, FND_LANGUAGES L

388: B.ACCESS_HOUR_MAP_ID,
389: B.security_group_id,
390: L.LANGUAGE_CODE,
391: B.SOURCE_LANG
392: from CSF_MAP_ACCESS_HOURS_TL B, FND_LANGUAGES L
393: where L.INSTALLED_FLAG in ('I', 'B')
394: and B.LANGUAGE = userenv('LANG')
395: and not exists
396: (select NULL

Line 397: from CSF_MAP_ACCESS_HOURS_TL T

393: where L.INSTALLED_FLAG in ('I', 'B')
394: and B.LANGUAGE = userenv('LANG')
395: and not exists
396: (select NULL
397: from CSF_MAP_ACCESS_HOURS_TL T
398: where T.ACCESS_HOUR_MAP_ID = B.ACCESS_HOUR_MAP_ID
399: and T.LANGUAGE = L.LANGUAGE_CODE);
400: end ADD_LANGUAGE;
401:

Line 485: update CSF_MAP_ACCESS_HOURS_TL set

481: else
482: l_user_id := 0;
483: end if;
484:
485: update CSF_MAP_ACCESS_HOURS_TL set
486: description = nvl(x_description,'none'),
487: last_update_date = nvl(x_last_update_date,sysdate),
488: last_updated_by = l_user_id,
489: last_update_login = 0,