APPS.BNE_DUP_INTERFACE_COLS_PKG dependencies on BNE_DUP_INTERFACE_COLS

Line 1: package body BNE_DUP_INTERFACE_COLS_PKG as

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

Line 19: cursor C is select ROWID from BNE_DUP_INTERFACE_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_DUP_INTERFACE_COLS
20: where INTERFACE_APP_ID = X_INTERFACE_APP_ID
21: and INTERFACE_CODE = X_INTERFACE_CODE
22: and DUP_PROFILE_APP_ID = X_DUP_PROFILE_APP_ID
23: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE

Line 27: insert into BNE_DUP_INTERFACE_COLS (

23: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
24: and INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM
25: ;
26: begin
27: insert into BNE_DUP_INTERFACE_COLS (
28: INTERFACE_APP_ID,
29: INTERFACE_CODE,
30: DUP_PROFILE_APP_ID,
31: DUP_PROFILE_CODE,

Line 77: from BNE_DUP_INTERFACE_COLS

73: ) is
74: cursor c1 is select
75: OBJECT_VERSION_NUMBER,
76: RESOLVER_CLASSNAME
77: from BNE_DUP_INTERFACE_COLS
78: where INTERFACE_APP_ID = X_INTERFACE_APP_ID
79: and INTERFACE_CODE = X_INTERFACE_CODE
80: and DUP_PROFILE_APP_ID = X_DUP_PROFILE_APP_ID
81: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE

Line 111: update BNE_DUP_INTERFACE_COLS set

107: X_LAST_UPDATED_BY in NUMBER,
108: X_LAST_UPDATE_LOGIN in NUMBER
109: ) is
110: begin
111: update BNE_DUP_INTERFACE_COLS set
112: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
113: RESOLVER_CLASSNAME = X_RESOLVER_CLASSNAME,
114: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
115: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 137: delete from BNE_DUP_INTERFACE_COLS

133: X_DUP_PROFILE_APP_ID in NUMBER,
134: X_DUP_PROFILE_CODE in VARCHAR2
135: ) is
136: begin
137: delete from BNE_DUP_INTERFACE_COLS
138: where INTERFACE_APP_ID = X_INTERFACE_APP_ID
139: and INTERFACE_CODE = X_INTERFACE_CODE
140: and DUP_PROFILE_APP_ID = X_DUP_PROFILE_APP_ID
141: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE

Line 201: from BNE_DUP_INTERFACE_COLS

197: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
198: begin
199: select LAST_UPDATED_BY, LAST_UPDATE_DATE
200: into db_luby, db_ludate
201: from BNE_DUP_INTERFACE_COLS
202: where INTERFACE_APP_ID = l_interface_app_id
203: and INTERFACE_CODE = x_interface_code
204: and DUP_PROFILE_APP_ID = l_dup_profile_app_id
205: and DUP_PROFILE_CODE = x_dup_profile_code

Line 213: BNE_DUP_INTERFACE_COLS_PKG.Update_Row(

209: -- Test for customization and version
210: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
211: db_ludate, x_custom_mode)) then
212: -- Update existing row
213: BNE_DUP_INTERFACE_COLS_PKG.Update_Row(
214: X_INTERFACE_APP_ID => l_interface_app_id,
215: X_INTERFACE_CODE => x_interface_code,
216: X_DUP_PROFILE_APP_ID => l_dup_profile_app_id,
217: X_DUP_PROFILE_CODE => x_dup_profile_code,

Line 229: BNE_DUP_INTERFACE_COLS_PKG.Insert_Row(

225: end if;
226: exception
227: when no_data_found then
228: -- Record doesn't exist - insert in all cases
229: BNE_DUP_INTERFACE_COLS_PKG.Insert_Row(
230: X_ROWID => l_row_id,
231: X_INTERFACE_APP_ID => l_interface_app_id,
232: X_INTERFACE_CODE => x_interface_code,
233: X_DUP_PROFILE_APP_ID => l_dup_profile_app_id,

Line 247: end BNE_DUP_INTERFACE_COLS_PKG;

243: );
244: end;
245: end LOAD_ROW;
246:
247: end BNE_DUP_INTERFACE_COLS_PKG;