APPS.ARH_CONT_PKG dependencies on HZ_ORG_CONTACTS

Line 136: FROM HZ_ORG_CONTACTS

132: SELECT ROWID,
133: OBJECT_VERSION_NUMBER,
134: LAST_UPDATE_DATE,
135: PARTY_RELATIONSHIP_ID
136: FROM HZ_ORG_CONTACTS
137: WHERE ORG_CONTACT_ID = p_col_id;
138:
139: CURSOR cu_relationship_version IS
140: SELECT ROWID,

Line 173: ELSIF p_table_name = 'HZ_ORG_CONTACTS' THEN

169: x_object_version_number,
170: l_last_update_date ,
171: x_id_value;
172: CLOSE cu_party_version;
173: ELSIF p_table_name = 'HZ_ORG_CONTACTS' THEN
174: OPEN cu_org_contact_version;
175: FETCH cu_org_contact_version INTO
176: x_rowid ,
177: x_object_version_number,

Line 238: FROM hz_org_contacts

234: IS
235: CURSOR cu_org_contact_update
236: IS
237: SELECT org_contact_id
238: FROM hz_org_contacts
239: WHERE org_contact_id = p_org_contact_id
240: FOR UPDATE OF org_contact_id NOWAIT;
241: l_lock NUMBER;
242: BEGIN

Line 246: UPDATE hz_org_contacts

242: BEGIN
243: OPEN cu_org_contact_update;
244: FETCH cu_org_contact_update INTO l_lock;
245: IF cu_org_contact_update%FOUND THEN
246: UPDATE hz_org_contacts
247: SET mail_stop = p_mail_stop
248: WHERE org_contact_id = p_org_contact_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');

Line 251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');

247: SET mail_stop = p_mail_stop
248: WHERE org_contact_id = p_org_contact_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;

Line 616: SELECT hz_org_contacts_s.nextval INTO x_contact_id FROM DUAL;

612: i_create_org_contact := 'N';
613: END IF;
614:
615: IF i_create_org_contact = 'Y' THEN
616: SELECT hz_org_contacts_s.nextval INTO x_contact_id FROM DUAL;
617: END IF;
618:
619: arp_standard.debug(' i_create_org_contact :'||i_create_org_contact );
620:

Line 869: hz_org_contacts o

865:
866: SELECT p.party_id
867: INTO cpoint_rec.owner_table_id
868: FROM hz_relationships p,
869: hz_org_contacts o
870: WHERE o.org_contact_id = x_org_contact_id
871: AND o.party_relationship_id = p.relationship_id
872: AND p.subject_table_name = 'HZ_PARTIES'
873: AND p.object_table_name = 'HZ_PARTIES'

Line 1406: p_table_name => 'HZ_ORG_CONTACTS',

1402:
1403: l_org_contact_object_version := x_org_contact_object_version;
1404: IF l_org_contact_object_version = -1 THEN
1405: object_version_select(
1406: p_table_name => 'HZ_ORG_CONTACTS',
1407: p_col_id => x_org_contact_id,
1408: x_rowid => l_org_contact_rowid,
1409: x_object_version_number => l_org_contact_object_version,
1410: x_last_update_date => l_org_contact_last_update_date,

Line 1557: from hz_org_contacts

1553: select last_update_date,
1554: object_version_number
1555: into X_org_cont_Last_Update_Date,
1556: x_org_contact_object_version
1557: from hz_org_contacts
1558: where org_contact_id = x_org_contact_id;
1559:
1560: select last_update_date,
1561: object_version_number

Line 1843: FROM hz_org_contacts

1839: attribute19,
1840: attribute20,
1841: object_version_number,
1842: party_relationship_id
1843: FROM hz_org_contacts
1844: WHERE org_contact_id = p_ocon_rec.org_contact_id;
1845: l_ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
1846: BEGIN
1847: x_update_required := 'N';

Line 2002: UPDATE hz_org_contacts

1998: PROCEDURE upd_ocon_update
1999: (p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type)
2000: IS
2001: BEGIN
2002: UPDATE hz_org_contacts
2003: SET contact_number = p_ocon_rec.contact_number,
2004: title = p_ocon_rec.title,
2005: job_title = p_ocon_rec.job_title,
2006: job_title_code = p_ocon_rec.job_title_code,