12970: person_rec hz_party_v2pub.person_rec_type;
12971: location_rec hz_location_v2pub.location_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12974: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
12975: email_rec hz_contact_point_v2pub.email_rec_type;
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12971: location_rec hz_location_v2pub.location_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12974: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
12975: email_rec hz_contact_point_v2pub.email_rec_type;
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12974: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
12975: email_rec hz_contact_point_v2pub.email_rec_type;
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12980: telex_rec hz_contact_point_v2pub.telex_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12974: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
12975: email_rec hz_contact_point_v2pub.email_rec_type;
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12980: telex_rec hz_contact_point_v2pub.telex_rec_type;
12981: web_rec hz_contact_point_v2pub.web_rec_type;
12975: email_rec hz_contact_point_v2pub.email_rec_type;
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12980: telex_rec hz_contact_point_v2pub.telex_rec_type;
12981: web_rec hz_contact_point_v2pub.web_rec_type;
12982:
12983:
12976: phone_rec hz_contact_point_v2pub.phone_rec_type;
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12980: telex_rec hz_contact_point_v2pub.telex_rec_type;
12981: web_rec hz_contact_point_v2pub.web_rec_type;
12982:
12983:
12984: cursor c_list_entries is
12977: fax_rec hz_contact_point_v2pub.phone_rec_type;
12978: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
12979: edi_rec hz_contact_point_v2pub.edi_rec_type;
12980: telex_rec hz_contact_point_v2pub.telex_rec_type;
12981: web_rec hz_contact_point_v2pub.web_rec_type;
12982:
12983:
12984: cursor c_list_entries is
12985: select list_entry_id from ams_list_entries where list_header_id = p_list_header_id