APPS.BNE_SECURITY_RULES_PKG dependencies on BNE_SECURITY_RULES

Line 1: package body BNE_SECURITY_RULES_PKG as

1: package body BNE_SECURITY_RULES_PKG as
2: /* $Header: bnesecruleb.pls 120.2 2005/06/29 03:40:54 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 17: cursor C is select ROWID from BNE_SECURITY_RULES

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from BNE_SECURITY_RULES
18: where APPLICATION_ID = X_APPLICATION_ID
19: and SECURITY_CODE = X_SECURITY_CODE
20: ;
21: begin

Line 22: insert into BNE_SECURITY_RULES (

18: where APPLICATION_ID = X_APPLICATION_ID
19: and SECURITY_CODE = X_SECURITY_CODE
20: ;
21: begin
22: insert into BNE_SECURITY_RULES (
23: APPLICATION_ID,
24: SECURITY_CODE,
25: OBJECT_VERSION_NUMBER,
26: SECURITY_TYPE,

Line 66: from BNE_SECURITY_RULES

62: cursor c1 is select
63: OBJECT_VERSION_NUMBER,
64: SECURITY_TYPE,
65: SECURITY_VALUE
66: from BNE_SECURITY_RULES
67: where APPLICATION_ID = X_APPLICATION_ID
68: and SECURITY_CODE = X_SECURITY_CODE
69: for update of APPLICATION_ID nowait;
70: begin

Line 96: update BNE_SECURITY_RULES set

92: X_LAST_UPDATED_BY in NUMBER,
93: X_LAST_UPDATE_LOGIN in NUMBER
94: ) is
95: begin
96: update BNE_SECURITY_RULES set
97: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
98: SECURITY_TYPE = X_SECURITY_TYPE,
99: SECURITY_VALUE = X_SECURITY_VALUE,
100: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 117: delete from BNE_SECURITY_RULES

113: X_APPLICATION_ID in NUMBER,
114: X_SECURITY_CODE in VARCHAR2
115: ) is
116: begin
117: delete from BNE_SECURITY_RULES
118: where APPLICATION_ID = X_APPLICATION_ID
119: and SECURITY_CODE = X_SECURITY_CODE;
120:
121: if (sql%notfound) then

Line 136: -- DESCRIPTION: Load a row into the BNE_SECURITY_RULES entity. --

132:
133: --------------------------------------------------------------------------------
134: -- PROCEDURE: LOAD_ROW --
135: -- --
136: -- DESCRIPTION: Load a row into the BNE_SECURITY_RULES entity. --
137: -- This proc is called from the apps loader. --
138: -- --
139: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
140: -- --

Line 175: from BNE_SECURITY_RULES

171: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
172: begin
173: select LAST_UPDATED_BY, LAST_UPDATE_DATE
174: into db_luby, db_ludate
175: from BNE_SECURITY_RULES
176: where APPLICATION_ID = l_app_id
177: and SECURITY_CODE = x_security_rule_code;
178:
179: -- Test for customization and version

Line 183: BNE_SECURITY_RULES_PKG.Update_Row(

179: -- Test for customization and version
180: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
181: db_ludate, x_custom_mode)) then
182: -- Update existing row
183: BNE_SECURITY_RULES_PKG.Update_Row(
184: X_APPLICATION_ID => l_app_id,
185: X_SECURITY_CODE => x_security_rule_code,
186: X_OBJECT_VERSION_NUMBER => x_object_version_number,
187: X_SECURITY_TYPE => x_security_type,

Line 197: BNE_SECURITY_RULES_PKG.Insert_Row(

193: end if;
194: exception
195: when no_data_found then
196: -- Record doesn't exist - insert in all cases
197: BNE_SECURITY_RULES_PKG.Insert_Row(
198: X_ROWID => l_row_id,
199: X_APPLICATION_ID => l_app_id,
200: X_SECURITY_CODE => x_security_rule_code,
201: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 213: end BNE_SECURITY_RULES_PKG;

209: );
210: end;
211: end LOAD_ROW;
212:
213: end BNE_SECURITY_RULES_PKG;