APPS.HZ_BUS_OBJ_DEFINITIONS_PKG dependencies on HZ_BUS_OBJ_DEFINITIONS

Line 1: PACKAGE BODY HZ_BUS_OBJ_DEFINITIONS_PKG AS

1: PACKAGE BODY HZ_BUS_OBJ_DEFINITIONS_PKG AS
2: /*$Header: ARHBODTB.pls 120.2 2006/04/22 00:47:47 smattegu noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_business_object_code IN OUT NOCOPY VARCHAR2,

Line 47: INSERT INTO HZ_BUS_OBJ_DEFINITIONS (

43: --raise no_data_found;
44: raise self_is_null ;
45: end if;
46: CLOSE C2;
47: INSERT INTO HZ_BUS_OBJ_DEFINITIONS (
48: business_object_code,
49: child_bo_code,
50: tca_mandated_flag,
51: user_mandated_flag,

Line 105: UPDATE HZ_BUS_OBJ_DEFINITIONS

101: x_last_update_login IN NUMBER,
102: x_object_version_number IN NUMBER
103: ) IS
104: BEGIN
105: UPDATE HZ_BUS_OBJ_DEFINITIONS
106: SET
107: business_object_code = x_business_object_code,
108: child_bo_code = DECODE(x_child_bo_code,
109: NULL, child_bo_code,

Line 188: FROM HZ_BUS_OBJ_DEFINITIONS

184: l_luby := fnd_load_util.owner_id(X_OWNER);
185:
186: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
187: INTO db_luby, db_ludate
188: FROM HZ_BUS_OBJ_DEFINITIONS
189: WHERE business_object_code = x_business_object_code
190: AND nvl(child_bo_code, 'N') = nvl( x_child_bo_code, 'N')
191: AND entity_name = x_entity_name;
192:

Line 267: FROM HZ_BUS_OBJ_DEFINITIONS

263: x_bo_indicator_flag,
264: x_display_flag,
265: x_bo_version_number,
266: x_object_version_number
267: FROM HZ_BUS_OBJ_DEFINITIONS
268: WHERE business_object_code = x_business_object_code
269: and nvl(child_bo_code, 'N') = nvl( x_child_bo_code, 'N')
270: and entity_name = x_entity_name;
271: EXCEPTION

Line 286: DELETE FROM HZ_BUS_OBJ_DEFINITIONS

282: x_entity_name IN VARCHAR2
283:
284: ) IS
285: BEGIN
286: DELETE FROM HZ_BUS_OBJ_DEFINITIONS
287: WHERE business_object_code = x_business_object_code
288: and nvl(child_bo_code, 'N') = nvl( x_child_bo_code, 'N')
289: and entity_name = x_entity_name;
290: IF ( SQL%NOTFOUND ) THEN

Line 294: END HZ_BUS_OBJ_DEFINITIONS_PKG;

290: IF ( SQL%NOTFOUND ) THEN
291: RAISE NO_DATA_FOUND;
292: END IF;
293: END Delete_Row;
294: END HZ_BUS_OBJ_DEFINITIONS_PKG;