APPS.JTF_RS_ROLES_PKG dependencies on JTF_RS_ROLES_B

Line 38: cursor C is select ROWID from JTF_RS_ROLES_B

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from JTF_RS_ROLES_B
39: where ROLE_ID = X_ROLE_ID
40: ;
41: begin
42: insert into JTF_RS_ROLES_B (

Line 42: insert into JTF_RS_ROLES_B (

38: cursor C is select ROWID from JTF_RS_ROLES_B
39: where ROLE_ID = X_ROLE_ID
40: ;
41: begin
42: insert into JTF_RS_ROLES_B (
43: ATTRIBUTE3,
44: ATTRIBUTE4,
45: ATTRIBUTE5,
46: ATTRIBUTE6,

Line 154: from JTF_RS_ROLES_B

150: X_OBJECT_VERSION_NUMBER in NUMBER
151: ) is
152: cursor c is select
153: OBJECT_VERSION_NUMBER
154: from JTF_RS_ROLES_B
155: where ROLE_ID = X_ROLE_ID
156: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
157: for update of ROLE_ID nowait;
158: recinfo c%rowtype;

Line 214: update JTF_RS_ROLES_B set

210: X_LAST_UPDATED_BY in NUMBER,
211: X_LAST_UPDATE_LOGIN in NUMBER
212: ) is
213: begin
214: update JTF_RS_ROLES_B set
215: ATTRIBUTE3 = X_ATTRIBUTE3,
216: ATTRIBUTE4 = X_ATTRIBUTE4,
217: ATTRIBUTE5 = X_ATTRIBUTE5,
218: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 420: delete from JTF_RS_ROLES_B

416: if (sql%notfound) then
417: raise no_data_found;
418: end if;
419:
420: delete from JTF_RS_ROLES_B
421: where ROLE_ID = X_ROLE_ID;
422:
423: if (sql%notfound) then
424: raise no_data_found;

Line 434: from JTF_RS_ROLES_B B

430: begin
431: delete from JTF_RS_ROLES_TL T
432: where not exists
433: (select NULL
434: from JTF_RS_ROLES_B B
435: where B.ROLE_ID = T.ROLE_ID
436: );
437:
438: update JTF_RS_ROLES_TL T set (