APPS.BNE_INTERFACE_KEY_COLS_PKG dependencies on BNE_INTERFACE_KEY_COLS

Line 1: package body BNE_INTERFACE_KEY_COLS_PKG as

1: package body BNE_INTERFACE_KEY_COLS_PKG as
2: /* $Header: bneintkeycolb.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_KEY_COLS

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_KEY_COLS
20: where APPLICATION_ID = X_APPLICATION_ID
21: and KEY_CODE = X_KEY_CODE
22: and SEQUENCE_NUM = X_SEQUENCE_NUM
23: ;

Line 25: insert into BNE_INTERFACE_KEY_COLS (

21: and KEY_CODE = X_KEY_CODE
22: and SEQUENCE_NUM = X_SEQUENCE_NUM
23: ;
24: begin
25: insert into BNE_INTERFACE_KEY_COLS (
26: APPLICATION_ID,
27: KEY_CODE,
28: SEQUENCE_NUM,
29: OBJECT_VERSION_NUMBER,

Line 76: from BNE_INTERFACE_KEY_COLS

72: OBJECT_VERSION_NUMBER,
73: INTERFACE_APP_ID,
74: INTERFACE_CODE,
75: INTERFACE_SEQ_NUM
76: from BNE_INTERFACE_KEY_COLS
77: where APPLICATION_ID = X_APPLICATION_ID
78: and KEY_CODE = X_KEY_CODE
79: and SEQUENCE_NUM = X_SEQUENCE_NUM
80: for update of APPLICATION_ID nowait;

Line 110: update BNE_INTERFACE_KEY_COLS set

106: X_LAST_UPDATED_BY in NUMBER,
107: X_LAST_UPDATE_LOGIN in NUMBER
108: ) is
109: begin
110: update BNE_INTERFACE_KEY_COLS set
111: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
112: INTERFACE_APP_ID = X_INTERFACE_APP_ID,
113: INTERFACE_CODE = X_INTERFACE_CODE,
114: INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM,

Line 134: delete from BNE_INTERFACE_KEY_COLS

130: X_KEY_CODE in VARCHAR2,
131: X_SEQUENCE_NUM in NUMBER
132: ) is
133: begin
134: delete from BNE_INTERFACE_KEY_COLS
135: where APPLICATION_ID = X_APPLICATION_ID
136: and KEY_CODE = X_KEY_CODE
137: and SEQUENCE_NUM = X_SEQUENCE_NUM;
138:

Line 154: -- DESCRIPTION: Load a row into the BNE_INTERFACE_KEY_COLS entity. --

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

Line 197: from BNE_INTERFACE_KEY_COLS

193: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
194: begin
195: select LAST_UPDATED_BY, LAST_UPDATE_DATE
196: into db_luby, db_ludate
197: from BNE_INTERFACE_KEY_COLS
198: where APPLICATION_ID = l_app_id
199: and KEY_CODE = x_key_code
200: and SEQUENCE_NUM = x_sequence_num;
201:

Line 206: BNE_INTERFACE_KEY_COLS_PKG.Update_Row(

202: -- Test for customization and version
203: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
204: db_ludate, x_custom_mode)) then
205: -- Update existing row
206: BNE_INTERFACE_KEY_COLS_PKG.Update_Row(
207: X_APPLICATION_ID => l_app_id,
208: X_KEY_CODE => x_key_code,
209: X_SEQUENCE_NUM => x_sequence_num,
210: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 222: BNE_INTERFACE_KEY_COLS_PKG.Insert_Row(

218: end if;
219: exception
220: when no_data_found then
221: -- Record doesn't exist - insert in all cases
222: BNE_INTERFACE_KEY_COLS_PKG.Insert_Row(
223: X_ROWID => l_row_id,
224: X_APPLICATION_ID => l_app_id,
225: X_KEY_CODE => x_key_code,
226: X_SEQUENCE_NUM => x_sequence_num,

Line 240: end BNE_INTERFACE_KEY_COLS_PKG;

236: );
237: end;
238: end LOAD_ROW;
239:
240: end BNE_INTERFACE_KEY_COLS_PKG;