DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 66: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;

62: --
63: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'InactivatePartySites';
64: l_debug_on BOOLEAN;
65: --
66: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;
67: l_msg_data VARCHAR2(32767);
68: l_num_warnings NUMBER :=0;
69: l_num_errors NUMBER :=0;
70: l_object_version_number NUMBER;

Line 145: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE_USE',WSH_DEBUG_SV.C_PROC_LEVEL);

141: l_object_version_number := get_party_site_rec.object_version_number;
142: l_from_party_rec.status := 'I' ;
143: --
144: IF l_debug_on THEN
145: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE_USE',WSH_DEBUG_SV.C_PROC_LEVEL);
146: END IF;
147: --
148: hz_party_site_v2pub.update_party_site
149: (

Line 148: hz_party_site_v2pub.update_party_site

144: IF l_debug_on THEN
145: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE_USE',WSH_DEBUG_SV.C_PROC_LEVEL);
146: END IF;
147: --
148: hz_party_site_v2pub.update_party_site
149: (
150: p_party_site_rec => l_from_party_rec,
151: p_object_version_number => l_object_version_number,
152: x_return_status => l_return_status,

Line 158: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);

154: x_msg_data => l_msg
155: );
156: --
157: IF l_debug_on THEN
158: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
159: END IF;
160: --
161: wsh_util_core.api_post_call
162: (

Line 1167: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;

1163: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
1164: AND hpsu.status = 'A';
1165:
1166:
1167: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;
1168: l_msg_data VARCHAR2(32767);
1169: l_num_warnings NUMBER :=0;
1170: l_num_errors NUMBER :=0;
1171: l_object_version_number NUMBER;