APPS.BNE_GRAPH_COLUMNS_PKG dependencies on BNE_GRAPH_COLUMNS

Line 1: package body BNE_GRAPH_COLUMNS_PKG as

1: package body BNE_GRAPH_COLUMNS_PKG as
2: /* $Header: bnegraphcolumnb.pls 120.0 2005/08/18 06:33:23 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 21: cursor C is select ROWID from BNE_GRAPH_COLUMNS

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from BNE_GRAPH_COLUMNS
22: where APPLICATION_ID = X_APPLICATION_ID
23: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
24: and GRAPH_SEQ_NUM = X_GRAPH_SEQ_NUM
25: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 28: insert into BNE_GRAPH_COLUMNS (

24: and GRAPH_SEQ_NUM = X_GRAPH_SEQ_NUM
25: and SEQUENCE_NUM = X_SEQUENCE_NUM
26: ;
27: begin
28: insert into BNE_GRAPH_COLUMNS (
29: APPLICATION_ID,
30: INTEGRATOR_CODE,
31: GRAPH_SEQ_NUM,
32: SEQUENCE_NUM,

Line 87: from BNE_GRAPH_COLUMNS

83: INTERFACE_APP_ID,
84: INTERFACE_CODE,
85: INTERFACE_SEQ_NUM,
86: LOCATION_CODE
87: from BNE_GRAPH_COLUMNS
88: where APPLICATION_ID = X_APPLICATION_ID
89: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
90: and GRAPH_SEQ_NUM = X_GRAPH_SEQ_NUM
91: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 125: update BNE_GRAPH_COLUMNS set

121: X_LAST_UPDATED_BY in NUMBER,
122: X_LAST_UPDATE_LOGIN in NUMBER
123: ) is
124: begin
125: update BNE_GRAPH_COLUMNS set
126: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
127: INTERFACE_APP_ID = X_INTERFACE_APP_ID,
128: INTERFACE_CODE = X_INTERFACE_CODE,
129: INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM,

Line 151: delete from BNE_GRAPH_COLUMNS

147: X_GRAPH_SEQ_NUM in NUMBER,
148: X_SEQUENCE_NUM in NUMBER
149: ) is
150: begin
151: delete from BNE_GRAPH_COLUMNS
152: where APPLICATION_ID = X_APPLICATION_ID
153: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
154: and GRAPH_SEQ_NUM = X_GRAPH_SEQ_NUM
155: and SEQUENCE_NUM = X_SEQUENCE_NUM;

Line 172: -- DESCRIPTION: Load a row into the BNE_GRAPH_COLUMNS entity. --

168:
169: --------------------------------------------------------------------------------
170: -- PROCEDURE: LOAD_ROW --
171: -- --
172: -- DESCRIPTION: Load a row into the BNE_GRAPH_COLUMNS entity. --
173: -- This proc is called from the apps loader. --
174: -- --
175: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
176: -- --

Line 217: from BNE_GRAPH_COLUMNS

213: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
214: begin
215: select LAST_UPDATED_BY, LAST_UPDATE_DATE
216: into db_luby, db_ludate
217: from BNE_GRAPH_COLUMNS
218: where APPLICATION_ID = l_app_id
219: and INTEGRATOR_CODE = x_integrator_code
220: and GRAPH_SEQ_NUM = x_graph_seq_num
221: and SEQUENCE_NUM = x_sequence_num;

Line 227: BNE_GRAPH_COLUMNS_PKG.Update_Row(

223: -- Test for customization and version
224: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
225: db_ludate, x_custom_mode)) then
226: -- Update existing row
227: BNE_GRAPH_COLUMNS_PKG.Update_Row(
228: X_APPLICATION_ID => l_app_id,
229: X_INTEGRATOR_CODE => x_integrator_code,
230: X_GRAPH_SEQ_NUM => x_graph_seq_num,
231: X_SEQUENCE_NUM => x_sequence_num,

Line 245: BNE_GRAPH_COLUMNS_PKG.Insert_Row(

241: end if;
242: exception
243: when no_data_found then
244: -- Record doesn't exist - insert in all cases
245: BNE_GRAPH_COLUMNS_PKG.Insert_Row(
246: X_ROWID => l_row_id,
247: X_APPLICATION_ID => l_app_id,
248: X_INTEGRATOR_CODE => x_integrator_code,
249: X_GRAPH_SEQ_NUM => x_graph_seq_num,

Line 266: end BNE_GRAPH_COLUMNS_PKG;

262:
263: end;
264: end LOAD_ROW;
265:
266: end BNE_GRAPH_COLUMNS_PKG;