APPS.BNE_SECURED_OBJECTS_PKG dependencies on BNE_SECURED_OBJECTS

Line 1: package body BNE_SECURED_OBJECTS_PKG as

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

Line 18: cursor C is select ROWID from BNE_SECURED_OBJECTS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from BNE_SECURED_OBJECTS
19: where APPLICATION_ID = X_APPLICATION_ID
20: and OBJECT_CODE = X_OBJECT_CODE
21: and OBJECT_TYPE = X_OBJECT_TYPE
22: ;

Line 24: insert into BNE_SECURED_OBJECTS (

20: and OBJECT_CODE = X_OBJECT_CODE
21: and OBJECT_TYPE = X_OBJECT_TYPE
22: ;
23: begin
24: insert into BNE_SECURED_OBJECTS (
25: APPLICATION_ID,
26: OBJECT_CODE,
27: OBJECT_TYPE,
28: OBJECT_VERSION_NUMBER,

Line 72: from BNE_SECURED_OBJECTS

68: cursor c1 is select
69: OBJECT_VERSION_NUMBER,
70: SECURITY_RULE_APP_ID,
71: SECURITY_RULE_CODE
72: from BNE_SECURED_OBJECTS
73: where APPLICATION_ID = X_APPLICATION_ID
74: and OBJECT_CODE = X_OBJECT_CODE
75: and OBJECT_TYPE = X_OBJECT_TYPE
76: for update of APPLICATION_ID nowait;

Line 104: update BNE_SECURED_OBJECTS set

100: X_LAST_UPDATED_BY in NUMBER,
101: X_LAST_UPDATE_LOGIN in NUMBER
102: ) is
103: begin
104: update BNE_SECURED_OBJECTS set
105: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
106: SECURITY_RULE_APP_ID = X_SECURITY_RULE_APP_ID,
107: SECURITY_RULE_CODE = X_SECURITY_RULE_CODE,
108: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 127: delete from BNE_SECURED_OBJECTS

123: X_OBJECT_CODE in VARCHAR2,
124: X_OBJECT_TYPE in VARCHAR2
125: ) is
126: begin
127: delete from BNE_SECURED_OBJECTS
128: where APPLICATION_ID = X_APPLICATION_ID
129: and OBJECT_CODE = X_OBJECT_CODE
130: and OBJECT_TYPE = X_OBJECT_TYPE;
131:

Line 147: -- DESCRIPTION: Load a row into the BNE_SECURED_OBJECTS entity. --

143:
144: --------------------------------------------------------------------------------
145: -- PROCEDURE: LOAD_ROW --
146: -- --
147: -- DESCRIPTION: Load a row into the BNE_SECURED_OBJECTS entity. --
148: -- This proc is called from the apps loader. --
149: -- --
150: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
151: -- --

Line 189: from BNE_SECURED_OBJECTS

185: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
186: begin
187: select LAST_UPDATED_BY, LAST_UPDATE_DATE
188: into db_luby, db_ludate
189: from BNE_SECURED_OBJECTS
190: where APPLICATION_ID = l_app_id
191: and OBJECT_CODE = x_secured_object_code
192: and OBJECT_TYPE = x_secured_object_type;
193:

Line 198: BNE_SECURED_OBJECTS_PKG.Update_Row(

194: -- Test for customization and version
195: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
196: db_ludate, x_custom_mode)) then
197: -- Update existing row
198: BNE_SECURED_OBJECTS_PKG.Update_Row(
199: X_APPLICATION_ID => l_app_id,
200: X_OBJECT_CODE => x_secured_object_code,
201: X_OBJECT_TYPE => x_secured_object_type,
202: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 213: BNE_SECURED_OBJECTS_PKG.Insert_Row(

209: end if;
210: exception
211: when no_data_found then
212: -- Record doesn't exist - insert in all cases
213: BNE_SECURED_OBJECTS_PKG.Insert_Row(
214: X_ROWID => l_row_id,
215: X_APPLICATION_ID => l_app_id,
216: X_OBJECT_CODE => x_secured_object_code,
217: X_OBJECT_TYPE => x_secured_object_type,

Line 230: end BNE_SECURED_OBJECTS_PKG;

226: );
227: end;
228: end LOAD_ROW;
229:
230: end BNE_SECURED_OBJECTS_PKG;