APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 73: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;

69: --
70: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'InactivatePartySites';
71: l_debug_on BOOLEAN;
72: --
73: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;
74: l_msg_data VARCHAR2(32767);
75: l_num_warnings NUMBER :=0;
76: l_num_errors NUMBER :=0;
77: l_object_version_number NUMBER;

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

148: l_object_version_number := get_party_site_rec.object_version_number;
149: l_from_party_rec.status := 'I' ;
150: --
151: IF l_debug_on THEN
152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE_USE',WSH_DEBUG_SV.C_PROC_LEVEL);
153: END IF;
154: --
155: hz_party_site_v2pub.update_party_site
156: (

Line 155: hz_party_site_v2pub.update_party_site

151: IF l_debug_on THEN
152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE_USE',WSH_DEBUG_SV.C_PROC_LEVEL);
153: END IF;
154: --
155: hz_party_site_v2pub.update_party_site
156: (
157: p_party_site_rec => l_from_party_rec,
158: p_object_version_number => l_object_version_number,
159: x_return_status => l_return_status,

Line 165: 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);

161: x_msg_data => l_msg
162: );
163: --
164: IF l_debug_on THEN
165: 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);
166: END IF;
167: --
168: wsh_util_core.api_post_call
169: (

Line 1174: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;

1170: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
1171: AND hpsu.status = 'A';
1172:
1173:
1174: l_from_party_rec hz_party_site_v2pub.party_site_rec_type;
1175: l_msg_data VARCHAR2(32767);
1176: l_num_warnings NUMBER :=0;
1177: l_num_errors NUMBER :=0;
1178: l_object_version_number NUMBER;