APPS.OKE_K_ACCESS_RULES_PKG dependencies on OKE_K_ACCESS_RULES

Line 1: package body OKE_K_ACCESS_RULES_PKG as

1: package body OKE_K_ACCESS_RULES_PKG as
2: /* $Header: OKEKACRB.pls 120.1 2005/06/02 12:00:37 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5: X_ACCESS_RULE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 18: cursor C is select ROWID from OKE_K_ACCESS_RULES

14: X_ATTRIBUTE_GROUP_CODE in VARCHAR2,
15: X_ATTRIBUTE_CODE in VARCHAR2,
16: X_ACCESS_LEVEL in VARCHAR2
17: ) is
18: cursor C is select ROWID from OKE_K_ACCESS_RULES
19: where ACCESS_RULE_ID = X_ACCESS_RULE_ID
20: ;
21: begin
22: select OKE_K_ACCESS_RULES_S.nextval

Line 22: select OKE_K_ACCESS_RULES_S.nextval

18: cursor C is select ROWID from OKE_K_ACCESS_RULES
19: where ACCESS_RULE_ID = X_ACCESS_RULE_ID
20: ;
21: begin
22: select OKE_K_ACCESS_RULES_S.nextval
23: into X_ACCESS_RULE_ID
24: from dual;
25:
26: insert into OKE_K_ACCESS_RULES (

Line 26: insert into OKE_K_ACCESS_RULES (

22: select OKE_K_ACCESS_RULES_S.nextval
23: into X_ACCESS_RULE_ID
24: from dual;
25:
26: insert into OKE_K_ACCESS_RULES (
27: ACCESS_RULE_ID,
28: CREATION_DATE,
29: CREATED_BY,
30: LAST_UPDATE_DATE,

Line 80: from OKE_K_ACCESS_RULES

76: ATTRIBUTE_GROUP_TYPE,
77: ATTRIBUTE_GROUP_CODE,
78: ATTRIBUTE_CODE,
79: ACCESS_LEVEL
80: from OKE_K_ACCESS_RULES
81: where ACCESS_RULE_ID = X_ACCESS_RULE_ID
82: for update of ACCESS_RULE_ID nowait;
83: recinfo c%rowtype;
84:

Line 126: update OKE_K_ACCESS_RULES set

122: X_ATTRIBUTE_CODE in VARCHAR2,
123: X_ACCESS_LEVEL in VARCHAR2
124: ) is
125: begin
126: update OKE_K_ACCESS_RULES set
127: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
128: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
129: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
130: ROLE_ID = X_ROLE_ID,

Line 147: delete from OKE_K_ACCESS_RULES

143: procedure DELETE_ROW (
144: X_ACCESS_RULE_ID in NUMBER
145: ) is
146: begin
147: delete from OKE_K_ACCESS_RULES
148: where ACCESS_RULE_ID = X_ACCESS_RULE_ID;
149:
150: if (sql%notfound) then
151: raise no_data_found;

Line 160: delete from OKE_K_ACCESS_RULES

156: procedure DELETE_ALL (
157: X_ROLE_ID in NUMBER
158: ) is
159: begin
160: delete from OKE_K_ACCESS_RULES
161: where ROLE_ID = X_ROLE_ID;
162:
163: delete from OKE_COMPILED_ACCESS_RULES
164: where ROLE_ID = X_ROLE_ID;

Line 168: end OKE_K_ACCESS_RULES_PKG;

164: where ROLE_ID = X_ROLE_ID;
165:
166: end DELETE_ALL;
167:
168: end OKE_K_ACCESS_RULES_PKG;