APPS.MTH_PROD_SEGMENTS_EXT_PKG dependencies on MTH_PRODUCTION_SEGMENTS_EXT_B

Line 120: cursor C is select ROWID from MTH_PRODUCTION_SEGMENTS_EXT_B

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

Line 124: insert into MTH_PRODUCTION_SEGMENTS_EXT_B (

120: cursor C is select ROWID from MTH_PRODUCTION_SEGMENTS_EXT_B
121: where EXTENSION_ID = X_EXTENSION_ID
122: ;
123: begin
124: insert into MTH_PRODUCTION_SEGMENTS_EXT_B (
125: EXTENSION_ID,
126: ATTR_GROUP_ID,
127: SEGMENT_PK_KEY,
128: C_EXT_ATTR1,

Line 578: from MTH_PRODUCTION_SEGMENTS_EXT_B

574: WORKORDER_FK_KEY,
575: ITEM_FK_KEY,
576: TRANSIENT,
577: READ_TIME
578: from MTH_PRODUCTION_SEGMENTS_EXT_B
579: where EXTENSION_ID = X_EXTENSION_ID
580: for update of EXTENSION_ID nowait;
581: recinfo c%rowtype;
582:

Line 973: update MTH_PRODUCTION_SEGMENTS_EXT_B set

969: X_LAST_UPDATED_BY in NUMBER,
970: X_LAST_UPDATE_LOGIN in NUMBER
971: ) is
972: begin
973: update MTH_PRODUCTION_SEGMENTS_EXT_B set
974: ATTR_GROUP_ID = X_ATTR_GROUP_ID,
975: SEGMENT_PK_KEY = X_SEGMENT_PK_KEY,
976: C_EXT_ATTR1 = X_C_EXT_ATTR1,
977: C_EXT_ATTR2 = X_C_EXT_ATTR2,

Line 1113: delete from MTH_PRODUCTION_SEGMENTS_EXT_B

1109: if (sql%notfound) then
1110: raise no_data_found;
1111: end if;
1112:
1113: delete from MTH_PRODUCTION_SEGMENTS_EXT_B
1114: where EXTENSION_ID = X_EXTENSION_ID;
1115:
1116: if (sql%notfound) then
1117: raise no_data_found;

Line 1129: from MTH_PRODUCTION_SEGMENTS_EXT_B B

1125: begin
1126: delete from MTH_PRODUCTION_SEGMENTS_EXT_TL T
1127: where not exists
1128: (select NULL
1129: from MTH_PRODUCTION_SEGMENTS_EXT_B B
1130: where B.EXTENSION_ID = T.EXTENSION_ID
1131: );
1132:
1133: update MTH_PRODUCTION_SEGMENTS_EXT_TL T set (