APPS.GMD_OPERATION_CLASS_PKG dependencies on GMD_OPERATION_CLASS_B

Line 16: cursor C is select ROWID from GMD_OPERATION_CLASS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from GMD_OPERATION_CLASS_B
17: where OPRN_CLASS = X_OPRN_CLASS
18: ;
19: begin
20: insert into GMD_OPERATION_CLASS_B (

Line 20: insert into GMD_OPERATION_CLASS_B (

16: cursor C is select ROWID from GMD_OPERATION_CLASS_B
17: where OPRN_CLASS = X_OPRN_CLASS
18: ;
19: begin
20: insert into GMD_OPERATION_CLASS_B (
21: OPRN_CLASS,
22: TRANS_CNT,
23: DELETE_MARK,
24: TEXT_CODE,

Line 91: from GMD_OPERATION_CLASS_B

87: cursor c is select
88: TRANS_CNT,
89: DELETE_MARK,
90: TEXT_CODE
91: from GMD_OPERATION_CLASS_B
92: where OPRN_CLASS = X_OPRN_CLASS
93: for update of OPRN_CLASS nowait;
94: recinfo c%rowtype;
95:

Line 149: update GMD_OPERATION_CLASS_B set

145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update GMD_OPERATION_CLASS_B set
150: TRANS_CNT = X_TRANS_CNT,
151: DELETE_MARK = X_DELETE_MARK,
152: TEXT_CODE = X_TEXT_CODE,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 181: UPDATE GMD_OPERATION_CLASS_B

177: X_OPRN_CLASS in VARCHAR2
178: ) is
179: begin
180:
181: UPDATE GMD_OPERATION_CLASS_B
182: SET delete_mark = 1
183: where OPRN_CLASS = X_OPRN_CLASS;
184:
185: if (sql%notfound) then

Line 196: from GMD_OPERATION_CLASS_B B

192: begin
193: delete from GMD_OPERATION_CLASS_TL T
194: where not exists
195: (select NULL
196: from GMD_OPERATION_CLASS_B B
197: where B.OPRN_CLASS = T.OPRN_CLASS
198: );
199:
200: update GMD_OPERATION_CLASS_TL T set (