APPS.PV_CONTACT_USER_BATCH_PUB dependencies on HZ_RELATIONSHIP_V2PUB

Line 256: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

252: l_party_site_id NUMBER;
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;

Line 1393: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

1389: l_relationship_code VARCHAR2(1000);
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;

Line 1987: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

1983: l_relationship_code VARCHAR2(1000);
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;