APPS.SO_PRICING_RULES_PKG dependencies on SO_PRICING_RULES_B

Line 33: cursor C is select ROWID from SO_PRICING_RULES_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 SO_PRICING_RULES_B
34: where PRICING_RULE_ID = X_PRICING_RULE_ID
35: ;
36: begin
37: insert into SO_PRICING_RULES_B (

Line 37: insert into SO_PRICING_RULES_B (

33: cursor C is select ROWID from SO_PRICING_RULES_B
34: where PRICING_RULE_ID = X_PRICING_RULE_ID
35: ;
36: begin
37: insert into SO_PRICING_RULES_B (
38: PRICING_RULE_ID,
39: FORMULA,
40: START_DATE_ACTIVE,
41: END_DATE_ACTIVE,

Line 175: from SO_PRICING_RULES_B

171: ATTRIBUTE12,
172: ATTRIBUTE13,
173: ATTRIBUTE14,
174: ATTRIBUTE15
175: from SO_PRICING_RULES_B
176: where PRICING_RULE_ID = X_PRICING_RULE_ID
177: for update of PRICING_RULE_ID nowait;
178: recinfo c%rowtype;
179:

Line 285: update SO_PRICING_RULES_B set

281: X_LAST_UPDATED_BY in NUMBER,
282: X_LAST_UPDATE_LOGIN in NUMBER
283: ) is
284: begin
285: update SO_PRICING_RULES_B set
286: FORMULA = X_FORMULA,
287: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
288: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
289: CONTEXT = X_CONTEXT,

Line 340: delete from SO_PRICING_RULES_B

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

Line 354: from SO_PRICING_RULES_B B

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