APPS.HZ_BES_BO_DEFINITION_PVT dependencies on HZ_BUS_OBJ_DEFINITIONS

Line 75: FROM HZ_BUS_OBJ_DEFINITIONS

71: SELECT OBJECT_VERSION_NUMBER,
72: USER_MANDATED_FLAG,
73: TCA_MANDATED_FLAG
74: INTO l_ovn, l_umf, l_tmf
75: FROM HZ_BUS_OBJ_DEFINITIONS
76: WHERE business_object_code = p_business_object_code
77: AND entity_name = p_entity_name
78: AND nvl(child_bo_code, 'X') = nvl(p_child_bo_code, 'X')
79: FOR UPDATE NOWAIT;

Line 85: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_BUS_OBJ_DEFINITIONS');

81: IF NOT((p_object_version_number IS NULL AND l_ovn IS NULL) OR
82: (p_object_version_number IS NOT NULL AND l_ovn IS NOT NULL AND
83: p_object_version_number = l_ovn)) THEN
84: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
85: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_BUS_OBJ_DEFINITIONS');
86: FND_MSG_PUB.ADD;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: EXCEPTION

Line 116: UPDATE HZ_BUS_OBJ_DEFINITIONS

112:
113: -- Not doing any update if the existing flag setting is same as
114: -- user pass in
115: IF NOT(l_umf = p_user_mandated_flag) THEN
116: UPDATE HZ_BUS_OBJ_DEFINITIONS
117: SET object_version_number = p_object_version_number,
118: user_mandated_flag = p_user_mandated_flag,
119: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
120: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,

Line 143: UPDATE HZ_BUS_OBJ_DEFINITIONS

139: p_entity_name => p_entity_name,
140: x_return_status => l_bo_found );
141:
142: IF(l_bo_found) THEN
143: UPDATE HZ_BUS_OBJ_DEFINITIONS
144: SET bo_version_number = nvl(bo_version_number,1) + 1,
145: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
146: last_updated_by = HZ_UTILITY_V2PUB.last_updated_by,
147: last_update_login = HZ_UTILITY_V2PUB.last_update_login