APPS.WSH_CARRIER_ADDRESS_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 51: l_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;

47:
48: -- Declarations for 'GENERAL_MAIL_TO' type site.
49: l_address_party_site_id NUMBER;
50: l_site_use_type_id NUMBER;
51: l_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
52: l_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
53: l_party_site_id NUMBER;
54: l_party_site_use_id NUMBER;
55: l_party_site_NUMBER VARCHAR2(100);

Line 52: l_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;

48: -- Declarations for 'GENERAL_MAIL_TO' type site.
49: l_address_party_site_id NUMBER;
50: l_site_use_type_id NUMBER;
51: l_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
52: l_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
53: l_party_site_id NUMBER;
54: l_party_site_use_id NUMBER;
55: l_party_site_NUMBER VARCHAR2(100);
56:

Line 151: -- TCA API: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE.

147: x_location_id := l_loc_id;
148:
149: ---------------------------------------------------
150: -- Create the Site Information by calling the
151: -- TCA API: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE.
152: ---------------------------------------------------
153:
154: -- Put information into l_site_rec.
155:

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

168: --
169: -- Debug Statements
170: --
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Create_Party_Site',WSH_DEBUG_SV.C_PROC_LEVEL);
173: END IF;
174: --
175:
176: HZ_PARTY_SITE_V2PUB.Create_Party_Site

Line 176: HZ_PARTY_SITE_V2PUB.Create_Party_Site

172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Create_Party_Site',WSH_DEBUG_SV.C_PROC_LEVEL);
173: END IF;
174: --
175:
176: HZ_PARTY_SITE_V2PUB.Create_Party_Site
177: (
178: p_init_msg_list => FND_API.G_TRUE,
179: p_party_site_rec => l_site_rec,
180: x_party_site_id => l_party_site_id,

Line 201: -- TCA API: hz_party_site_v2pub.create_party_site_use.

197:
198:
199: --------------------------------------------------------
200: -- Create the Party Site Use Information by calling the
201: -- TCA API: hz_party_site_v2pub.create_party_site_use.
202: --------------------------------------------------------
203:
204: -- Put the information into site_rec.
205: -- l_site_use_rec.begin_date := trunc(SYSDATE);

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

212: --
213: -- Debug Statements
214: --
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use',WSH_DEBUG_SV.C_PROC_LEVEL);
217: END IF;
218: --
219:
220: HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use

Line 220: HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use

216: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use',WSH_DEBUG_SV.C_PROC_LEVEL);
217: END IF;
218: --
219:
220: HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use
221: (
222: p_init_msg_list => FND_API.G_TRUE,
223: p_party_site_use_rec => l_site_use_rec,
224: x_party_site_use_id => l_party_site_use_id,

Line 295: l_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;

291: )
292:
293: is
294:
295: l_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
296: l_position NUMBER;
297: l_procedure VARCHAR2(100);
298: l_loc_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
299: l_return_status VARCHAR2(100);

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

386: --
387: -- Debug Statements
388: --
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Update_Party_Site',WSH_DEBUG_SV.C_PROC_LEVEL);
391: END IF;
392: --
393:
394: HZ_PARTY_SITE_V2PUB.Update_Party_Site

Line 394: HZ_PARTY_SITE_V2PUB.Update_Party_Site

390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_SITE_V2PUB.Update_Party_Site',WSH_DEBUG_SV.C_PROC_LEVEL);
391: END IF;
392: --
393:
394: HZ_PARTY_SITE_V2PUB.Update_Party_Site
395: (
396: p_init_msg_list => FND_API.G_TRUE,
397: p_party_site_rec => l_site_rec,
398: p_object_version_number => l_site_object_number,