DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on INV_RCV_CACHE

Line 545: l_primary_uom_code := inv_rcv_cache.get_primary_uom_code(l_organization_id,l_inventory_item_id);

541: ELSE
542: l_inspection_status := g_reject; /* Reject */
543: END IF;
544:
545: l_primary_uom_code := inv_rcv_cache.get_primary_uom_code(l_organization_id,l_inventory_item_id);
546: l_sec_uom_code := inv_rcv_cache.get_secondary_uom_code(l_organization_id,l_inventory_item_id);
547:
548: -- Purchasing/receiving uses unit of measure (Each)
549: -- rather than uom code(Ea) and hence the following..

Line 546: l_sec_uom_code := inv_rcv_cache.get_secondary_uom_code(l_organization_id,l_inventory_item_id);

542: l_inspection_status := g_reject; /* Reject */
543: END IF;
544:
545: l_primary_uom_code := inv_rcv_cache.get_primary_uom_code(l_organization_id,l_inventory_item_id);
546: l_sec_uom_code := inv_rcv_cache.get_secondary_uom_code(l_organization_id,l_inventory_item_id);
547:
548: -- Purchasing/receiving uses unit of measure (Each)
549: -- rather than uom code(Ea) and hence the following..
550: -- This will be used later while inserting into interface table

Line 606: l_mol_qty := inv_rcv_cache.convert_qty

602: END IF;
603:
604: -- If inspection uom is not same as move order uom, we convert
605: IF (l_uom_code <> l_mol_uom_code) THEN
606: l_mol_qty := inv_rcv_cache.convert_qty
607: (p_inventory_item_id => l_inventory_item_id
608: ,p_from_qty => l_mol_qty
609: ,p_from_uom_code => l_mol_uom_code
610: ,p_to_uom_code => l_uom_code);

Line 781: l_cnv_rls_qty := inv_rcv_cache.convert_qty

777: print_debug('l_rtv_uom_code: '||l_rtv_uom_code||' l_uom_code : '||l_uom_code,4);
778: END IF;
779:
780: IF (l_uom_code <> l_rtv_uom_code) THEN
781: l_cnv_rls_qty := inv_rcv_cache.convert_qty
782: (p_inventory_item_id => l_inventory_item_id
783: ,p_from_qty => l_rls_qty
784: ,p_from_uom_code => l_rtv_uom_code
785: ,p_to_uom_code => l_uom_code);

Line 798: l_rtv_qty := l_rls_qty - inv_rcv_cache.convert_qty

794:
795: -- If inspection uom is not same as receipt uom, convert
796: /*
797: IF (l_primary_uom_code <> l_uom_code) THEN
798: l_rtv_qty := l_rls_qty - inv_rcv_cache.convert_qty
799: (p_inventory_item_id => l_inventory_item_id
800: ,p_from_qty => l_processed_lot_prim_qty
801: ,p_from_uom_code => l_primary_uom_code
802: ,p_to_uom_code => l_uom_code);

Line 808: l_rtv_qty := l_cnv_rls_qty - inv_rcv_cache.convert_qty

804: l_rtv_qty := l_rls_qty - l_processed_lot_prim_qty;
805: END IF;
806: */
807: IF (l_primary_uom_code <> l_uom_code) THEN
808: l_rtv_qty := l_cnv_rls_qty - inv_rcv_cache.convert_qty
809: (p_inventory_item_id => l_inventory_item_id
810: ,p_from_qty => l_processed_lot_prim_qty
811: ,p_from_uom_code => l_primary_uom_code
812: ,p_to_uom_code => l_uom_code);

Line 847: l_rtv_qty := inv_rcv_cache.convert_qty

843:
844: -- If inspection uom is not same as receipt uom, convert
845:
846: IF (l_uom_code <> l_rtv_uom_code) THEN
847: l_rtv_qty := inv_rcv_cache.convert_qty
848: (p_inventory_item_id => l_inventory_item_id
849: ,p_from_qty => l_rtv_qty
850: ,p_from_uom_code => l_rtv_uom_code
851: ,p_to_uom_code => l_uom_code);

Line 876: l_primary_qty := inv_rcv_cache.convert_qty

872: END IF;
873:
874: -- If required convert into primary unit of measure
875: IF (l_uom_code <> l_primary_uom_code) THEN
876: l_primary_qty := inv_rcv_cache.convert_qty
877: (p_inventory_item_id => l_inventory_item_id
878: ,p_from_qty => l_rtv_qty
879: ,p_from_uom_code => l_uom_code
880: ,p_to_uom_code => l_primary_uom_code);

Line 976: , inv_rcv_cache.convert_qty

972: , primary_quantity
973: , DECODE(transaction_uom
974: , l_uom_code
975: , transaction_quantity /*Bug6133345*/
976: , inv_rcv_cache.convert_qty
977: (l_inventory_item_id
978: ,transaction_quantity
979: ,transaction_uom
980: ,l_uom_code