APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_ORG_CONTACTS

Line 560: SELECT OBJECT_VERSION_NUMBER FROM hz_org_contacts

556: WHERE RELATIONSHIP_ID = nvl(x_party_relationship_id,l_rel_id)
557: and subject_type = 'PERSON';
558:
559: cursor c_org_cont_rel is
560: SELECT OBJECT_VERSION_NUMBER FROM hz_org_contacts
561: WHERE PARTY_RELATIONSHIP_ID = nvl(x_party_relationship_id,l_rel_id);
562:
563: cursor c_party_rel is
564: SELECT OBJECT_VERSION_NUMBER FROM hz_parties

Line 1114: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;

1110: if p_pr_party_id is not null then
1111: x_party_rel_party_id := p_pr_party_id;
1112: end if;
1113: if p_pr_party_id is null then
1114: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
1115: if x_generate_party_number = 'N' then
1116: select hz_party_number_s.nextval into x_party_number from dual;
1117: end if;
1118:

Line 1195: select ORG_CONTACT_ID into x_org_contact_id from hz_org_contacts

1191: Return;
1192: end if;
1193: else
1194: if l_rec_update_flag = 'Y' and p_pr_party_id is not NULL then
1195: select ORG_CONTACT_ID into x_org_contact_id from hz_org_contacts
1196: where PARTY_RELATIONSHIP_ID = l_rel_id ; -- x_party_rel_party_id;
1197:
1198: ocon_rec.org_contact_id := x_org_contact_id;
1199: select OBJECT_VERSION_NUMBER into l_party_obj_number

Line 1207: from hz_org_contacts

1203: from hz_relationships
1204: where relationship_id = l_rel_id and directional_flag = 'F'; -- x_party_rel_party_id;
1205:
1206: select OBJECT_VERSION_NUMBER into l_con_obj_number
1207: from hz_org_contacts
1208: where ORG_CONTACT_ID = x_org_contact_id;
1209: ocon_rec.orig_system_reference := NULL;
1210: ocon_rec.party_rel_rec.party_rec.orig_system_reference := NULL;
1211: