APPS.QP_PRC_CONTEXTS_PKG dependencies on QP_PRC_CONTEXTS_B

Line 36: cursor C is select ROWID from QP_PRC_CONTEXTS_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from QP_PRC_CONTEXTS_B
37: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID
38: ;
39: l_x_rowid VARCHAR2(240); /* file.sql.39 changes */
40: begin

Line 41: insert into QP_PRC_CONTEXTS_B (

37: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID
38: ;
39: l_x_rowid VARCHAR2(240); /* file.sql.39 changes */
40: begin
41: insert into QP_PRC_CONTEXTS_B (
42: ATTRIBUTE7,
43: ATTRIBUTE8,
44: ATTRIBUTE9,
45: ATTRIBUTE10,

Line 192: from QP_PRC_CONTEXTS_B

188: PRC_CONTEXT_TYPE,
189: SEEDED_FLAG,
190: ENABLED_FLAG,
191: CONTEXT
192: from QP_PRC_CONTEXTS_B
193: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID
194: for update of PRC_CONTEXT_ID nowait;
195: recinfo c%rowtype;
196:

Line 309: update QP_PRC_CONTEXTS_B set

305: X_LAST_UPDATED_BY in NUMBER,
306: X_LAST_UPDATE_LOGIN in NUMBER
307: ) is
308: begin
309: update QP_PRC_CONTEXTS_B set
310: ATTRIBUTE7 = X_ATTRIBUTE7,
311: ATTRIBUTE8 = X_ATTRIBUTE8,
312: ATTRIBUTE9 = X_ATTRIBUTE9,
313: ATTRIBUTE10 = X_ATTRIBUTE10,

Line 367: delete from QP_PRC_CONTEXTS_B

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: delete from QP_PRC_CONTEXTS_B
368: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 381: from QP_PRC_CONTEXTS_B B

377: begin
378: delete from QP_PRC_CONTEXTS_TL T
379: where not exists
380: (select NULL
381: from QP_PRC_CONTEXTS_B B
382: where B.PRC_CONTEXT_ID = T.PRC_CONTEXT_ID
383: );
384:
385: update QP_PRC_CONTEXTS_TL T set (