APPS.JTF_RS_GROUP_MEMBERS_AUD_PKG dependencies on JTF_RS_GROUP_MEMBERS_AUD

Line 1: package body JTF_RS_GROUP_MEMBERS_AUD_PKG as

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

Line 21: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS_AUD

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS_AUD
22: where GROUP_MEMBER_AUDIT_ID = X_GROUP_MEMBER_AUDIT_ID
23: ;
24: begin
25: insert into JTF_RS_GROUP_MEMBERS_AUD (

Line 25: insert into JTF_RS_GROUP_MEMBERS_AUD (

21: cursor C is select ROWID from JTF_RS_GROUP_MEMBERS_AUD
22: where GROUP_MEMBER_AUDIT_ID = X_GROUP_MEMBER_AUDIT_ID
23: ;
24: begin
25: insert into JTF_RS_GROUP_MEMBERS_AUD (
26: GROUP_MEMBER_AUDIT_ID,
27: GROUP_MEMBER_ID,
28: NEW_GROUP_ID,
29: OLD_GROUP_ID,

Line 90: from JTF_RS_GROUP_MEMBERS_AUD

86: NEW_PERSON_ID,
87: OLD_PERSON_ID,
88: NEW_OBJECT_VERSION_NUMBER,
89: OLD_OBJECT_VERSION_NUMBER
90: from JTF_RS_GROUP_MEMBERS_AUD
91: where GROUP_MEMBER_AUDIT_ID = X_GROUP_MEMBER_AUDIT_ID
92: for update of GROUP_MEMBER_AUDIT_ID nowait;
93: tlinfo c1%rowtype;
94: begin

Line 146: update JTF_RS_GROUP_MEMBERS_AUD set

142: X_LAST_UPDATED_BY in NUMBER,
143: X_LAST_UPDATE_LOGIN in NUMBER
144: ) is
145: begin
146: update JTF_RS_GROUP_MEMBERS_AUD set
147: GROUP_MEMBER_ID = X_GROUP_MEMBER_ID,
148: NEW_GROUP_ID = X_NEW_GROUP_ID,
149: OLD_GROUP_ID = X_OLD_GROUP_ID,
150: NEW_RESOURCE_ID = X_NEW_RESOURCE_ID,

Line 170: delete from JTF_RS_GROUP_MEMBERS_AUD

166: procedure DELETE_ROW (
167: X_GROUP_MEMBER_AUDIT_ID in NUMBER
168: ) is
169: begin
170: delete from JTF_RS_GROUP_MEMBERS_AUD
171: where GROUP_MEMBER_AUDIT_ID = X_GROUP_MEMBER_AUDIT_ID;
172:
173: if (sql%notfound) then
174: raise no_data_found;

Line 179: end JTF_RS_GROUP_MEMBERS_AUD_PKG;

175: end if;
176:
177: end DELETE_ROW;
178:
179: end JTF_RS_GROUP_MEMBERS_AUD_PKG;