APPS.BNE_DUP_INTERFACE_PROFILES_PKG dependencies on BNE_DUP_INTERFACE_PROFILES

Line 1: package body BNE_DUP_INTERFACE_PROFILES_PKG as

1: package body BNE_DUP_INTERFACE_PROFILES_PKG as
2: /* $Header: bnedupintprofb.pls 120.2 2005/06/29 03:39:51 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_PROFILES

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_PROFILES
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 26: insert into BNE_DUP_INTERFACE_PROFILES (

22: and DUP_PROFILE_APP_ID = X_DUP_PROFILE_APP_ID
23: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
24: ;
25: begin
26: insert into BNE_DUP_INTERFACE_PROFILES (
27: INTERFACE_APP_ID,
28: INTERFACE_CODE,
29: DUP_PROFILE_APP_ID,
30: DUP_PROFILE_CODE,

Line 77: from BNE_DUP_INTERFACE_PROFILES

73: cursor c1 is select
74: OBJECT_VERSION_NUMBER,
75: DUP_HANDLING_CODE,
76: DEFAULT_RESOLVER_CLASSNAME
77: from BNE_DUP_INTERFACE_PROFILES
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 112: update BNE_DUP_INTERFACE_PROFILES set

108: X_LAST_UPDATED_BY in NUMBER,
109: X_LAST_UPDATE_LOGIN in NUMBER
110: ) is
111: begin
112: update BNE_DUP_INTERFACE_PROFILES set
113: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
114: DUP_HANDLING_CODE = X_DUP_HANDLING_CODE,
115: DEFAULT_RESOLVER_CLASSNAME = X_DEFAULT_RESOLVER_CLASSNAME,
116: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 137: delete from BNE_DUP_INTERFACE_PROFILES

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_PROFILES
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 158: -- DESCRIPTION: Load a row into the BNE_DUP_INTERFACE_PROFILES entity. --

154:
155: --------------------------------------------------------------------------------
156: -- PROCEDURE: LOAD_ROW --
157: -- --
158: -- DESCRIPTION: Load a row into the BNE_DUP_INTERFACE_PROFILES entity. --
159: -- This proc is called from the apps loader. --
160: -- --
161: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
162: -- --

Line 200: from BNE_DUP_INTERFACE_PROFILES

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

Line 211: BNE_DUP_INTERFACE_PROFILES_PKG.Update_Row(

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

Line 227: BNE_DUP_INTERFACE_PROFILES_PKG.Insert_Row(

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

Line 245: end BNE_DUP_INTERFACE_PROFILES_PKG;

241: );
242: end;
243: end LOAD_ROW;
244:
245: end BNE_DUP_INTERFACE_PROFILES_PKG;