APPS.WSH_CARRIER_CONTACT_INFO_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 55: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

51: -- Declarations for Contact Point Creation for the above Relation.
52: ------------------------------------------------------------------
53:
54: l_contact_point_id NUMBER;
55: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
56: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
57:
58: --
59: l_debug_on BOOLEAN;

Line 56: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

52: ------------------------------------------------------------------
53:
54: l_contact_point_id NUMBER;
55: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
56: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
57:
58: --
59: l_debug_on BOOLEAN;
60: --

Line 126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);

122: --
123: -- Debug Statements
124: --
125: IF l_debug_on THEN
126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
127: END IF;
128: --
129:
130: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point

Line 130: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point

126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
127: END IF;
128: --
129:
130: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point
131: (
132: p_init_msg_list => FND_API.G_TRUE,
133: p_contact_point_rec => l_contact_points_rec_type,
134: p_phone_rec => l_phone_rec_type,

Line 198: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

194: X_PROCEDURE OUT NOCOPY VARCHAR2,
195: X_SQLERR OUT NOCOPY VARCHAR2,
196: X_SQL_CODE OUT NOCOPY VARCHAR2 ) IS
197:
198: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
199: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
200: l_return_status varchar2(100);
201: l_msg_count number;
202: l_msg_data varchar2(2000);

Line 199: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

195: X_SQLERR OUT NOCOPY VARCHAR2,
196: X_SQL_CODE OUT NOCOPY VARCHAR2 ) IS
197:
198: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
199: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
200: l_return_status varchar2(100);
201: l_msg_count number;
202: l_msg_data varchar2(2000);
203: l_exception_msg varchar2(1000);

Line 293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);

289: --
290: -- Debug Statements
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
294: END IF;
295: --
296:
297: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point

Line 297: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point

293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
294: END IF;
295: --
296:
297: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point
298: (
299: p_init_msg_list => FND_API.G_TRUE,
300: p_contact_point_rec => l_contact_points_rec_type,
301: p_phone_rec => l_phone_rec_type,