30: p_party_id IN NUMBER,
31: p_party_site_id IN OUT NOCOPY NUMBER,
32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
37: );
38:
31: p_party_site_id IN OUT NOCOPY NUMBER,
32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
37: );
38:
39:
32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
37: );
38:
39:
40: procedure UPDATE_ROW (
66: p_party_id IN NUMBER,
67: p_party_site_id IN OUT NOCOPY NUMBER,
68: p_party_type IN VARCHAR2,
69: p_last_update_date IN OUT NOCOPY DATE,
70: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
71: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
72: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
73: );
74:
67: p_party_site_id IN OUT NOCOPY NUMBER,
68: p_party_type IN VARCHAR2,
69: p_last_update_date IN OUT NOCOPY DATE,
70: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
71: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
72: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
73: );
74:
75: END igs_pe_person_addr_pkg;
68: p_party_type IN VARCHAR2,
69: p_last_update_date IN OUT NOCOPY DATE,
70: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
71: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
72: p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
73: );
74:
75: END igs_pe_person_addr_pkg;