143: )
144:
145: as
146: ddp_person_rec hz_party_v2pub.person_rec_type;
147: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
148: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
149: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
150: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
151: ddindx binary_integer; indx binary_integer;
144:
145: as
146: ddp_person_rec hz_party_v2pub.person_rec_type;
147: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
148: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
149: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
150: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
145: as
146: ddp_person_rec hz_party_v2pub.person_rec_type;
147: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
148: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
149: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
150: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
146: ddp_person_rec hz_party_v2pub.person_rec_type;
147: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
148: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
149: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
150: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
151: ddindx binary_integer; indx binary_integer;
152: begin
153:
154: -- copy data to the local IN or IN-OUT args, if any
703: as
704: ddp_person_rec hz_party_v2pub.person_rec_type;
705: ddp_organization_rec hz_party_v2pub.organization_rec_type;
706: ddp_location_rec hz_location_v2pub.location_rec_type;
707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
704: ddp_person_rec hz_party_v2pub.person_rec_type;
705: ddp_organization_rec hz_party_v2pub.organization_rec_type;
706: ddp_location_rec hz_location_v2pub.location_rec_type;
707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
712: ddp_rel_email_rec hz_contact_point_v2pub.email_rec_type;
705: ddp_organization_rec hz_party_v2pub.organization_rec_type;
706: ddp_location_rec hz_location_v2pub.location_rec_type;
707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
712: ddp_rel_email_rec hz_contact_point_v2pub.email_rec_type;
713: ddindx binary_integer; indx binary_integer;
706: ddp_location_rec hz_location_v2pub.location_rec_type;
707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
712: ddp_rel_email_rec hz_contact_point_v2pub.email_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
712: ddp_rel_email_rec hz_contact_point_v2pub.email_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:
708: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_rec_type;
710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_rec_type;
711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_rec_type;
712: ddp_rel_email_rec hz_contact_point_v2pub.email_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:
716: -- copy data to the local IN or IN-OUT args, if any
1279: )
1280:
1281: as
1282: ddp_person_rec hz_party_v2pub.person_rec_type;
1283: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1284: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1285: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1286: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1280:
1281: as
1282: ddp_person_rec hz_party_v2pub.person_rec_type;
1283: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1284: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1285: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1286: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1281: as
1282: ddp_person_rec hz_party_v2pub.person_rec_type;
1283: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1284: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1285: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1286: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1289:
1282: ddp_person_rec hz_party_v2pub.person_rec_type;
1283: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1284: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1285: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1286: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1289:
1290: -- copy data to the local IN or IN-OUT args, if any
1585: )
1586:
1587: as
1588: ddp_person_rec hz_party_v2pub.person_rec_type;
1589: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1590: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1591: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1592: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1593: ddindx binary_integer; indx binary_integer;
1586:
1587: as
1588: ddp_person_rec hz_party_v2pub.person_rec_type;
1589: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1590: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1591: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1592: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin
1587: as
1588: ddp_person_rec hz_party_v2pub.person_rec_type;
1589: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1590: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1591: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1592: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin
1595:
1588: ddp_person_rec hz_party_v2pub.person_rec_type;
1589: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1590: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
1591: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
1592: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin
1595:
1596: -- copy data to the local IN or IN-OUT args, if any
2055: )
2056:
2057: as
2058: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2059: ddp_org_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2060: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2061: ddp_location_rec hz_location_v2pub.location_rec_type;
2062: ddp_party_site_rec hz_party_site_v2pub.party_site_rec_type;
2063: ddindx binary_integer; indx binary_integer;
2056:
2057: as
2058: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2059: ddp_org_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2060: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2061: ddp_location_rec hz_location_v2pub.location_rec_type;
2062: ddp_party_site_rec hz_party_site_v2pub.party_site_rec_type;
2063: ddindx binary_integer; indx binary_integer;
2064: begin
2432: , x_msg_data out nocopy VARCHAR2
2433: )
2434:
2435: as
2436: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
2437: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
2438: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2439: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2440: ddp_contact_point_purpose boolean;
2433: )
2434:
2435: as
2436: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
2437: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
2438: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2439: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2440: ddp_contact_point_purpose boolean;
2441: ddindx binary_integer; indx binary_integer;
2434:
2435: as
2436: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
2437: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
2438: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2439: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2440: ddp_contact_point_purpose boolean;
2441: ddindx binary_integer; indx binary_integer;
2442: begin
2435: as
2436: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;
2437: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;
2438: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2439: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2440: ddp_contact_point_purpose boolean;
2441: ddindx binary_integer; indx binary_integer;
2442: begin
2443:
2944: , x_msg_data out nocopy VARCHAR2
2945: )
2946: as
2947: ddp_person_rec hz_party_v2pub.person_rec_type;
2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2945: )
2946: as
2947: ddp_person_rec hz_party_v2pub.person_rec_type;
2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2946: as
2947: ddp_person_rec hz_party_v2pub.person_rec_type;
2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2947: ddp_person_rec hz_party_v2pub.person_rec_type;
2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2949: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2951: ddp_workphone_rec hz_contact_point_v2pub.phone_rec_type;
2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2953: ddp_homephone_rec hz_contact_point_v2pub.phone_rec_type;
2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2959: ddp_orgph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2955: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2959: ddp_orgph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2960: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
2961: ddp_orgfax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2962: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2963:
2956: ddp_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2959: ddp_orgph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2960: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
2961: ddp_orgfax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2962: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2963:
2964: begin
2957: ddp_organization_rec hz_party_v2pub.organization_rec_type;
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2959: ddp_orgph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2960: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
2961: ddp_orgfax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2962: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2963:
2964: begin
2965:
2958: ddp_location_rec hz_location_v2pub.location_rec_type;
2959: ddp_orgph_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2960: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;
2961: ddp_orgfax_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2962: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;
2963:
2964: begin
2965:
2966: -- copy data to the local IN or IN-OUT args, if any