[Home] [Help]
186: AND subject_type = 'PERSON';
187:
188:
189: /*CURSOR LOCATION_EXISTS IS
190: SELECT party_site_id FROM hz_party_sites
191: WHERE party_id = x_org_party_id
192: AND location_id = x_location_id;
193:
194: CURSOR PER_LOCATION_EXISTS IS
191: WHERE party_id = x_org_party_id
192: AND location_id = x_location_id;
193:
194: CURSOR PER_LOCATION_EXISTS IS
195: SELECT party_site_id FROM hz_party_sites
196: WHERE party_id = x_per_party_id
197: AND location_id = x_location_id;
198:
199: CURSOR CHECK_PSITE_EXISTS IS
196: WHERE party_id = x_per_party_id
197: AND location_id = x_location_id;
198:
199: CURSOR CHECK_PSITE_EXISTS IS
200: SELECT party_site_id FROM hz_party_sites
201: WHERE party_id = x_party_rel_party_id
202: AND location_id = x_location_id;
203: */
204: CURSOR phone_exists (party_id_in number, phone_number VARCHAR2, country_code in VARCHAR2, area_code in VARCHAR2,
419: AND subject_id = x_per_party_id
420: AND relationship_code = 'CONTACT_OF';
421:
422: CURSOR LOCATION_EXISTS IS
423: SELECT party_site_id FROM hz_party_sites
424: WHERE party_id = x_org_party_id
425: AND location_id = x_location_id;
426:
427: CURSOR PER_LOCATION_EXISTS IS
424: WHERE party_id = x_org_party_id
425: AND location_id = x_location_id;
426:
427: CURSOR PER_LOCATION_EXISTS IS
428: SELECT party_site_id FROM hz_party_sites
429: WHERE party_id = x_per_party_id
430: AND location_id = x_location_id;
431:
432: CURSOR CHECK_PSITE_EXISTS IS
429: WHERE party_id = x_per_party_id
430: AND location_id = x_location_id;
431:
432: CURSOR CHECK_PSITE_EXISTS IS
433: SELECT party_site_id FROM hz_party_sites
434: WHERE party_id = x_party_rel_party_id
435: AND location_id = x_location_id;
436:
437: CURSOR phone_exists (x_hz_party_id number) IS
952: x_return_status := null;
953: x_msg_count := null;
954: x_msg_data := null;
955: x_party_site_number := null;
956: select hz_party_sites_s.nextval into x_party_site_id from dual;
957: if x_gen_party_site_number = 'N' then
958: select hz_party_site_number_s.nextval into x_party_site_number from dual;
959: end if;
960:
1065: x_return_status := null;
1066: x_msg_count := null;
1067: x_msg_data := null;
1068: x_party_site_number := null;
1069: select hz_party_sites_s.nextval into x_party_site_id from dual;
1070: if x_gen_party_site_number = 'N' then
1071: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1072: end if;
1073:
1528: x_return_status := null;
1529: x_msg_count := null;
1530: x_msg_data := null;
1531: x_party_site_number := null;
1532: select hz_party_sites_s.nextval into x_party_site_id from dual;
1533: if x_gen_party_site_number = 'N' then
1534: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1535: end if;
1536:
1863: and nvl(cp.phone_area_code, nvl(p_ph_area_code, 'x')) = nvl(p_ph_area_code, 'x');
1864:
1865: cursor c_address_country is
1866: select max(psite.party_id)
1867: from hz_party_sites psite,
1868: hz_locations loc,
1869: hz_parties party
1870: where psite.location_id = loc.location_id
1871: and loc.address1 = p_address1
1979: x_per_party_id number;
1980: L_API_NAME CONSTANT VARCHAR2(30) := ' party_echeck';
1981:
1982: cursor c_address_country is
1983: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
1984: hz_parties party
1985: where psite.location_id = loc.location_id
1986: and loc.address1 = p_address1
1987: and loc.country = p_country
1988: and party.customer_key = l_party_key
1989: and psite.party_id = party.party_id;
1990:
1991: cursor c_country is
1992: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
1993: hz_parties party
1994: where psite.location_id = loc.location_id
1995: and loc.country = p_country
1996: and party.customer_key = l_party_key
2311:
2312:
2313: cursor c_addr_ps is
2314: select max(loc.location_id)
2315: from hz_party_sites ps, hz_locations loc
2316: where ps.party_id = p_party_id
2317: and ps.location_id = loc.location_id
2318: and loc.address_key = l_address_key
2319: and loc.country = p_country