[Home] [Help]
1051: IF p_in_rec.caller = 'PLSQL' THEN
1052: BEGIN
1053: SELECT 'Y',wt.name into l_status,l_name
1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1055: wsh_delivery_assignments wda, wsh_delivery_details wdd
1056: WHERE wt.trip_id = l_trip_id
1057: AND wts.trip_id = wt.trip_id
1058: AND wdl.pick_up_stop_id = wts.stop_id
1059: AND wnd.delivery_id = wdl.delivery_id
1128: IF p_in_rec.caller = 'PLSQL' THEN
1129: BEGIN
1130: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1132: wsh_delivery_assignments wda, wsh_delivery_details wdd
1133: WHERE wts.stop_id = l_stop_id
1134: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1135: AND wnd.delivery_id = wdl.delivery_id
1136: AND wda.delivery_id = wnd.delivery_id
1204: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1205: IF p_in_rec.caller = 'PLSQL' THEN
1206: BEGIN
1207: SELECT 'Y',wnd.name into l_status,l_name
1208: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda, wsh_delivery_details wdd
1209: WHERE wnd.delivery_id = l_delivery_id
1210: AND wda.delivery_id = wnd.delivery_id
1211: AND wdd.delivery_detail_id = wda.delivery_detail_id
1212: AND wdd.oe_interfaced_flag = 'Y'
1278: l_entity_name := 'LPN';
1279: SELECT 'Y' into l_status
1280: FROM wsh_delivery_details
1281: WHERE delivery_detail_id in (SELECT delivery_detail_id
1282: FROM wsh_delivery_assignments
1283: WHERE parent_delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id)
1284: AND oe_interfaced_flag = 'Y'
1285: AND container_flag = 'N'
1286: AND ROWNUM = 1;