APPS.JTF_RS_GROUP_MEMBERS_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 1: package body JTF_RS_GROUP_MEMBERS_PKG as

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

Line 32: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS
33: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
34: ;
35: begin
36: insert into JTF_RS_GROUP_MEMBERS (

Line 36: insert into JTF_RS_GROUP_MEMBERS (

32: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS
33: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
34: ;
35: begin
36: insert into JTF_RS_GROUP_MEMBERS (
37: ATTRIBUTE4,
38: ATTRIBUTE5,
39: ATTRIBUTE6,
40: ATTRIBUTE7,

Line 109: from JTF_RS_GROUP_MEMBERS

105: X_OBJECT_VERSION_NUMBER in NUMBER
106: ) is
107: cursor c1 is select
108: OBJECT_VERSION_NUMBER
109: from JTF_RS_GROUP_MEMBERS
110: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID
111: for update of GROUP_MEMBER_ID nowait;
112: tlinfo c1%rowtype ;
113: begin

Line 161: update JTF_RS_GROUP_MEMBERS set

157: X_LAST_UPDATED_BY in NUMBER,
158: X_LAST_UPDATE_LOGIN in NUMBER
159: ) is
160: begin
161: update JTF_RS_GROUP_MEMBERS set
162: ATTRIBUTE4 = X_ATTRIBUTE4,
163: ATTRIBUTE5 = X_ATTRIBUTE5,
164: ATTRIBUTE6 = X_ATTRIBUTE6,
165: ATTRIBUTE7 = X_ATTRIBUTE7,

Line 197: delete from JTF_RS_GROUP_MEMBERS

193: procedure DELETE_ROW (
194: X_GROUP_MEMBER_ID in NUMBER
195: ) is
196: begin
197: delete from JTF_RS_GROUP_MEMBERS
198: where GROUP_MEMBER_ID = X_GROUP_MEMBER_ID;
199:
200: if (sql%notfound) then
201: raise no_data_found;

Line 210: update JTF_RS_GROUP_MEMBERS set

206: procedure LOGICAL_DELETE_ROW (
207: X_GROUP_MEMBER_ID in NUMBER
208: ) is
209: begin
210: update JTF_RS_GROUP_MEMBERS set
211: DELETE_FLAG = 'Y',
212: LAST_UPDATE_DATE = sysdate,
213: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
214: LAST_UPDATE_LOGIN = nvl(fnd_global.login_id,-1)

Line 224: end JTF_RS_GROUP_MEMBERS_PKG;

220:
221: end LOGICAL_DELETE_ROW;
222:
223:
224: end JTF_RS_GROUP_MEMBERS_PKG;