APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_ORG_CONTACT_ROLES

Line 7349: FROM HZ_ORG_CONTACT_ROLES

7345: l_orig_system_reference,
7346: l_status,
7347: l_created_by_module,
7348: l_application_id
7349: FROM HZ_ORG_CONTACT_ROLES
7350: WHERE ROWID = p_rowid;
7351: END IF;
7352:
7353: --------------------------

Line 7453: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',

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

Line 7594: FROM HZ_ORG_CONTACT_ROLES

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

Line 7636: FROM HZ_ORG_CONTACT_ROLES

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

Line 7697: HZ_ORG_CONTACT_ROLES OCR,

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