APPS.PRP_COMPONENT_STYLES_PKG dependencies on PRP_COMPONENT_STYLES_B

Line 34: cursor C is select ROWID from PRP_COMPONENT_STYLES_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from PRP_COMPONENT_STYLES_B
35: where COMPONENT_STYLE_ID = X_COMPONENT_STYLE_ID
36: ;
37: begin
38: insert into PRP_COMPONENT_STYLES_B (

Line 38: insert into PRP_COMPONENT_STYLES_B (

34: cursor C is select ROWID from PRP_COMPONENT_STYLES_B
35: where COMPONENT_STYLE_ID = X_COMPONENT_STYLE_ID
36: ;
37: begin
38: insert into PRP_COMPONENT_STYLES_B (
39: ATTRIBUTE_CATEGORY,
40: ATTRIBUTE1,
41: ATTRIBUTE2,
42: ATTRIBUTE3,

Line 181: from PRP_COMPONENT_STYLES_B

177: COMPONENT_ID,
178: -- COMPONENT_STYLE_CODE
179: CONTENT_NODE_TYPE,
180: CONTENT_ITEM_ID
181: from PRP_COMPONENT_STYLES_B
182: where COMPONENT_STYLE_ID = X_COMPONENT_STYLE_ID
183: for update of COMPONENT_STYLE_ID nowait;
184: recinfo c%rowtype;
185:

Line 293: update PRP_COMPONENT_STYLES_B set

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER
291: ) is
292: begin
293: update PRP_COMPONENT_STYLES_B set
294: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
295: ATTRIBUTE1 = X_ATTRIBUTE1,
296: ATTRIBUTE2 = X_ATTRIBUTE2,
297: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 349: delete from PRP_COMPONENT_STYLES_B

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: delete from PRP_COMPONENT_STYLES_B
350: where COMPONENT_STYLE_ID = X_COMPONENT_STYLE_ID;
351:
352: if (sql%notfound) then
353: raise no_data_found;

Line 363: from PRP_COMPONENT_STYLES_B B

359: begin
360: delete from PRP_COMPONENT_STYLES_TL T
361: where not exists
362: (select NULL
363: from PRP_COMPONENT_STYLES_B B
364: where B.COMPONENT_STYLE_ID = T.COMPONENT_STYLE_ID
365: );
366:
367: update PRP_COMPONENT_STYLES_TL T set (