APPS.PRP_TEMPLATES_PKG dependencies on PRP_TEMPLATES_B

Line 34: cursor C is select ROWID from PRP_TEMPLATES_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_TEMPLATES_B
35: where TEMPLATE_ID = X_TEMPLATE_ID
36: ;
37: begin
38: insert into PRP_TEMPLATES_B (

Line 38: insert into PRP_TEMPLATES_B (

34: cursor C is select ROWID from PRP_TEMPLATES_B
35: where TEMPLATE_ID = X_TEMPLATE_ID
36: ;
37: begin
38: insert into PRP_TEMPLATES_B (
39: ATTRIBUTE12,
40: ATTRIBUTE13,
41: ATTRIBUTE14,
42: ATTRIBUTE15,

Line 180: from PRP_TEMPLATES_B

176: OBJECT_VERSION_NUMBER,
177: TEMPLATE_CODE,
178: ATTRIBUTE7,
179: ATTRIBUTE8
180: from PRP_TEMPLATES_B
181: where TEMPLATE_ID = X_TEMPLATE_ID
182: for update of TEMPLATE_ID nowait;
183: recinfo c%rowtype;
184:

Line 291: update PRP_TEMPLATES_B set

287: X_LAST_UPDATED_BY in NUMBER,
288: X_LAST_UPDATE_LOGIN in NUMBER
289: ) is
290: begin
291: update PRP_TEMPLATES_B set
292: ATTRIBUTE12 = X_ATTRIBUTE12,
293: ATTRIBUTE13 = X_ATTRIBUTE13,
294: ATTRIBUTE14 = X_ATTRIBUTE14,
295: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 347: delete from PRP_TEMPLATES_B

343: if (sql%notfound) then
344: raise no_data_found;
345: end if;
346:
347: delete from PRP_TEMPLATES_B
348: where TEMPLATE_ID = X_TEMPLATE_ID;
349:
350: if (sql%notfound) then
351: raise no_data_found;

Line 361: from PRP_TEMPLATES_B B

357: begin
358: delete from PRP_TEMPLATES_TL T
359: where not exists
360: (select NULL
361: from PRP_TEMPLATES_B B
362: where B.TEMPLATE_ID = T.TEMPLATE_ID
363: );
364:
365: update PRP_TEMPLATES_TL T set (