APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on HZ_PARTIES

Line 155: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;

151: p_country_code IN VARCHAR2
152: ) is
153: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
154: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
155: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
156:
157: CURSOR ptp_cur IS
158: SELECT PARTY_TAX_PROFILE_ID
159: FROM ZX_PARTY_TAX_PROFILE

Line 172: -- from hz_parties where party_id = P_PARTY_ID;

168: -- BEGIN
169: -- Check created module name
170: -- select nvl(substr(created_by_module,1,3),'ZX') created_by_module
171: -- into L_CREATED_BY_MODULE
172: -- from hz_parties where party_id = P_PARTY_ID;
173: -- IF L_CREATED_BY_MODULE = 'XLE' THEN
174: -- return;
175: -- END IF;
176: -- EXCEPTION

Line 574: l_dummy_char HZ_PARTIES.party_type%TYPE;

570:
571: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
572: l_party_ovn NUMBER(15) := NULL;
573: l_dummy_number NUMBER(15) := NULL;
574: l_dummy_char HZ_PARTIES.party_type%TYPE;
575:
576: BEGIN
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: x_msg_count := 0;

Line 588: FROM hz_parties

584: BEGIN
585:
586: SELECT party_type
587: INTO l_dummy_char
588: FROM hz_parties
589: WHERE party_id = p_party_id;
590:
591: IF l_dummy_char <> 'ORGANIZATION' THEN
592: -- no action reqd for suppliers

Line 621: FROM hz_parties

617: l_organization_rec.tax_reference := NVL(p_tax_reg_num,FND_API.G_MISS_CHAR);
618:
619: SELECT object_version_number
620: INTO l_party_ovn
621: FROM hz_parties
622: WHERE party_id = p_party_id;
623:
624: hz_party_v2pub.update_organization
625: (p_init_msg_list => FND_API.G_TRUE