APPS.PRP_GROUPS_PKG dependencies on PRP_GROUPS_B

Line 31: cursor C is select ROWID from PRP_GROUPS_B

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from PRP_GROUPS_B
32: where GROUP_ID = X_GROUP_ID
33: ;
34: begin
35: insert into PRP_GROUPS_B (

Line 35: insert into PRP_GROUPS_B (

31: cursor C is select ROWID from PRP_GROUPS_B
32: where GROUP_ID = X_GROUP_ID
33: ;
34: begin
35: insert into PRP_GROUPS_B (
36: GROUP_ID,
37: OBJECT_VERSION_NUMBER,
38: ATTRIBUTE_CATEGORY,
39: ATTRIBUTE1,

Line 165: from PRP_GROUPS_B

161: ATTRIBUTE12,
162: ATTRIBUTE13,
163: ATTRIBUTE14,
164: ATTRIBUTE15
165: from PRP_GROUPS_B
166: where GROUP_ID = X_GROUP_ID
167: for update of GROUP_ID nowait;
168: recinfo c%rowtype;
169:

Line 269: update PRP_GROUPS_B set

265: X_LAST_UPDATED_BY in NUMBER,
266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: update PRP_GROUPS_B set
270: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
271: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
272: ATTRIBUTE1 = X_ATTRIBUTE1,
273: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 322: delete from PRP_GROUPS_B

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: delete from PRP_GROUPS_B
323: where GROUP_ID = X_GROUP_ID;
324:
325: if (sql%notfound) then
326: raise no_data_found;

Line 336: from PRP_GROUPS_B B

332: begin
333: delete from PRP_GROUPS_TL T
334: where not exists
335: (select NULL
336: from PRP_GROUPS_B B
337: where B.GROUP_ID = T.GROUP_ID
338: );
339:
340: update PRP_GROUPS_TL T set (