APPS.WSH_INTEGRATION dependencies on ISC_DBI_CHANGE_LOG_PKG

Line 1105: x_dbi_id_tab OUT NOCOPY ISC_DBI_CHANGE_LOG_PKG.log_tab_type,

1101:
1102: -- 1.Convert WSH Table of ids to DBI Table of ids
1103: PROCEDURE WSH_ID_TAB_TO_DBI_ID_TAB
1104: (p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type,
1105: x_dbi_id_tab OUT NOCOPY ISC_DBI_CHANGE_LOG_PKG.log_tab_type,
1106: x_return_status OUT NOCOPY VARCHAR2
1107: ) IS
1108:
1109: --

Line 1175: l_dbi_detail_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;

1171: (p_delivery_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
1172: p_dml_type IN VARCHAR2,
1173: x_return_status OUT NOCOPY VARCHAR2) IS
1174:
1175: l_dbi_detail_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;
1176: --
1177: l_debug_on BOOLEAN;
1178: --
1179: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DBI_UPDATE_DETAIL_LOG';BEGIN

Line 1220: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log

1216: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1217: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1218: END IF;
1219: --
1220: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log
1221: (p_detail_list => l_dbi_detail_list,
1222: p_dml_type => p_dml_type,
1223: x_return_status => x_return_status
1224: );

Line 1285: l_dbi_stop_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;

1281: (p_stop_id_tab IN WSH_UTIL_CORE.id_tab_type,
1282: p_dml_type IN VARCHAR2,
1283: x_return_status OUT NOCOPY VARCHAR2) IS
1284:
1285: l_dbi_stop_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;
1286: --
1287: l_debug_on BOOLEAN;
1288: --
1289: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'DBI_UPDATE_TRIP_STOP_LOG';

Line 1331: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log

1327: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1328: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1329: END IF;
1330: --
1331: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log
1332: (p_stop_list => l_dbi_stop_list,
1333: p_dml_type => p_dml_type,
1334: x_return_status => x_return_status
1335: );