APPS.JTF_AUTH_PRINCIPALS_PKG dependencies on JTF_AUTH_PRINCIPALS_B

Line 20: cursor C is select ROWID from JTF_AUTH_PRINCIPALS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from JTF_AUTH_PRINCIPALS_B
21: where JTF_AUTH_PRINCIPAL_ID = X_JTF_AUTH_PRINCIPAL_ID
22: ;
23: begin
24: insert into JTF_AUTH_PRINCIPALS_B (

Line 24: insert into JTF_AUTH_PRINCIPALS_B (

20: cursor C is select ROWID from JTF_AUTH_PRINCIPALS_B
21: where JTF_AUTH_PRINCIPAL_ID = X_JTF_AUTH_PRINCIPAL_ID
22: ;
23: begin
24: insert into JTF_AUTH_PRINCIPALS_B (
25: JTF_AUTH_PRINCIPAL_ID,
26: OBJECT_VERSION_NUMBER,
27: PRINCIPAL_NAME,
28: APPLICATION_ID,

Line 113: from JTF_AUTH_PRINCIPALS_B

109: APPLICATION_ID,
110: USER_ID,
111: IS_USER_FLAG,
112: DAC_ROLE_FLAG
113: from JTF_AUTH_PRINCIPALS_B
114: where JTF_AUTH_PRINCIPAL_ID = X_JTF_AUTH_PRINCIPAL_ID
115: for update of JTF_AUTH_PRINCIPAL_ID nowait;
116: recinfo c%rowtype;
117:

Line 186: update JTF_AUTH_PRINCIPALS_B set

182: X_LAST_UPDATED_BY in NUMBER,
183: X_LAST_UPDATE_LOGIN in NUMBER
184: ) is
185: begin
186: update JTF_AUTH_PRINCIPALS_B set
187: PRINCIPAL_DESC_ID = X_PRINCIPAL_DESC_ID,
188: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
189: PRINCIPAL_NAME = X_PRINCIPAL_NAME,
190: APPLICATION_ID = X_APPLICATION_ID,

Line 250: FROM JTF_AUTH_PRINCIPALS_B

246: x_msg_data => x_msg_data);
247:
248: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
249: DELETE
250: FROM JTF_AUTH_PRINCIPALS_B
251: WHERE PRINCIPAL_NAME = p_principal_name
252: AND IS_USER_FLAG = 0;
253: END IF;
254: ELSE

Line 256: FROM JTF_AUTH_PRINCIPALS_B

252: AND IS_USER_FLAG = 0;
253: END IF;
254: ELSE
255: DELETE
256: FROM JTF_AUTH_PRINCIPALS_B
257: WHERE PRINCIPAL_NAME = p_principal_name
258: AND IS_USER_FLAG = 1;
259: IF ( SQL%NOTFOUND ) THEN
260: RAISE NO_DATA_FOUND;

Line 272: from JTF_AUTH_PRINCIPALS_B B

268: begin
269: delete from JTF_AUTH_PRINCIPALS_TL T
270: where not exists
271: (select NULL
272: from JTF_AUTH_PRINCIPALS_B B
273: where B.JTF_AUTH_PRINCIPAL_ID = T.PRINCIPAL_DESC_ID
274: );
275:
276: update JTF_AUTH_PRINCIPALS_TL T set (