APPS.JTF_RS_DYNAMIC_GROUPS_PKG dependencies on JTF_RS_DYNAMIC_GROUPS_B

Line 35: cursor C is select ROWID from JTF_RS_DYNAMIC_GROUPS_B

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

Line 39: insert into JTF_RS_DYNAMIC_GROUPS_B (

35: cursor C is select ROWID from JTF_RS_DYNAMIC_GROUPS_B
36: where GROUP_ID = X_GROUP_ID
37: ;
38: begin
39: insert into JTF_RS_DYNAMIC_GROUPS_B (
40: GROUP_ID,
41: GROUP_NUMBER,
42: USAGE,
43: START_DATE_ACTIVE,

Line 145: from JTF_RS_DYNAMIC_GROUPS_B

141: X_OBJECT_VERSION_NUMBER in NUMBER
142: ) is
143: cursor c is select
144: OBJECT_VERSION_NUMBER
145: from JTF_RS_DYNAMIC_GROUPS_B
146: where GROUP_ID = X_GROUP_ID
147: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
148: for update of GROUP_ID nowait;
149: recinfo c%rowtype;

Line 202: update JTF_RS_DYNAMIC_GROUPS_B set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update JTF_RS_DYNAMIC_GROUPS_B set
203: GROUP_NUMBER = X_GROUP_NUMBER,
204: USAGE = X_USAGE,
205: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
206: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 260: delete from JTF_RS_DYNAMIC_GROUPS_B

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: delete from JTF_RS_DYNAMIC_GROUPS_B
261: where GROUP_ID = X_GROUP_ID;
262:
263: if (sql%notfound) then
264: raise no_data_found;

Line 274: from JTF_RS_DYNAMIC_GROUPS_B B

270: begin
271: delete from JTF_RS_DYNAMIC_GROUPS_TL T
272: where not exists
273: (select NULL
274: from JTF_RS_DYNAMIC_GROUPS_B B
275: where B.GROUP_ID = T.GROUP_ID
276: );
277:
278: update JTF_RS_DYNAMIC_GROUPS_TL T set (