APPS.MTH_OTHERS_EXT_PKG dependencies on MTH_OTHERS_EXT_B

Line 116: cursor C is select ROWID from MTH_OTHERS_EXT_B

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

Line 120: insert into MTH_OTHERS_EXT_B (

116: cursor C is select ROWID from MTH_OTHERS_EXT_B
117: where EXTENSION_ID = X_EXTENSION_ID
118: ;
119: begin
120: insert into MTH_OTHERS_EXT_B (
121: D_EXT_ATTR7,
122: D_EXT_ATTR8,
123: D_EXT_ATTR9,
124: D_EXT_ATTR10,

Line 558: from MTH_OTHERS_EXT_B

554: D_EXT_ATTR3,
555: D_EXT_ATTR4,
556: D_EXT_ATTR5,
557: D_EXT_ATTR6
558: from MTH_OTHERS_EXT_B
559: where EXTENSION_ID = X_EXTENSION_ID
560: for update of EXTENSION_ID nowait;
561: recinfo c%rowtype;
562:

Line 941: update MTH_OTHERS_EXT_B set

937: X_LAST_UPDATED_BY in NUMBER,
938: X_LAST_UPDATE_LOGIN in NUMBER
939: ) is
940: begin
941: update MTH_OTHERS_EXT_B set
942: D_EXT_ATTR7 = X_D_EXT_ATTR7,
943: D_EXT_ATTR8 = X_D_EXT_ATTR8,
944: D_EXT_ATTR9 = X_D_EXT_ATTR9,
945: D_EXT_ATTR10 = X_D_EXT_ATTR10,

Line 1077: delete from MTH_OTHERS_EXT_B

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

Line 1093: from MTH_OTHERS_EXT_B B

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