APPS.BNE_INTERFACE_KEYS_PKG dependencies on BNE_INTERFACE_KEYS

Line 1: package body BNE_INTERFACE_KEYS_PKG as

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

Line 19: cursor C is select ROWID from BNE_INTERFACE_KEYS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from BNE_INTERFACE_KEYS
20: where APPLICATION_ID = X_APPLICATION_ID
21: and KEY_CODE = X_KEY_CODE
22: ;
23: begin

Line 24: insert into BNE_INTERFACE_KEYS (

20: where APPLICATION_ID = X_APPLICATION_ID
21: and KEY_CODE = X_KEY_CODE
22: ;
23: begin
24: insert into BNE_INTERFACE_KEYS (
25: APPLICATION_ID,
26: KEY_CODE,
27: OBJECT_VERSION_NUMBER,
28: INTERFACE_APP_ID,

Line 77: from BNE_INTERFACE_KEYS

73: INTERFACE_APP_ID,
74: INTERFACE_CODE,
75: KEY_TYPE,
76: KEY_CLASS
77: from BNE_INTERFACE_KEYS
78: where APPLICATION_ID = X_APPLICATION_ID
79: and KEY_CODE = X_KEY_CODE
80: for update of APPLICATION_ID nowait;
81: begin

Line 111: update BNE_INTERFACE_KEYS set

107: X_LAST_UPDATED_BY in NUMBER,
108: X_LAST_UPDATE_LOGIN in NUMBER
109: ) is
110: begin
111: update BNE_INTERFACE_KEYS set
112: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
113: INTERFACE_APP_ID = X_INTERFACE_APP_ID,
114: INTERFACE_CODE = X_INTERFACE_CODE,
115: KEY_TYPE = X_KEY_TYPE,

Line 134: delete from BNE_INTERFACE_KEYS

130: X_APPLICATION_ID in NUMBER,
131: X_KEY_CODE in VARCHAR2
132: ) is
133: begin
134: delete from BNE_INTERFACE_KEYS
135: where APPLICATION_ID = X_APPLICATION_ID
136: and KEY_CODE = X_KEY_CODE;
137:
138: if (sql%notfound) then

Line 153: -- DESCRIPTION: Load a row into the BNE_INTERFACE_KEYS entity. --

149:
150: --------------------------------------------------------------------------------
151: -- PROCEDURE: LOAD_ROW --
152: -- --
153: -- DESCRIPTION: Load a row into the BNE_INTERFACE_KEYS entity. --
154: -- This proc is called from the apps loader. --
155: -- --
156: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
157: -- --

Line 196: from BNE_INTERFACE_KEYS

192: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
193: begin
194: select LAST_UPDATED_BY, LAST_UPDATE_DATE
195: into db_luby, db_ludate
196: from BNE_INTERFACE_KEYS
197: where APPLICATION_ID = l_app_id
198: and KEY_CODE = x_key_code;
199:
200: -- Test for customization and version

Line 204: BNE_INTERFACE_KEYS_PKG.Update_Row(

200: -- Test for customization and version
201: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
202: db_ludate, x_custom_mode)) then
203: -- Update existing row
204: BNE_INTERFACE_KEYS_PKG.Update_Row(
205: X_APPLICATION_ID => l_app_id,
206: X_KEY_CODE => x_key_code,
207: X_OBJECT_VERSION_NUMBER => x_object_version_number,
208: X_INTERFACE_APP_ID => l_interface_app_id,

Line 220: BNE_INTERFACE_KEYS_PKG.Insert_Row(

216: end if;
217: exception
218: when no_data_found then
219: -- Record doesn't exist - insert in all cases
220: BNE_INTERFACE_KEYS_PKG.Insert_Row(
221: X_ROWID => l_row_id,
222: X_APPLICATION_ID => l_app_id,
223: X_KEY_CODE => x_key_code,
224: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 238: end BNE_INTERFACE_KEYS_PKG;

234: );
235: end;
236: end LOAD_ROW;
237:
238: end BNE_INTERFACE_KEYS_PKG;