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 1110: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;

1106: if p_pr_party_id is not null then
1107: x_party_rel_party_id := p_pr_party_id;
1108: end if;
1109: if p_pr_party_id is null then
1110: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
1111: if x_generate_party_number = 'N' then
1112: select hz_party_number_s.nextval into x_party_number from dual;
1113: end if;
1114:

Line 1191: select ORG_CONTACT_ID into x_org_contact_id from hz_org_contacts

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

Line 1203: from hz_org_contacts

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