APPS.MTH_EQUIPMENTS_EXT_PKG dependencies on MTH_EQUIPMENTS_EXT_B

Line 122: cursor C is select ROWID from MTH_EQUIPMENTS_EXT_B

118: X_LAST_UPDATE_DATE in DATE,
119: X_LAST_UPDATED_BY in NUMBER,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: cursor C is select ROWID from MTH_EQUIPMENTS_EXT_B
123: where EXTENSION_ID = X_EXTENSION_ID
124: ;
125: begin
126: insert into MTH_EQUIPMENTS_EXT_B (

Line 126: insert into MTH_EQUIPMENTS_EXT_B (

122: cursor C is select ROWID from MTH_EQUIPMENTS_EXT_B
123: where EXTENSION_ID = X_EXTENSION_ID
124: ;
125: begin
126: insert into MTH_EQUIPMENTS_EXT_B (
127: EXTENSION_ID,
128: ATTR_GROUP_ID,
129: EQUIPMENT_PK_KEY,
130: C_EXT_ATTR1,

Line 588: from MTH_EQUIPMENTS_EXT_B

584: SHIFT_WORKDAY_FK_KEY,
585: ITEM_FK_KEY,
586: TRANSIENT,
587: READ_TIME
588: from MTH_EQUIPMENTS_EXT_B
589: where EXTENSION_ID = X_EXTENSION_ID
590: for update of EXTENSION_ID nowait;
591: recinfo c%rowtype;
592:

Line 989: update MTH_EQUIPMENTS_EXT_B set

985: X_LAST_UPDATED_BY in NUMBER,
986: X_LAST_UPDATE_LOGIN in NUMBER
987: ) is
988: begin
989: update MTH_EQUIPMENTS_EXT_B set
990: ATTR_GROUP_ID = X_ATTR_GROUP_ID,
991: EQUIPMENT_PK_KEY = X_EQUIPMENT_PK_KEY,
992: C_EXT_ATTR1 = X_C_EXT_ATTR1,
993: C_EXT_ATTR2 = X_C_EXT_ATTR2,

Line 1131: delete from MTH_EQUIPMENTS_EXT_B

1127: if (sql%notfound) then
1128: raise no_data_found;
1129: end if;
1130:
1131: delete from MTH_EQUIPMENTS_EXT_B
1132: where EXTENSION_ID = X_EXTENSION_ID;
1133:
1134: if (sql%notfound) then
1135: raise no_data_found;

Line 1147: from MTH_EQUIPMENTS_EXT_B B

1143: begin
1144: delete from MTH_EQUIPMENTS_EXT_TL T
1145: where not exists
1146: (select NULL
1147: from MTH_EQUIPMENTS_EXT_B B
1148: where B.EXTENSION_ID = T.EXTENSION_ID
1149: );
1150:
1151: update MTH_EQUIPMENTS_EXT_TL T set (