APPS.FND_OBJECT_DEFINITIONS_PKG dependencies on FND_OBJECT_DEFINITIONS

Line 1: package body FND_OBJECT_DEFINITIONS_PKG as

1: package body FND_OBJECT_DEFINITIONS_PKG as
2: /* $Header: AFOBDEFB.pls 120.1.12010000.3 2009/08/26 13:15:37 vsoolapa noship $*/
3:
4: procedure INSERT_ROW (
5: X_OBJECT_DEFINITION_ID in NUMBER,

Line 25: insert into FND_OBJECT_DEFINITIONS (

21: X_OBJECT_REFERENCE in XMLTYPE
22: ) is
23: begin
24:
25: insert into FND_OBJECT_DEFINITIONS (
26: OBJECT_DEFINITION_ID,
27: APPLICATION_ID,
28: OBJECT_ID,
29: OBJECT_DEFINITION_TYPE,

Line 85: update FND_OBJECT_DEFINITIONS set

81: X_OBJECT_REFERENCE in XMLTYPE
82: ) is
83: begin
84:
85: update FND_OBJECT_DEFINITIONS set
86: APPLICATION_ID = X_APPLICATION_ID,
87: OBJECT_DEFINITION_TYPE = X_OBJECT_DEFINITION_TYPE,
88: OBJECT_VERSION = X_OBJECT_VERSION,
89: OBJECT_EXTENSION_VERSION = X_OBJECT_EXTENSION_VERSION,

Line 142: fnd_object_definitions_pkg.UPDATE_ROW (

138: into obj_id, db_luby, db_ludate
139: from fnd_objects
140: where obj_name = X_OBJ_NAME;
141:
142: fnd_object_definitions_pkg.UPDATE_ROW (
143: X_APPLICATION_ID => X_APPLICATION_ID,
144: X_OBJECT_ID => obj_id,
145: X_OBJECT_DEFINITION_TYPE => X_OBJECT_DEFINITION_TYPE,
146: X_OBJECT_VERSION => '12.0',

Line 163: select fnd_object_definitions_s.nextval into obj_def_id from dual;

159:
160: exception
161: when NO_DATA_FOUND then
162:
163: select fnd_object_definitions_s.nextval into obj_def_id from dual;
164:
165: fnd_object_definitions_pkg.INSERT_ROW (
166: X_OBJECT_DEFINITION_ID => obj_def_id,
167: X_APPLICATION_ID => X_APPLICATION_ID,

Line 165: fnd_object_definitions_pkg.INSERT_ROW (

161: when NO_DATA_FOUND then
162:
163: select fnd_object_definitions_s.nextval into obj_def_id from dual;
164:
165: fnd_object_definitions_pkg.INSERT_ROW (
166: X_OBJECT_DEFINITION_ID => obj_def_id,
167: X_APPLICATION_ID => X_APPLICATION_ID,
168: X_OBJECT_ID => obj_id,
169: X_OBJECT_DEFINITION_TYPE => X_OBJECT_DEFINITION_TYPE,

Line 217: from fnd_objects fo, fnd_object_definitions fod

213: begin
214:
215: select fo.object_id, fod.last_updated_by, fod.last_update_date
216: into obj_id, db_luby, db_ludate
217: from fnd_objects fo, fnd_object_definitions fod
218: where obj_name = X_OBJ_NAME
219: and fo.object_id = fod.object_id(+);
220:
221: f_luby := X_LAST_UPDATED_BY;

Line 226: select fnd_object_definitions_s.nextval into obj_def_id from dual;

222: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
223:
224: if (db_luby is null OR db_ludate is null) then
225:
226: select fnd_object_definitions_s.nextval into obj_def_id from dual;
227:
228: fnd_object_definitions_pkg.INSERT_ROW (
229: X_OBJECT_DEFINITION_ID => obj_def_id,
230: X_APPLICATION_ID => X_APPLICATION_ID,

Line 228: fnd_object_definitions_pkg.INSERT_ROW (

224: if (db_luby is null OR db_ludate is null) then
225:
226: select fnd_object_definitions_s.nextval into obj_def_id from dual;
227:
228: fnd_object_definitions_pkg.INSERT_ROW (
229: X_OBJECT_DEFINITION_ID => obj_def_id,
230: X_APPLICATION_ID => X_APPLICATION_ID,
231: X_OBJECT_ID => obj_id,
232: X_OBJECT_DEFINITION_TYPE => X_OBJECT_DEFINITION_TYPE,

Line 249: fnd_object_definitions_pkg.UPDATE_ROW (

245: X_OBJECT_REFERENCE => X_OBJECT_REFERENCE);
246:
247: elsif (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
248: db_ludate, X_CUSTOM_MODE)) then
249: fnd_object_definitions_pkg.UPDATE_ROW (
250: X_APPLICATION_ID => X_APPLICATION_ID,
251: X_OBJECT_ID => obj_id,
252: X_OBJECT_DEFINITION_TYPE => X_OBJECT_DEFINITION_TYPE,
253: X_OBJECT_VERSION => '12.0',

Line 270: end FND_OBJECT_DEFINITIONS_PKG;

266: end if;
267:
268: end LOAD_ROW;
269:
270: end FND_OBJECT_DEFINITIONS_PKG;