APPS.QP_PRICE_FORMULAS_PKG dependencies on QP_PRICE_FORMULAS_B

Line 33: cursor C is select ROWID from QP_PRICE_FORMULAS_B

29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER,
31: X_FORMULA in VARCHAR2
32: ) is
33: cursor C is select ROWID from QP_PRICE_FORMULAS_B
34: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID
35: ;
36: begin
37: insert into QP_PRICE_FORMULAS_B (

Line 37: insert into QP_PRICE_FORMULAS_B (

33: cursor C is select ROWID from QP_PRICE_FORMULAS_B
34: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID
35: ;
36: begin
37: insert into QP_PRICE_FORMULAS_B (
38: ATTRIBUTE15,
39: START_DATE_ACTIVE,
40: END_DATE_ACTIVE,
41: CONTEXT,

Line 175: from QP_PRICE_FORMULAS_B

171: ATTRIBUTE12,
172: ATTRIBUTE10,
173: ATTRIBUTE11,
174: FORMULA
175: from QP_PRICE_FORMULAS_B
176: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID
177: for update of PRICE_FORMULA_ID nowait;
178: recinfo c%rowtype;
179:

Line 285: update QP_PRICE_FORMULAS_B set

281: X_LAST_UPDATE_LOGIN in NUMBER,
282: X_FORMULA in VARCHAR2
283: ) is
284: begin
285: update QP_PRICE_FORMULAS_B set
286: ATTRIBUTE15 = X_ATTRIBUTE15,
287: START_DATE_ACTIVE = X_START_DATE_EFFECTIVE,
288: END_DATE_ACTIVE = X_END_DATE_EFFECTIVE,
289: CONTEXT = X_CONTEXT,

Line 340: delete from QP_PRICE_FORMULAS_B

336: if (sql%notfound) then
337: raise no_data_found;
338: end if;
339:
340: delete from QP_PRICE_FORMULAS_B
341: where PRICE_FORMULA_ID = X_PRICE_FORMULA_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;

Line 354: from QP_PRICE_FORMULAS_B B

350: begin
351: delete from QP_PRICE_FORMULAS_TL T
352: where not exists
353: (select NULL
354: from QP_PRICE_FORMULAS_B B
355: where B.PRICE_FORMULA_ID = T.PRICE_FORMULA_ID
356: );
357:
358: update QP_PRICE_FORMULAS_TL T set (