APPS.CM_CMPT_MST_PKG dependencies on CM_CMPT_MST_TL

Line 159: insert into CM_CMPT_MST_TL (

155: X_LAST_UPDATED_BY,
156: X_LAST_UPDATE_LOGIN
157: );
158:
159: insert into CM_CMPT_MST_TL (
160: COST_CMPNTCLS_ID,
161: COST_CMPNTCLS_DESC,
162: CREATION_DATE,
163: CREATED_BY,

Line 183: from CM_CMPT_MST_TL T

179: from FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')
181: and not exists
182: (select NULL
183: from CM_CMPT_MST_TL T
184: where T.COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID
185: and T.LANGUAGE = L.LANGUAGE_CODE);
186:
187: open c;

Line 294: from CM_CMPT_MST_TL

290:
291: cursor c1 is select
292: COST_CMPNTCLS_DESC,
293: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
294: from CM_CMPT_MST_TL
295: where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID
296: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
297: for update of COST_CMPNTCLS_ID nowait;
298: begin

Line 506: update CM_CMPT_MST_TL set

502: if (sql%notfound) then
503: raise no_data_found;
504: end if;
505:
506: update CM_CMPT_MST_TL set
507: COST_CMPNTCLS_DESC = X_COST_CMPNTCLS_DESC,
508: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
509: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
510: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 525: * delete from CM_CMPT_MST_TL

521: X_COST_CMPNTCLS_ID in NUMBER
522: ) is
523: begin
524: /*
525: * delete from CM_CMPT_MST_TL
526: * where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID;
527: *
528: * if (sql%notfound) then
529: * raise no_data_found;

Line 548: delete from CM_CMPT_MST_TL T

544:
545: procedure ADD_LANGUAGE
546: is
547: begin
548: delete from CM_CMPT_MST_TL T
549: where not exists
550: (select NULL
551: from CM_CMPT_MST_B B
552: where B.COST_CMPNTCLS_ID = T.COST_CMPNTCLS_ID

Line 555: update CM_CMPT_MST_TL T set (

551: from CM_CMPT_MST_B B
552: where B.COST_CMPNTCLS_ID = T.COST_CMPNTCLS_ID
553: );
554:
555: update CM_CMPT_MST_TL T set (
556: COST_CMPNTCLS_DESC
557: ) = (select
558: B.COST_CMPNTCLS_DESC
559: from CM_CMPT_MST_TL B

Line 559: from CM_CMPT_MST_TL B

555: update CM_CMPT_MST_TL T set (
556: COST_CMPNTCLS_DESC
557: ) = (select
558: B.COST_CMPNTCLS_DESC
559: from CM_CMPT_MST_TL B
560: where B.COST_CMPNTCLS_ID = T.COST_CMPNTCLS_ID
561: and B.LANGUAGE = T.SOURCE_LANG)
562: where (
563: T.COST_CMPNTCLS_ID,

Line 568: from CM_CMPT_MST_TL SUBB, CM_CMPT_MST_TL SUBT

564: T.LANGUAGE
565: ) in (select
566: SUBT.COST_CMPNTCLS_ID,
567: SUBT.LANGUAGE
568: from CM_CMPT_MST_TL SUBB, CM_CMPT_MST_TL SUBT
569: where SUBB.COST_CMPNTCLS_ID = SUBT.COST_CMPNTCLS_ID
570: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
571: and (SUBB.COST_CMPNTCLS_DESC <> SUBT.COST_CMPNTCLS_DESC
572: ));

Line 574: insert into CM_CMPT_MST_TL (

570: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
571: and (SUBB.COST_CMPNTCLS_DESC <> SUBT.COST_CMPNTCLS_DESC
572: ));
573:
574: insert into CM_CMPT_MST_TL (
575: COST_CMPNTCLS_ID,
576: COST_CMPNTCLS_DESC,
577: CREATION_DATE,
578: CREATED_BY,

Line 594: from CM_CMPT_MST_TL B, FND_LANGUAGES L

590: B.LAST_UPDATED_BY,
591: B.LAST_UPDATE_LOGIN,
592: L.LANGUAGE_CODE,
593: B.SOURCE_LANG
594: from CM_CMPT_MST_TL B, FND_LANGUAGES L
595: where L.INSTALLED_FLAG in ('I', 'B')
596: and B.LANGUAGE = userenv('LANG')
597: and not exists
598: (select NULL

Line 599: from CM_CMPT_MST_TL T

595: where L.INSTALLED_FLAG in ('I', 'B')
596: and B.LANGUAGE = userenv('LANG')
597: and not exists
598: (select NULL
599: from CM_CMPT_MST_TL T
600: where T.COST_CMPNTCLS_ID = B.COST_CMPNTCLS_ID
601: and T.LANGUAGE = L.LANGUAGE_CODE);
602: end ADD_LANGUAGE;
603: