APPS.WMS_SHIPPING_INTERFACE_GRP dependencies on WMS_WP_WAVE_LINES

Line 891: (select 1 from wms_wp_wave_lines

887: l_return varchar2(1):='N';
888: begin
889: begin
890: select 'Y' into l_return from dual where exists
891: (select 1 from wms_wp_wave_lines
892: where delivery_detail_id = p_delivery_detail_id
893: and nvl(remove_from_wave_flag, 'N') <> 'Y');
894: exception
895: when no_data_found then

Line 924: from wms_wp_wave_lines wwl, wsh_delivery_details wdd

920: ,wwl.planned_fill_rate
921: ,wwl.crossdock_quantity
922: ,wwl.crossdock_uom
923: ,wdd.requested_quantity --needed to calculate new crossdock quantity...
924: from wms_wp_wave_lines wwl, wsh_delivery_details wdd
925: where wdd.delivery_detail_id = p_orig_delivery_detail_id
926: and wdd.delivery_detail_id = wwl.delivery_detail_id
927: and wwl.organization_id = wdd.organization_id
928: and nvl(remove_from_wave_flag, 'N') <> 'Y';

Line 939: update wms_wp_wave_lines

935: --keep as much xdock qty on original wave line; only put some on new line if old line requestd quantity is less than old line xdock quantity
936: l_new_crossdock_quantity:=0;
937: if nvl(l_split_from_wave_line.crossdock_quantity,0)>l_split_from_wave_line.crossdock_quantity then
938: l_new_crossdock_quantity := l_split_from_wave_line.crossdock_quantity - l_split_from_wave_line.requested_quantity;
939: update wms_wp_wave_lines
940: set crossdock_quantity = requested_quantity
941: where wave_line_id = l_split_from_wave_line.wave_line_id;
942: end if;
943:

Line 945: insert into wms_wp_wave_lines

941: where wave_line_id = l_split_from_wave_line.wave_line_id;
942: end if;
943:
944: --copy relevant information into new wave line
945: insert into wms_wp_wave_lines
946: (WAVE_HEADER_ID,
947: WAVE_LINE_ID,
948: WAVE_LINE_SOURCE,
949: WAVE_LINE_STATUS,

Line 964: WMS_WP_WAVE_LINES_S.NEXTVAL,

960: crossdock_quantity,
961: crossdock_uom)
962: values
963: (l_split_from_wave_line.wave_header_id,
964: WMS_WP_WAVE_LINES_S.NEXTVAL,
965: l_split_from_wave_line.WAVE_LINE_SOURCE,
966: l_split_from_wave_line.WAVE_LINE_STATUS,
967: fnd_global.user_id,
968: sysdate,