APPS.BNE_INTEGRATOR_VIEWERS_PKG dependencies on BNE_INTEGRATOR_VIEWERS

Line 1: package body BNE_INTEGRATOR_VIEWERS_PKG as

1: package body BNE_INTEGRATOR_VIEWERS_PKG as
2: /* $Header: bneintviewerb.pls 120.0 2005/08/18 07:09:51 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 17: cursor C is select ROWID from BNE_INTEGRATOR_VIEWERS

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from BNE_INTEGRATOR_VIEWERS
18: where INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID
19: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
20: and VIEWER_APP_ID = X_VIEWER_APP_ID
21: and VIEWER_CODE = X_VIEWER_CODE

Line 24: insert into BNE_INTEGRATOR_VIEWERS (

20: and VIEWER_APP_ID = X_VIEWER_APP_ID
21: and VIEWER_CODE = X_VIEWER_CODE
22: ;
23: begin
24: insert into BNE_INTEGRATOR_VIEWERS (
25: INTEGRATOR_APP_ID,
26: INTEGRATOR_CODE,
27: VIEWER_APP_ID,
28: VIEWER_CODE,

Line 71: from BNE_INTEGRATOR_VIEWERS

67: INTEGRATOR_CODE,
68: VIEWER_APP_ID,
69: VIEWER_CODE,
70: OBJECT_VERSION_NUMBER
71: from BNE_INTEGRATOR_VIEWERS
72: where INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID
73: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
74: and VIEWER_APP_ID = X_VIEWER_APP_ID
75: and VIEWER_CODE = X_VIEWER_CODE

Line 101: update BNE_INTEGRATOR_VIEWERS set

97: X_LAST_UPDATED_BY in NUMBER,
98: X_LAST_UPDATE_LOGIN in NUMBER
99: ) is
100: begin
101: update BNE_INTEGRATOR_VIEWERS set
102: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
103: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
104: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
105: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 123: delete from BNE_INTEGRATOR_VIEWERS

119: X_VIEWER_APP_ID in NUMBER,
120: X_VIEWER_CODE in VARCHAR2
121: ) is
122: begin
123: delete from BNE_INTEGRATOR_VIEWERS
124: where INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID
125: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
126: and VIEWER_APP_ID = X_VIEWER_APP_ID
127: and VIEWER_CODE = X_VIEWER_CODE;

Line 144: -- DESCRIPTION: Load a row into the BNE_INTEGRATOR_VIEWERS entity. --

140:
141: --------------------------------------------------------------------------------
142: -- PROCEDURE: LOAD_ROW --
143: -- --
144: -- DESCRIPTION: Load a row into the BNE_INTEGRATOR_VIEWERS entity. --
145: -- This proc is called from the apps loader. --
146: -- --
147: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
148: -- --

Line 184: from BNE_INTEGRATOR_VIEWERS

180: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
181: begin
182: select LAST_UPDATED_BY, LAST_UPDATE_DATE
183: into db_luby, db_ludate
184: from BNE_INTEGRATOR_VIEWERS
185: where INTEGRATOR_APP_ID = l_integrator_app_id
186: and INTEGRATOR_CODE = x_integrator_code
187: and VIEWER_APP_ID = l_viewer_app_id
188: and VIEWER_CODE = x_viewer_code;

Line 194: BNE_INTEGRATOR_VIEWERS_PKG.Update_Row(

190: -- Test for customization and version
191: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
192: db_ludate, x_custom_mode)) then
193: -- Update existing row
194: BNE_INTEGRATOR_VIEWERS_PKG.Update_Row(
195: X_INTEGRATOR_APP_ID => l_integrator_app_id,
196: X_INTEGRATOR_CODE => x_integrator_code,
197: X_VIEWER_APP_ID => l_viewer_app_id,
198: X_VIEWER_CODE => x_viewer_code,

Line 208: BNE_INTEGRATOR_VIEWERS_PKG.Insert_Row(

204: end if;
205: exception
206: when no_data_found then
207: -- Record doesn't exist - insert in all cases
208: BNE_INTEGRATOR_VIEWERS_PKG.Insert_Row(
209: X_ROWID => l_row_id,
210: X_INTEGRATOR_APP_ID => l_integrator_app_id,
211: X_INTEGRATOR_CODE => x_integrator_code,
212: X_VIEWER_APP_ID => l_viewer_app_id,

Line 226: end BNE_INTEGRATOR_VIEWERS_PKG;

222:
223: end LOAD_ROW;
224:
225:
226: end BNE_INTEGRATOR_VIEWERS_PKG;