APPS.CS_SRCONTACT_PKG dependencies on HZ_PARTIES

Line 377: -- Associate party has to exist in hz_parties only. there may

373: -- Date Name Desc
374: -------- ----------- -----------------------------------------------------------
375: -- 04/15/05 smisra Created
376: -- 08/10/05 smisra Added following validations
377: -- Associate party has to exist in hz_parties only. there may
378: -- not be any relationship with SR customer
379: -- Primary contact can not have end date value
380: -- 10/05/05 smisra Change Request: 4645490
381: -- Raise error is party_id, contact_type or party_role_code

Line 396: l_status hz_parties.status % TYPE;

392: ) IS
393: l_api_name_full VARCHAR2(61);
394: l_employee_name VARCHAR2(80);
395: l_party_type cs_hz_sr_contact_points.contact_type % TYPE;
396: l_status hz_parties.status % TYPE;
397: p_mode VARCHAR2(30);
398: l_today DATE;
399: BEGIN
400: l_api_name_full := 'CS_SRCONTACT_PKG.validate_contact';

Line 523: -- hz_parties table

519: ELSIF NVL(p_new_contact_rec.party_role_code,'CONTACT') <> 'CONTACT'
520: -- Else condition means contact type is either person, org or relationship
521: -- so if party role is CONTACT then do not validation relationship between
522: -- SR customer and contact party. contact party should merely exist in
523: -- hz_parties table
524: THEN
525: CS_SERVICEREQUEST_UTIL.get_party_details
526: ( p_party_id => p_new_contact_rec.party_id
527: , x_party_type => l_party_type

Line 1401: from HZ_PARTIES where party_id = l_primary_contact_id;

1397: from PER_ALL_PEOPLE_F where person_id = l_primary_contact_id;
1398: ELSIF l_primary_contact_type = 'PERSON'
1399: THEN
1400: select PERSON_LAST_NAME,PERSON_FIRST_NAME into l_last_name,l_first_name
1401: from HZ_PARTIES where party_id = l_primary_contact_id;
1402: ELSIF l_primary_contact_type = 'PARTY_RELATIONSHIP'
1403: THEN
1404: select PERSON_LAST_NAME,PERSON_FIRST_NAME into l_last_name,l_first_name
1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r

Line 1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r

1401: from HZ_PARTIES where party_id = l_primary_contact_id;
1402: ELSIF l_primary_contact_type = 'PARTY_RELATIONSHIP'
1403: THEN
1404: select PERSON_LAST_NAME,PERSON_FIRST_NAME into l_last_name,l_first_name
1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r
1406: where r.party_id = l_primary_contact_id
1407: and r.subject_id = p.party_id
1408: and r.subject_type = 'PERSON'
1409: and r.subject_table_name = 'HZ_PARTIES'

Line 1409: and r.subject_table_name = 'HZ_PARTIES'

1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r
1406: where r.party_id = l_primary_contact_id
1407: and r.subject_id = p.party_id
1408: and r.subject_type = 'PERSON'
1409: and r.subject_table_name = 'HZ_PARTIES'
1410: and r.directional_flag = 'F';
1411: END IF;
1412: IF l_prm_contact_mand = 'Y'
1413: THEN