APPS.GMD_ROUTING_CLASS_PKG dependencies on GMD_ROUTING_CLASS_B

Line 17: cursor C is select ROWID from GMD_ROUTING_CLASS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from GMD_ROUTING_CLASS_B
18: where ROUTING_CLASS = X_ROUTING_CLASS
19: ;
20: begin
21: insert into GMD_ROUTING_CLASS_B (

Line 21: insert into GMD_ROUTING_CLASS_B (

17: cursor C is select ROWID from GMD_ROUTING_CLASS_B
18: where ROUTING_CLASS = X_ROUTING_CLASS
19: ;
20: begin
21: insert into GMD_ROUTING_CLASS_B (
22: ROUTING_CLASS,
23: TEXT_CODE,
24: TRANS_CNT,
25: DELETE_MARK,

Line 96: from GMD_ROUTING_CLASS_B

92: TEXT_CODE,
93: TRANS_CNT,
94: DELETE_MARK,
95: ROUTING_CLASS_UOM
96: from GMD_ROUTING_CLASS_B
97: where ROUTING_CLASS = X_ROUTING_CLASS
98: for update of ROUTING_CLASS nowait;
99: recinfo c%rowtype;
100:

Line 157: update GMD_ROUTING_CLASS_B set

153: X_LAST_UPDATED_BY in NUMBER,
154: X_LAST_UPDATE_LOGIN in NUMBER
155: ) is
156: begin
157: update GMD_ROUTING_CLASS_B set
158: TEXT_CODE = X_TEXT_CODE,
159: TRANS_CNT = X_TRANS_CNT,
160: DELETE_MARK = X_DELETE_MARK,
161: ROUTING_CLASS_UOM = X_ROUTING_CLASS_UOM,

Line 190: UPDATE GMD_ROUTING_CLASS_B

186: X_ROUTING_CLASS in VARCHAR2
187: ) is
188: begin
189:
190: UPDATE GMD_ROUTING_CLASS_B
191: SET delete_mark = 1
192: where ROUTING_CLASS = X_ROUTING_CLASS;
193:
194: if (sql%notfound) then

Line 205: from GMD_ROUTING_CLASS_B B

201: begin
202: delete from GMD_ROUTING_CLASS_TL T
203: where not exists
204: (select NULL
205: from GMD_ROUTING_CLASS_B B
206: where B.ROUTING_CLASS = T.ROUTING_CLASS
207: );
208:
209: update GMD_ROUTING_CLASS_TL T set (