APPS.BNE_MAPPING_LINES_PKG dependencies on BNE_MAPPING_LINES

Line 1: package body BNE_MAPPING_LINES_PKG as

1: package body BNE_MAPPING_LINES_PKG as
2: /* $Header: bnemaplineb.pls 120.2 2005/06/29 03:40:23 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 23: cursor C is select ROWID from BNE_MAPPING_LINES

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from BNE_MAPPING_LINES
24: where APPLICATION_ID = X_APPLICATION_ID
25: and MAPPING_CODE = X_MAPPING_CODE
26: and INTERFACE_APP_ID = X_INTERFACE_APP_ID
27: and INTERFACE_CODE = X_INTERFACE_CODE

Line 31: insert into BNE_MAPPING_LINES (

27: and INTERFACE_CODE = X_INTERFACE_CODE
28: and INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM
29: ;
30: begin
31: insert into BNE_MAPPING_LINES (
32: INTERFACE_CODE,
33: INTERFACE_SEQ_NUM,
34: OBJECT_VERSION_NUMBER,
35: CREATED_BY,

Line 97: from BNE_MAPPING_LINES

93: CONTENT_SEQ_NUM,
94: CONTENT_APP_ID,
95: CONTENT_CODE,
96: DECODE_FLAG
97: from BNE_MAPPING_LINES
98: where APPLICATION_ID = X_APPLICATION_ID
99: and MAPPING_CODE = X_MAPPING_CODE
100: and INTERFACE_APP_ID = X_INTERFACE_APP_ID
101: and INTERFACE_CODE = X_INTERFACE_CODE

Line 140: update BNE_MAPPING_LINES set

136: X_LAST_UPDATED_BY in NUMBER,
137: X_LAST_UPDATE_LOGIN in NUMBER
138: ) is
139: begin
140: update BNE_MAPPING_LINES set
141: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
142: INTERFACE_APP_ID = X_INTERFACE_APP_ID,
143: INTERFACE_CODE = X_INTERFACE_CODE,
144: INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM,

Line 172: delete from BNE_MAPPING_LINES

168: X_INTERFACE_CODE in VARCHAR2,
169: X_INTERFACE_SEQ_NUM in NUMBER
170: ) is
171: begin
172: delete from BNE_MAPPING_LINES
173: where APPLICATION_ID = X_APPLICATION_ID
174: and MAPPING_CODE = X_MAPPING_CODE
175: and INTERFACE_APP_ID = X_INTERFACE_APP_ID
176: and INTERFACE_CODE = X_INTERFACE_CODE

Line 194: -- DESCRIPTION: Load a row into the BNE_MAPPING_LINES entity. --

190:
191: --------------------------------------------------------------------------------
192: -- PROCEDURE: LOAD_ROW --
193: -- --
194: -- DESCRIPTION: Load a row into the BNE_MAPPING_LINES entity. --
195: -- This proc is called from the apps loader. --
196: -- --
197: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
198: -- --

Line 243: from BNE_MAPPING_LINES

239: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
240: begin
241: select LAST_UPDATED_BY, LAST_UPDATE_DATE
242: into db_luby, db_ludate
243: from BNE_MAPPING_LINES
244: where APPLICATION_ID = l_app_id
245: and MAPPING_CODE = x_mapping_code
246: and SEQUENCE_NUM = x_sequence_num;
247: -- bug3510034 - DBI70:INST:FII LDT FILES FAILURE WHILE APPLYING BIS_PF.D

Line 261: BNE_MAPPING_LINES_PKG.Update_Row(

257: -- Test for customization and version
258: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
259: db_ludate, x_custom_mode)) then
260: -- Update existing row
261: BNE_MAPPING_LINES_PKG.Update_Row(
262: X_APPLICATION_ID => l_app_id,
263: X_MAPPING_CODE => x_mapping_code,
264: X_INTERFACE_APP_ID => l_interface_app_id,
265: X_INTERFACE_CODE => x_interface_code,

Line 281: BNE_MAPPING_LINES_PKG.Insert_Row(

277: end if;
278: exception
279: when no_data_found then
280: -- Record doesn't exist - insert in all cases
281: BNE_MAPPING_LINES_PKG.Insert_Row(
282: X_ROWID => l_row_id,
283: X_APPLICATION_ID => l_app_id,
284: X_MAPPING_CODE => x_mapping_code,
285: X_INTERFACE_APP_ID => l_interface_app_id,

Line 305: end BNE_MAPPING_LINES_PKG;

301: end LOAD_ROW;
302:
303:
304:
305: end BNE_MAPPING_LINES_PKG;