APPS.JTF_AUTH_PERMISSIONS_PKG dependencies on JTF_AUTH_PERMISSIONS_B

Line 21: cursor C is select ROWID from JTF_AUTH_PERMISSIONS_B

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_AUTH_PERMISSIONS_B
22: where JTF_AUTH_PERMISSION_ID = X_JTF_AUTH_PERMISSION_ID
23: ;
24: begin
25: insert into JTF_AUTH_PERMISSIONS_B (

Line 25: insert into JTF_AUTH_PERMISSIONS_B (

21: cursor C is select ROWID from JTF_AUTH_PERMISSIONS_B
22: where JTF_AUTH_PERMISSION_ID = X_JTF_AUTH_PERMISSION_ID
23: ;
24: begin
25: insert into JTF_AUTH_PERMISSIONS_B (
26: JTF_AUTH_PERMISSION_ID,
27: OBJECT_VERSION_NUMBER,
28: PERMISSION_NAME,
29: APPLICATION_ID,

Line 118: from JTF_AUTH_PERMISSIONS_B

114: PERMISSION_CLASS_NAME,
115: OWNERABLE_FLAG,
116: IS_DAC_FLAG,
117: MAINTENANCE_MODE_FLAG
118: from JTF_AUTH_PERMISSIONS_B
119: where JTF_AUTH_PERMISSION_ID = X_JTF_AUTH_PERMISSION_ID
120: for update of JTF_AUTH_PERMISSION_ID nowait;
121: recinfo c%rowtype;
122:

Line 193: update JTF_AUTH_PERMISSIONS_B set

189: X_LAST_UPDATED_BY in NUMBER,
190: X_LAST_UPDATE_LOGIN in NUMBER
191: ) is
192: begin
193: update JTF_AUTH_PERMISSIONS_B set
194: PERMISSION_DESC_ID = X_PERMISSION_DESC_ID,
195: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
196: PERMISSION_NAME = X_PERMISSION_NAME,
197: APPLICATION_ID = X_APPLICATION_ID,

Line 237: delete from JTF_AUTH_PERMISSIONS_B

233: if (sql%notfound) then
234: raise no_data_found;
235: end if;
236:
237: delete from JTF_AUTH_PERMISSIONS_B
238: where JTF_AUTH_PERMISSION_ID = X_JTF_AUTH_PERMISSION_ID;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 251: from JTF_AUTH_PERMISSIONS_B B

247: begin
248: delete from JTF_AUTH_PERMISSIONS_TL T
249: where not exists
250: (select NULL
251: from JTF_AUTH_PERMISSIONS_B B
252: where B.JTF_AUTH_PERMISSION_ID = T.PERMISSION_DESC_ID
253: );
254:
255: update JTF_AUTH_PERMISSIONS_TL T set (