APPS.CM_CLDR_HDR_PKG dependencies on CM_CLDR_HDR_TL

Line 135: insert into CM_CLDR_HDR_TL (

131: X_LAST_UPDATED_BY,
132: X_LAST_UPDATE_LOGIN
133: );
134:
135: insert into CM_CLDR_HDR_TL (
136: LAST_UPDATE_LOGIN,
137: LAST_UPDATED_BY,
138: CREATION_DATE,
139: CREATED_BY,

Line 159: from CM_CLDR_HDR_TL T

155: from FND_LANGUAGES L
156: where L.INSTALLED_FLAG in ('I', 'B')
157: and not exists
158: (select NULL
159: from CM_CLDR_HDR_TL T
160: where T.CALENDAR_CODE = X_CALENDAR_CODE
161: and T.LANGUAGE = L.LANGUAGE_CODE);
162:
163: open c;

Line 254: from CM_CLDR_HDR_TL

250:
251: cursor c1 is select
252: CALENDAR_DESC,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from CM_CLDR_HDR_TL
255: where CALENDAR_CODE = X_CALENDAR_CODE
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of CALENDAR_CODE nowait;
258: begin

Line 441: update CM_CLDR_HDR_TL set

437: if (sql%notfound) then
438: raise no_data_found;
439: end if;
440:
441: update CM_CLDR_HDR_TL set
442: CALENDAR_DESC = X_CALENDAR_DESC,
443: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
444: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
445: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 461: * delete from CM_CLDR_HDR_TL

457: ) is
458: begin
459:
460: /*
461: * delete from CM_CLDR_HDR_TL
462: * where CALENDAR_CODE = X_CALENDAR_CODE;
463: *
464: * if (sql%notfound) then
465: * raise no_data_found;

Line 485: delete from CM_CLDR_HDR_TL T

481:
482: procedure ADD_LANGUAGE
483: is
484: begin
485: delete from CM_CLDR_HDR_TL T
486: where not exists
487: (select NULL
488: from CM_CLDR_HDR_B B
489: where B.CALENDAR_CODE = T.CALENDAR_CODE

Line 492: update CM_CLDR_HDR_TL T set (

488: from CM_CLDR_HDR_B B
489: where B.CALENDAR_CODE = T.CALENDAR_CODE
490: );
491:
492: update CM_CLDR_HDR_TL T set (
493: CALENDAR_DESC
494: ) = (select
495: B.CALENDAR_DESC
496: from CM_CLDR_HDR_TL B

Line 496: from CM_CLDR_HDR_TL B

492: update CM_CLDR_HDR_TL T set (
493: CALENDAR_DESC
494: ) = (select
495: B.CALENDAR_DESC
496: from CM_CLDR_HDR_TL B
497: where B.CALENDAR_CODE = T.CALENDAR_CODE
498: and B.LANGUAGE = T.SOURCE_LANG)
499: where (
500: T.CALENDAR_CODE,

Line 505: from CM_CLDR_HDR_TL SUBB, CM_CLDR_HDR_TL SUBT

501: T.LANGUAGE
502: ) in (select
503: SUBT.CALENDAR_CODE,
504: SUBT.LANGUAGE
505: from CM_CLDR_HDR_TL SUBB, CM_CLDR_HDR_TL SUBT
506: where SUBB.CALENDAR_CODE = SUBT.CALENDAR_CODE
507: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
508: and (SUBB.CALENDAR_DESC <> SUBT.CALENDAR_DESC
509: ));

Line 511: insert into CM_CLDR_HDR_TL (

507: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
508: and (SUBB.CALENDAR_DESC <> SUBT.CALENDAR_DESC
509: ));
510:
511: insert into CM_CLDR_HDR_TL (
512: LAST_UPDATE_LOGIN,
513: LAST_UPDATED_BY,
514: CREATION_DATE,
515: CREATED_BY,

Line 531: from CM_CLDR_HDR_TL B, FND_LANGUAGES L

527: B.CALENDAR_DESC,
528: B.CALENDAR_CODE,
529: L.LANGUAGE_CODE,
530: B.SOURCE_LANG
531: from CM_CLDR_HDR_TL B, FND_LANGUAGES L
532: where L.INSTALLED_FLAG in ('I', 'B')
533: and B.LANGUAGE = userenv('LANG')
534: and not exists
535: (select NULL

Line 536: from CM_CLDR_HDR_TL T

532: where L.INSTALLED_FLAG in ('I', 'B')
533: and B.LANGUAGE = userenv('LANG')
534: and not exists
535: (select NULL
536: from CM_CLDR_HDR_TL T
537: where T.CALENDAR_CODE = B.CALENDAR_CODE
538: and T.LANGUAGE = L.LANGUAGE_CODE);
539: end ADD_LANGUAGE;
540: