APPS.JTF_DAC_ROLE_PERMS_PKG dependencies on JTF_DAC_ROLE_PERMS

Line 1: PACKAGE BODY JTF_DAC_ROLE_PERMS_PKG AS

1: PACKAGE BODY JTF_DAC_ROLE_PERMS_PKG AS
2: /* $Header: jtfarpb.pls 120.2 2005/10/25 05:15:20 psanyal ship $ */
3:
4: procedure INSERT_ROW(
5: X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 21: cursor C is select ROWID from JTF_DAC_ROLE_PERMS

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: )IS
20:
21: cursor C is select ROWID from JTF_DAC_ROLE_PERMS
22: where ROLE_PERM_ID = X_ROLE_PERM_ID;
23: BEGIN
24:
25: insert into JTF_DAC_ROLE_PERMS(

Line 25: insert into JTF_DAC_ROLE_PERMS(

21: cursor C is select ROWID from JTF_DAC_ROLE_PERMS
22: where ROLE_PERM_ID = X_ROLE_PERM_ID;
23: BEGIN
24:
25: insert into JTF_DAC_ROLE_PERMS(
26: ROLE_PERM_ID,
27: ROLE_ID,
28: PERMISSION_ID,
29: BASE_OBJECT,

Line 83: update JTF_DAC_ROLE_PERMS set

79: X_LAST_UPDATE_LOGIN in NUMBER
80: ) is
81: begin
82:
83: update JTF_DAC_ROLE_PERMS set
84: ROLE_PERM_ID = x_role_perm_id,
85: ROLE_ID = x_role_id,
86: PERMISSION_ID = x_permission_id,
87: BASE_OBJECT = x_base_object,

Line 127: JTF_DAC_ROLE_PERMS_PKG.Update_Row(

123: else
124: l_user_id := 0;
125: end if;
126:
127: JTF_DAC_ROLE_PERMS_PKG.Update_Row(
128: X_ROLE_PERM_ID => X_ROLE_PERM_ID,
129: x_role_id => x_role_id,
130: x_permission_id => x_permission_id,
131: x_base_object => x_base_object,

Line 168: JTF_DAC_ROLE_PERMS_PKG.Update_Row(

164: else
165: l_user_id := 0;
166: end if;
167:
168: JTF_DAC_ROLE_PERMS_PKG.Update_Row(
169: X_ROLE_PERM_ID => X_ROLE_PERM_ID,
170: x_role_id => x_role_id,
171: x_permission_id => x_permission_id,
172: x_base_object => x_base_object,

Line 183: JTF_DAC_ROLE_PERMS_PKG.Insert_Row(

179: X_Last_Update_Login => 0);
180:
181: exception
182: when no_data_found then
183: JTF_DAC_ROLE_PERMS_PKG.Insert_Row(
184: X_Rowid => l_rowid,
185: X_ROLE_PERM_ID => X_ROLE_PERM_ID,
186: x_role_id => x_role_id,
187: x_permission_id => x_permission_id,

Line 202: end JTF_DAC_ROLE_PERMS_PKG;

198:
199: end;
200:
201:
202: end JTF_DAC_ROLE_PERMS_PKG;