[Home] [Help]
1005: IF p_in_rec.caller = 'PLSQL' THEN
1006: BEGIN
1007: SELECT 'Y',wt.name into l_status,l_name
1008: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1009: wsh_delivery_assignments wda, wsh_delivery_details wdd
1010: WHERE wt.trip_id = l_trip_id
1011: AND wts.trip_id = wt.trip_id
1012: AND wdl.pick_up_stop_id = wts.stop_id
1013: AND wnd.delivery_id = wdl.delivery_id
1082: IF p_in_rec.caller = 'PLSQL' THEN
1083: BEGIN
1084: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1085: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1086: wsh_delivery_assignments wda, wsh_delivery_details wdd
1087: WHERE wts.stop_id = l_stop_id
1088: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1089: AND wnd.delivery_id = wdl.delivery_id
1090: AND wda.delivery_id = wnd.delivery_id
1158: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1159: IF p_in_rec.caller = 'PLSQL' THEN
1160: BEGIN
1161: SELECT 'Y',wnd.name into l_status,l_name
1162: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda, wsh_delivery_details wdd
1163: WHERE wnd.delivery_id = l_delivery_id
1164: AND wda.delivery_id = wnd.delivery_id
1165: AND wdd.delivery_detail_id = wda.delivery_detail_id
1166: AND wdd.oe_interfaced_flag = 'Y'
1232: l_entity_name := 'LPN';
1233: SELECT 'Y' into l_status
1234: FROM wsh_delivery_details
1235: WHERE delivery_detail_id in (SELECT delivery_detail_id
1236: FROM wsh_delivery_assignments
1237: WHERE parent_delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id)
1238: AND oe_interfaced_flag = 'Y'
1239: AND container_flag = 'N'
1240: AND ROWNUM = 1;