APPS.BNE_DUPLICATE_PROFILES_PKG dependencies on BNE_DUPLICATE_PROFILES_B

Line 18: cursor C is select ROWID from BNE_DUPLICATE_PROFILES_B

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_DUPLICATE_PROFILES_B
19: where APPLICATION_ID = X_APPLICATION_ID
20: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
21: ;
22: begin

Line 23: insert into BNE_DUPLICATE_PROFILES_B (

19: where APPLICATION_ID = X_APPLICATION_ID
20: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
21: ;
22: begin
23: insert into BNE_DUPLICATE_PROFILES_B (
24: APPLICATION_ID,
25: DUP_PROFILE_CODE,
26: OBJECT_VERSION_NUMBER,
27: INTEGRATOR_APP_ID,

Line 100: from BNE_DUPLICATE_PROFILES_B

96: cursor c is select
97: OBJECT_VERSION_NUMBER,
98: INTEGRATOR_APP_ID,
99: INTEGRATOR_CODE
100: from BNE_DUPLICATE_PROFILES_B
101: where APPLICATION_ID = X_APPLICATION_ID
102: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
103: for update of APPLICATION_ID nowait;
104: recinfo c%rowtype;

Line 159: update BNE_DUPLICATE_PROFILES_B set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update BNE_DUPLICATE_PROFILES_B set
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
161: INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID,
162: INTEGRATOR_CODE = X_INTEGRATOR_CODE,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 201: delete from BNE_DUPLICATE_PROFILES_B

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: delete from BNE_DUPLICATE_PROFILES_B
202: where APPLICATION_ID = X_APPLICATION_ID
203: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE;
204:
205: if (sql%notfound) then

Line 216: from BNE_DUPLICATE_PROFILES_B B

212: begin
213: delete from BNE_DUPLICATE_PROFILES_TL T
214: where not exists
215: (select NULL
216: from BNE_DUPLICATE_PROFILES_B B
217: where B.APPLICATION_ID = T.APPLICATION_ID
218: and B.DUP_PROFILE_CODE = T.DUP_PROFILE_CODE
219: );
220:

Line 387: from BNE_DUPLICATE_PROFILES_B

383: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
384: begin
385: select LAST_UPDATED_BY, LAST_UPDATE_DATE
386: into db_luby, db_ludate
387: from BNE_DUPLICATE_PROFILES_B
388: where APPLICATION_ID = l_app_id
389: and DUP_PROFILE_CODE = x_dup_profile_code;
390:
391: -- Test for customization and version