APPS.JTF_RS_TEAM_MEMBERS_PKG dependencies on JTF_RS_TEAM_MEMBERS

Line 1: package body JTF_RS_TEAM_MEMBERS_PKG as

1: package body JTF_RS_TEAM_MEMBERS_PKG as
2: /* $Header: jtfrstbb.pls 120.0 2005/05/11 08:22:05 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_TEAM_MEMBER_ID in NUMBER,

Line 33: cursor C is select ROWID from JTF_RS_TEAM_MEMBERS

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from JTF_RS_TEAM_MEMBERS
34: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID
35: ;
36: begin
37: insert into JTF_RS_TEAM_MEMBERS (

Line 37: insert into JTF_RS_TEAM_MEMBERS (

33: cursor C is select ROWID from JTF_RS_TEAM_MEMBERS
34: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID
35: ;
36: begin
37: insert into JTF_RS_TEAM_MEMBERS (
38: TEAM_MEMBER_ID,
39: TEAM_ID,
40: TEAM_RESOURCE_ID,
41: PERSON_ID,

Line 112: from JTF_RS_TEAM_MEMBERS

108: X_OBJECT_VERSION_NUMBER in NUMBER
109: ) is
110: cursor c1 is select
111: OBJECT_VERSION_NUMBER
112: from JTF_RS_TEAM_MEMBERS
113: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID
114: for update of TEAM_MEMBER_ID nowait;
115: tlinfo c1%rowtype ;
116: begin

Line 165: update JTF_RS_TEAM_MEMBERS set

161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: begin
165: update JTF_RS_TEAM_MEMBERS set
166: TEAM_ID = X_TEAM_ID,
167: TEAM_RESOURCE_ID = X_TEAM_RESOURCE_ID,
168: PERSON_ID = X_PERSON_ID,
169: RESOURCE_TYPE = X_RESOURCE_TYPE,

Line 202: delete from JTF_RS_TEAM_MEMBERS

198: procedure DELETE_ROW (
199: X_TEAM_MEMBER_ID in NUMBER
200: ) is
201: begin
202: delete from JTF_RS_TEAM_MEMBERS
203: where TEAM_MEMBER_ID = X_TEAM_MEMBER_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 215: update JTF_RS_TEAM_MEMBERS set

211: procedure LOGICAL_DELETE_ROW (
212: X_TEAM_MEMBER_ID in NUMBER
213: ) is
214: begin
215: update JTF_RS_TEAM_MEMBERS set
216: DELETE_FLAG = 'Y',
217: LAST_UPDATE_DATE = sysdate,
218: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
219: LAST_UPDATE_LOGIN = nvl(fnd_global.login_id,-1)

Line 229: end JTF_RS_TEAM_MEMBERS_PKG;

225:
226: end LOGICAL_DELETE_ROW;
227:
228:
229: end JTF_RS_TEAM_MEMBERS_PKG;