APPS.CM_CMPT_MST_PKG dependencies on CM_CMPT_MST_B

Line 55: cursor C is select ROWID from CM_CMPT_MST_B

51: X_LAST_UPDATE_DATE in DATE,
52: X_LAST_UPDATED_BY in NUMBER,
53: X_LAST_UPDATE_LOGIN in NUMBER
54: ) is
55: cursor C is select ROWID from CM_CMPT_MST_B
56: where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID
57: ;
58: begin
59: insert into CM_CMPT_MST_B (

Line 59: insert into CM_CMPT_MST_B (

55: cursor C is select ROWID from CM_CMPT_MST_B
56: where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID
57: ;
58: begin
59: insert into CM_CMPT_MST_B (
60: COST_CMPNTCLS_ID,
61: COST_CMPNTCLS_CODE,
62: SORT_SEQUENCE,
63: USAGE_IND,

Line 286: from CM_CMPT_MST_B

282: ATTRIBUTE28,
283: ATTRIBUTE29,
284: ATTRIBUTE30,
285: ATTRIBUTE_CATEGORY
286: from CM_CMPT_MST_B
287: where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID
288: for update of COST_CMPNTCLS_ID nowait;
289: recinfo c%rowtype;
290:

Line 454: update CM_CMPT_MST_B set

450: X_LAST_UPDATED_BY in NUMBER,
451: X_LAST_UPDATE_LOGIN in NUMBER
452: ) is
453: begin
454: update CM_CMPT_MST_B set
455: COST_CMPNTCLS_CODE = X_COST_CMPNTCLS_CODE,
456: SORT_SEQUENCE = X_SORT_SEQUENCE,
457: USAGE_IND = X_USAGE_IND,
458: PRIMARY_CMPNTCLS_ID = X_PRIMARY_CMPNTCLS_ID,

Line 532: * delete from CM_CMPT_MST_B

528: * if (sql%notfound) then
529: * raise no_data_found;
530: * end if;
531: *
532: * delete from CM_CMPT_MST_B
533: * where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID;
534: */
535:
536: update CM_CMPT_MST_B

Line 536: update CM_CMPT_MST_B

532: * delete from CM_CMPT_MST_B
533: * where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID;
534: */
535:
536: update CM_CMPT_MST_B
537: set DELETE_MARK = 1
538: where COST_CMPNTCLS_ID = X_COST_CMPNTCLS_ID;
539:
540: if (sql%notfound) then

Line 551: from CM_CMPT_MST_B B

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
553: );
554:
555: update CM_CMPT_MST_TL T set (