DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PKG dependencies on JTF_RS_GROUPS_B

Line 37: cursor C is select ROWID from JTF_RS_GROUPS_B

33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER,
35: X_TIME_ZONE in NUMBER
36: ) is
37: cursor C is select ROWID from JTF_RS_GROUPS_B
38: where GROUP_ID = X_GROUP_ID
39: ;
40: begin
41: insert into JTF_RS_GROUPS_B (

Line 41: insert into JTF_RS_GROUPS_B (

37: cursor C is select ROWID from JTF_RS_GROUPS_B
38: where GROUP_ID = X_GROUP_ID
39: ;
40: begin
41: insert into JTF_RS_GROUPS_B (
42: ATTRIBUTE1,
43: ATTRIBUTE2,
44: ATTRIBUTE3,
45: ATTRIBUTE4,

Line 210: update JTF_RS_GROUPS_B set

206: X_LAST_UPDATE_LOGIN in NUMBER,
207: X_TIME_ZONE in NUMBER
208: ) is
209: begin
210: update JTF_RS_GROUPS_B set
211: ATTRIBUTE1 = X_ATTRIBUTE1,
212: ATTRIBUTE2 = X_ATTRIBUTE2,
213: ATTRIBUTE3 = X_ATTRIBUTE3,
214: ATTRIBUTE4 = X_ATTRIBUTE4,

Line 270: delete from JTF_RS_GROUPS_B

266: if (sql%notfound) then
267: raise no_data_found;
268: end if;
269:
270: delete from JTF_RS_GROUPS_B
271: where GROUP_ID = X_GROUP_ID;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 284: from JTF_RS_GROUPS_B B

280: begin
281: delete from JTF_RS_GROUPS_TL T
282: where not exists
283: (select NULL
284: from JTF_RS_GROUPS_B B
285: where B.GROUP_ID = T.GROUP_ID
286: );
287:
288: update JTF_RS_GROUPS_TL T set (