APPS.PRP_COMPONENTS_PKG dependencies on PRP_COMPONENTS_B

Line 32: cursor C is select ROWID from PRP_COMPONENTS_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from PRP_COMPONENTS_B
33: where COMPONENT_ID = X_COMPONENT_ID
34: ;
35: begin
36: insert into PRP_COMPONENTS_B (

Line 36: insert into PRP_COMPONENTS_B (

32: cursor C is select ROWID from PRP_COMPONENTS_B
33: where COMPONENT_ID = X_COMPONENT_ID
34: ;
35: begin
36: insert into PRP_COMPONENTS_B (
37: COMPONENT_ID,
38: OBJECT_VERSION_NUMBER,
39: COMPONENT_CODE,
40: ATTRIBUTE_CATEGORY,

Line 170: from PRP_COMPONENTS_B

166: ATTRIBUTE12,
167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: from PRP_COMPONENTS_B
171: where COMPONENT_ID = X_COMPONENT_ID
172: for update of COMPONENT_ID nowait;
173: recinfo c%rowtype;
174:

Line 276: update PRP_COMPONENTS_B set

272: X_LAST_UPDATED_BY in NUMBER,
273: X_LAST_UPDATE_LOGIN in NUMBER
274: ) is
275: begin
276: update PRP_COMPONENTS_B set
277: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
278: COMPONENT_CODE = X_COMPONENT_CODE,
279: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
280: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 330: delete from PRP_COMPONENTS_B

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: delete from PRP_COMPONENTS_B
331: where COMPONENT_ID = X_COMPONENT_ID;
332:
333: if (sql%notfound) then
334: raise no_data_found;

Line 344: from PRP_COMPONENTS_B B

340: begin
341: delete from PRP_COMPONENTS_TL T
342: where not exists
343: (select NULL
344: from PRP_COMPONENTS_B B
345: where B.COMPONENT_ID = T.COMPONENT_ID
346: );
347:
348: update PRP_COMPONENTS_TL T set (