APPS.PV_CONTACT_USER_BATCH_PUB dependencies on HZ_PARTY_CONTACT_V2PUB

Line 257: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;

253: l_contact_point_id NUMBER;
254: l_party_site_number VARCHAR2(1000);
255: l_cust_acct_role_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;
256: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
257: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
258: l_location_id NUMBER;
259: l_log_msg LOG_MESSAGE_TBL_TYPE;
260: l_log_count NUMBER:=0;
261: l_attr_log_msg LOG_MESSAGE_TBL_TYPE;

Line 639: HZ_PARTY_CONTACT_V2PUB.create_org_contact (

635: l_org_contact_rec.created_by_module := 'PV';
636: l_org_contact_rec.application_id := 691;
637:
638:
639: HZ_PARTY_CONTACT_V2PUB.create_org_contact (
640: p_org_contact_rec => l_org_contact_rec,
641: x_org_contact_id => l_org_contact_party_id,
642: x_party_rel_id => l_rel_id,
643: x_party_id => l_rel_party_id,

Line 677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');

673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');
678: l_log_count:= l_log_count + 1;
679: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
680: END IF;
681:

Line 1394: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;

1390: l_party_status VARCHAR2(1000);
1391:
1392:
1393: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1394: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
1395:
1396: CURSOR user_type_id (user_type VARCHAR2) IS
1397: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1398:

Line 1988: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;

1984: l_party_status VARCHAR2(1000);
1985:
1986:
1987: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1988: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
1989:
1990: CURSOR user_type_id (user_type VARCHAR2) IS
1991: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1992: