APPS.JTF_RS_TEAMS_PKG dependencies on JTF_RS_TEAMS_B

Line 35: cursor C is select ROWID from JTF_RS_TEAMS_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_TEAMS_B
36: where TEAM_ID = X_TEAM_ID
37: ;
38: begin
39: insert into JTF_RS_TEAMS_B (

Line 39: insert into JTF_RS_TEAMS_B (

35: cursor C is select ROWID from JTF_RS_TEAMS_B
36: where TEAM_ID = X_TEAM_ID
37: ;
38: begin
39: insert into JTF_RS_TEAMS_B (
40: TEAM_ID,
41: TEAM_NUMBER,
42: EMAIL_ADDRESS,
43: EXCLUSIVE_FLAG,

Line 202: update JTF_RS_TEAMS_B set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update JTF_RS_TEAMS_B set
203: TEAM_NUMBER = X_TEAM_NUMBER,
204: EMAIL_ADDRESS = X_EMAIL_ADDRESS,
205: EXCLUSIVE_FLAG = X_EXCLUSIVE_FLAG,
206: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 260: delete from JTF_RS_TEAMS_B

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

Line 274: from JTF_RS_TEAMS_B B

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