APPS.MTH_ITEMS_EXT_PKG dependencies on MTH_ITEMS_EXT_B

Line 117: cursor C is select ROWID from MTH_ITEMS_EXT_B

113: X_LAST_UPDATE_DATE in DATE,
114: X_LAST_UPDATED_BY in NUMBER,
115: X_LAST_UPDATE_LOGIN in NUMBER
116: ) is
117: cursor C is select ROWID from MTH_ITEMS_EXT_B
118: where EXTENSION_ID = X_EXTENSION_ID
119: ;
120: begin
121: insert into MTH_ITEMS_EXT_B (

Line 121: insert into MTH_ITEMS_EXT_B (

117: cursor C is select ROWID from MTH_ITEMS_EXT_B
118: where EXTENSION_ID = X_EXTENSION_ID
119: ;
120: begin
121: insert into MTH_ITEMS_EXT_B (
122: EXTENSION_ID,
123: ATTR_GROUP_ID,
124: ITEM_PK_KEY,
125: C_EXT_ATTR1,

Line 559: from MTH_ITEMS_EXT_B

555: D_EXT_ATTR17,
556: D_EXT_ATTR18,
557: D_EXT_ATTR19,
558: D_EXT_ATTR20
559: from MTH_ITEMS_EXT_B
560: where EXTENSION_ID = X_EXTENSION_ID
561: for update of EXTENSION_ID nowait;
562: recinfo c%rowtype;
563:

Line 942: update MTH_ITEMS_EXT_B set

938: X_LAST_UPDATED_BY in NUMBER,
939: X_LAST_UPDATE_LOGIN in NUMBER
940: ) is
941: begin
942: update MTH_ITEMS_EXT_B set
943: ATTR_GROUP_ID = X_ATTR_GROUP_ID,
944: ITEM_PK_KEY = X_ITEM_PK_KEY,
945: C_EXT_ATTR1 = X_C_EXT_ATTR1,
946: C_EXT_ATTR2 = X_C_EXT_ATTR2,

Line 1078: delete from MTH_ITEMS_EXT_B

1074: if (sql%notfound) then
1075: raise no_data_found;
1076: end if;
1077:
1078: delete from MTH_ITEMS_EXT_B
1079: where EXTENSION_ID = X_EXTENSION_ID;
1080:
1081: if (sql%notfound) then
1082: raise no_data_found;

Line 1094: from MTH_ITEMS_EXT_B B

1090: begin
1091: delete from MTH_ITEMS_EXT_TL T
1092: where not exists
1093: (select NULL
1094: from MTH_ITEMS_EXT_B B
1095: where B.EXTENSION_ID = T.EXTENSION_ID
1096: );
1097:
1098: update MTH_ITEMS_EXT_TL T set (