DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PKG dependencies on JTF_RS_GROUPS_B

Line 36: cursor C is select ROWID from JTF_RS_GROUPS_B

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

Line 40: insert into JTF_RS_GROUPS_B (

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

Line 206: update JTF_RS_GROUPS_B set

202: X_LAST_UPDATED_BY in NUMBER,
203: X_LAST_UPDATE_LOGIN in NUMBER
204: ) is
205: begin
206: update JTF_RS_GROUPS_B set
207: ATTRIBUTE1 = X_ATTRIBUTE1,
208: ATTRIBUTE2 = X_ATTRIBUTE2,
209: ATTRIBUTE3 = X_ATTRIBUTE3,
210: ATTRIBUTE4 = X_ATTRIBUTE4,

Line 265: delete from JTF_RS_GROUPS_B

261: if (sql%notfound) then
262: raise no_data_found;
263: end if;
264:
265: delete from JTF_RS_GROUPS_B
266: where GROUP_ID = X_GROUP_ID;
267:
268: if (sql%notfound) then
269: raise no_data_found;

Line 279: from JTF_RS_GROUPS_B B

275: begin
276: delete from JTF_RS_GROUPS_TL T
277: where not exists
278: (select NULL
279: from JTF_RS_GROUPS_B B
280: where B.GROUP_ID = T.GROUP_ID
281: );
282:
283: update JTF_RS_GROUPS_TL T set (