APPS.JTF_RS_ROLE_RELATE_AUD_PKG dependencies on JTF_RS_ROLE_RELATE_AUD

Line 1: package body JTF_RS_ROLE_RELATE_AUD_PKG as

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

Line 25: cursor C is select ROWID from JTF_RS_ROLE_RELATE_AUD

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from JTF_RS_ROLE_RELATE_AUD
26: where ROLE_RELATE_AUDIT_ID = X_ROLE_RELATE_AUDIT_ID
27: ;
28: begin
29: insert into JTF_RS_ROLE_RELATE_AUD (

Line 29: insert into JTF_RS_ROLE_RELATE_AUD (

25: cursor C is select ROWID from JTF_RS_ROLE_RELATE_AUD
26: where ROLE_RELATE_AUDIT_ID = X_ROLE_RELATE_AUDIT_ID
27: ;
28: begin
29: insert into JTF_RS_ROLE_RELATE_AUD (
30: ROLE_RELATE_AUDIT_ID,
31: ROLE_RELATE_ID,
32: NEW_ROLE_RESOURCE_TYPE,
33: OLD_ROLE_RESOURCE_TYPE,

Line 110: from JTF_RS_ROLE_RELATE_AUD

106: NEW_END_DATE_ACTIVE,
107: OLD_END_DATE_ACTIVE,
108: NEW_OBJECT_VERSION_NUMBER,
109: OLD_OBJECT_VERSION_NUMBER
110: from JTF_RS_ROLE_RELATE_AUD
111: where ROLE_RELATE_AUDIT_ID = X_ROLE_RELATE_AUDIT_ID
112: for update of ROLE_RELATE_AUDIT_ID nowait;
113: tlinfo c1%rowtype;
114: begin

Line 178: update JTF_RS_ROLE_RELATE_AUD set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update JTF_RS_ROLE_RELATE_AUD set
179: ROLE_RELATE_ID = X_ROLE_RELATE_ID,
180: NEW_ROLE_RESOURCE_TYPE = X_NEW_ROLE_RESOURCE_TYPE,
181: OLD_ROLE_RESOURCE_TYPE = X_OLD_ROLE_RESOURCE_TYPE,
182: NEW_ROLE_RESOURCE_ID = X_NEW_ROLE_RESOURCE_ID,

Line 206: delete from JTF_RS_ROLE_RELATE_AUD

202: procedure DELETE_ROW (
203: X_ROLE_RELATE_AUDIT_ID in NUMBER
204: ) is
205: begin
206: delete from JTF_RS_ROLE_RELATE_AUD
207: where ROLE_RELATE_AUDIT_ID = X_ROLE_RELATE_AUDIT_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 215: end JTF_RS_ROLE_RELATE_AUD_PKG;

211: end if;
212:
213: end DELETE_ROW;
214:
215: end JTF_RS_ROLE_RELATE_AUD_PKG;