DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT_W dependencies on HZ_CONTACT_POINT_V2PUB

Line 147: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

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;

Line 148: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 149: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;

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:

Line 150: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 707: ddp_org_phone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 708: ddp_org_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;

Line 709: ddp_rel_workphone_rec hz_contact_point_v2pub.phone_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;

Line 710: ddp_rel_homephone_rec hz_contact_point_v2pub.phone_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;
714: begin

Line 711: ddp_rel_fax_rec hz_contact_point_v2pub.phone_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
715:

Line 712: ddp_rel_email_rec hz_contact_point_v2pub.email_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:
716: -- copy data to the local IN or IN-OUT args, if any

Line 1283: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 1284: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 1285: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;

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:

Line 1286: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

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

Line 1589: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

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;

Line 1590: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 1591: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;

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:

Line 1592: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 2059: ddp_org_workphone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 2060: ddp_org_fax_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 2436: ddp_work_phone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 2437: ddp_home_phone_rec hz_contact_point_v2pub.phone_rec_type;

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;

Line 2438: ddp_fax_rec hz_contact_point_v2pub.phone_rec_type;

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

Line 2439: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

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:

Line 2948: ddp_email_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

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;

Line 2949: ddp_email_rec hz_contact_point_v2pub.email_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;

Line 2950: ddp_workph_contact_point_rec hz_contact_point_v2pub.contact_point_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;

Line 2951: ddp_workphone_rec hz_contact_point_v2pub.phone_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;

Line 2952: ddp_homeph_contact_point_rec hz_contact_point_v2pub.contact_point_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;

Line 2953: ddp_homephone_rec hz_contact_point_v2pub.phone_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;

Line 2954: ddp_fax_contact_point_rec hz_contact_point_v2pub.contact_point_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;

Line 2955: ddp_fax_rec hz_contact_point_v2pub.phone_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;

Line 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:

Line 2960: ddp_org_phone_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:
2964: begin

Line 2961: ddp_orgfax_contact_point_rec hz_contact_point_v2pub.contact_point_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
2965:

Line 2962: ddp_org_fax_rec hz_contact_point_v2pub.phone_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:
2966: -- copy data to the local IN or IN-OUT args, if any