DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PUB dependencies on HZ_PARTY_SITE_V2PUB

Line 38: px_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

34: p_ps_id IN NUMBER,
35: p_ps_os IN VARCHAR2,
36: p_ps_osr IN VARCHAR2,
37: p_create_or_update IN VARCHAR2 := 'C',
38: px_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
39: );
40:
41: -- PRIVATE PROCEDURE assign_party_site_rec
42: --

Line 75: px_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

71: p_ps_id IN NUMBER,
72: p_ps_os IN VARCHAR2,
73: p_ps_osr IN VARCHAR2,
74: p_create_or_update IN VARCHAR2 := 'C',
75: px_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
76: ) IS
77: BEGIN
78: px_party_site_rec.party_site_id := p_ps_id;
79: px_party_site_rec.party_id := p_party_id;

Line 143: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;

139: px_parent_osr IN OUT NOCOPY VARCHAR2,
140: px_parent_obj_type IN OUT NOCOPY VARCHAR2
141: ) IS
142: l_debug_prefix VARCHAR2(30);
143: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
144: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
145: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
146: l_party_site_id NUMBER;
147: l_ps_number VARCHAR2(30);

Line 145: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;

141: ) IS
142: l_debug_prefix VARCHAR2(30);
143: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
144: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
145: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
146: l_party_site_id NUMBER;
147: l_ps_number VARCHAR2(30);
148: l_location_id NUMBER;
149: l_valid_obj BOOLEAN;

Line 300: HZ_PARTY_SITE_V2PUB.create_party_site(

296: p_ps_osr => x_party_site_osr,
297: px_party_site_rec => l_party_site_rec
298: );
299:
300: HZ_PARTY_SITE_V2PUB.create_party_site(
301: p_party_site_rec => l_party_site_rec,
302: x_party_site_id => x_party_site_id,
303: x_party_site_number => l_ps_number,
304: x_return_status => x_return_status,

Line 723: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;

719: x_party_site_osr OUT NOCOPY VARCHAR2,
720: p_parent_os IN VARCHAR2
721: )IS
722: l_debug_prefix VARCHAR2(30);
723: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
724: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
725: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
726: l_ps_id NUMBER;
727: l_ps_ovn NUMBER;

Line 725: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;

721: )IS
722: l_debug_prefix VARCHAR2(30);
723: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
724: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
725: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
726: l_ps_id NUMBER;
727: l_ps_ovn NUMBER;
728: l_loc_ovn NUMBER;
729: l_location_id NUMBER;

Line 810: HZ_PARTY_SITE_V2PUB.update_party_site(

806: p_create_or_update => 'U',
807: px_party_site_rec => l_party_site_rec
808: );
809:
810: HZ_PARTY_SITE_V2PUB.update_party_site(
811: p_party_site_rec => l_party_site_rec,
812: p_object_version_number => l_ps_ovn,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,