APPS.HZ_PARTY_BO_PVT dependencies on HZ_BUS_OBJ_DEFINITIONS

Line 3609: FROM HZ_BUS_OBJ_DEFINITIONS

3605: BEGIN
3606: IF(p_bo_code = 'PERSON') THEN
3607: UPDATE HZ_PARTIES
3608: SET PERSON_BO_VERSION = (SELECT BO_VERSION_NUMBER
3609: FROM HZ_BUS_OBJ_DEFINITIONS
3610: WHERE BUSINESS_OBJECT_CODE = 'PERSON'
3611: AND ENTITY_NAME = 'HZ_PARTIES')
3612: WHERE PARTY_ID = p_party_id;
3613: ELSIF(p_bo_code = 'PERSON_CUST') THEN

Line 3616: FROM HZ_BUS_OBJ_DEFINITIONS

3612: WHERE PARTY_ID = p_party_id;
3613: ELSIF(p_bo_code = 'PERSON_CUST') THEN
3614: UPDATE HZ_PARTIES
3615: SET PERSON_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3616: FROM HZ_BUS_OBJ_DEFINITIONS
3617: WHERE BUSINESS_OBJECT_CODE = 'PERSON_CUST'
3618: AND ENTITY_NAME = 'HZ_PARTIES'
3619: AND CHILD_BO_CODE IS NULL)
3620: WHERE PARTY_ID = p_party_id;

Line 3624: FROM HZ_BUS_OBJ_DEFINITIONS

3620: WHERE PARTY_ID = p_party_id;
3621: ELSIF(p_bo_code = 'ORG') THEN
3622: UPDATE HZ_PARTIES
3623: SET ORG_BO_VERSION = (SELECT BO_VERSION_NUMBER
3624: FROM HZ_BUS_OBJ_DEFINITIONS
3625: WHERE BUSINESS_OBJECT_CODE = 'ORG'
3626: AND ENTITY_NAME = 'HZ_PARTIES')
3627: WHERE PARTY_ID = p_party_id;
3628: ELSIF(p_bo_code = 'ORG_CUST') THEN

Line 3631: FROM HZ_BUS_OBJ_DEFINITIONS

3627: WHERE PARTY_ID = p_party_id;
3628: ELSIF(p_bo_code = 'ORG_CUST') THEN
3629: UPDATE HZ_PARTIES
3630: SET ORG_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3631: FROM HZ_BUS_OBJ_DEFINITIONS
3632: WHERE BUSINESS_OBJECT_CODE = 'ORG_CUST'
3633: AND ENTITY_NAME = 'HZ_PARTIES'
3634: AND CHILD_BO_CODE IS NULL)
3635: WHERE PARTY_ID = p_party_id;

Line 3684: FROM HZ_BUS_OBJ_DEFINITIONS

3680: WHERE party_id = p_party_id;
3681:
3682: CURSOR get_def_bo_version IS
3683: SELECT nvl(BO_VERSION_NUMBER, 0)
3684: FROM HZ_BUS_OBJ_DEFINITIONS
3685: WHERE BUSINESS_OBJECT_CODE = p_bo_code
3686: AND ENTITY_NAME = 'HZ_PARTIES'
3687: AND CHILD_BO_CODE IS NULL;
3688: