APPS.BNE_IMPORT_PROGRAMS_PKG dependencies on BNE_IMPORT_PROGRAMS

Line 1: package body BNE_IMPORT_PROGRAMS_PKG as

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

Line 20: cursor C is select ROWID from BNE_IMPORT_PROGRAMS

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

Line 26: insert into BNE_IMPORT_PROGRAMS (

22: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
23: and SEQUENCE_NUM = X_SEQUENCE_NUM
24: ;
25: begin
26: insert into BNE_IMPORT_PROGRAMS (
27: APPLICATION_ID,
28: INTEGRATOR_CODE,
29: SEQUENCE_NUM,
30: OBJECT_VERSION_NUMBER,

Line 82: from BNE_IMPORT_PROGRAMS

78: PARENT_SEQ_NUM,
79: IMPORT_TYPE,
80: IMPORT_PARAM_LIST_APP_ID,
81: IMPORT_PARAM_LIST_CODE
82: from BNE_IMPORT_PROGRAMS
83: where APPLICATION_ID = X_APPLICATION_ID
84: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
85: and SEQUENCE_NUM = X_SEQUENCE_NUM
86: for update of APPLICATION_ID nowait;

Line 121: update BNE_IMPORT_PROGRAMS set

117: X_LAST_UPDATED_BY in NUMBER,
118: X_LAST_UPDATE_LOGIN in NUMBER
119: ) is
120: begin
121: update BNE_IMPORT_PROGRAMS set
122: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
123: PARENT_SEQ_NUM = X_PARENT_SEQ_NUM,
124: IMPORT_TYPE = X_IMPORT_TYPE,
125: IMPORT_PARAM_LIST_APP_ID = X_IMPORT_PARAM_LIST_APP_ID,

Line 145: delete from BNE_IMPORT_PROGRAMS

141: X_INTEGRATOR_CODE in VARCHAR2,
142: X_SEQUENCE_NUM in NUMBER
143: ) is
144: begin
145: delete from BNE_IMPORT_PROGRAMS
146: where APPLICATION_ID = X_APPLICATION_ID
147: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
148: and SEQUENCE_NUM = X_SEQUENCE_NUM;
149:

Line 166: -- DESCRIPTION: Load a row into the BNE_IMPORT_PROGRAMS entity. --

162:
163: --------------------------------------------------------------------------------
164: -- PROCEDURE: LOAD_ROW --
165: -- --
166: -- DESCRIPTION: Load a row into the BNE_IMPORT_PROGRAMS entity. --
167: -- This proc is called from the apps loader. --
168: -- --
169: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
170: -- --

Line 210: from BNE_IMPORT_PROGRAMS

206: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
207: begin
208: select LAST_UPDATED_BY, LAST_UPDATE_DATE
209: into db_luby, db_ludate
210: from BNE_IMPORT_PROGRAMS
211: where APPLICATION_ID = l_app_id
212: and INTEGRATOR_CODE = x_integrator_code
213: and SEQUENCE_NUM = x_sequence_num;
214:

Line 219: BNE_IMPORT_PROGRAMS_PKG.Update_Row(

215: -- Test for customization and version
216: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
217: db_ludate, x_custom_mode)) then
218: -- Update existing row
219: BNE_IMPORT_PROGRAMS_PKG.Update_Row(
220: X_APPLICATION_ID => l_app_id,
221: X_INTEGRATOR_CODE => x_integrator_code,
222: X_SEQUENCE_NUM => x_sequence_num,
223: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 236: BNE_IMPORT_PROGRAMS_PKG.Insert_Row(

232: end if;
233: exception
234: when no_data_found then
235: -- Record doesn't exist - insert in all cases
236: BNE_IMPORT_PROGRAMS_PKG.Insert_Row(
237: X_ROWID => l_row_id,
238: X_APPLICATION_ID => l_app_id,
239: X_INTEGRATOR_CODE => x_integrator_code,
240: X_SEQUENCE_NUM => x_sequence_num,

Line 255: end BNE_IMPORT_PROGRAMS_PKG;

251: );
252: end;
253: end LOAD_ROW;
254:
255: end BNE_IMPORT_PROGRAMS_PKG;