APPS.MTH_PROD_SCH_EXT_PKG dependencies on MTH_PRODUCTION_SCHEDULES_EXT_B

Line 117: cursor C is select ROWID from MTH_PRODUCTION_SCHEDULES_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_PRODUCTION_SCHEDULES_EXT_B
118: where EXTENSION_ID = X_EXTENSION_ID
119: ;
120: begin
121: insert into MTH_PRODUCTION_SCHEDULES_EXT_B (

Line 121: insert into MTH_PRODUCTION_SCHEDULES_EXT_B (

117: cursor C is select ROWID from MTH_PRODUCTION_SCHEDULES_EXT_B
118: where EXTENSION_ID = X_EXTENSION_ID
119: ;
120: begin
121: insert into MTH_PRODUCTION_SCHEDULES_EXT_B (
122: D_EXT_ATTR4,
123: D_EXT_ATTR5,
124: D_EXT_ATTR6,
125: D_EXT_ATTR7,

Line 559: from MTH_PRODUCTION_SCHEDULES_EXT_B

555: N_EXT_ATTR20,
556: D_EXT_ATTR1,
557: D_EXT_ATTR2,
558: D_EXT_ATTR3
559: from MTH_PRODUCTION_SCHEDULES_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_PRODUCTION_SCHEDULES_EXT_B set

938: X_LAST_UPDATED_BY in NUMBER,
939: X_LAST_UPDATE_LOGIN in NUMBER
940: ) is
941: begin
942: update MTH_PRODUCTION_SCHEDULES_EXT_B set
943: D_EXT_ATTR4 = X_D_EXT_ATTR4,
944: D_EXT_ATTR5 = X_D_EXT_ATTR5,
945: D_EXT_ATTR6 = X_D_EXT_ATTR6,
946: D_EXT_ATTR7 = X_D_EXT_ATTR7,

Line 1078: delete from MTH_PRODUCTION_SCHEDULES_EXT_B

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

Line 1093: from MTH_PRODUCTION_SCHEDULES_EXT_B B

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