APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_ORG_CONTACT_ROLES

Line 7346: FROM HZ_ORG_CONTACT_ROLES

7342: l_orig_system_reference,
7343: l_status,
7344: l_created_by_module,
7345: l_application_id
7346: FROM HZ_ORG_CONTACT_ROLES
7347: WHERE ROWID = p_rowid;
7348: END IF;
7349:
7350: --------------------------

Line 7450: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',

7446: then
7447: hz_orig_system_ref_pub.get_owner_table_id
7448: (p_orig_system => p_org_contact_role_rec.orig_system,
7449: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
7450: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
7451: x_owner_table_id => l_mosr_owner_table_id,
7452: x_return_status => l_temp_return_status);
7453:
7454: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 7591: FROM HZ_ORG_CONTACT_ROLES

7587: IF p_org_contact_role_rec.primary_flag = 'Y' THEN
7588: BEGIN
7589: SELECT ORG_CONTACT_ROLE_ID
7590: INTO l_role_id
7591: FROM HZ_ORG_CONTACT_ROLES
7592: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id
7593: AND PRIMARY_FLAG = 'Y'
7594: AND ROWNUM = 1;
7595: /* Bug Fix: 3936336 */

Line 7633: FROM HZ_ORG_CONTACT_ROLES

7629:
7630: BEGIN
7631: SELECT ORG_CONTACT_ROLE_ID
7632: INTO l_role_id
7633: FROM HZ_ORG_CONTACT_ROLES
7634: WHERE ORG_CONTACT_ID = NVL(p_org_contact_role_rec.org_contact_id, fnd_api.g_miss_num)
7635: AND ROLE_TYPE = p_org_contact_role_rec.role_type
7636: AND STATUS = 'A' -- Added: Bug#6411541
7637: AND ROWNUM = 1;

Line 7694: HZ_ORG_CONTACT_ROLES OCR,

7690: SELECT 'Y'
7691: INTO l_dummy
7692: FROM HZ_RELATIONSHIPS PR,
7693: HZ_ORG_CONTACTS OC,
7694: HZ_ORG_CONTACT_ROLES OCR,
7695: HZ_RELATIONSHIPS PR2,
7696: HZ_ORG_CONTACTS OC2
7697: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
7698: AND OCR.ROLE_TYPE = p_org_contact_role_rec.role_type