APPS.GMO_DISPENSE_AREA_PKG dependencies on GMO_DISPENSE_AREA_B

Line 18: cursor C is select ROWID from GMO_DISPENSE_AREA_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from GMO_DISPENSE_AREA_B
19: where DISPENSE_AREA_ID = X_DISPENSE_AREA_ID
20: ;
21: begin
22: insert into GMO_DISPENSE_AREA_B (

Line 22: insert into GMO_DISPENSE_AREA_B (

18: cursor C is select ROWID from GMO_DISPENSE_AREA_B
19: where DISPENSE_AREA_ID = X_DISPENSE_AREA_ID
20: ;
21: begin
22: insert into GMO_DISPENSE_AREA_B (
23: DISPENSE_AREA_ID,
24: ORGANIZATION_ID,
25: DISPENSE_AREA_NAME,
26: DEFAULT_AREA_IND,

Line 101: from GMO_DISPENSE_AREA_B

97: DISPENSE_AREA_NAME,
98: DEFAULT_AREA_IND,
99: SUBINVENTORY_CODE,
100: NUMBER_OF_TASKS_PER_DAY
101: from GMO_DISPENSE_AREA_B
102: where DISPENSE_AREA_ID = X_DISPENSE_AREA_ID
103: for update of DISPENSE_AREA_ID nowait;
104: recinfo c%rowtype;
105:

Line 166: update GMO_DISPENSE_AREA_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update GMO_DISPENSE_AREA_B set
167: ORGANIZATION_ID = X_ORGANIZATION_ID,
168: DISPENSE_AREA_NAME = X_DISPENSE_AREA_NAME,
169: DEFAULT_AREA_IND = X_DEFAULT_AREA_IND,
170: SUBINVENTORY_CODE = X_SUBINVENTORY_CODE,

Line 206: delete from GMO_DISPENSE_AREA_B

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: delete from GMO_DISPENSE_AREA_B
207: where DISPENSE_AREA_ID = X_DISPENSE_AREA_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 220: from GMO_DISPENSE_AREA_B B

216: begin
217: delete from GMO_DISPENSE_AREA_TL T
218: where not exists
219: (select NULL
220: from GMO_DISPENSE_AREA_B B
221: where B.DISPENSE_AREA_ID = T.DISPENSE_AREA_ID
222: );
223:
224: update GMO_DISPENSE_AREA_TL T set (