[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
648: --End of ECO 4524041
649:
650: -- bug 2662327: overship tolerance fix to update line_set_id for all delivery lines if it is populated
651: -- assumption: line_set_id will be populated only when OM splits order line.
652: IF (p_changed_attributes(l_counter).source_line_set_id <> FND_API.G_MISS_NUM)
653: AND ( (c.source_line_set_id IS NULL)
654: OR (p_changed_attributes(l_counter).source_line_set_id <> c.source_line_set_id))
655: AND (l_prev_source_line_id <> p_changed_attributes(l_counter).original_source_line_id) THEN
656: UPDATE WSH_DELIVERY_DETAILS
683: -- details to new order line irrespective of whatever quantity OM passes. If we rely on
684: -- OM quantity there could be some precision loss and we may have orphan pending details
685: -- still attached to original order line.
686: IF ((p_interface_flag = 'Y') AND
687: ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
688: (p_changed_attributes(l_counter).top_model_line_id IS NULL)))
689: THEN
690: OPEN c_req_qty(p_source_code,
691: p_changed_attributes(l_counter).original_source_line_id);
789: --wrudge
790: -- Bug 2540015
791: IF (c.released_status = 'S') THEN
792: IF (p_interface_flag = 'Y') THEN
793: IF ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
794: (p_changed_attributes(l_counter).top_model_line_id IS NULL)) OR
795: -- the following condition added for bug 3858111(front port of bug 3808946)
796: ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
797: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
792: IF (p_interface_flag = 'Y') THEN
793: IF ((p_changed_attributes(l_counter).top_model_line_id = FND_API.G_MISS_NUM) OR
794: (p_changed_attributes(l_counter).top_model_line_id IS NULL)) OR
795: -- the following condition added for bug 3858111(front port of bug 3808946)
796: ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
797: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
798: AND p_changed_attributes(l_counter).top_model_line_id = p_changed_attributes(l_counter).ato_line_id )
799: THEN
800: IF l_debug_on THEN
1065: -- only when the released to warehouse dd is considereed
1066: -- to be transferred to the new line.
1067: -- NOTE: L_RES_QTY_TO_TRANSFER gets some value only when DD is transferred to new line.
1068: IF (c.released_status = 'S') AND (p_interface_flag = 'Y')
1069: AND ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
1070: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
1071: AND (p_changed_attributes(l_counter).ato_line_id IS NULL OR p_changed_attributes(l_counter).ato_line_id = FND_API.G_MISS_NUM )) THEN
1072: --{
1073: IF L_RES_QTY_TO_TRANSFER IS NULL THEN
1067: -- NOTE: L_RES_QTY_TO_TRANSFER gets some value only when DD is transferred to new line.
1068: IF (c.released_status = 'S') AND (p_interface_flag = 'Y')
1069: AND ( p_changed_attributes(l_counter).top_model_line_id <> FND_API.G_MISS_NUM
1070: AND p_changed_attributes(l_counter).top_model_line_id IS NOT NULL
1071: AND (p_changed_attributes(l_counter).ato_line_id IS NULL OR p_changed_attributes(l_counter).ato_line_id = FND_API.G_MISS_NUM )) THEN
1072: --{
1073: IF L_RES_QTY_TO_TRANSFER IS NULL THEN
1074: l_trnfer_reservations := 'N';
1075: ELSE
2050: from wsh_delivery_details
2051: WHERE source_code = p_source_code
2052: AND source_line_id = p_attributes_rec.source_line_id
2053: AND container_flag = 'N'
2054: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
2055: delivery_detail_id, p_attributes_rec.delivery_detail_id );
2056:
2057: cursor c_get_tpdetails IS
2058: select organization_id, carrier_id, ship_method_code, ignore_for_planning
2059: from wsh_delivery_details
2060: WHERE source_code = p_source_code
2061: AND source_line_id = p_attributes_rec.source_line_id
2062: AND container_flag = 'N'
2063: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
2064: delivery_detail_id, p_attributes_rec.delivery_detail_id )
2065: AND nvl(ignore_for_planning,'N')<>'Y'
2066: AND rownum=1;
2067:
2227: -- bug#6407943 (Begin):
2228: --When there is a change in org value on sale order line, needs to change
2229: --item attributes which are org dependent .
2230: --BUG#11893915
2231: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM
2232: AND p_attributes_rec.ship_from_org_id <> l_organization_id
2233: AND ( (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM) OR
2234: (p_attributes_rec.inventory_item_id = l_inventory_item_id) )
2235: AND p_attributes_rec.ship_from_org_id IS NOT NULL THEN
2229: --item attributes which are org dependent .
2230: --BUG#11893915
2231: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM
2232: AND p_attributes_rec.ship_from_org_id <> l_organization_id
2233: AND ( (p_attributes_rec.inventory_item_id = FND_API.G_MISS_NUM) OR
2234: (p_attributes_rec.inventory_item_id = l_inventory_item_id) )
2235: AND p_attributes_rec.ship_from_org_id IS NOT NULL THEN
2236: --{
2237: OPEN c_specific_item_info(l_inventory_item_id, p_attributes_rec.ship_from_org_id);
2274: --}
2275: END IF;
2276: -- bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2277:
2278: IF p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
2279:
2280: WSH_UTIL_CORE.GET_LOCATION_ID('ORG', p_attributes_rec.ship_from_org_id,
2281: l_ship_from_location_id, x_return_status);
2282:
2302: x_item_id => l_inventory_item_id,
2303: x_organization_id => l_organization_id,
2304: x_pickable_flag => l_pickable_flag);
2305:
2306: IF p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
2307:
2308: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.ship_to_org_id,
2309: l_ship_to_location_id, x_return_status);
2310:
2317:
2318: END IF;
2319:
2320: IF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
2321: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
2322: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.deliver_to_org_id,
2323: l_deliver_to_location_id, x_return_status);
2324:
2325: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2331:
2332: END IF;
2333:
2334: IF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
2335: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2336: --
2337: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.intmed_ship_to_org_id,
2338: l_intmed_ship_to_location_id, x_return_status);
2339:
2348:
2349: IF (l_deliver_to_location_id is NULL) AND (l_ship_to_location_id IS NOT NULL) THEN
2350: l_deliver_to_location_id := l_ship_to_location_id;
2351: ELSIF (l_deliver_to_location_id is NULL) AND (l_ship_to_location_id IS NULL)
2352: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
2353: --
2354: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', p_attributes_rec.ship_to_org_id,
2355: l_deliver_to_location_id, x_return_status);
2356:
2364: END IF;
2365: --OTM R12 Org-Specific Start
2366: IF l_gc3_is_installed = 'Y' THEN
2367: IF ( p_attributes_rec.ship_from_org_id IS NOT NULL AND
2368: p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.log(l_module_name,'Before call to WSH_SHIPPING_PARAMS_PVT.Get to parameter values for Org',
2371: p_attributes_rec.ship_from_org_id );
2372: END IF;
2401:
2402: --1. check for updates to org, carrier, smc and based on
2403: -- that set ignore_for_planning
2404:
2405: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2406: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2407: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2408: AND b_ignore )
2409: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2402: --1. check for updates to org, carrier, smc and based on
2403: -- that set ignore_for_planning
2404:
2405: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2406: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2407: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2408: AND b_ignore )
2409: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2410:
2403: -- that set ignore_for_planning
2404:
2405: IF (((p_attributes_rec.ship_from_org_id IS NOT NULL AND p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM)
2406: OR (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM)
2407: OR (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
2408: AND b_ignore )
2409: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2410:
2411: THEN
2409: OR (l_shipping_param_info.otm_enabled='Y')) --OTM R12 Org-Specific
2410:
2411: THEN
2412:
2413: 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
2414: l_orgid:=p_attributes_rec.ship_from_org_id;
2415: END IF;
2416: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2417: l_carrierid:=p_attributes_rec.carrier_id;
2412:
2413: 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
2414: l_orgid:=p_attributes_rec.ship_from_org_id;
2415: END IF;
2416: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2417: l_carrierid:=p_attributes_rec.carrier_id;
2418: END IF;
2419: IF (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2420: l_smc:=p_attributes_rec.shipping_method_code;
2415: END IF;
2416: IF (p_attributes_rec.carrier_id IS NOT NULL AND p_attributes_rec.carrier_id <> FND_API.G_MISS_NUM) THEN
2417: l_carrierid:=p_attributes_rec.carrier_id;
2418: END IF;
2419: IF (p_attributes_rec.shipping_method_code IS NOT NULL AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2420: l_smc:=p_attributes_rec.shipping_method_code;
2421: END IF;
2422: IF l_debug_on THEN
2423: WSH_DEBUG_SV.log(l_module_name,'l_orgid', l_orgid);
2443: END IF;
2444: raise Update_Failed;
2445: END IF;
2446:
2447: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN --{
2448: l_ignore_for_planning:='Y';
2449: WSH_TP_RELEASE.Check_Shipset_Ignoreflag(p_attributes_rec.delivery_detail_id ,'Y',TRUE,x_return_status);
2450: --OTM R12 Start Org-Specific
2451: ELSIF (l_gc3_is_installed ='Y') THEN
2471: --OTM R12 End
2472:
2473:
2474: IF (p_attributes_rec.shipping_method_code IS NOT NULL
2475: AND p_attributes_rec.shipping_method_code <> FND_API.G_MISS_CHAR) THEN
2476:
2477: l_carrier_rec.ship_method_code := p_attributes_rec.shipping_method_code;
2478: IF l_debug_on THEN
2479: WSH_DEBUG_SV.log(l_module_name,'ship_method_code ',p_attributes_rec.shipping_method_code);
2524: -- are changed in WDD.
2525: FOR cur in c_get_delivery_detail_id LOOP
2526: IF ( cur.released_status <> 'C' AND
2527: ( ( cur.date_requested <> p_attributes_rec.date_requested and
2528: p_attributes_rec.date_requested <> FND_API.G_MISS_DATE ) OR
2529: ( cur.date_scheduled <> p_attributes_rec.date_scheduled and
2530: p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE ) OR
2531: tpdates_changed = 'Y' ) )
2532: THEN
2526: IF ( cur.released_status <> 'C' AND
2527: ( ( cur.date_requested <> p_attributes_rec.date_requested and
2528: p_attributes_rec.date_requested <> FND_API.G_MISS_DATE ) OR
2529: ( cur.date_scheduled <> p_attributes_rec.date_scheduled and
2530: p_attributes_rec.date_scheduled <> FND_API.G_MISS_DATE ) OR
2531: tpdates_changed = 'Y' ) )
2532: THEN
2533: l_tp_details(l_tp_details.COUNT+1) := cur.delivery_detail_id;
2534: END IF;
2544: l_oke_full_cancel_flag := 'Y';
2545: end if; -- OKE
2546:
2547: --Added for bug 8995849
2548: If l_organization_id <> nvl(p_attributes_rec.ship_from_org_id,FND_API.G_MISS_NUM) THEN
2549: l_change_sub := 'Y';
2550: ELSE
2551: l_change_sub := 'N';
2552: END IF;
2554: /*2740139 : For non-transactable,non-reservable,but stockable and shippable
2555: items, the release status is 'X'.In this case the subinventory value is
2556: set to the value that is present in wdd and not from the order lines.*/
2557: UPDATE wsh_delivery_details
2558: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2559: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2560: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2561: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2562: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2556: set to the value that is present in wdd and not from the order lines.*/
2557: UPDATE wsh_delivery_details
2558: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2559: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2560: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2561: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2562: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2563: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2564: organization_id = decode (p_attributes_rec.ship_from_org_id,
2558: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2559: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2560: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2561: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2562: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2563: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2564: organization_id = decode (p_attributes_rec.ship_from_org_id,
2565: FND_API.G_MISS_NUM, organization_id,
2566: NULL, organization_id,
2561: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,
2562: deliver_to_contact_id = decode ( p_attributes_rec.deliver_to_contact_id, FND_API.G_MISS_NUM ,
2563: deliver_to_contact_id , p_attributes_rec.deliver_to_contact_id ) ,
2564: organization_id = decode (p_attributes_rec.ship_from_org_id,
2565: FND_API.G_MISS_NUM, organization_id,
2566: NULL, organization_id,
2567: p_attributes_rec.ship_from_org_id),
2568: ship_from_location_id = decode (p_attributes_rec.ship_from_org_id,
2569: FND_API.G_MISS_NUM, ship_from_location_id,
2565: FND_API.G_MISS_NUM, organization_id,
2566: NULL, organization_id,
2567: p_attributes_rec.ship_from_org_id),
2568: ship_from_location_id = decode (p_attributes_rec.ship_from_org_id,
2569: FND_API.G_MISS_NUM, ship_from_location_id,
2570: NULL, ship_from_location_id,
2571: -- bug 2894922: if organization is not changed, keep ship_from_location_id
2572: organization_id, ship_from_location_id,
2573: l_ship_from_location_id ) ,
2570: NULL, ship_from_location_id,
2571: -- bug 2894922: if organization is not changed, keep ship_from_location_id
2572: organization_id, ship_from_location_id,
2573: l_ship_from_location_id ) ,
2574: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2575: ship_to_location_id , l_ship_to_location_id ) ,
2576: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2577: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2578: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2572: organization_id, ship_from_location_id,
2573: l_ship_from_location_id ) ,
2574: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2575: ship_to_location_id , l_ship_to_location_id ) ,
2576: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2577: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2578: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2579: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2580: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2574: ship_to_location_id = decode (p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2575: ship_to_location_id , l_ship_to_location_id ) ,
2576: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2577: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2578: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2579: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2580: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2581: deliver_to_location_id , l_deliver_to_location_id ) ,
2582: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2576: ship_to_site_use_id = decode ( p_attributes_rec.ship_to_org_id, FND_API.G_MISS_NUM ,
2577: ship_to_site_use_id , p_attributes_rec.ship_to_org_id ) ,
2578: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2579: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2580: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2581: deliver_to_location_id , l_deliver_to_location_id ) ,
2582: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2583: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2584: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2578: deliver_to_site_use_id = decode ( p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2579: deliver_to_site_use_id , p_attributes_rec.deliver_to_org_id ) ,
2580: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2581: deliver_to_location_id , l_deliver_to_location_id ) ,
2582: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2583: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2584: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2585: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2586: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2580: deliver_to_location_id = decode (p_attributes_rec.deliver_to_org_id, FND_API.G_MISS_NUM ,
2581: deliver_to_location_id , l_deliver_to_location_id ) ,
2582: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2583: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2584: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2585: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2586: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2587: customer_id , p_attributes_rec.sold_to_org_id),
2588: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2582: intmed_ship_to_contact_id = decode ( p_attributes_rec.intmed_ship_to_contact_id, FND_API.G_MISS_NUM ,
2583: intmed_ship_to_contact_id , p_attributes_rec.intmed_ship_to_contact_id ) ,
2584: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2585: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2586: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2587: customer_id , p_attributes_rec.sold_to_org_id),
2588: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2589: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2590: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2584: intmed_ship_to_location_id = decode (p_attributes_rec.intmed_ship_to_org_id, FND_API.G_MISS_NUM ,
2585: intmed_ship_to_location_id , l_intmed_ship_to_location_id ) ,
2586: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2587: customer_id , p_attributes_rec.sold_to_org_id),
2588: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2589: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2590: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2591: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2592: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2586: customer_id = decode (p_attributes_rec.sold_to_org_id, FND_API.G_MISS_NUM ,
2587: customer_id , p_attributes_rec.sold_to_org_id),
2588: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2589: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2590: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2591: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2592: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2593: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2594: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2588: ship_tolerance_above = decode ( p_attributes_rec.ship_tolerance_above, FND_API.G_MISS_NUM ,
2589: ship_tolerance_above , p_attributes_rec.ship_tolerance_above ) ,
2590: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2591: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2592: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2593: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2594: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2595: date_requested , p_attributes_rec.date_requested ) ,
2596: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2590: ship_tolerance_below = decode ( p_attributes_rec.ship_tolerance_below, FND_API.G_MISS_NUM ,
2591: ship_tolerance_below , p_attributes_rec.ship_tolerance_below ) ,
2592: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2593: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2594: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2595: date_requested , p_attributes_rec.date_requested ) ,
2596: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2597: date_scheduled , p_attributes_rec.date_scheduled ) ,
2598: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2592: customer_requested_lot_flag = decode ( p_attributes_rec.customer_requested_lot_flag, FND_API.G_MISS_CHAR ,
2593: customer_requested_lot_flag , p_attributes_rec.customer_requested_lot_flag ),
2594: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2595: date_requested , p_attributes_rec.date_requested ) ,
2596: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2597: date_scheduled , p_attributes_rec.date_scheduled ) ,
2598: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2599: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2600: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2594: date_requested = decode ( p_attributes_rec.date_requested, FND_API.G_MISS_DATE ,
2595: date_requested , p_attributes_rec.date_requested ) ,
2596: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2597: date_scheduled , p_attributes_rec.date_scheduled ) ,
2598: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2599: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2600: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2601: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2602: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2596: date_scheduled = decode ( p_attributes_rec.date_scheduled, FND_API.G_MISS_DATE ,
2597: date_scheduled , p_attributes_rec.date_scheduled ) ,
2598: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2599: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2600: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2601: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2602: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2603: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2604: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2598: dep_plan_required_flag = decode ( p_attributes_rec.dep_plan_required_flag, FND_API.G_MISS_CHAR ,
2599: dep_plan_required_flag , p_attributes_rec.dep_plan_required_flag ) ,
2600: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2601: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2602: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2603: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2604: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2605: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2606: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2600: customer_prod_seq = decode ( p_attributes_rec.customer_prod_seq, FND_API.G_MISS_CHAR ,
2601: customer_prod_seq , p_attributes_rec.customer_prod_seq ) ,
2602: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2603: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2604: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2605: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2606: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2607: customer_job , p_attributes_rec.customer_job ) ,
2608: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2602: customer_dock_code = decode ( p_attributes_rec.customer_dock_code, FND_API.G_MISS_CHAR ,
2603: customer_dock_code , p_attributes_rec.customer_dock_code ) ,
2604: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2605: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2606: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2607: customer_job , p_attributes_rec.customer_job ) ,
2608: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2609: customer_production_line , p_attributes_rec.customer_production_line ) ,
2610: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2604: cust_model_serial_number = decode ( p_attributes_rec.cust_model_serial_number, FND_API.G_MISS_CHAR ,
2605: cust_model_serial_number , p_attributes_rec.cust_model_serial_number ) ,
2606: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2607: customer_job , p_attributes_rec.customer_job ) ,
2608: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2609: customer_production_line , p_attributes_rec.customer_production_line ) ,
2610: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2611: cust_po_number , p_attributes_rec.cust_po_number ) ,
2612: packing_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2606: customer_job = decode ( p_attributes_rec.customer_job, FND_API.G_MISS_CHAR ,
2607: customer_job , p_attributes_rec.customer_job ) ,
2608: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2609: customer_production_line , p_attributes_rec.customer_production_line ) ,
2610: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2611: cust_po_number , p_attributes_rec.cust_po_number ) ,
2612: packing_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2613: packing_instructions , p_attributes_rec.packing_instructions) ,packing_instructions), --bugfix 10175902
2614: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2608: customer_production_line = decode ( p_attributes_rec.customer_production_line, FND_API.G_MISS_CHAR ,
2609: customer_production_line , p_attributes_rec.customer_production_line ) ,
2610: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2611: cust_po_number , p_attributes_rec.cust_po_number ) ,
2612: packing_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2613: packing_instructions , p_attributes_rec.packing_instructions) ,packing_instructions), --bugfix 10175902
2614: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2615: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2616: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2610: cust_po_number = decode ( p_attributes_rec.cust_po_number, FND_API.G_MISS_CHAR ,
2611: cust_po_number , p_attributes_rec.cust_po_number ) ,
2612: packing_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2613: packing_instructions , p_attributes_rec.packing_instructions) ,packing_instructions), --bugfix 10175902
2614: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2615: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2616: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2617: ship_set_id , p_attributes_rec.ship_set_id ) ,
2618: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2612: packing_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.packing_instructions, FND_API.G_MISS_CHAR ,
2613: packing_instructions , p_attributes_rec.packing_instructions) ,packing_instructions), --bugfix 10175902
2614: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2615: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2616: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2617: ship_set_id , p_attributes_rec.ship_set_id ) ,
2618: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2619: ato_line_id , p_attributes_rec.ato_line_id ) ,
2620: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2614: shipment_priority_code = decode ( p_attributes_rec.shipment_priority_code, FND_API.G_MISS_CHAR ,
2615: shipment_priority_code , p_attributes_rec.shipment_priority_code ) ,
2616: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2617: ship_set_id , p_attributes_rec.ship_set_id ) ,
2618: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2619: ato_line_id , p_attributes_rec.ato_line_id ) ,
2620: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2621: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2622: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2616: ship_set_id = decode ( p_attributes_rec.ship_set_id, FND_API.G_MISS_NUM ,
2617: ship_set_id , p_attributes_rec.ship_set_id ) ,
2618: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2619: ato_line_id , p_attributes_rec.ato_line_id ) ,
2620: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2621: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2622: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2623: ship_model_complete_flag , p_attributes_rec.ship_model_complete_flag ) ,
2624: -- Bug 2830372. We update the released status to 'N' only if the released status is in ('R', 'B', 'Y').
2618: ato_line_id = decode ( p_attributes_rec.ato_line_id, FND_API.G_MISS_NUM ,
2619: ato_line_id , p_attributes_rec.ato_line_id ) ,
2620: arrival_set_id = decode ( p_attributes_rec.arrival_set_id, FND_API.G_MISS_NUM ,
2621: arrival_set_id , p_attributes_rec.arrival_set_id ) ,
2622: ship_model_complete_flag = decode ( p_attributes_rec.ship_model_complete_flag, FND_API.G_MISS_CHAR ,
2623: ship_model_complete_flag , p_attributes_rec.ship_model_complete_flag ) ,
2624: -- Bug 2830372. We update the released status to 'N' only if the released status is in ('R', 'B', 'Y').
2625: -- ATO sets the released status to 'N' only when the reservations are removed for that order line.
2626: -- OM does not pass a released status of 'N', always passes 'R'.
2639: 'N', p_attributes_rec.released_status,
2640: decode(l_pickable_flag, 'Y', released_status, 'X')),
2641: /* bug 2421965: backordered should stay backordered except for ATO reservations: Bug: 2587777 */
2642: decode ( l_pickable_flag, 'N' , 'X',
2643: decode ( p_attributes_rec.released_status, FND_API.G_MISS_CHAR ,
2644: released_status , p_attributes_rec.released_status ))) ,
2645:
2646: shipping_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2647: shipping_instructions , p_attributes_rec.shipping_instructions ),shipping_instructions) , --bugfix 10175902
2642: decode ( l_pickable_flag, 'N' , 'X',
2643: decode ( p_attributes_rec.released_status, FND_API.G_MISS_CHAR ,
2644: released_status , p_attributes_rec.released_status ))) ,
2645:
2646: shipping_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2647: shipping_instructions , p_attributes_rec.shipping_instructions ),shipping_instructions) , --bugfix 10175902
2648: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2649: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2650: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2644: released_status , p_attributes_rec.released_status ))) ,
2645:
2646: shipping_instructions = decode(p_interface_flag, 'N',decode ( p_attributes_rec.shipping_instructions, FND_API.G_MISS_CHAR,
2647: shipping_instructions , p_attributes_rec.shipping_instructions ),shipping_instructions) , --bugfix 10175902
2648: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2649: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2650: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2651: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2652: FND_API.G_MISS_NUM, cycle_count_quantity,
2647: shipping_instructions , p_attributes_rec.shipping_instructions ),shipping_instructions) , --bugfix 10175902
2648: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2649: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2650: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2651: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2652: FND_API.G_MISS_NUM, cycle_count_quantity,
2653: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2654: p_attributes_rec.cycle_count_quantity),
2655: -- OPM
2648: shipped_quantity = decode ( p_attributes_rec.shipped_quantity, FND_API.G_MISS_NUM ,
2649: shipped_quantity , p_attributes_rec.shipped_quantity ) ,
2650: cycle_count_quantity = decode ( p_attributes_rec.cycle_count_quantity,
2651: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity,
2652: FND_API.G_MISS_NUM, cycle_count_quantity,
2653: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2654: p_attributes_rec.cycle_count_quantity),
2655: -- OPM
2656: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2652: FND_API.G_MISS_NUM, cycle_count_quantity,
2653: GREATEST(requested_quantity - p_attributes_rec.shipped_quantity, 0)),
2654: p_attributes_rec.cycle_count_quantity),
2655: -- OPM
2656: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2657: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2658: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2659: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2660: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2655: -- OPM
2656: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2657: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2658: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2659: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2660: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2661: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2662: p_attributes_rec.cycle_count_quantity2 ),
2663: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2656: shipped_quantity2 = decode ( p_attributes_rec.shipped_quantity2, FND_API.G_MISS_NUM ,
2657: shipped_quantity2 , p_attributes_rec.shipped_quantity2 ) ,
2658: cycle_count_quantity2 = decode ( p_attributes_rec.cycle_count_quantity2,
2659: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2660: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2661: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2662: p_attributes_rec.cycle_count_quantity2 ),
2663: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2664: currency_code , p_attributes_rec.currency_code ) ,
2659: FND_API.G_MISS_NUM , decode(p_attributes_rec.shipped_quantity2,
2660: FND_API.G_MISS_NUM , cycle_count_quantity2 ,
2661: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2662: p_attributes_rec.cycle_count_quantity2 ),
2663: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2664: currency_code , p_attributes_rec.currency_code ) ,
2665: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2666: tracking_number , p_attributes_rec.tracking_number ) ,
2667: locator_id = decode(p_attributes_rec.locator_id,
2661: GREATEST(requested_quantity2 - p_attributes_rec.shipped_quantity2, 0)),
2662: p_attributes_rec.cycle_count_quantity2 ),
2663: currency_code = decode ( p_attributes_rec.currency_code, FND_API.G_MISS_CHAR ,
2664: currency_code , p_attributes_rec.currency_code ) ,
2665: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2666: tracking_number , p_attributes_rec.tracking_number ) ,
2667: locator_id = decode(p_attributes_rec.locator_id,
2668: FND_API.G_MISS_NUM, locator_id,
2669: decode(released_status,
2664: currency_code , p_attributes_rec.currency_code ) ,
2665: tracking_number = decode(p_attributes_rec.tracking_number, FND_API.G_MISS_CHAR ,
2666: tracking_number , p_attributes_rec.tracking_number ) ,
2667: locator_id = decode(p_attributes_rec.locator_id,
2668: FND_API.G_MISS_NUM, locator_id,
2669: decode(released_status,
2670: 'C', locator_id,
2671: p_attributes_rec.locator_id)),
2672: serial_number = decode(p_attributes_rec.serial_number,
2669: decode(released_status,
2670: 'C', locator_id,
2671: p_attributes_rec.locator_id)),
2672: serial_number = decode(p_attributes_rec.serial_number,
2673: FND_API.G_MISS_CHAR, serial_number,
2674: decode(released_status,
2675: 'C',serial_number,
2676: p_attributes_rec.serial_number)),
2677: lot_number = decode(p_attributes_rec.lot_number,
2674: decode(released_status,
2675: 'C',serial_number,
2676: p_attributes_rec.serial_number)),
2677: lot_number = decode(p_attributes_rec.lot_number,
2678: FND_API.G_MISS_CHAR, lot_number,
2679: decode(released_status,
2680: 'C', lot_number,
2681: p_attributes_rec.lot_number)),
2682: -- OPM
2682: -- OPM
2683: -- HW OPMCONV - Removed sublot code
2684:
2685: preferred_grade = decode(p_attributes_rec.preferred_grade,
2686: FND_API.G_MISS_CHAR, preferred_grade,
2687: decode(released_status,
2688: 'C', preferred_grade,
2689: 'Y', preferred_grade,
2690: p_attributes_rec.preferred_grade)),
2688: 'C', preferred_grade,
2689: 'Y', preferred_grade,
2690: p_attributes_rec.preferred_grade)),
2691: revision = decode(p_attributes_rec.revision,
2692: FND_API.G_MISS_CHAR, revision,
2693: decode(released_status,
2694: 'C', revision,
2695: p_attributes_rec.revision)),
2696: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2694: 'C', revision,
2695: p_attributes_rec.revision)),
2696: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2697: subinventory = decode(p_attributes_rec.subinventory,
2698: FND_API.G_MISS_CHAR, subinventory,
2699: decode(released_status,
2700: 'Y', decode(l_reservable_flag,
2701: 'N', decode(original_subinventory,
2702: p_attributes_rec.subinventory, subinventory,
2711: subinventory),
2712: 'C', subinventory,
2713: -- Bug 7665338:For Non-Inventory items,when Subinventory is changed in Order lines, it should be reflected on delivery details.
2714: 'X', decode(subinventory,
2715: NULL,decode(p_attributes_rec.subinventory,FND_API.G_MISS_CHAR,subinventory,p_attributes_rec.subinventory),
2716: subinventory),
2717: --bug 8995849:Modified decode statement such that for non-reservable items,when Warehouse is modified on
2718: -- Order lines,Subinventory should be updated on WDD
2719: decode(l_reservable_flag,
2723: p_attributes_rec.subinventory)),
2724: p_attributes_rec.subinventory))),
2725:
2726: original_subinventory = decode(p_attributes_rec.subinventory,
2727: FND_API.G_MISS_CHAR, original_subinventory,
2728: decode (released_status,
2729: 'C', original_subinventory,
2730: p_attributes_rec.subinventory)),
2731:
2728: decode (released_status,
2729: 'C', original_subinventory,
2730: p_attributes_rec.subinventory)),
2731:
2732: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2733: source_line_number , p_attributes_rec.line_number ) ,
2734: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2735: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2736: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2730: p_attributes_rec.subinventory)),
2731:
2732: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2733: source_line_number , p_attributes_rec.line_number ) ,
2734: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2735: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2736: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2737: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2738: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2732: source_line_number = decode ( p_attributes_rec.line_number, FND_API.G_MISS_CHAR ,
2733: source_line_number , p_attributes_rec.line_number ) ,
2734: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2735: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2736: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2737: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2738: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2739: ship_method_code , l_ship_method_code ) ,
2740: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2734: master_container_item_id = decode ( p_attributes_rec.master_container_item_id, FND_API.G_MISS_NUM ,
2735: master_container_item_id , p_attributes_rec.master_container_item_id ) ,
2736: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2737: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2738: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2739: ship_method_code , l_ship_method_code ) ,
2740: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2741: mode_of_transport , l_mode_of_transport ) ,
2742: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2736: detail_container_item_id = decode ( p_attributes_rec.detail_container_item_id, FND_API.G_MISS_NUM ,
2737: detail_container_item_id , p_attributes_rec.detail_container_item_id ) ,
2738: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2739: ship_method_code , l_ship_method_code ) ,
2740: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2741: mode_of_transport , l_mode_of_transport ) ,
2742: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2743: service_level , l_service_level ) ,
2744: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2738: ship_method_code = decode ( l_ship_method_code, FND_API.G_MISS_CHAR ,
2739: ship_method_code , l_ship_method_code ) ,
2740: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2741: mode_of_transport , l_mode_of_transport ) ,
2742: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2743: service_level , l_service_level ) ,
2744: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2745: carrier_id , l_carrier_id ) ,
2746: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2740: mode_of_transport = decode ( l_mode_of_transport, FND_API.G_MISS_CHAR ,
2741: mode_of_transport , l_mode_of_transport ) ,
2742: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2743: service_level , l_service_level ) ,
2744: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2745: carrier_id , l_carrier_id ) ,
2746: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2747: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2748: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2742: service_level = decode ( l_service_level, FND_API.G_MISS_CHAR ,
2743: service_level , l_service_level ) ,
2744: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2745: carrier_id , l_carrier_id ) ,
2746: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2747: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2748: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2749: fob_code , p_attributes_rec.fob_code ) ,
2750: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2744: carrier_id = decode ( l_carrier_id, FND_API.G_MISS_NUM ,
2745: carrier_id , l_carrier_id ) ,
2746: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2747: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2748: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2749: fob_code , p_attributes_rec.fob_code ) ,
2750: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2751: customer_item_id , p_attributes_rec.customer_item_id ) ,
2752: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2746: freight_terms_code = decode ( p_attributes_rec.freight_terms_code, FND_API.G_MISS_CHAR ,
2747: freight_terms_code , p_attributes_rec.freight_terms_code ) ,
2748: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2749: fob_code , p_attributes_rec.fob_code ) ,
2750: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2751: customer_item_id , p_attributes_rec.customer_item_id ) ,
2752: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2753: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2754: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2748: fob_code = decode ( p_attributes_rec.fob_code, FND_API.G_MISS_CHAR ,
2749: fob_code , p_attributes_rec.fob_code ) ,
2750: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2751: customer_item_id , p_attributes_rec.customer_item_id ) ,
2752: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2753: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2754: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2755: hold_code , p_attributes_rec.hold_code ) ,
2756: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2750: customer_item_id = decode ( p_attributes_rec.customer_item_id, FND_API.G_MISS_NUM ,
2751: customer_item_id , p_attributes_rec.customer_item_id ) ,
2752: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2753: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2754: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2755: hold_code , p_attributes_rec.hold_code ) ,
2756: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2757: inspection_flag , p_attributes_rec.inspection_flag ) ,
2758: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2752: top_model_line_id = decode ( p_attributes_rec.top_model_line_id, FND_API.G_MISS_NUM ,
2753: top_model_line_id , p_attributes_rec.top_model_line_id ) ,
2754: hold_code = decode ( p_attributes_rec.hold_code, FND_API.G_MISS_CHAR ,
2755: hold_code , p_attributes_rec.hold_code ) ,
2756: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2757: inspection_flag , p_attributes_rec.inspection_flag ) ,
2758: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2759: src_requested_quantity,
2760: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2756: inspection_flag = decode ( p_attributes_rec.inspection_flag, FND_API.G_MISS_CHAR ,
2757: inspection_flag , p_attributes_rec.inspection_flag ) ,
2758: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2759: src_requested_quantity,
2760: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2761: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2762: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2763: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2764: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2758: src_requested_quantity = decode ( l_oke_full_cancel_flag, 'Y', -- 5870774, Bypass for Non-Canceled dds
2759: src_requested_quantity,
2760: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2761: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2762: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2763: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2764: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2765: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2766: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2760: decode ( p_attributes_rec.ordered_quantity, FND_API.G_MISS_NUM ,
2761: src_requested_quantity , p_attributes_rec.ordered_quantity )) ,
2762: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2763: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2764: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2765: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2766: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2767: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2768: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2762: src_requested_quantity_uom = decode ( p_attributes_rec.order_quantity_uom, FND_API.G_MISS_CHAR ,
2763: src_requested_quantity_uom , p_attributes_rec.order_quantity_uom ) ,
2764: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2765: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2766: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2767: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2768: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2769: attribute_category , p_attributes_rec.attribute_category ) ,
2770: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2764: src_requested_quantity2 = decode ( p_attributes_rec.ordered_quantity2, FND_API.G_MISS_NUM ,
2765: src_requested_quantity2 , p_attributes_rec.ordered_quantity2 ) ,
2766: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2767: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2768: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2769: attribute_category , p_attributes_rec.attribute_category ) ,
2770: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2771: attribute1 , p_attributes_rec.attribute1 ) ,
2772: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2766: src_requested_quantity_uom2 = decode ( p_attributes_rec.ordered_quantity_uom2, FND_API.G_MISS_CHAR ,
2767: src_requested_quantity_uom2 , p_attributes_rec.ordered_quantity_uom2 ) ,
2768: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2769: attribute_category , p_attributes_rec.attribute_category ) ,
2770: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2771: attribute1 , p_attributes_rec.attribute1 ) ,
2772: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2773: attribute2 , p_attributes_rec.attribute2 ) ,
2774: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2768: attribute_category = decode ( p_attributes_rec.attribute_category, FND_API.G_MISS_CHAR ,
2769: attribute_category , p_attributes_rec.attribute_category ) ,
2770: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2771: attribute1 , p_attributes_rec.attribute1 ) ,
2772: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2773: attribute2 , p_attributes_rec.attribute2 ) ,
2774: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2775: attribute3 , p_attributes_rec.attribute3 ) ,
2776: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2770: attribute1 = decode ( p_attributes_rec.attribute1, FND_API.G_MISS_CHAR ,
2771: attribute1 , p_attributes_rec.attribute1 ) ,
2772: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2773: attribute2 , p_attributes_rec.attribute2 ) ,
2774: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2775: attribute3 , p_attributes_rec.attribute3 ) ,
2776: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2777: attribute4 , p_attributes_rec.attribute4 ) ,
2778: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2772: attribute2 = decode ( p_attributes_rec.attribute2, FND_API.G_MISS_CHAR ,
2773: attribute2 , p_attributes_rec.attribute2 ) ,
2774: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2775: attribute3 , p_attributes_rec.attribute3 ) ,
2776: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2777: attribute4 , p_attributes_rec.attribute4 ) ,
2778: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2779: attribute5 , p_attributes_rec.attribute5 ) ,
2780: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2774: attribute3 = decode ( p_attributes_rec.attribute3, FND_API.G_MISS_CHAR ,
2775: attribute3 , p_attributes_rec.attribute3 ) ,
2776: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2777: attribute4 , p_attributes_rec.attribute4 ) ,
2778: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2779: attribute5 , p_attributes_rec.attribute5 ) ,
2780: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2781: attribute6 , p_attributes_rec.attribute6 ) ,
2782: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2776: attribute4 = decode ( p_attributes_rec.attribute4, FND_API.G_MISS_CHAR ,
2777: attribute4 , p_attributes_rec.attribute4 ) ,
2778: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2779: attribute5 , p_attributes_rec.attribute5 ) ,
2780: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2781: attribute6 , p_attributes_rec.attribute6 ) ,
2782: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2783: attribute7 , p_attributes_rec.attribute7 ) ,
2784: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2778: attribute5 = decode ( p_attributes_rec.attribute5, FND_API.G_MISS_CHAR ,
2779: attribute5 , p_attributes_rec.attribute5 ) ,
2780: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2781: attribute6 , p_attributes_rec.attribute6 ) ,
2782: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2783: attribute7 , p_attributes_rec.attribute7 ) ,
2784: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2785: attribute8 , p_attributes_rec.attribute8 ) ,
2786: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2780: attribute6 = decode ( p_attributes_rec.attribute6, FND_API.G_MISS_CHAR ,
2781: attribute6 , p_attributes_rec.attribute6 ) ,
2782: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2783: attribute7 , p_attributes_rec.attribute7 ) ,
2784: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2785: attribute8 , p_attributes_rec.attribute8 ) ,
2786: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2787: attribute9 , p_attributes_rec.attribute9 ) ,
2788: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2782: attribute7 = decode ( p_attributes_rec.attribute7, FND_API.G_MISS_CHAR ,
2783: attribute7 , p_attributes_rec.attribute7 ) ,
2784: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2785: attribute8 , p_attributes_rec.attribute8 ) ,
2786: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2787: attribute9 , p_attributes_rec.attribute9 ) ,
2788: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2789: attribute10 , p_attributes_rec.attribute10 ) ,
2790: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2784: attribute8 = decode ( p_attributes_rec.attribute8, FND_API.G_MISS_CHAR ,
2785: attribute8 , p_attributes_rec.attribute8 ) ,
2786: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2787: attribute9 , p_attributes_rec.attribute9 ) ,
2788: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2789: attribute10 , p_attributes_rec.attribute10 ) ,
2790: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2791: attribute11 , p_attributes_rec.attribute11 ) ,
2792: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2786: attribute9 = decode ( p_attributes_rec.attribute9, FND_API.G_MISS_CHAR ,
2787: attribute9 , p_attributes_rec.attribute9 ) ,
2788: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2789: attribute10 , p_attributes_rec.attribute10 ) ,
2790: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2791: attribute11 , p_attributes_rec.attribute11 ) ,
2792: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2793: attribute12 , p_attributes_rec.attribute12 ) ,
2794: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2788: attribute10 = decode ( p_attributes_rec.attribute10, FND_API.G_MISS_CHAR ,
2789: attribute10 , p_attributes_rec.attribute10 ) ,
2790: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2791: attribute11 , p_attributes_rec.attribute11 ) ,
2792: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2793: attribute12 , p_attributes_rec.attribute12 ) ,
2794: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2795: attribute13 , p_attributes_rec.attribute13 ) ,
2796: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2790: attribute11 = decode ( p_attributes_rec.attribute11, FND_API.G_MISS_CHAR ,
2791: attribute11 , p_attributes_rec.attribute11 ) ,
2792: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2793: attribute12 , p_attributes_rec.attribute12 ) ,
2794: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2795: attribute13 , p_attributes_rec.attribute13 ) ,
2796: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2797: attribute14 , p_attributes_rec.attribute14 ) ,
2798: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2792: attribute12 = decode ( p_attributes_rec.attribute12, FND_API.G_MISS_CHAR ,
2793: attribute12 , p_attributes_rec.attribute12 ) ,
2794: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2795: attribute13 , p_attributes_rec.attribute13 ) ,
2796: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2797: attribute14 , p_attributes_rec.attribute14 ) ,
2798: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2799: attribute15 , p_attributes_rec.attribute15 ),
2800: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2794: attribute13 = decode ( p_attributes_rec.attribute13, FND_API.G_MISS_CHAR ,
2795: attribute13 , p_attributes_rec.attribute13 ) ,
2796: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2797: attribute14 , p_attributes_rec.attribute14 ) ,
2798: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2799: attribute15 , p_attributes_rec.attribute15 ),
2800: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2801: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2802: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2796: attribute14 = decode ( p_attributes_rec.attribute14, FND_API.G_MISS_CHAR ,
2797: attribute14 , p_attributes_rec.attribute14 ) ,
2798: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2799: attribute15 , p_attributes_rec.attribute15 ),
2800: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2801: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2802: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2803: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2804: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2798: attribute15 = decode ( p_attributes_rec.attribute15, FND_API.G_MISS_CHAR ,
2799: attribute15 , p_attributes_rec.attribute15 ),
2800: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2801: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2802: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2803: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2804: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2805: classification , p_attributes_rec.classification ) ,
2806: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2800: cancelled_quantity = decode ( p_attributes_rec.cancelled_quantity, FND_API.G_MISS_NUM ,
2801: cancelled_quantity , p_attributes_rec.cancelled_quantity ),
2802: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2803: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2804: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2805: classification , p_attributes_rec.classification ) ,
2806: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2807: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2808: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2802: cancelled_quantity2 = decode ( p_attributes_rec.cancelled_quantity2, FND_API.G_MISS_NUM ,
2803: cancelled_quantity2 , p_attributes_rec.cancelled_quantity2 ) ,
2804: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2805: classification , p_attributes_rec.classification ) ,
2806: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2807: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2808: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2809: container_flag , p_attributes_rec.container_flag ) ,
2810: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2804: classification = decode ( p_attributes_rec.classification, FND_API.G_MISS_CHAR ,
2805: classification , p_attributes_rec.classification ) ,
2806: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2807: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2808: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2809: container_flag , p_attributes_rec.container_flag ) ,
2810: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2811: container_name , p_attributes_rec.container_name ) ,
2812: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2806: commodity_code_cat_id = decode ( p_attributes_rec.commodity_code_cat_id, FND_API.G_MISS_NUM ,
2807: commodity_code_cat_id , p_attributes_rec.commodity_code_cat_id ) ,
2808: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2809: container_flag , p_attributes_rec.container_flag ) ,
2810: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2811: container_name , p_attributes_rec.container_name ) ,
2812: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2813: container_type_code , p_attributes_rec.container_type_code ) ,
2814: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2808: container_flag = decode ( p_attributes_rec.container_flag, FND_API.G_MISS_CHAR ,
2809: container_flag , p_attributes_rec.container_flag ) ,
2810: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2811: container_name , p_attributes_rec.container_name ) ,
2812: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2813: container_type_code , p_attributes_rec.container_type_code ) ,
2814: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2815: country_of_origin , p_attributes_rec.country_of_origin ) ,
2816: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2810: container_name = decode ( p_attributes_rec.container_name, FND_API.G_MISS_CHAR ,
2811: container_name , p_attributes_rec.container_name ) ,
2812: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2813: container_type_code , p_attributes_rec.container_type_code ) ,
2814: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2815: country_of_origin , p_attributes_rec.country_of_origin ) ,
2816: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2817: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2818: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2812: container_type_code = decode ( p_attributes_rec.container_type_code, FND_API.G_MISS_CHAR ,
2813: container_type_code , p_attributes_rec.container_type_code ) ,
2814: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2815: country_of_origin , p_attributes_rec.country_of_origin ) ,
2816: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2817: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2818: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2819: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2820: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2814: country_of_origin = decode ( p_attributes_rec.country_of_origin, FND_API.G_MISS_CHAR ,
2815: country_of_origin , p_attributes_rec.country_of_origin ) ,
2816: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2817: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2818: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2819: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2820: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2821: fill_percent , p_attributes_rec.fill_percent ) ,
2822: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2816: delivered_quantity = decode ( p_attributes_rec.delivered_quantity, FND_API.G_MISS_NUM ,
2817: delivered_quantity , p_attributes_rec.delivered_quantity ) ,
2818: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2819: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2820: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2821: fill_percent , p_attributes_rec.fill_percent ) ,
2822: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2823: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2824: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2818: delivered_quantity2 = decode ( p_attributes_rec.delivered_quantity2, FND_API.G_MISS_NUM ,
2819: delivered_quantity2 , p_attributes_rec.delivered_quantity2 ) ,
2820: fill_percent = decode ( p_attributes_rec.fill_percent, FND_API.G_MISS_NUM ,
2821: fill_percent , p_attributes_rec.fill_percent ) ,
2822: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2823: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2824: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2825: inv_interfaced_flag = decode (inv_interfaced_flag, 'Y',
2826: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2822: freight_class_cat_id = decode ( p_attributes_rec.freight_class_cat_id, FND_API.G_MISS_NUM ,
2823: freight_class_cat_id , p_attributes_rec.freight_class_cat_id ) ,
2824: -- Bug 3125768: Checking for l_pickable_flag to update the inv_interfaced_flag
2825: inv_interfaced_flag = decode (inv_interfaced_flag, 'Y',
2826: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2827: inv_interfaced_flag , p_attributes_rec.inv_interfaced_flag ) ,
2828: decode (l_pickable_flag, 'N', 'X', 'N')
2829: ),
2830: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2826: decode ( p_attributes_rec.inv_interfaced_flag, FND_API.G_MISS_CHAR ,
2827: inv_interfaced_flag , p_attributes_rec.inv_interfaced_flag ) ,
2828: decode (l_pickable_flag, 'N', 'X', 'N')
2829: ),
2830: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2831: inventory_item_id , p_attributes_rec.inventory_item_id ),
2832: --bug#6407943 (begin) :Needs to change items org dependent attributes when org changes
2833: item_description = decode(l_change_item_desc,'Y',l_item_description,
2834: decode (p_attributes_rec.item_description, FND_API.G_MISS_CHAR ,
2830: inventory_item_id = decode ( p_attributes_rec.inventory_item_id, FND_API.G_MISS_NUM ,
2831: inventory_item_id , p_attributes_rec.inventory_item_id ),
2832: --bug#6407943 (begin) :Needs to change items org dependent attributes when org changes
2833: item_description = decode(l_change_item_desc,'Y',l_item_description,
2834: decode (p_attributes_rec.item_description, FND_API.G_MISS_CHAR ,
2835: item_description , p_attributes_rec.item_description )),
2836: requested_quantity_uom = decode (l_change_req_quantity_uom,'Y',l_primary_uom_code,
2837: requested_quantity_uom) ,
2838: unit_weight = decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2837: requested_quantity_uom) ,
2838: unit_weight = decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2839: unit_volume = decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2840: net_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2841: decode ( p_attributes_rec.net_weight, FND_API.G_MISS_NUM ,
2842: net_weight , p_attributes_rec.net_weight )) ,
2843: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2844: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2845: gross_weight , p_attributes_rec.gross_weight )) ,
2840: net_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2841: decode ( p_attributes_rec.net_weight, FND_API.G_MISS_NUM ,
2842: net_weight , p_attributes_rec.net_weight )) ,
2843: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2844: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2845: gross_weight , p_attributes_rec.gross_weight )) ,
2846: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2847: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2848: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2842: net_weight , p_attributes_rec.net_weight )) ,
2843: gross_weight = decode(l_change_weight,'Y',requested_quantity * decode(l_change_unit_weight,'Y',l_unit_weight,unit_weight),
2844: decode ( p_attributes_rec.gross_weight, FND_API.G_MISS_NUM ,
2845: gross_weight , p_attributes_rec.gross_weight )) ,
2846: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2847: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2848: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2849: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2850: volume , p_attributes_rec.volume )) ,
2845: gross_weight , p_attributes_rec.gross_weight )) ,
2846: weight_uom_code = decode(l_change_weight_uom,'Y',l_weight_uom,decode ( p_attributes_rec.weight_uom_code, FND_API.G_MISS_CHAR ,
2847: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2848: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2849: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2850: volume , p_attributes_rec.volume )) ,
2851: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2852: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2853: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2847: weight_uom_code , p_attributes_rec.weight_uom_code )) ,
2848: volume = decode(l_change_volume,'Y', requested_quantity * decode (l_change_unit_volume,'Y',l_unit_volume,unit_volume),
2849: decode ( p_attributes_rec.volume, FND_API.G_MISS_NUM ,
2850: volume , p_attributes_rec.volume )) ,
2851: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2852: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2853: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2854: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2855: hazard_class_id , p_attributes_rec.hazard_class_id)),
2850: volume , p_attributes_rec.volume )) ,
2851: volume_uom_code = decode(l_change_volume_uom,'Y',l_volume_uom,decode ( p_attributes_rec.volume_uom_code, FND_API.G_MISS_CHAR ,
2852: volume_uom_code , p_attributes_rec.volume_uom_code )) ,
2853: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2854: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2855: hazard_class_id , p_attributes_rec.hazard_class_id)),
2856: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2857: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2858: load_seq_number , p_attributes_rec.load_seq_number ) ,
2853: hazard_class_id = decode(l_change_haz_class_id,'Y',l_haz_class_id,
2854: decode( p_attributes_rec.hazard_class_id, FND_API.G_MISS_NUM ,
2855: hazard_class_id , p_attributes_rec.hazard_class_id)),
2856: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2857: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2858: load_seq_number , p_attributes_rec.load_seq_number ) ,
2859: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2860: lpn_id , p_attributes_rec.lpn_id ) ,
2861: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2855: hazard_class_id , p_attributes_rec.hazard_class_id)),
2856: --bug#6407943 (end):Needs to change items org dependent attributes when org changes.
2857: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2858: load_seq_number , p_attributes_rec.load_seq_number ) ,
2859: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2860: lpn_id , p_attributes_rec.lpn_id ) ,
2861: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2862: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2863: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2857: load_seq_number = decode ( p_attributes_rec.load_seq_number, FND_API.G_MISS_NUM ,
2858: load_seq_number , p_attributes_rec.load_seq_number ) ,
2859: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2860: lpn_id , p_attributes_rec.lpn_id ) ,
2861: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2862: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2863: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2864: maximum_volume , p_attributes_rec.maximum_volume ) ,
2865: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2859: lpn_id = decode ( p_attributes_rec.lpn_id, FND_API.G_MISS_NUM ,
2860: lpn_id , p_attributes_rec.lpn_id ) ,
2861: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2862: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2863: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2864: maximum_volume , p_attributes_rec.maximum_volume ) ,
2865: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2866: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2867: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2861: maximum_load_weight = decode ( p_attributes_rec.maximum_load_weight, FND_API.G_MISS_NUM ,
2862: maximum_load_weight , p_attributes_rec.maximum_load_weight ) ,
2863: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2864: maximum_volume , p_attributes_rec.maximum_volume ) ,
2865: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2866: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2867: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2868: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2869: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2863: maximum_volume = decode ( p_attributes_rec.maximum_volume, FND_API.G_MISS_NUM ,
2864: maximum_volume , p_attributes_rec.maximum_volume ) ,
2865: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2866: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2867: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2868: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2869: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2870: movement_id , p_attributes_rec.movement_id ) ,
2871: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2865: minimum_fill_percent = decode ( p_attributes_rec.minimum_fill_percent, FND_API.G_MISS_NUM ,
2866: minimum_fill_percent , p_attributes_rec.minimum_fill_percent ) ,
2867: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2868: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2869: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2870: movement_id , p_attributes_rec.movement_id ) ,
2871: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2872: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2873: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2867: move_order_line_id = decode ( p_attributes_rec.move_order_line_id, FND_API.G_MISS_NUM ,
2868: move_order_line_id, p_attributes_rec.move_order_line_id ) ,
2869: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2870: movement_id , p_attributes_rec.movement_id ) ,
2871: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2872: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2873: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2874: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2875: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2869: movement_id = decode ( p_attributes_rec.movement_id, FND_API.G_MISS_NUM ,
2870: movement_id , p_attributes_rec.movement_id ) ,
2871: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2872: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2873: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2874: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2875: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2876: org_id , p_attributes_rec.org_id ) ,
2877: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2871: mvt_stat_status = decode ( p_attributes_rec.mvt_stat_status, FND_API.G_MISS_CHAR ,
2872: mvt_stat_status , p_attributes_rec.mvt_stat_status ) ,
2873: oe_interfaced_flag = decode ( p_attributes_rec.oe_interfaced_flag, FND_API.G_MISS_CHAR ,
2874: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2875: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2876: org_id , p_attributes_rec.org_id ) ,
2877: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2878: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2879: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2874: oe_interfaced_flag , p_attributes_rec.oe_interfaced_flag ) ,
2875: org_id = decode ( p_attributes_rec.org_id, FND_API.G_MISS_NUM ,
2876: org_id , p_attributes_rec.org_id ) ,
2877: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2878: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2879: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2880: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2881: picked_quantity , p_attributes_rec.picked_quantity ),
2882: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2876: org_id , p_attributes_rec.org_id ) ,
2877: -- Bug 3125768: changed pickable_flag to l_pickable_flag
2878: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2879: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2880: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2881: picked_quantity , p_attributes_rec.picked_quantity ),
2882: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2883: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2884: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2878: pickable_flag = decode ( p_attributes_rec.pickable_flag, FND_API.G_MISS_CHAR ,
2879: l_pickable_flag , p_attributes_rec.pickable_flag ) ,
2880: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2881: picked_quantity , p_attributes_rec.picked_quantity ),
2882: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2883: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2884: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2885: project_id , p_attributes_rec.project_id ) ,
2886: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2880: picked_quantity = decode ( p_attributes_rec.picked_quantity, FND_API.G_MISS_NUM ,
2881: picked_quantity , p_attributes_rec.picked_quantity ),
2882: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2883: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2884: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2885: project_id , p_attributes_rec.project_id ) ,
2886: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2887: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2888: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2882: picked_quantity2 = decode ( p_attributes_rec.picked_quantity2, FND_API.G_MISS_NUM ,
2883: picked_quantity2 , p_attributes_rec.picked_quantity2 ),
2884: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2885: project_id , p_attributes_rec.project_id ) ,
2886: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2887: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2888: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2889: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2890: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2884: project_id = decode ( p_attributes_rec.project_id, FND_API.G_MISS_NUM ,
2885: project_id , p_attributes_rec.project_id ) ,
2886: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2887: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2888: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2889: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2890: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2891: received_quantity , p_attributes_rec.received_quantity ) ,
2892: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2886: quality_control_quantity = decode ( p_attributes_rec.quality_control_quantity, FND_API.G_MISS_NUM ,
2887: quality_control_quantity , p_attributes_rec.quality_control_quantity ) ,
2888: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2889: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2890: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2891: received_quantity , p_attributes_rec.received_quantity ) ,
2892: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2893: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2894: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2888: quality_control_quantity2 = decode ( p_attributes_rec.quality_control_quantity2, FND_API.G_MISS_NUM ,
2889: quality_control_quantity2 , p_attributes_rec.quality_control_quantity2 ) ,
2890: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2891: received_quantity , p_attributes_rec.received_quantity ) ,
2892: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2893: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2894: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2895: request_id , p_attributes_rec.request_id ) ,
2896: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2890: received_quantity = decode ( p_attributes_rec.received_quantity, FND_API.G_MISS_NUM ,
2891: received_quantity , p_attributes_rec.received_quantity ) ,
2892: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2893: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2894: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2895: request_id , p_attributes_rec.request_id ) ,
2896: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2897: seal_code , p_attributes_rec.seal_code ) ,
2898: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2892: received_quantity2 = decode ( p_attributes_rec.received_quantity2, FND_API.G_MISS_NUM ,
2893: received_quantity2 , p_attributes_rec.received_quantity2 ) ,
2894: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2895: request_id , p_attributes_rec.request_id ) ,
2896: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2897: seal_code , p_attributes_rec.seal_code ) ,
2898: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2899: source_code , p_attributes_rec.source_code ),
2900: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2894: request_id = decode ( p_attributes_rec.request_id, FND_API.G_MISS_NUM ,
2895: request_id , p_attributes_rec.request_id ) ,
2896: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2897: seal_code , p_attributes_rec.seal_code ) ,
2898: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2899: source_code , p_attributes_rec.source_code ),
2900: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2901: source_header_id , p_attributes_rec.source_header_id ) ,
2902: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2896: seal_code = decode ( p_attributes_rec.seal_code, FND_API.G_MISS_CHAR ,
2897: seal_code , p_attributes_rec.seal_code ) ,
2898: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2899: source_code , p_attributes_rec.source_code ),
2900: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2901: source_header_id , p_attributes_rec.source_header_id ) ,
2902: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2903: source_header_number , p_attributes_rec.source_header_number ) ,
2904: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2898: source_code = decode ( p_attributes_rec.source_code, FND_API.G_MISS_CHAR ,
2899: source_code , p_attributes_rec.source_code ),
2900: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2901: source_header_id , p_attributes_rec.source_header_id ) ,
2902: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2903: source_header_number , p_attributes_rec.source_header_number ) ,
2904: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2905: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2906: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2900: source_header_id = decode ( p_attributes_rec.source_header_id, FND_API.G_MISS_NUM ,
2901: source_header_id , p_attributes_rec.source_header_id ) ,
2902: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2903: source_header_number , p_attributes_rec.source_header_number ) ,
2904: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2905: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2906: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2907: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2908: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2902: source_header_number = decode ( p_attributes_rec.source_header_number, FND_API.G_MISS_CHAR ,
2903: source_header_number , p_attributes_rec.source_header_number ) ,
2904: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2905: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2906: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2907: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2908: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2909: source_line_id , p_attributes_rec.source_line_id ) ,
2910: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2904: source_header_type_id = decode ( p_attributes_rec.source_header_type_id, FND_API.G_MISS_NUM ,
2905: source_header_type_id , p_attributes_rec.source_header_type_id ) ,
2906: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2907: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2908: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2909: source_line_id , p_attributes_rec.source_line_id ) ,
2910: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2911: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2912: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2906: source_header_type_name = decode ( p_attributes_rec.source_header_type_name, FND_API.G_MISS_CHAR ,
2907: source_header_type_name , p_attributes_rec.source_header_type_name ) ,
2908: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2909: source_line_id , p_attributes_rec.source_line_id ) ,
2910: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2911: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2912: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2913: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2914: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2908: source_line_id = decode ( p_attributes_rec.source_line_id, FND_API.G_MISS_NUM ,
2909: source_line_id , p_attributes_rec.source_line_id ) ,
2910: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2911: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2912: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2913: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2914: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2915: task_id , p_attributes_rec.task_id ) ,
2916: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2910: source_line_set_id = decode ( p_attributes_rec.source_line_set_id, FND_API.G_MISS_NUM ,
2911: source_line_set_id , p_attributes_rec.source_line_set_id ) ,
2912: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2913: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2914: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2915: task_id , p_attributes_rec.task_id ) ,
2916: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2917: to_serial_number , p_attributes_rec.to_serial_number ) ,
2918: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2912: split_from_delivery_detail_id = decode (p_attributes_rec.split_from_delivery_detail_id, FND_API.G_MISS_NUM,
2913: split_from_delivery_detail_id , p_attributes_rec.split_from_delivery_detail_id ) ,
2914: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2915: task_id , p_attributes_rec.task_id ) ,
2916: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2917: to_serial_number , p_attributes_rec.to_serial_number ) ,
2918: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2919: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2920: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2914: task_id = decode ( p_attributes_rec.task_id, FND_API.G_MISS_NUM ,
2915: task_id , p_attributes_rec.task_id ) ,
2916: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2917: to_serial_number , p_attributes_rec.to_serial_number ) ,
2918: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2919: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2920: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2921: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2922: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2916: to_serial_number = decode ( p_attributes_rec.to_serial_number, FND_API.G_MISS_CHAR ,
2917: to_serial_number , p_attributes_rec.to_serial_number ) ,
2918: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2919: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2920: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2921: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2922: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2923: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2924: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2918: tp_attribute1 = decode ( p_attributes_rec.tp_attribute1, FND_API.G_MISS_CHAR ,
2919: tp_attribute1 , p_attributes_rec.tp_attribute1 ),
2920: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2921: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2922: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2923: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2924: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2925: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2926: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2920: tp_attribute10 = decode ( p_attributes_rec.tp_attribute10, FND_API.G_MISS_CHAR ,
2921: tp_attribute10 , p_attributes_rec.tp_attribute10 ) ,
2922: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2923: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2924: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2925: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2926: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2927: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2928: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2922: tp_attribute11 = decode ( p_attributes_rec.tp_attribute11, FND_API.G_MISS_CHAR ,
2923: tp_attribute11 , p_attributes_rec.tp_attribute11 ) ,
2924: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2925: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2926: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2927: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2928: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2929: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2930: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2924: tp_attribute12 = decode ( p_attributes_rec.tp_attribute12, FND_API.G_MISS_CHAR ,
2925: tp_attribute12 , p_attributes_rec.tp_attribute12 ) ,
2926: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2927: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2928: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2929: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2930: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2931: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2932: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2926: tp_attribute13 = decode ( p_attributes_rec.tp_attribute13, FND_API.G_MISS_CHAR ,
2927: tp_attribute13 , p_attributes_rec.tp_attribute13 ) ,
2928: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2929: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2930: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2931: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2932: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2933: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2934: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2928: tp_attribute14 = decode ( p_attributes_rec.tp_attribute14, FND_API.G_MISS_CHAR ,
2929: tp_attribute14 , p_attributes_rec.tp_attribute14 ) ,
2930: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2931: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2932: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2933: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2934: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2935: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2936: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2930: tp_attribute15 = decode ( p_attributes_rec.tp_attribute15, FND_API.G_MISS_CHAR ,
2931: tp_attribute15 , p_attributes_rec.tp_attribute15 ) ,
2932: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2933: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2934: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2935: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2936: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2937: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2938: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2932: tp_attribute2 = decode ( p_attributes_rec.tp_attribute2, FND_API.G_MISS_CHAR ,
2933: tp_attribute2 , p_attributes_rec.tp_attribute2 ) ,
2934: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2935: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2936: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2937: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2938: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2939: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2940: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2934: tp_attribute3 = decode ( p_attributes_rec.tp_attribute3, FND_API.G_MISS_CHAR ,
2935: tp_attribute3 , p_attributes_rec.tp_attribute3 ) ,
2936: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2937: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2938: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2939: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2940: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2941: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2942: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2936: tp_attribute4 = decode ( p_attributes_rec.tp_attribute4, FND_API.G_MISS_CHAR ,
2937: tp_attribute4 , p_attributes_rec.tp_attribute4 ) ,
2938: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2939: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2940: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2941: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2942: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2943: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2944: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2938: tp_attribute5 = decode ( p_attributes_rec.tp_attribute5, FND_API.G_MISS_CHAR ,
2939: tp_attribute5 , p_attributes_rec.tp_attribute5 ) ,
2940: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2941: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2942: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2943: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2944: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2945: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2946: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2940: tp_attribute6 = decode ( p_attributes_rec.tp_attribute6, FND_API.G_MISS_CHAR ,
2941: tp_attribute6 , p_attributes_rec.tp_attribute6 ) ,
2942: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2943: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2944: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2945: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2946: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2947: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2948: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2942: tp_attribute7 = decode ( p_attributes_rec.tp_attribute7, FND_API.G_MISS_CHAR ,
2943: tp_attribute7 , p_attributes_rec.tp_attribute7 ) ,
2944: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2945: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2946: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2947: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2948: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2949: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2950: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2944: tp_attribute8 = decode ( p_attributes_rec.tp_attribute8, FND_API.G_MISS_CHAR ,
2945: tp_attribute8 , p_attributes_rec.tp_attribute8 ) ,
2946: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2947: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2948: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2949: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2950: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2951: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2952: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2946: tp_attribute9 = decode ( p_attributes_rec.tp_attribute9, FND_API.G_MISS_CHAR ,
2947: tp_attribute9 , p_attributes_rec.tp_attribute9 ),
2948: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2949: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2950: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2951: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2952: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2953: unit_number , p_attributes_rec.unit_number ) ,
2954: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2948: tp_attribute_category = decode ( p_attributes_rec.tp_attribute_category, FND_API.G_MISS_CHAR ,
2949: tp_attribute_category , p_attributes_rec.tp_attribute_category ) ,
2950: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2951: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2952: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2953: unit_number , p_attributes_rec.unit_number ) ,
2954: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2955: unit_price , p_attributes_rec.unit_price ),
2956: /* J TP Release */
2950: transaction_temp_id = decode ( p_attributes_rec.transaction_temp_id, FND_API.G_MISS_NUM ,
2951: transaction_temp_id , p_attributes_rec.transaction_temp_id ) ,
2952: unit_number = decode ( p_attributes_rec.unit_number, FND_API.G_MISS_CHAR ,
2953: unit_number , p_attributes_rec.unit_number ) ,
2954: unit_price = decode ( p_attributes_rec.unit_price, FND_API.G_MISS_NUM ,
2955: unit_price , p_attributes_rec.unit_price ),
2956: /* J TP Release */
2957: earliest_pickup_date = decode(tpdates_changed, 'N' ,
2958: to_date(to_char(earliest_pickup_date,'mm-dd-yy HH24:MI:SS'),'mm-dd-yy HH24:MI:SS')
2977: last_update_login = FND_GLOBAL.LOGIN_ID
2978: WHERE source_code = p_source_code
2979: AND source_line_id = p_attributes_rec.source_line_id
2980: AND container_flag = 'N'
2981: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,
2982: delivery_detail_id, p_attributes_rec.delivery_detail_id );
2983:
2984: /* H projects: pricing integration csun */
2985:
2983:
2984: /* H projects: pricing integration csun */
2985:
2986: IF (p_attributes_rec.gross_weight IS NOT NULL)
2987: AND (p_attributes_rec.gross_weight <> FND_API.G_MISS_NUM) THEN
2988: l_mark_reprice_flag := 'Y';
2989: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2990: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2991: l_mark_reprice_flag := 'Y';
2986: IF (p_attributes_rec.gross_weight IS NOT NULL)
2987: AND (p_attributes_rec.gross_weight <> FND_API.G_MISS_NUM) THEN
2988: l_mark_reprice_flag := 'Y';
2989: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2990: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2991: l_mark_reprice_flag := 'Y';
2992: ELSIF (p_attributes_rec.volume IS NOT NULL)
2993: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2994: l_mark_reprice_flag := 'Y';
2989: ELSIF (p_attributes_rec.net_weight IS NOT NULL)
2990: AND (p_attributes_rec.net_weight <> FND_API.G_MISS_NUM) THEN
2991: l_mark_reprice_flag := 'Y';
2992: ELSIF (p_attributes_rec.volume IS NOT NULL)
2993: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2994: l_mark_reprice_flag := 'Y';
2995: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2996: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2997: l_mark_reprice_flag := 'Y';
2992: ELSIF (p_attributes_rec.volume IS NOT NULL)
2993: AND (p_attributes_rec.volume <> FND_API.G_MISS_NUM) THEN
2994: l_mark_reprice_flag := 'Y';
2995: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2996: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2997: l_mark_reprice_flag := 'Y';
2998: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2999: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
3000: l_mark_reprice_flag := 'Y';
2995: ELSIF (p_attributes_rec.volume_uom_code IS NOT NULL)
2996: AND (p_attributes_rec.volume_uom_code <> FND_API.G_MISS_CHAR) THEN
2997: l_mark_reprice_flag := 'Y';
2998: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2999: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
3000: l_mark_reprice_flag := 'Y';
3001: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
3002: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
3003: l_mark_reprice_flag := 'Y';
2998: ELSIF (p_attributes_rec.weight_uom_code IS NOT NULL)
2999: AND (p_attributes_rec.weight_uom_code <> FND_API.G_MISS_CHAR) THEN
3000: l_mark_reprice_flag := 'Y';
3001: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
3002: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
3003: l_mark_reprice_flag := 'Y';
3004: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
3005: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3006: l_mark_reprice_flag := 'Y';
3001: ELSIF (p_attributes_rec.subinventory IS NOT NULL)
3002: AND (p_attributes_rec.subinventory <> FND_API.G_MISS_CHAR) THEN
3003: l_mark_reprice_flag := 'Y';
3004: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
3005: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3006: l_mark_reprice_flag := 'Y';
3007: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
3008: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
3009: l_mark_reprice_flag := 'Y';
3004: ELSIF (p_attributes_rec.ship_from_org_id IS NOT NULL)
3005: AND (p_attributes_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3006: l_mark_reprice_flag := 'Y';
3007: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
3008: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
3009: l_mark_reprice_flag := 'Y';
3010: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
3011: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
3012: l_mark_reprice_flag := 'Y';
3007: ELSIF (p_attributes_rec.ship_to_org_id IS NOT NULL)
3008: AND (p_attributes_rec.ship_to_org_id <> FND_API.G_MISS_NUM) THEN
3009: l_mark_reprice_flag := 'Y';
3010: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
3011: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
3012: l_mark_reprice_flag := 'Y';
3013: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
3014: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
3015: l_mark_reprice_flag := 'Y';
3010: ELSIF (p_attributes_rec.deliver_to_org_id IS NOT NULL)
3011: AND (p_attributes_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) THEN
3012: l_mark_reprice_flag := 'Y';
3013: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL)
3014: AND (p_attributes_rec.intmed_ship_to_org_id <> FND_API.G_MISS_NUM) THEN
3015: l_mark_reprice_flag := 'Y';
3016: END IF;
3017: IF l_debug_on THEN
3018: WSH_DEBUG_SV.log(l_module_name,'l_mark_reprice_flag',l_mark_reprice_flag);