[Home] [Help]
65: CURSOR c1 IS
66: SELECT 'Y'
67: FROM hz_relationships
68: WHERE relationship_id = p_rel_id
69: AND object_table_name = 'HZ_PARTIES'
70: AND object_id = p_party_id
71: AND directional_flag = 'F';
72: ret VARCHAR2(1);
73: BEGIN
254: SELECT relationship_id,
255: relationship_code
256: FROM hz_relationships
257: WHERE subject_type = 'PERSON'
258: AND subject_table_name= 'HZ_PARTIES'
259: AND subject_id = p_pers_id
260: AND object_type = 'ORGANIZATION'
261: AND object_table_name = 'HZ_PARTIES'
262: AND object_id = p_party_id
257: WHERE subject_type = 'PERSON'
258: AND subject_table_name= 'HZ_PARTIES'
259: AND subject_id = p_pers_id
260: AND object_type = 'ORGANIZATION'
261: AND object_table_name = 'HZ_PARTIES'
262: AND object_id = p_party_id
263: AND directional_flag = 'F';
264: ret NUMBER := -9999;
265: BEGIN
276: (p_party_id IN NUMBER)
277: RETURN VARCHAR2 IS
278: CURSOR c_type IS
279: SELECT party_type
280: FROM hz_parties
281: WHERE party_id = p_party_id;
282: ret VARCHAR2(30);
283: BEGIN
284: OPEN c_type;
290: FUNCTION party_or_site_from_cpt
291: ---------------------------------------------------------------------------------------
292: -- RETURN party_site_id if contact_point at PS
293: -- + flag x_type to 'HZ_PARTY_SITES'
294: -- RETURN party_id if contact_point at HZ_PARTIES
295: -- + flag x_type to 'ORGANIZATION' if the party is type 'ORGANIZATION'
296: -- flag x_type to 'PARTY_RELATIONSHIP' if the party is type 'PARTY_RELATIONSHIP'
297: -- RETURN -9999 if contact_point not found
298: ---------------------------------------------------------------------------------------
310: OPEN c_contact_point;
311: FETCH c_contact_point INTO x_type, ret;
312: IF c_contact_point%NOTFOUND THEN
313: ret := -9999;
314: IF x_type = 'HZ_PARTIES' THEN
315: x_type := party_type(ret);
316: END IF;
317: END IF;
318: CLOSE c_contact_point;