APPS.QPR_PRICE_PLANS_PKG dependencies on QPR_PRICE_PLANS_B

Line 29: cursor C is select ROWID from QPR_PRICE_PLANS_B

25: X_LAST_UPDATE_DATE in DATE,
26: X_LAST_UPDATED_BY in NUMBER,
27: X_LAST_UPDATE_LOGIN in NUMBER
28: ) is
29: cursor C is select ROWID from QPR_PRICE_PLANS_B
30: where PRICE_PLAN_ID = X_PRICE_PLAN_ID
31: ;
32: begin
33: insert into QPR_PRICE_PLANS_B (

Line 33: insert into QPR_PRICE_PLANS_B (

29: cursor C is select ROWID from QPR_PRICE_PLANS_B
30: where PRICE_PLAN_ID = X_PRICE_PLAN_ID
31: ;
32: begin
33: insert into QPR_PRICE_PLANS_B (
34: REQUEST_ID,
35: PROGRAM_LOGIN_ID,
36: PRICE_PLAN_ID,
37: INSTANCE_ID,

Line 163: from QPR_PRICE_PLANS_B

159: BASE_UOM_CODE,
160: USE_FOR_DEAL_FLAG,
161: CURRENCY_CODE,
162: AW_XML
163: from QPR_PRICE_PLANS_B
164: where PRICE_PLAN_ID = X_PRICE_PLAN_ID
165: for update of PRICE_PLAN_ID nowait;
166: recinfo c%rowtype;
167:

Line 259: update QPR_PRICE_PLANS_B set

255: X_LAST_UPDATED_BY in NUMBER,
256: X_LAST_UPDATE_LOGIN in NUMBER
257: ) is
258: begin
259: update QPR_PRICE_PLANS_B set
260: REQUEST_ID = X_REQUEST_ID,
261: PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
262: INSTANCE_ID = X_INSTANCE_ID,
263: AW_TYPE_CODE = X_AW_TYPE_CODE,

Line 310: delete from QPR_PRICE_PLANS_B

306: if (sql%notfound) then
307: raise no_data_found;
308: end if;
309:
310: delete from QPR_PRICE_PLANS_B
311: where PRICE_PLAN_ID = X_PRICE_PLAN_ID;
312:
313: if (sql%notfound) then
314: raise no_data_found;

Line 324: from QPR_PRICE_PLANS_B B

320: begin
321: delete from QPR_PRICE_PLANS_TL T
322: where not exists
323: (select NULL
324: from QPR_PRICE_PLANS_B B
325: where B.PRICE_PLAN_ID = T.PRICE_PLAN_ID
326: );
327:
328: update QPR_PRICE_PLANS_TL T set (