APPS.OKC_REP_UTIL_PVT dependencies on HZ_PARTIES

Line 1592: FROM hz_parties

1588: WHERE UPPER(name) = UPPER(p_party_name);
1589:
1590: CURSOR tca_party_exist_csr IS
1591: SELECT party_id
1592: FROM hz_parties
1593: WHERE UPPER(party_name) = UPPER(p_party_name)
1594: AND party_type IN ('ORGANIZATION', 'PERSON'); /*--10334886: Added person party Type*/
1595:
1596: /*CURSOR vendor_exist_csr IS

Line 1604: hz_parties hp

1600:
1601: CURSOR vendor_exist_csr IS
1602: SELECT ap.vendor_id
1603: FROM ap_suppliers ap,
1604: hz_parties hp
1605: WHERE ap.party_id = hp.party_id
1606: AND UPPER(hp.party_name) = UPPER(p_party_name);
1607:
1608: CURSOR rep_party_unique_csr(l_party_role_code2 varchar2) IS

Line 1630: FROM hz_parties

1626: AND organization_id = p_party_id;
1627:
1628: CURSOR tca_party_and_role_csr IS
1629: SELECT 1
1630: FROM hz_parties
1631: WHERE UPPER(party_name) = UPPER(p_party_name)
1632: AND party_id = p_party_id;
1633:
1634: /*CURSOR vendor_and_role_csr IS

Line 1643: hz_parties hp

1639:
1640: CURSOR vendor_and_role_csr IS
1641: SELECT 1
1642: FROM ap_suppliers ap,
1643: hz_parties hp
1644: WHERE UPPER(ap.vendor_name) = UPPER(p_party_name)
1645: AND hp.party_id = ap.party_id
1646: AND ap.vendor_id = p_party_id;
1647:

Line 2068: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HZ_PARTIES');

2064: IF tca_party_and_role_csr%NOTFOUND THEN
2065:
2066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2068: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HZ_PARTIES');
2069: END IF;
2070:
2071: CLOSE tca_party_and_role_csr;
2072:

Line 2463: hz_parties hz,

2459:
2460: CURSOR tca_party_contact_csr IS
2461: SELECT 1
2462: FROM hz_relationships hr,
2463: hz_parties hz,
2464: hz_parties hz1
2465: WHERE hr.party_id = p_contact_id
2466: AND hr.subject_type = 'PERSON'
2467: AND hr.object_type = 'ORGANIZATION'

Line 2464: hz_parties hz1

2460: CURSOR tca_party_contact_csr IS
2461: SELECT 1
2462: FROM hz_relationships hr,
2463: hz_parties hz,
2464: hz_parties hz1
2465: WHERE hr.party_id = p_contact_id
2466: AND hr.subject_type = 'PERSON'
2467: AND hr.object_type = 'ORGANIZATION'
2468: AND hr.object_table_name = 'HZ_PARTIES'

Line 2468: AND hr.object_table_name = 'HZ_PARTIES'

2464: hz_parties hz1
2465: WHERE hr.party_id = p_contact_id
2466: AND hr.subject_type = 'PERSON'
2467: AND hr.object_type = 'ORGANIZATION'
2468: AND hr.object_table_name = 'HZ_PARTIES'
2469: AND hr.object_id = p_party_id
2470: AND hr.relationship_code = 'CONTACT_OF'
2471: AND hz.party_id = p_contact_id
2472: AND hz1.party_id = hr.subject_id

Line 7209: AND cp.owner_table_name='HZ_PARTIES'

7205: CURSOR tca_email_csr(l_contact_id NUMBER) IS
7206: SELECT email_address
7207: FROM hz_contact_points cp
7208: WHERE cp.owner_table_id = l_contact_id
7209: AND cp.owner_table_name='HZ_PARTIES'
7210: AND cp.contact_point_type = 'EMAIL';
7211: BEGIN
7212: l_api_name := 'get_customer_userlist';
7213: