APPS.WSH_OTM_SYNC_REF_DATA_PKG dependencies on WSH_OTM_SYNC_REF_DATA_PKG

Line 1: PACKAGE BODY WSH_OTM_SYNC_REF_DATA_PKG AS

1: PACKAGE BODY WSH_OTM_SYNC_REF_DATA_PKG AS
2: /* $Header: WSHTMTHB.pls 120.0.12000000.1 2007/01/25 16:15:16 amohamme noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_SYNC_REF_DATA_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_SYNC_REF_DATA_PKG';

1: PACKAGE BODY WSH_OTM_SYNC_REF_DATA_PKG AS
2: /* $Header: WSHTMTHB.pls 120.0.12000000.1 2007/01/25 16:15:16 amohamme noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_SYNC_REF_DATA_PKG';
5:
6: PROCEDURE is_ref_data_send_reqd(p_entity_id IN NUMBER,
7: p_parent_entity_id IN VARCHAR2,
8: p_entity_type IN VARCHAR2,

Line 104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA',WSH_DEBUG_SV.C_PROC_LEVEL);

100: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id IS NULL');
101: END IF;
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA',WSH_DEBUG_SV.C_PROC_LEVEL);
105: END IF;
106: insert_row_sync_ref_data(p_entity_id => p_entity_id ,
107: p_parent_entity_id => p_parent_entity_id,
108: p_entity_type => p_entity_type,

Line 124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);

120: x_num_warnings => l_num_warnings,
121: x_num_errors => l_num_errors);
122:
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: insert_row_sync_ref_data_log (p_sync_ref_id => l_sync_ref_id,
127: p_transmission_id => p_transmission_id,
128: p_entity_type => p_entity_type,

Line 150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);

146: IF p_entity_updated_date >= l_last_sent_date OR
147: to_number(sysdate - l_last_sent_date) <= 1 THEN
148:
149: IF l_debug_on THEN
150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);
151: END IF;
152:
153: insert_row_sync_ref_data_log (p_sync_ref_id => l_sync_ref_id,
154: p_transmission_id => p_transmission_id,

Line 551: END WSH_OTM_SYNC_REF_DATA_PKG;

547: END IF;
548:
549: END insert_row_sync_ref_data_log;
550:
551: END WSH_OTM_SYNC_REF_DATA_PKG;