[Home] [Help]
50: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
51: EXIT records_loop;
52: END IF;
53:
54: IF (NVL(p_changed_attributes(l_counter).released_status,'@') <> FND_API.G_MISS_CHAR) THEN
55:
56: -- pickable lines should have status updated to 'R'.
57: -- non-pickable (non-reservable) lines should have status updated to 'X'.
58: IF l_debug_on THEN
601: --End of ECO 4524041
602:
603: -- bug 2662327: overship tolerance fix to update line_set_id for all delivery lines if it is populated
604: -- assumption: line_set_id will be populated only when OM splits order line.
605: IF (p_changed_attributes(l_counter).source_line_set_id <> FND_API.G_MISS_NUM)
606: AND ( (c.source_line_set_id IS NULL)
607: OR (p_changed_attributes(l_counter).source_line_set_id <> c.source_line_set_id))
608: AND (l_prev_source_line_id <> p_changed_attributes(l_counter).original_source_line_id) THEN
609: UPDATE WSH_DELIVERY_DETAILS
636: -- details to new order line irrespective of whatever quantity OM passes. If we rely on
637: -- OM quantity there could be some precision loss and we may have orphan pending details
638: -- still attached to original order line.
639: IF ((p_interface_flag = 'Y') AND
640: ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
641: (p_changed_attributes(l_counter).top_model_line_id IS NULL)))
642: THEN
643: OPEN c_req_qty(p_source_code,
644: p_changed_attributes(l_counter).original_source_line_id);
733: --wrudge
734: -- Bug 2540015
735: IF (c.released_status = 'S') THEN
736: IF (p_interface_flag = 'Y') THEN
737: IF ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
738: (p_changed_attributes(l_counter).top_model_line_id IS NULL)) OR
739: -- the following condition added for bug 3858111(front port of bug 3808946)
740: ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
741: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
736: IF (p_interface_flag = 'Y') THEN
737: IF ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
738: (p_changed_attributes(l_counter).top_model_line_id IS NULL)) OR
739: -- the following condition added for bug 3858111(front port of bug 3808946)
740: ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
741: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
742: AND p_changed_attributes(l_counter).top_model_line_id = p_changed_attributes(l_counter).ato_line_id )
743: THEN
744: IF l_debug_on THEN
1756: from wsh_delivery_details
1757: WHERE source_code = p_source_code
1758: AND source_line_id = p_attributes_rec.source_line_id
1759: AND container_flag = 'N'
1760: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
1761: delivery_detail_id, p_attributes_rec.delivery_detail_id );
1762:
1763: cursor c_get_tpdetails IS
1764: select organization_id, carrier_id, ship_method_code, ignore_for_planning
1765: from wsh_delivery_details
1766: WHERE source_code = p_source_code
1767: AND source_line_id = p_attributes_rec.source_line_id
1768: AND container_flag = 'N'
1769: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
1770: delivery_detail_id, p_attributes_rec.delivery_detail_id )
1771: AND nvl(ignore_for_planning,'N')<>'Y'
1772: AND rownum=1;
1773:
1930:
1931: -- bug#6407943 (Begin):
1932: --When there is a change in org value on sale order line, needs to change
1933: --item attributes which are org dependent .
1934: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM
1935: AND p_attributes_rec.ship_from_org_id <> l_organization_id
1936: AND p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM
1937: AND p_attributes_rec.ship_from_org_id IS NOT NULL THEN
1938: --{
1932: --When there is a change in org value on sale order line, needs to change
1933: --item attributes which are org dependent .
1934: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM
1935: AND p_attributes_rec.ship_from_org_id <> l_organization_id
1936: AND p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM
1937: AND p_attributes_rec.ship_from_org_id IS NOT NULL THEN
1938: --{
1939: OPEN c_specific_item_info(l_inventory_item_id, p_attributes_rec.ship_from_org_id);
1940: FETCH C_SPECIFIC_ITEM_INFO INTO l_haz_class_id, l_primary_uom_code, l_weight_uom, l_unit_weight,
1976: --}
1977: END IF;
1978: -- bug#6407943 (end):Needs to change items org dependent attributes when org changes.
1979:
1980: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
1981:
1982: WSH_UTIL_CORE.GET_LOCATION_ID('ORG', p_attributes_rec.ship_from_org_id,
1983: l_ship_from_location_id, x_return_status);
1984:
2004: x_item_id => l_inventory_item_id,
2005: x_organization_id => l_organization_id,
2006: x_pickable_flag => l_pickable_flag);
2007:
2008: IF p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
2009:
2010: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.ship_to_org_id,
2011: l_ship_to_location_id, x_return_status);
2012:
2019:
2020: END IF;
2021:
2022: IF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
2023: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
2024: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.deliver_to_org_id,
2025: l_deliver_to_location_id, x_return_status);
2026:
2027: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2033:
2034: END IF;
2035:
2036: IF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
2037: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2038: --
2039: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.intmed_ship_to_org_id,
2040: l_intmed_ship_to_location_id, x_return_status);
2041:
2050:
2051: IF (l_deliver_to_location_id is NULL) AND (l_ship_to_location_id IS NOT NULL) THEN
2052: l_deliver_to_location_id := l_ship_to_location_id;
2053: ELSIF (l_deliver_to_location_id is NULL) AND (l_ship_to_location_id IS NULL)
2054: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2055: --
2056: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.ship_to_org_id,
2057: l_deliver_to_location_id, x_return_status);
2058:
2066: END IF;
2067: --OTM R12 Org-Specific Start
2068: IF l_gc3_is_installed = 'Y' THEN
2069: IF ( p_attributes_rec.ship_from_org_id IS NOT NULL AND
2070: p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2071: IF l_debug_on THEN
2072: WSH_DEBUG_SV.log(l_module_name,'Before call to WSH_SHIPPING_PARAMS_PVT.Get to parameter values for Org',
2073: p_attributes_rec.ship_from_org_id );
2074: END IF;
2102:
2103: --1. check for updates to org, carrier, smc and based on
2104: -- that set ignore_for_planning
2105:
2106: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2107: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2108: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2109: AND b_ignore )
2110: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2103: --1. check for updates to org, carrier, smc and based on
2104: -- that set ignore_for_planning
2105:
2106: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2107: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2108: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2109: AND b_ignore )
2110: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2111:
2104: -- that set ignore_for_planning
2105:
2106: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2107: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2108: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2109: AND b_ignore )
2110: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2111:
2112: THEN
2110: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2111:
2112: THEN
2113:
2114: IF (p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2115: l_orgid:=p_attributes_rec.ship_from_org_id;
2116: END IF;
2117: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2118: l_carrierid:=p_attributes_rec.carrier_id;
2113:
2114: IF (p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2115: l_orgid:=p_attributes_rec.ship_from_org_id;
2116: END IF;
2117: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2118: l_carrierid:=p_attributes_rec.carrier_id;
2119: END IF;
2120: IF (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2121: l_smc:=p_attributes_rec.shipping_method_code;
2116: END IF;
2117: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2118: l_carrierid:=p_attributes_rec.carrier_id;
2119: END IF;
2120: IF (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2121: l_smc:=p_attributes_rec.shipping_method_code;
2122: END IF;
2123: IF l_debug_on THEN
2124: WSH_DEBUG_SV.log(l_module_name,'l_orgid', l_orgid);
2144: END IF;
2145: raise Update_Failed;
2146: END IF;
2147:
2148: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN --{
2149: l_ignore_for_planning:='Y';
2150: WSH_TP_RELEASE.Check_Shipset_Ignoreflag(p_attributes_rec.delivery_detail_id ,'Y',TRUE,x_return_status);
2151: --OTM R12 Start Org-Specific
2152: ELSIF (l_gc3_is_installed ='Y') THEN
2172: --OTM R12 End
2173:
2174:
2175: IF (p_attributes_rec.shipping_method_code IS NOT NULL
2176: AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2177:
2178: l_carrier_rec.ship_method_code := p_attributes_rec.shipping_method_code;
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.log(l_module_name,'ship_method_code ',p_attributes_rec.shipping_method_code);
2225: -- are changed in WDD.
2226: FOR cur in c_get_delivery_detail_id LOOP
2227: IF ( cur.released_status <> 'C' AND
2228: ( ( cur.date_requested <> p_attributes_rec.date_requested and
2229: p_attributes_rec.date_requested <> FND_API.G_MISS_DATE ) OR
2230: ( cur.date_scheduled <> p_attributes_rec.date_scheduled and
2231: p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE ) OR
2232: tpdates_changed = 'Y' ) )
2233: THEN
2227: IF ( cur.released_status <> 'C' AND
2228: ( ( cur.date_requested <> p_attributes_rec.date_requested and
2229: p_attributes_rec.date_requested <> FND_API.G_MISS_DATE ) OR
2230: ( cur.date_scheduled <> p_attributes_rec.date_scheduled and
2231: p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE ) OR
2232: tpdates_changed = 'Y' ) )
2233: THEN
2234: l_tp_details(l_tp_details.COUNT+1) := cur.delivery_detail_id;
2235: END IF;
2248: /*2740139 : For non-transactable,non-reservable,but stockable and shippable
2249: items, the release status is 'X'.In this case the subinventory value is
2250: set to the value that is present in wdd and not from the order lines.*/
2251: UPDATE wsh_delivery_details
2252: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2253: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2254: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2255: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2256: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2250: set to the value that is present in wdd and not from the order lines.*/
2251: UPDATE wsh_delivery_details
2252: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2253: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2254: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2255: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2256: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2257: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2258: organization_id = decode (p_attributes_rec.ship_from_org_id,
2252: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2253: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2254: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2255: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2256: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2257: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2258: organization_id = decode (p_attributes_rec.ship_from_org_id,
2259: FND_API.G_MISS_NUM, organization_id,
2260: NULL, organization_id,
2255: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2256: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2257: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2258: organization_id = decode (p_attributes_rec.ship_from_org_id,
2259: FND_API.G_MISS_NUM, organization_id,
2260: NULL, organization_id,
2261: p_attributes_rec.ship_from_org_id),
2262: ship_from_location_id = decode (p_attributes_rec.ship_from_org_id,
2263: FND_API.G_MISS_NUM, ship_from_location_id,
2259: FND_API.G_MISS_NUM, organization_id,
2260: NULL, organization_id,
2261: p_attributes_rec.ship_from_org_id),
2262: ship_from_location_id = decode (p_attributes_rec.ship_from_org_id,
2263: FND_API.G_MISS_NUM, ship_from_location_id,
2264: NULL, ship_from_location_id,
2265: -- bug 2894922: if organization is not changed, keep ship_from_location_id
2266: organization_id, ship_from_location_id,
2267: l_ship_from_location_id ) ,
2264: NULL, ship_from_location_id,
2265: -- bug 2894922: if organization is not changed, keep ship_from_location_id
2266: organization_id, ship_from_location_id,
2267: l_ship_from_location_id ) ,
2268: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2269: ship_to_location_id , l_ship_to_location_id ) ,
2270: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2271: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2272: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2266: organization_id, ship_from_location_id,
2267: l_ship_from_location_id ) ,
2268: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2269: ship_to_location_id , l_ship_to_location_id ) ,
2270: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2271: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2272: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2273: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2274: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2268: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2269: ship_to_location_id , l_ship_to_location_id ) ,
2270: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2271: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2272: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2273: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2274: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2275: deliver_to_location_id , l_deliver_to_location_id ) ,
2276: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2270: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2271: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2272: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2273: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2274: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2275: deliver_to_location_id , l_deliver_to_location_id ) ,
2276: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2277: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2278: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2272: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2273: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2274: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2275: deliver_to_location_id , l_deliver_to_location_id ) ,
2276: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2277: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2278: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2279: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2280: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2274: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2275: deliver_to_location_id , l_deliver_to_location_id ) ,
2276: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2277: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2278: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2279: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2280: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2281: customer_id , p_attributes_rec.sold_to_org_id),
2282: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2276: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2277: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2278: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2279: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2280: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2281: customer_id , p_attributes_rec.sold_to_org_id),
2282: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2283: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2284: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2278: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2279: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2280: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2281: customer_id , p_attributes_rec.sold_to_org_id),
2282: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2283: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2284: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2285: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2286: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2280: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2281: customer_id , p_attributes_rec.sold_to_org_id),
2282: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2283: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2284: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2285: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2286: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2287: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2288: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2282: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2283: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2284: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2285: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2286: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2287: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2288: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2289: date_requested , p_attributes_rec.date_requested ) ,
2290: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2284: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2285: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2286: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2287: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2288: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2289: date_requested , p_attributes_rec.date_requested ) ,
2290: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2291: date_scheduled , p_attributes_rec.date_scheduled ) ,
2292: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2286: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2287: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2288: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2289: date_requested , p_attributes_rec.date_requested ) ,
2290: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2291: date_scheduled , p_attributes_rec.date_scheduled ) ,
2292: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2293: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2294: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2288: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2289: date_requested , p_attributes_rec.date_requested ) ,
2290: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2291: date_scheduled , p_attributes_rec.date_scheduled ) ,
2292: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2293: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2294: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2295: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2296: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2290: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2291: date_scheduled , p_attributes_rec.date_scheduled ) ,
2292: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2293: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2294: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2295: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2296: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2297: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2298: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2292: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2293: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2294: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2295: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2296: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2297: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2298: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2299: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2300: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2294: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2295: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2296: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2297: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2298: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2299: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2300: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2301: customer_job , p_attributes_rec.customer_job ) ,
2302: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2296: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2297: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2298: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2299: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2300: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2301: customer_job , p_attributes_rec.customer_job ) ,
2302: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2303: customer_production_line , p_attributes_rec.customer_production_line ) ,
2304: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2298: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2299: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2300: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2301: customer_job , p_attributes_rec.customer_job ) ,
2302: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2303: customer_production_line , p_attributes_rec.customer_production_line ) ,
2304: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2305: cust_po_number , p_attributes_rec.cust_po_number ) ,
2306: packing_instructions = decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2300: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2301: customer_job , p_attributes_rec.customer_job ) ,
2302: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2303: customer_production_line , p_attributes_rec.customer_production_line ) ,
2304: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2305: cust_po_number , p_attributes_rec.cust_po_number ) ,
2306: packing_instructions = decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2307: packing_instructions , p_attributes_rec.packing_instructions ) ,
2308: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2302: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2303: customer_production_line , p_attributes_rec.customer_production_line ) ,
2304: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2305: cust_po_number , p_attributes_rec.cust_po_number ) ,
2306: packing_instructions = decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2307: packing_instructions , p_attributes_rec.packing_instructions ) ,
2308: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2309: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2310: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2304: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2305: cust_po_number , p_attributes_rec.cust_po_number ) ,
2306: packing_instructions = decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2307: packing_instructions , p_attributes_rec.packing_instructions ) ,
2308: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2309: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2310: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2311: ship_set_id , p_attributes_rec.ship_set_id ) ,
2312: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2306: packing_instructions = decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2307: packing_instructions , p_attributes_rec.packing_instructions ) ,
2308: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2309: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2310: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2311: ship_set_id , p_attributes_rec.ship_set_id ) ,
2312: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2313: ato_line_id , p_attributes_rec.ato_line_id ) ,
2314: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2308: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2309: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2310: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2311: ship_set_id , p_attributes_rec.ship_set_id ) ,
2312: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2313: ato_line_id , p_attributes_rec.ato_line_id ) ,
2314: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2315: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2316: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2310: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2311: ship_set_id , p_attributes_rec.ship_set_id ) ,
2312: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2313: ato_line_id , p_attributes_rec.ato_line_id ) ,
2314: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2315: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2316: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2317: ship_model_complete_flag , p_attributes_rec.ship_model_complete_flag ) ,
2318: -- Bug 2830372. We update the released status to 'N' only if the released status is in ('R', 'B', 'Y').
2312: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2313: ato_line_id , p_attributes_rec.ato_line_id ) ,
2314: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2315: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2316: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2317: ship_model_complete_flag , p_attributes_rec.ship_model_complete_flag ) ,
2318: -- Bug 2830372. We update the released status to 'N' only if the released status is in ('R', 'B', 'Y').
2319: -- ATO sets the released status to 'N' only when the reservations are removed for that order line.
2320: -- OM does not pass a released status of 'N', always passes 'R'.
2333: 'N', p_attributes_rec.released_status,
2334: decode(l_pickable_flag, 'Y', released_status, 'X')),
2335: /* bug 2421965: backordered should stay backordered except for ATO reservations: Bug: 2587777 */
2336: decode ( l_pickable_flag, 'N' , 'X',
2337: decode ( p_attributes_rec.released_status, FND_API.G_MISS_CHAR ,
2338: released_status , p_attributes_rec.released_status ))) ,
2339:
2340: shipping_instructions = decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2341: shipping_instructions , p_attributes_rec.shipping_instructions ) ,
2336: decode ( l_pickable_flag, 'N' , 'X',
2337: decode ( p_attributes_rec.released_status, FND_API.G_MISS_CHAR ,
2338: released_status , p_attributes_rec.released_status ))) ,
2339:
2340: shipping_instructions = decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2341: shipping_instructions , p_attributes_rec.shipping_instructions ) ,
2342: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2343: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2344: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2338: released_status , p_attributes_rec.released_status ))) ,
2339:
2340: shipping_instructions = decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2341: shipping_instructions , p_attributes_rec.shipping_instructions ) ,
2342: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2343: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2344: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2345: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2346: FND_API.G_MISS_NUM, cycle_count_quantity,
2341: shipping_instructions , p_attributes_rec.shipping_instructions ) ,
2342: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2343: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2344: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2345: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2346: FND_API.G_MISS_NUM, cycle_count_quantity,
2347: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2348: p_attributes_rec.cycle_count_quantity),
2349: -- OPM
2342: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2343: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2344: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2345: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2346: FND_API.G_MISS_NUM, cycle_count_quantity,
2347: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2348: p_attributes_rec.cycle_count_quantity),
2349: -- OPM
2350: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2346: FND_API.G_MISS_NUM, cycle_count_quantity,
2347: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2348: p_attributes_rec.cycle_count_quantity),
2349: -- OPM
2350: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2351: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2352: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2353: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2354: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2349: -- OPM
2350: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2351: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2352: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2353: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2354: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2355: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2356: p_attributes_rec.cycle_count_quantity2 ),
2357: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2350: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2351: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2352: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2353: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2354: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2355: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2356: p_attributes_rec.cycle_count_quantity2 ),
2357: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2358: currency_code , p_attributes_rec.currency_code ) ,
2353: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2354: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2355: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2356: p_attributes_rec.cycle_count_quantity2 ),
2357: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2358: currency_code , p_attributes_rec.currency_code ) ,
2359: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2360: tracking_number , p_attributes_rec.tracking_number ) ,
2361: locator_id = decode(p_attributes_rec.locator_id,
2355: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2356: p_attributes_rec.cycle_count_quantity2 ),
2357: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2358: currency_code , p_attributes_rec.currency_code ) ,
2359: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2360: tracking_number , p_attributes_rec.tracking_number ) ,
2361: locator_id = decode(p_attributes_rec.locator_id,
2362: FND_API.G_MISS_NUM, locator_id,
2363: decode(released_status,
2358: currency_code , p_attributes_rec.currency_code ) ,
2359: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2360: tracking_number , p_attributes_rec.tracking_number ) ,
2361: locator_id = decode(p_attributes_rec.locator_id,
2362: FND_API.G_MISS_NUM, locator_id,
2363: decode(released_status,
2364: 'C', locator_id,
2365: p_attributes_rec.locator_id)),
2366: serial_number = decode(p_attributes_rec.serial_number,
2363: decode(released_status,
2364: 'C', locator_id,
2365: p_attributes_rec.locator_id)),
2366: serial_number = decode(p_attributes_rec.serial_number,
2367: FND_API.G_MISS_CHAR, serial_number,
2368: decode(released_status,
2369: 'C',serial_number,
2370: p_attributes_rec.serial_number)),
2371: lot_number = decode(p_attributes_rec.lot_number,
2368: decode(released_status,
2369: 'C',serial_number,
2370: p_attributes_rec.serial_number)),
2371: lot_number = decode(p_attributes_rec.lot_number,
2372: FND_API.G_MISS_CHAR, lot_number,
2373: decode(released_status,
2374: 'C', lot_number,
2375: p_attributes_rec.lot_number)),
2376: -- OPM
2376: -- OPM
2377: -- HW OPMCONV - Removed sublot code
2378:
2379: preferred_grade = decode(p_attributes_rec.preferred_grade,
2380: FND_API.G_MISS_CHAR, preferred_grade,
2381: decode(released_status,
2382: 'C', preferred_grade,
2383: 'Y', preferred_grade,
2384: p_attributes_rec.preferred_grade)),
2382: 'C', preferred_grade,
2383: 'Y', preferred_grade,
2384: p_attributes_rec.preferred_grade)),
2385: revision = decode(p_attributes_rec.revision,
2386: FND_API.G_MISS_CHAR, revision,
2387: decode(released_status,
2388: 'C', revision,
2389: p_attributes_rec.revision)),
2390: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2388: 'C', revision,
2389: p_attributes_rec.revision)),
2390: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2391: subinventory = decode(p_attributes_rec.subinventory,
2392: FND_API.G_MISS_CHAR, subinventory,
2393: decode(released_status,
2394: 'Y', decode(l_reservable_flag,
2395: 'N', decode(original_subinventory,
2396: p_attributes_rec.subinventory, subinventory,
2411: p_attributes_rec.subinventory),
2412: p_attributes_rec.subinventory))),
2413:
2414: original_subinventory = decode(p_attributes_rec.subinventory,
2415: FND_API.G_MISS_CHAR, original_subinventory,
2416: decode (released_status,
2417: 'C', original_subinventory,
2418: p_attributes_rec.subinventory)),
2419:
2416: decode (released_status,
2417: 'C', original_subinventory,
2418: p_attributes_rec.subinventory)),
2419:
2420: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2421: source_line_number , p_attributes_rec.line_number ) ,
2422: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2423: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2424: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2418: p_attributes_rec.subinventory)),
2419:
2420: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2421: source_line_number , p_attributes_rec.line_number ) ,
2422: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2423: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2424: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2425: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2426: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2420: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2421: source_line_number , p_attributes_rec.line_number ) ,
2422: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2423: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2424: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2425: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2426: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2427: ship_method_code , l_ship_method_code ) ,
2428: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2422: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2423: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2424: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2425: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2426: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2427: ship_method_code , l_ship_method_code ) ,
2428: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2429: mode_of_transport , l_mode_of_transport ) ,
2430: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2424: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2425: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2426: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2427: ship_method_code , l_ship_method_code ) ,
2428: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2429: mode_of_transport , l_mode_of_transport ) ,
2430: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2431: service_level , l_service_level ) ,
2432: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2426: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2427: ship_method_code , l_ship_method_code ) ,
2428: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2429: mode_of_transport , l_mode_of_transport ) ,
2430: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2431: service_level , l_service_level ) ,
2432: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2433: carrier_id , l_carrier_id ) ,
2434: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2428: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2429: mode_of_transport , l_mode_of_transport ) ,
2430: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2431: service_level , l_service_level ) ,
2432: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2433: carrier_id , l_carrier_id ) ,
2434: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2435: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2436: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2430: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2431: service_level , l_service_level ) ,
2432: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2433: carrier_id , l_carrier_id ) ,
2434: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2435: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2436: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2437: fob_code , p_attributes_rec.fob_code ) ,
2438: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2432: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2433: carrier_id , l_carrier_id ) ,
2434: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2435: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2436: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2437: fob_code , p_attributes_rec.fob_code ) ,
2438: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2439: customer_item_id , p_attributes_rec.customer_item_id ) ,
2440: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2434: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2435: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2436: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2437: fob_code , p_attributes_rec.fob_code ) ,
2438: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2439: customer_item_id , p_attributes_rec.customer_item_id ) ,
2440: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2441: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2442: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2436: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2437: fob_code , p_attributes_rec.fob_code ) ,
2438: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2439: customer_item_id , p_attributes_rec.customer_item_id ) ,
2440: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2441: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2442: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2443: hold_code , p_attributes_rec.hold_code ) ,
2444: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2438: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2439: customer_item_id , p_attributes_rec.customer_item_id ) ,
2440: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2441: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2442: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2443: hold_code , p_attributes_rec.hold_code ) ,
2444: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2445: inspection_flag , p_attributes_rec.inspection_flag ) ,
2446: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2440: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2441: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2442: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2443: hold_code , p_attributes_rec.hold_code ) ,
2444: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2445: inspection_flag , p_attributes_rec.inspection_flag ) ,
2446: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2447: src_requested_quantity,
2448: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2444: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2445: inspection_flag , p_attributes_rec.inspection_flag ) ,
2446: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2447: src_requested_quantity,
2448: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2449: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2450: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2451: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2452: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2446: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2447: src_requested_quantity,
2448: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2449: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2450: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2451: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2452: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2453: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2454: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2448: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2449: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2450: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2451: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2452: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2453: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2454: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2455: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2456: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2450: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2451: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2452: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2453: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2454: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2455: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2456: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2457: attribute_category , p_attributes_rec.attribute_category ) ,
2458: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2452: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2453: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2454: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2455: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2456: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2457: attribute_category , p_attributes_rec.attribute_category ) ,
2458: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2459: attribute1 , p_attributes_rec.attribute1 ) ,
2460: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2454: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2455: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2456: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2457: attribute_category , p_attributes_rec.attribute_category ) ,
2458: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2459: attribute1 , p_attributes_rec.attribute1 ) ,
2460: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2461: attribute2 , p_attributes_rec.attribute2 ) ,
2462: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2456: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2457: attribute_category , p_attributes_rec.attribute_category ) ,
2458: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2459: attribute1 , p_attributes_rec.attribute1 ) ,
2460: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2461: attribute2 , p_attributes_rec.attribute2 ) ,
2462: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2463: attribute3 , p_attributes_rec.attribute3 ) ,
2464: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2458: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2459: attribute1 , p_attributes_rec.attribute1 ) ,
2460: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2461: attribute2 , p_attributes_rec.attribute2 ) ,
2462: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2463: attribute3 , p_attributes_rec.attribute3 ) ,
2464: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2465: attribute4 , p_attributes_rec.attribute4 ) ,
2466: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2460: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2461: attribute2 , p_attributes_rec.attribute2 ) ,
2462: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2463: attribute3 , p_attributes_rec.attribute3 ) ,
2464: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2465: attribute4 , p_attributes_rec.attribute4 ) ,
2466: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2467: attribute5 , p_attributes_rec.attribute5 ) ,
2468: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2462: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2463: attribute3 , p_attributes_rec.attribute3 ) ,
2464: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2465: attribute4 , p_attributes_rec.attribute4 ) ,
2466: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2467: attribute5 , p_attributes_rec.attribute5 ) ,
2468: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2469: attribute6 , p_attributes_rec.attribute6 ) ,
2470: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2464: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2465: attribute4 , p_attributes_rec.attribute4 ) ,
2466: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2467: attribute5 , p_attributes_rec.attribute5 ) ,
2468: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2469: attribute6 , p_attributes_rec.attribute6 ) ,
2470: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2471: attribute7 , p_attributes_rec.attribute7 ) ,
2472: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2466: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2467: attribute5 , p_attributes_rec.attribute5 ) ,
2468: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2469: attribute6 , p_attributes_rec.attribute6 ) ,
2470: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2471: attribute7 , p_attributes_rec.attribute7 ) ,
2472: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2473: attribute8 , p_attributes_rec.attribute8 ) ,
2474: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2468: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2469: attribute6 , p_attributes_rec.attribute6 ) ,
2470: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2471: attribute7 , p_attributes_rec.attribute7 ) ,
2472: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2473: attribute8 , p_attributes_rec.attribute8 ) ,
2474: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2475: attribute9 , p_attributes_rec.attribute9 ) ,
2476: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2470: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2471: attribute7 , p_attributes_rec.attribute7 ) ,
2472: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2473: attribute8 , p_attributes_rec.attribute8 ) ,
2474: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2475: attribute9 , p_attributes_rec.attribute9 ) ,
2476: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2477: attribute10 , p_attributes_rec.attribute10 ) ,
2478: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2472: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2473: attribute8 , p_attributes_rec.attribute8 ) ,
2474: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2475: attribute9 , p_attributes_rec.attribute9 ) ,
2476: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2477: attribute10 , p_attributes_rec.attribute10 ) ,
2478: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2479: attribute11 , p_attributes_rec.attribute11 ) ,
2480: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2474: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2475: attribute9 , p_attributes_rec.attribute9 ) ,
2476: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2477: attribute10 , p_attributes_rec.attribute10 ) ,
2478: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2479: attribute11 , p_attributes_rec.attribute11 ) ,
2480: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2481: attribute12 , p_attributes_rec.attribute12 ) ,
2482: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2476: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2477: attribute10 , p_attributes_rec.attribute10 ) ,
2478: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2479: attribute11 , p_attributes_rec.attribute11 ) ,
2480: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2481: attribute12 , p_attributes_rec.attribute12 ) ,
2482: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2483: attribute13 , p_attributes_rec.attribute13 ) ,
2484: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2478: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2479: attribute11 , p_attributes_rec.attribute11 ) ,
2480: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2481: attribute12 , p_attributes_rec.attribute12 ) ,
2482: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2483: attribute13 , p_attributes_rec.attribute13 ) ,
2484: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2485: attribute14 , p_attributes_rec.attribute14 ) ,
2486: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2480: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2481: attribute12 , p_attributes_rec.attribute12 ) ,
2482: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2483: attribute13 , p_attributes_rec.attribute13 ) ,
2484: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2485: attribute14 , p_attributes_rec.attribute14 ) ,
2486: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2487: attribute15 , p_attributes_rec.attribute15 ),
2488: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2482: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2483: attribute13 , p_attributes_rec.attribute13 ) ,
2484: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2485: attribute14 , p_attributes_rec.attribute14 ) ,
2486: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2487: attribute15 , p_attributes_rec.attribute15 ),
2488: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2489: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2490: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2484: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2485: attribute14 , p_attributes_rec.attribute14 ) ,
2486: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2487: attribute15 , p_attributes_rec.attribute15 ),
2488: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2489: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2490: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2491: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2492: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2486: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2487: attribute15 , p_attributes_rec.attribute15 ),
2488: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2489: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2490: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2491: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2492: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2493: classification , p_attributes_rec.classification ) ,
2494: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2488: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2489: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2490: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2491: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2492: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2493: classification , p_attributes_rec.classification ) ,
2494: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2495: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2496: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2490: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2491: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2492: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2493: classification , p_attributes_rec.classification ) ,
2494: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2495: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2496: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2497: container_flag , p_attributes_rec.container_flag ) ,
2498: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2492: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2493: classification , p_attributes_rec.classification ) ,
2494: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2495: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2496: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2497: container_flag , p_attributes_rec.container_flag ) ,
2498: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2499: container_name , p_attributes_rec.container_name ) ,
2500: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2494: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2495: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2496: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2497: container_flag , p_attributes_rec.container_flag ) ,
2498: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2499: container_name , p_attributes_rec.container_name ) ,
2500: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2501: container_type_code , p_attributes_rec.container_type_code ) ,
2502: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2496: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2497: container_flag , p_attributes_rec.container_flag ) ,
2498: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2499: container_name , p_attributes_rec.container_name ) ,
2500: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2501: container_type_code , p_attributes_rec.container_type_code ) ,
2502: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2503: country_of_origin , p_attributes_rec.country_of_origin ) ,
2504: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2498: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2499: container_name , p_attributes_rec.container_name ) ,
2500: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2501: container_type_code , p_attributes_rec.container_type_code ) ,
2502: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2503: country_of_origin , p_attributes_rec.country_of_origin ) ,
2504: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2505: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2506: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2500: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2501: container_type_code , p_attributes_rec.container_type_code ) ,
2502: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2503: country_of_origin , p_attributes_rec.country_of_origin ) ,
2504: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2505: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2506: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2507: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2508: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2502: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2503: country_of_origin , p_attributes_rec.country_of_origin ) ,
2504: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2505: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2506: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2507: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2508: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2509: fill_percent , p_attributes_rec.fill_percent ) ,
2510: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2504: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2505: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2506: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2507: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2508: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2509: fill_percent , p_attributes_rec.fill_percent ) ,
2510: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2511: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2512: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2506: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2507: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2508: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2509: fill_percent , p_attributes_rec.fill_percent ) ,
2510: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2511: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2512: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2513: inv_interfaced_flag = decode (inv_interfaced_flag, 'Y',
2514: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2510: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2511: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2512: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2513: inv_interfaced_flag = decode (inv_interfaced_flag, 'Y',
2514: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2515: inv_interfaced_flag , p_attributes_rec.inv_interfaced_flag ) ,
2516: decode (l_pickable_flag, 'N', 'X', 'N')
2517: ),
2518: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2514: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2515: inv_interfaced_flag , p_attributes_rec.inv_interfaced_flag ) ,
2516: decode (l_pickable_flag, 'N', 'X', 'N')
2517: ),
2518: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2519: inventory_item_id , p_attributes_rec.inventory_item_id ),
2520: --bug#6407943 (begin) :Needs to change items org dependent attributes when org changes
2521: item_description = decode(l_change_item_desc,'Y',l_item_description,
2522: decode (p_attributes_rec.item_description, FND_API.G_MISS_CHAR ,
2518: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2519: inventory_item_id , p_attributes_rec.inventory_item_id ),
2520: --bug#6407943 (begin) :Needs to change items org dependent attributes when org changes
2521: item_description = decode(l_change_item_desc,'Y',l_item_description,
2522: decode (p_attributes_rec.item_description, FND_API.G_MISS_CHAR ,
2523: item_description , p_attributes_rec.item_description )),
2524: requested_quantity_uom = decode (l_change_req_quantity_uom,'Y',l_primary_uom_code,
2525: requested_quantity_uom) ,
2526: unit_weight = decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2525: requested_quantity_uom) ,
2526: unit_weight = decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2527: unit_volume = decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2528: net_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2529: decode ( p_attributes_rec.net_weight, FND_API.G_MISS_NUM ,
2530: net_weight , p_attributes_rec.net_weight )) ,
2531: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2532: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2533: gross_weight , p_attributes_rec.gross_weight )) ,
2528: net_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2529: decode ( p_attributes_rec.net_weight, FND_API.G_MISS_NUM ,
2530: net_weight , p_attributes_rec.net_weight )) ,
2531: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2532: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2533: gross_weight , p_attributes_rec.gross_weight )) ,
2534: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2535: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2536: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2530: net_weight , p_attributes_rec.net_weight )) ,
2531: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2532: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2533: gross_weight , p_attributes_rec.gross_weight )) ,
2534: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2535: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2536: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2537: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2538: volume , p_attributes_rec.volume )) ,
2533: gross_weight , p_attributes_rec.gross_weight )) ,
2534: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2535: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2536: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2537: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2538: volume , p_attributes_rec.volume )) ,
2539: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2540: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2541: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2535: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2536: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2537: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2538: volume , p_attributes_rec.volume )) ,
2539: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2540: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2541: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2542: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2543: hazard_class_id , p_attributes_rec.hazard_class_id)),
2538: volume , p_attributes_rec.volume )) ,
2539: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2540: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2541: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2542: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2543: hazard_class_id , p_attributes_rec.hazard_class_id)),
2544: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2545: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2546: load_seq_number , p_attributes_rec.load_seq_number ) ,
2541: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2542: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2543: hazard_class_id , p_attributes_rec.hazard_class_id)),
2544: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2545: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2546: load_seq_number , p_attributes_rec.load_seq_number ) ,
2547: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2548: lpn_id , p_attributes_rec.lpn_id ) ,
2549: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2543: hazard_class_id , p_attributes_rec.hazard_class_id)),
2544: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2545: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2546: load_seq_number , p_attributes_rec.load_seq_number ) ,
2547: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2548: lpn_id , p_attributes_rec.lpn_id ) ,
2549: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2550: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2551: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2545: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2546: load_seq_number , p_attributes_rec.load_seq_number ) ,
2547: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2548: lpn_id , p_attributes_rec.lpn_id ) ,
2549: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2550: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2551: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2552: maximum_volume , p_attributes_rec.maximum_volume ) ,
2553: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2547: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2548: lpn_id , p_attributes_rec.lpn_id ) ,
2549: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2550: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2551: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2552: maximum_volume , p_attributes_rec.maximum_volume ) ,
2553: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2554: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2555: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2549: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2550: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2551: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2552: maximum_volume , p_attributes_rec.maximum_volume ) ,
2553: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2554: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2555: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2556: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2557: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2551: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2552: maximum_volume , p_attributes_rec.maximum_volume ) ,
2553: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2554: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2555: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2556: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2557: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2558: movement_id , p_attributes_rec.movement_id ) ,
2559: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2553: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2554: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2555: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2556: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2557: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2558: movement_id , p_attributes_rec.movement_id ) ,
2559: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2560: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2561: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2555: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2556: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2557: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2558: movement_id , p_attributes_rec.movement_id ) ,
2559: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2560: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2561: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2562: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2563: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2557: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2558: movement_id , p_attributes_rec.movement_id ) ,
2559: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2560: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2561: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2562: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2563: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2564: org_id , p_attributes_rec.org_id ) ,
2565: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2559: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2560: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2561: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2562: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2563: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2564: org_id , p_attributes_rec.org_id ) ,
2565: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2566: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2567: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2562: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2563: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2564: org_id , p_attributes_rec.org_id ) ,
2565: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2566: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2567: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2568: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2569: picked_quantity , p_attributes_rec.picked_quantity ),
2570: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2564: org_id , p_attributes_rec.org_id ) ,
2565: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2566: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2567: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2568: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2569: picked_quantity , p_attributes_rec.picked_quantity ),
2570: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2571: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2572: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2566: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2567: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2568: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2569: picked_quantity , p_attributes_rec.picked_quantity ),
2570: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2571: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2572: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2573: project_id , p_attributes_rec.project_id ) ,
2574: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2568: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2569: picked_quantity , p_attributes_rec.picked_quantity ),
2570: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2571: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2572: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2573: project_id , p_attributes_rec.project_id ) ,
2574: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2575: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2576: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2570: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2571: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2572: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2573: project_id , p_attributes_rec.project_id ) ,
2574: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2575: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2576: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2577: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2578: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2572: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2573: project_id , p_attributes_rec.project_id ) ,
2574: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2575: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2576: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2577: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2578: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2579: received_quantity , p_attributes_rec.received_quantity ) ,
2580: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2574: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2575: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2576: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2577: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2578: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2579: received_quantity , p_attributes_rec.received_quantity ) ,
2580: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2581: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2582: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2576: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2577: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2578: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2579: received_quantity , p_attributes_rec.received_quantity ) ,
2580: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2581: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2582: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2583: request_id , p_attributes_rec.request_id ) ,
2584: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2578: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2579: received_quantity , p_attributes_rec.received_quantity ) ,
2580: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2581: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2582: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2583: request_id , p_attributes_rec.request_id ) ,
2584: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2585: seal_code , p_attributes_rec.seal_code ) ,
2586: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2580: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2581: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2582: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2583: request_id , p_attributes_rec.request_id ) ,
2584: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2585: seal_code , p_attributes_rec.seal_code ) ,
2586: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2587: source_code , p_attributes_rec.source_code ),
2588: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2582: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2583: request_id , p_attributes_rec.request_id ) ,
2584: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2585: seal_code , p_attributes_rec.seal_code ) ,
2586: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2587: source_code , p_attributes_rec.source_code ),
2588: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2589: source_header_id , p_attributes_rec.source_header_id ) ,
2590: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2584: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2585: seal_code , p_attributes_rec.seal_code ) ,
2586: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2587: source_code , p_attributes_rec.source_code ),
2588: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2589: source_header_id , p_attributes_rec.source_header_id ) ,
2590: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2591: source_header_number , p_attributes_rec.source_header_number ) ,
2592: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2586: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2587: source_code , p_attributes_rec.source_code ),
2588: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2589: source_header_id , p_attributes_rec.source_header_id ) ,
2590: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2591: source_header_number , p_attributes_rec.source_header_number ) ,
2592: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2593: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2594: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2588: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2589: source_header_id , p_attributes_rec.source_header_id ) ,
2590: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2591: source_header_number , p_attributes_rec.source_header_number ) ,
2592: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2593: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2594: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2595: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2596: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2590: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2591: source_header_number , p_attributes_rec.source_header_number ) ,
2592: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2593: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2594: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2595: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2596: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2597: source_line_id , p_attributes_rec.source_line_id ) ,
2598: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2592: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2593: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2594: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2595: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2596: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2597: source_line_id , p_attributes_rec.source_line_id ) ,
2598: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2599: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2600: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2594: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2595: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2596: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2597: source_line_id , p_attributes_rec.source_line_id ) ,
2598: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2599: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2600: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2601: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2602: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2596: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2597: source_line_id , p_attributes_rec.source_line_id ) ,
2598: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2599: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2600: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2601: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2602: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2603: task_id , p_attributes_rec.task_id ) ,
2604: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2598: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2599: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2600: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2601: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2602: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2603: task_id , p_attributes_rec.task_id ) ,
2604: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2605: to_serial_number , p_attributes_rec.to_serial_number ) ,
2606: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2600: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2601: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2602: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2603: task_id , p_attributes_rec.task_id ) ,
2604: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2605: to_serial_number , p_attributes_rec.to_serial_number ) ,
2606: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2607: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2608: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2602: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2603: task_id , p_attributes_rec.task_id ) ,
2604: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2605: to_serial_number , p_attributes_rec.to_serial_number ) ,
2606: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2607: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2608: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2609: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2610: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2604: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2605: to_serial_number , p_attributes_rec.to_serial_number ) ,
2606: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2607: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2608: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2609: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2610: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2611: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2612: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2606: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2607: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2608: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2609: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2610: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2611: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2612: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2613: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2614: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2608: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2609: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2610: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2611: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2612: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2613: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2614: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2615: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2616: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2610: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2611: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2612: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2613: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2614: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2615: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2616: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2617: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2618: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2612: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2613: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2614: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2615: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2616: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2617: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2618: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2619: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2620: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2614: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2615: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2616: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2617: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2618: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2619: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2620: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2621: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2622: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2616: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2617: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2618: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2619: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2620: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2621: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2622: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2623: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2624: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2618: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2619: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2620: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2621: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2622: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2623: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2624: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2625: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2626: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2620: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2621: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2622: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2623: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2624: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2625: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2626: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2627: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2628: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2622: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2623: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2624: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2625: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2626: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2627: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2628: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2629: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2630: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2624: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2625: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2626: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2627: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2628: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2629: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2630: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2631: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2632: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2626: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2627: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2628: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2629: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2630: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2631: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2632: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2633: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2634: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2628: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2629: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2630: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2631: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2632: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2633: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2634: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2635: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2636: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2630: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2631: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2632: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2633: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2634: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2635: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2636: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2637: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2638: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2632: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2633: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2634: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2635: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2636: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2637: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2638: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2639: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2640: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2634: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2635: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2636: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2637: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2638: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2639: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2640: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2641: unit_number , p_attributes_rec.unit_number ) ,
2642: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2636: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2637: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2638: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2639: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2640: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2641: unit_number , p_attributes_rec.unit_number ) ,
2642: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2643: unit_price , p_attributes_rec.unit_price ),
2644: /* J TP Release */
2638: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2639: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2640: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2641: unit_number , p_attributes_rec.unit_number ) ,
2642: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2643: unit_price , p_attributes_rec.unit_price ),
2644: /* J TP Release */
2645: earliest_pickup_date = decode(tpdates_changed, 'N' ,
2646: to_date(to_char(earliest_pickup_date,'mm-dd-yy HH24:MI:SS'),'mm-dd-yy HH24:MI:SS')
2665: last_update_login = FND_GLOBAL.LOGIN_ID
2666: WHERE source_code = p_source_code
2667: AND source_line_id = p_attributes_rec.source_line_id
2668: AND container_flag = 'N'
2669: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
2670: delivery_detail_id, p_attributes_rec.delivery_detail_id );
2671:
2672: /* H projects: pricing integration csun */
2673:
2671:
2672: /* H projects: pricing integration csun */
2673:
2674: IF (p_attributes_rec.gross_weight IS NOT NULL)
2675: AND (p_attributes_rec.gross_weight <> FND_API.G_MISS_NUM) THEN
2676: l_mark_reprice_flag := 'Y';
2677: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2678: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2679: l_mark_reprice_flag := 'Y';
2674: IF (p_attributes_rec.gross_weight IS NOT NULL)
2675: AND (p_attributes_rec.gross_weight <> FND_API.G_MISS_NUM) THEN
2676: l_mark_reprice_flag := 'Y';
2677: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2678: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2679: l_mark_reprice_flag := 'Y';
2680: ELSIF (p_attributes_rec.volume IS NOT NULL)
2681: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2682: l_mark_reprice_flag := 'Y';
2677: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2678: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2679: l_mark_reprice_flag := 'Y';
2680: ELSIF (p_attributes_rec.volume IS NOT NULL)
2681: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2682: l_mark_reprice_flag := 'Y';
2683: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2684: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2685: l_mark_reprice_flag := 'Y';
2680: ELSIF (p_attributes_rec.volume IS NOT NULL)
2681: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2682: l_mark_reprice_flag := 'Y';
2683: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2684: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2685: l_mark_reprice_flag := 'Y';
2686: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2687: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
2688: l_mark_reprice_flag := 'Y';
2683: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2684: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2685: l_mark_reprice_flag := 'Y';
2686: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2687: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
2688: l_mark_reprice_flag := 'Y';
2689: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
2690: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
2691: l_mark_reprice_flag := 'Y';
2686: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2687: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
2688: l_mark_reprice_flag := 'Y';
2689: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
2690: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
2691: l_mark_reprice_flag := 'Y';
2692: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
2693: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2694: l_mark_reprice_flag := 'Y';
2689: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
2690: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
2691: l_mark_reprice_flag := 'Y';
2692: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
2693: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2694: l_mark_reprice_flag := 'Y';
2695: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
2696: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2697: l_mark_reprice_flag := 'Y';
2692: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
2693: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2694: l_mark_reprice_flag := 'Y';
2695: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
2696: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2697: l_mark_reprice_flag := 'Y';
2698: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
2699: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
2700: l_mark_reprice_flag := 'Y';
2695: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
2696: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2697: l_mark_reprice_flag := 'Y';
2698: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
2699: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
2700: l_mark_reprice_flag := 'Y';
2701: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
2702: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2703: l_mark_reprice_flag := 'Y';
2698: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
2699: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
2700: l_mark_reprice_flag := 'Y';
2701: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
2702: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2703: l_mark_reprice_flag := 'Y';
2704: END IF;
2705: IF l_debug_on THEN
2706: WSH_DEBUG_SV.log(l_module_name,'l_mark_reprice_flag',l_mark_reprice_flag);