APPS.GML_OP_ORDR_TYP_PKG dependencies on OP_ORDR_TYP_B

Line 33: cursor C is select ROWID from OP_ORDR_TYP_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from OP_ORDR_TYP_B
34: where ORDER_TYPE = X_ORDER_TYPE
35: ;
36: begin
37: insert into OP_ORDR_TYP_B (

Line 37: insert into OP_ORDR_TYP_B (

33: cursor C is select ROWID from OP_ORDR_TYP_B
34: where ORDER_TYPE = X_ORDER_TYPE
35: ;
36: begin
37: insert into OP_ORDR_TYP_B (
38: ORDER_TYPE,
39: ORDER_TYPE_CODE,
40: LANG_CODE,
41: INVEN_TRANS_TYPE,

Line 177: from OP_ORDR_TYP_B

173: ORDER_LEADTIME,
174: TRANS_CNT,
175: TEXT_CODE,
176: DELETE_MARK
177: from OP_ORDR_TYP_B
178: where ORDER_TYPE = X_ORDER_TYPE
179: for update of ORDER_TYPE nowait;
180: recinfo c%rowtype;
181:

Line 268: update OP_ORDR_TYP_B set

264: X_LAST_UPDATED_BY in NUMBER,
265: X_LAST_UPDATE_LOGIN in NUMBER
266: ) is
267: begin
268: update OP_ORDR_TYP_B set
269: LANG_CODE = X_LANG_CODE,
270: INVEN_TRANS_TYPE = X_INVEN_TRANS_TYPE,
271: SHIPMENT_IND = X_SHIPMENT_IND,
272: INVOICE_IND = X_INVOICE_IND,

Line 323: delete from OP_ORDR_TYP_B

319: if (sql%notfound) then
320: raise no_data_found;
321: end if;
322:
323: delete from OP_ORDR_TYP_B
324: where ORDER_TYPE = X_ORDER_TYPE;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 337: from OP_ORDR_TYP_B B

333: begin
334: delete from OP_ORDR_TYP_TL T
335: where not exists
336: (select NULL
337: from OP_ORDR_TYP_B B
338: where B.ORDER_TYPE = T.ORDER_TYPE
339: );
340:
341: update OP_ORDR_TYP_TL T set (