APPS.BNE_FILES_PKG dependencies on BNE_FILES

Line 1: package body BNE_FILES_PKG as

1: package body BNE_FILES_PKG as
2: /* $Header: bnefileb.pls 120.2 2005/06/29 03:39:56 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 21: cursor C is select ROWID from BNE_FILES

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_FILES
22: where APPLICATION_ID = X_APPLICATION_ID
23: and CONTENT_CODE = X_CONTENT_CODE
24: and USER_FILE_NAME = X_USER_FILE_NAME
25: ;

Line 27: insert into BNE_FILES (

23: and CONTENT_CODE = X_CONTENT_CODE
24: and USER_FILE_NAME = X_USER_FILE_NAME
25: ;
26: begin
27: insert into BNE_FILES (
28: OBJECT_VERSION_NUMBER,
29: MIDDLE_TIER_FILE_NAME,
30: USER_FILE_NAME,
31: START_LINE,

Line 88: from BNE_FILES

84: COLUMN_DELIMITER_CHAR,
85: IGNORE_CONSEC_DELIMS_FLAG,
86: SEQUENCE_NUM,
87: CONTENT_CODE
88: from BNE_FILES
89: where APPLICATION_ID = X_APPLICATION_ID
90: and CONTENT_CODE = X_CONTENT_CODE
91: and USER_FILE_NAME = X_USER_FILE_NAME
92: for update of APPLICATION_ID nowait;

Line 127: update BNE_FILES set

123: X_LAST_UPDATED_BY in NUMBER,
124: X_LAST_UPDATE_LOGIN in NUMBER
125: ) is
126: begin
127: update BNE_FILES set
128: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
129: MIDDLE_TIER_FILE_NAME = X_MIDDLE_TIER_FILE_NAME,
130: START_LINE = X_START_LINE,
131: COLUMN_DELIMITER_CHAR = X_COLUMN_DELIMITER_CHAR,

Line 153: delete from BNE_FILES

149: X_CONTENT_CODE in VARCHAR2,
150: X_USER_FILE_NAME in VARCHAR2
151: ) is
152: begin
153: delete from BNE_FILES
154: where APPLICATION_ID = X_APPLICATION_ID
155: and CONTENT_CODE = X_CONTENT_CODE
156: and USER_FILE_NAME = X_USER_FILE_NAME;
157:

Line 173: -- DESCRIPTION: Load a row into the BNE_FILES entity. --

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

Line 217: from BNE_FILES

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_FILES
218: where APPLICATION_ID = l_app_id
219: and CONTENT_CODE = x_content_code
220: and USER_FILE_NAME = x_user_file_name;
221:

Line 226: BNE_FILES_PKG.Update_Row(

222: -- Test for customization and version
223: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
224: db_ludate, x_custom_mode)) then
225: -- Update existing row
226: BNE_FILES_PKG.Update_Row(
227: X_APPLICATION_ID => l_app_id,
228: X_CONTENT_CODE => x_content_code,
229: X_USER_FILE_NAME => x_user_file_name,
230: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 244: BNE_FILES_PKG.Insert_Row(

240: end if;
241: exception
242: when no_data_found then
243: -- Record doesn't exist - insert in all cases
244: BNE_FILES_PKG.Insert_Row(
245: X_ROWID => l_row_id,
246: X_APPLICATION_ID => l_app_id,
247: X_CONTENT_CODE => x_content_code,
248: X_USER_FILE_NAME => x_user_file_name,

Line 264: end BNE_FILES_PKG;

260: );
261: end;
262: end LOAD_ROW;
263:
264: end BNE_FILES_PKG;