APPS.GMD_FORMULA_CLASS_PKG dependencies on GMD_FORMULA_CLASS_B

Line 16: cursor C is select ROWID from GMD_FORMULA_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_FORMULA_CLASS_B
17: where FORMULA_CLASS = X_FORMULA_CLASS
18: ;
19: begin
20: insert into GMD_FORMULA_CLASS_B (

Line 20: insert into GMD_FORMULA_CLASS_B (

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

Line 91: from GMD_FORMULA_CLASS_B

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

Line 149: update GMD_FORMULA_CLASS_B set

145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update GMD_FORMULA_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: /* delete from GMD_FORMULA_CLASS_B

177: X_FORMULA_CLASS in VARCHAR2
178: ) is
179: begin
180:
181: /* delete from GMD_FORMULA_CLASS_B
182: where FORMULA_CLASS = X_FORMULA_CLASS;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 189: update GMD_FORMULA_CLASS_B

185: raise no_data_found;
186: end if;
187: */
188:
189: update GMD_FORMULA_CLASS_B
190: set delete_mark = 1
191: where FORMULA_CLASS = X_FORMULA_CLASS;
192:
193: if (sql%notfound) then

Line 204: from GMD_FORMULA_CLASS_B B

200: begin
201: delete from GMD_FORMULA_CLASS_TL T
202: where not exists
203: (select NULL
204: from GMD_FORMULA_CLASS_B B
205: where B.FORMULA_CLASS = T.FORMULA_CLASS
206: );
207:
208: update GMD_FORMULA_CLASS_TL T set (