[Home] [Help]
7434: --=============================================================
7435: if t_ship_date(j) is null and t_order_type(j) in (G_SALES_FORECAST, G_SUPPLY_COMMIT,
7436: G_SALES_ORDER, G_ASN, G_PO_ACKNOWLEDGEMENT, G_ORDER_FORECAST, G_PURCHASE_ORDER, G_SHIP_RECEIPT,
7437: G_REQUISITION) then
7438: t_ship_date(j) := msc_x_util.update_ship_rcpt_dates(
7439: t_cust_id(j),
7440: t_cust_site_id(j),
7441: t_supp_id(j),
7442: t_supp_site_id(j),
7459: -- Obtain the receipt date
7460: --=============================================================
7461: if t_receipt_date(j) is null and t_order_type(j) in (G_SALES_FORECAST, G_SUPPLY_COMMIT,
7462: G_SALES_ORDER, G_ASN, G_PO_ACKNOWLEDGEMENT) then
7463: t_receipt_date(j) := msc_x_util.update_ship_rcpt_dates(
7464: t_cust_id(j),
7465: t_cust_site_id(j),
7466: t_supp_id(j),
7467: t_supp_site_id(j),
8726: --================================================================
8727: --Obtain the tp uom, primary quantity and tp quantity
8728: --================================================================
8729:
8730: msc_x_util.get_uom_conversion_rates(t_uom(j),
8731: t_ins_pri_uom(t_insert_id.COUNT),
8732: t_item_id(j),
8733: l_conversion_found,
8734: l_conversion_rate);
8738: t_ins_pri_qty(t_insert_id.COUNT) := round(t_quantity(j), 6);
8739: END IF;
8740:
8741: IF t_ins_order_type(t_insert_id.COUNT) NOT IN (g_unallocated_onhand, g_safety_stock, g_proj_avai_bal) THEN
8742: msc_x_util.get_uom_conversion_rates(t_uom(j),
8743: t_ins_ref_uom(t_insert_id.COUNT),
8744: t_item_id(j),
8745: l_conversion_found,
8746: l_conversion_rate);
8766: ) THEN
8767: IF ((t_ins_supp_id (t_insert_id.COUNT) = 1) OR -- if OEM is supplier or supplier=publisher
8768: (t_ins_supp_id (t_insert_id.COUNT) = t_ins_pub_id (t_insert_id.COUNT))) THEN --- Bug #6274985
8769: OPEN c_shipping_control_meaning (
8770: MSC_X_UTIL.GET_SHIPPING_CONTROL_ID
8771: ( NVL(t_ins_cust_id(t_insert_id.COUNT), t_ins_pub_id(t_insert_id.COUNT))
8772: , NVL(t_ins_cust_site_id(t_insert_id.COUNT), t_ins_pub_site_id(t_insert_id.COUNT))
8773: , NVL(t_ins_supp_id(t_insert_id.COUNT), t_ins_pub_id(t_insert_id.COUNT))
8774: , NVL(t_ins_supp_site_id(t_insert_id.COUNT), t_ins_pub_site_id(t_insert_id.COUNT))
9664: l_conv_rate1 number;
9665: l_conv_rate2 number;
9666: BEGIN
9667: IF p_pri_uom <> p_uom THEN
9668: msc_x_util.get_uom_conversion_rates(
9669: p_uom,
9670: p_pri_uom,
9671: p_item_id,
9672: l_conv_found,
9682: p_pri_qty := round(p_qty,6);
9683: END IF;
9684:
9685: IF p_tp_uom <> p_uom THEN
9686: msc_x_util.get_uom_conversion_rates(
9687: p_uom,
9688: p_tp_uom,
9689: p_item_id,
9690: l_conv_found,
9713: l_conv_found boolean;
9714: l_conv_rate number;
9715: BEGIN
9716: IF p_uom <> p_uom1 THEN
9717: msc_x_util.get_uom_conversion_rates(
9718: p_uom,
9719: p_uom1,
9720: p_item_id,
9721: l_conv_found,
10734: , G_NEGOTIATED_CAPACITY
10735: , G_PO_ACKNOWLEDGEMENT
10736: , G_SALES_ORDER
10737: ))
10738: AND MSC_X_UTIL.GET_SHIPPING_CONTROL
10739: ( NVL(ln.customer_company, ln.publisher_company)
10740: , NVL(ln.customer_site, ln.publisher_site)
10741: , NVL(ln.supplier_company, ln.publisher_company)
10742: , NVL(ln.supplier_site, ln.publisher_site)
10776: FORALL j in t_line_id.FIRST..t_line_id.LAST
10777: UPDATE msc_supdem_lines_interface ln
10778: SET ln.key_date = ln.receipt_date,
10779: ln.key_end_date = ln.new_schedule_end_date
10780: , ln.shipping_control = MSC_X_UTIL.GET_SHIPPING_CONTROL
10781: ( NVL(ln.customer_company, ln.publisher_company)
10782: , NVL(ln.customer_site, ln.publisher_site)
10783: , NVL(ln.supplier_company, ln.publisher_company)
10784: , NVL(ln.supplier_site, ln.publisher_site)
10798: , G_NEGOTIATED_CAPACITY
10799: , G_PO_ACKNOWLEDGEMENT
10800: , G_SALES_ORDER
10801: ))
10802: AND MSC_X_UTIL.GET_SHIPPING_CONTROL
10803: ( NVL(ln.customer_company, ln.publisher_company)
10804: , NVL(ln.customer_site, ln.publisher_site)
10805: , NVL(ln.supplier_company, ln.publisher_company)
10806: , NVL(ln.supplier_site, ln.publisher_site)
10815: FORALL j in t_line_id.FIRST..t_line_id.LAST
10816: UPDATE msc_supdem_lines_interface ln
10817: SET ln.key_date = ln.receipt_date,
10818: ln.key_end_date = ln.new_schedule_end_date
10819: , ln.shipping_control = MSC_X_UTIL.GET_SHIPPING_CONTROL
10820: ( NVL(ln.customer_company, ln.publisher_company)
10821: , NVL(ln.customer_site, ln.publisher_site)
10822: , NVL(ln.supplier_company, ln.publisher_company)
10823: , NVL(ln.supplier_site, ln.publisher_site)
10871: , G_PO_ACKNOWLEDGEMENT
10872: , G_REQUISITION
10873: , G_SALES_ORDER
10874: ))
10875: AND MSC_X_UTIL.GET_SHIPPING_CONTROL
10876: ( NVL(ln.customer_company, ln.publisher_company)
10877: , NVL(ln.customer_site, ln.publisher_site)
10878: , NVL(ln.supplier_company, ln.publisher_company)
10879: , NVL(ln.supplier_site, ln.publisher_site)
10912: FORALL j in t_line_id.FIRST..t_line_id.LAST
10913: UPDATE msc_supdem_lines_interface ln
10914: SET ln.key_date = ln.ship_date,
10915: ln.key_end_date = ln.new_schedule_end_date
10916: , ln.shipping_control = MSC_X_UTIL.GET_SHIPPING_CONTROL
10917: ( NVL(ln.customer_company, ln.publisher_company)
10918: , NVL(ln.customer_site, ln.publisher_site)
10919: , NVL(ln.supplier_company, ln.publisher_company)
10920: , NVL(ln.supplier_site, ln.publisher_site)
10938: , G_PO_ACKNOWLEDGEMENT
10939: , G_REQUISITION
10940: , G_SALES_ORDER
10941: ))
10942: AND MSC_X_UTIL.GET_SHIPPING_CONTROL
10943: ( NVL(ln.customer_company, ln.publisher_company)
10944: , NVL(ln.customer_site, ln.publisher_site)
10945: , NVL(ln.supplier_company, ln.publisher_company)
10946: , NVL(ln.supplier_site, ln.publisher_site)
10955: FORALL j in t_line_id.FIRST..t_line_id.LAST
10956: UPDATE msc_supdem_lines_interface ln
10957: SET ln.key_date = ln.ship_date,
10958: ln.key_end_date = ln.new_schedule_end_date
10959: , ln.shipping_control = MSC_X_UTIL.GET_SHIPPING_CONTROL
10960: ( NVL(ln.customer_company, ln.publisher_company)
10961: , NVL(ln.customer_site, ln.publisher_site)
10962: , NVL(ln.supplier_company, ln.publisher_company)
10963: , NVL(ln.supplier_site, ln.publisher_site)