1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_pickup_stop_id);
1113: END IF;
1114: l_stop_tab(1) := l_pickup_stop_id;
1115: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
1116: (p_stop_id_tab => l_stop_tab,
1117: p_dml_type => 'UPDATE',
1118: x_return_status => l_dbi_rs);
1119:
1632: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_pickup_stop_id);
1633: END IF;
1634: l_stop_tab.delete;
1635: l_stop_tab(1) := l_pickup_stop_id;
1636: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
1637: (p_stop_id_tab => l_stop_tab,
1638: p_dml_type => 'UPDATE',
1639: x_return_status => l_dbi_rs);
1640:
1680: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',l_dropoff_stop_id);
1681: END IF;
1682: l_stop_tab.delete;
1683: l_stop_tab(1) := l_dropoff_stop_id;
1684: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
1685: (p_stop_id_tab => l_stop_tab,
1686: p_dml_type => 'UPDATE',
1687: x_return_status => l_dbi_rs);
1688:
1806: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',p_pickup_stop_id);
1807: END IF;
1808: l_stop_tab.delete;
1809: l_stop_tab(1) := p_pickup_stop_id;
1810: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
1811: (p_stop_id_tab => l_stop_tab,
1812: p_dml_type => 'UPDATE',
1813: x_return_status => l_dbi_rs);
1814:
1883: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id -',p_dropoff_stop_id);
1884: END IF;
1885: l_stop_tab.delete;
1886: l_stop_tab(1) := p_dropoff_stop_id;
1887: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
1888: (p_stop_id_tab => l_stop_tab,
1889: p_dml_type => 'UPDATE',
1890: x_return_status => l_dbi_rs);
1891: