APPS.JTF_RS_ROLE_RELATIONS_PKG dependencies on JTF_RS_ROLE_RELATIONS

Line 1: package body JTF_RS_ROLE_RELATIONS_PKG as

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

Line 34: cursor C is select ROWID from JTF_RS_ROLE_RELATIONS

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from JTF_RS_ROLE_RELATIONS
35: where ROLE_RELATE_ID = X_ROLE_RELATE_ID
36: ;
37: begin
38: insert into JTF_RS_ROLE_RELATIONS (

Line 38: insert into JTF_RS_ROLE_RELATIONS (

34: cursor C is select ROWID from JTF_RS_ROLE_RELATIONS
35: where ROLE_RELATE_ID = X_ROLE_RELATE_ID
36: ;
37: begin
38: insert into JTF_RS_ROLE_RELATIONS (
39: ATTRIBUTE9,
40: ATTRIBUTE10,
41: ATTRIBUTE11,
42: ATTRIBUTE12,

Line 115: from JTF_RS_ROLE_RELATIONS

111: X_OBJECT_VERSION_NUMBER in NUMBER
112: ) is
113: cursor c1 is select
114: OBJECT_VERSION_NUMBER
115: from JTF_RS_ROLE_RELATIONS
116: where ROLE_RELATE_ID = X_ROLE_RELATE_ID
117: for update of ROLE_RELATE_ID nowait;
118: tlinfo c1%rowtype ;
119: begin

Line 169: update JTF_RS_ROLE_RELATIONS set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update JTF_RS_ROLE_RELATIONS set
170: ATTRIBUTE9 = X_ATTRIBUTE9,
171: ATTRIBUTE10 = X_ATTRIBUTE10,
172: ATTRIBUTE11 = X_ATTRIBUTE11,
173: ATTRIBUTE12 = X_ATTRIBUTE12,

Line 207: delete from JTF_RS_ROLE_RELATIONS

203: procedure DELETE_ROW (
204: X_ROLE_RELATE_ID in NUMBER
205: ) is
206: begin
207: delete from JTF_RS_ROLE_RELATIONS
208: where ROLE_RELATE_ID = X_ROLE_RELATE_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 220: update JTF_RS_ROLE_RELATIONS set

216: procedure LOGICAL_DELETE_ROW (
217: X_ROLE_RELATE_ID in NUMBER
218: ) is
219: begin
220: update JTF_RS_ROLE_RELATIONS set
221: DELETE_FLAG = 'Y'
222: where ROLE_RELATE_ID = X_ROLE_RELATE_ID;
223:
224: if (sql%notfound) then

Line 231: end JTF_RS_ROLE_RELATIONS_PKG;

227:
228: end LOGICAL_DELETE_ROW;
229:
230:
231: end JTF_RS_ROLE_RELATIONS_PKG;