DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on INV_RCV_CACHE

Line 523: inv_rcv_cache.convert_qty (l_inventory_item_id,

519: DECODE (transaction_uom,
520: l_uom_code, transaction_quantity
521: /*Bug6133345*/
522: ,
523: inv_rcv_cache.convert_qty (l_inventory_item_id,
524: transaction_quantity,
525: transaction_uom,
526: l_uom_code,
527: NULL

Line 1256: inv_rcv_cache.get_primary_uom_code (l_organization_id,

1252: /* Reject */
1253: END IF;
1254:
1255: l_primary_uom_code :=
1256: inv_rcv_cache.get_primary_uom_code (l_organization_id,
1257: l_inventory_item_id
1258: );
1259: l_sec_uom_code :=
1260: inv_rcv_cache.get_secondary_uom_code (l_organization_id,

Line 1260: inv_rcv_cache.get_secondary_uom_code (l_organization_id,

1256: inv_rcv_cache.get_primary_uom_code (l_organization_id,
1257: l_inventory_item_id
1258: );
1259: l_sec_uom_code :=
1260: inv_rcv_cache.get_secondary_uom_code (l_organization_id,
1261: l_inventory_item_id
1262: );
1263:
1264: -- Purchasing/receiving uses unit of measure (Each)

Line 1335: inv_rcv_cache.convert_qty

1331: -- If inspection uom is not same as move order uom, we convert
1332: IF (l_uom_code <> l_mol_uom_code)
1333: THEN
1334: l_mol_qty :=
1335: inv_rcv_cache.convert_qty
1336: (p_inventory_item_id => l_inventory_item_id,
1337: p_from_qty => l_mol_qty,
1338: p_from_uom_code => l_mol_uom_code,
1339: p_to_uom_code => l_uom_code

Line 1619: inv_rcv_cache.convert_qty

1615:
1616: IF (l_uom_code <> l_rtv_uom_code)
1617: THEN
1618: l_cnv_rls_qty :=
1619: inv_rcv_cache.convert_qty
1620: (p_inventory_item_id => l_inventory_item_id,
1621: p_from_qty => l_rls_qty,
1622: p_from_uom_code => l_rtv_uom_code,
1623: p_to_uom_code => l_uom_code

Line 1638: - inv_rcv_cache.convert_qty

1634: IF (l_primary_uom_code <> l_uom_code)
1635: THEN
1636: l_rtv_qty :=
1637: l_cnv_rls_qty
1638: - inv_rcv_cache.convert_qty
1639: (p_inventory_item_id => l_inventory_item_id,
1640: p_from_qty => l_processed_lot_prim_qty,
1641: p_from_uom_code => l_primary_uom_code,
1642: p_to_uom_code => l_uom_code

Line 1682: inv_rcv_cache.convert_qty

1678: -- If inspection uom is not same as receipt uom, convert
1679: IF (l_uom_code <> l_rtv_uom_code)
1680: THEN
1681: l_rtv_qty :=
1682: inv_rcv_cache.convert_qty
1683: (p_inventory_item_id => l_inventory_item_id,
1684: p_from_qty => l_rtv_qty,
1685: p_from_uom_code => l_rtv_uom_code,
1686: p_to_uom_code => l_uom_code

Line 1732: inv_rcv_cache.convert_qty

1728: -- If required convert into primary unit of measure
1729: IF (l_uom_code <> l_primary_uom_code)
1730: THEN
1731: l_primary_qty :=
1732: inv_rcv_cache.convert_qty
1733: (p_inventory_item_id => l_inventory_item_id,
1734: p_from_qty => l_rtv_qty,
1735: p_from_uom_code => l_uom_code,
1736: p_to_uom_code => l_primary_uom_code

Line 1807: inv_rcv_cache.convert_qty

1803: THEN
1804: IF (l_uom_code <> l_rtv_uom_code)
1805: THEN
1806: l_ser_rtv_qty :=
1807: inv_rcv_cache.convert_qty
1808: (p_inventory_item_id => l_inventory_item_id,
1809: p_from_qty => l_ser_rtv_qty,
1810: p_from_uom_code => l_rtv_uom_code,
1811: p_to_uom_code => l_uom_code

Line 1819: inv_rcv_cache.convert_qty

1815:
1816: IF (l_uom_code <> l_primary_uom_code)
1817: THEN
1818: l_primary_qty :=
1819: inv_rcv_cache.convert_qty
1820: (p_inventory_item_id => l_inventory_item_id,
1821: p_from_qty => l_ser_rtv_qty,
1822: p_from_uom_code => l_uom_code,
1823: p_to_uom_code => l_primary_uom_code

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

2393: ELSE
2394: l_inspection_status := g_reject; /* Reject */
2395: END IF;
2396:
2397: l_primary_uom_code := inv_rcv_cache.get_primary_uom_code(l_organization_id,l_inventory_item_id);
2398: l_sec_uom_code := inv_rcv_cache.get_secondary_uom_code(l_organization_id,l_inventory_item_id);
2399:
2400: -- Purchasing/receiving uses unit of measure (Each)
2401: -- rather than uom code(Ea) and hence the following..

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

2394: l_inspection_status := g_reject; /* Reject */
2395: END IF;
2396:
2397: l_primary_uom_code := inv_rcv_cache.get_primary_uom_code(l_organization_id,l_inventory_item_id);
2398: l_sec_uom_code := inv_rcv_cache.get_secondary_uom_code(l_organization_id,l_inventory_item_id);
2399:
2400: -- Purchasing/receiving uses unit of measure (Each)
2401: -- rather than uom code(Ea) and hence the following..
2402: -- This will be used later while inserting into interface table

Line 2480: l_mol_qty := inv_rcv_cache.convert_qty

2476: print_debug ('ASSIGNED THE PRIMARY QTY TO l_mol_qty:' || l_mol_qty, 4);
2477: END IF;
2478: ELSE-- -Bug 13484877 End
2479: IF (l_uom_code <> l_mol_uom_code) THEN
2480: l_mol_qty := inv_rcv_cache.convert_qty
2481: (p_inventory_item_id => l_inventory_item_id
2482: ,p_from_qty => l_mol_qty
2483: ,p_from_uom_code => l_mol_uom_code
2484: ,p_to_uom_code => l_uom_code);

Line 2671: l_cnv_rls_qty := inv_rcv_cache.convert_qty

2667: print_debug('l_rtv_uom_code: '||l_rtv_uom_code||' l_uom_code : '||l_uom_code,4);
2668: END IF;
2669:
2670: IF (l_uom_code <> l_rtv_uom_code) THEN
2671: l_cnv_rls_qty := inv_rcv_cache.convert_qty
2672: (p_inventory_item_id => l_inventory_item_id
2673: ,p_from_qty => l_rls_qty
2674: ,p_from_uom_code => l_rtv_uom_code
2675: ,p_to_uom_code => l_uom_code);

Line 2688: l_rtv_qty := l_rls_qty - inv_rcv_cache.convert_qty

2684:
2685: -- If inspection uom is not same as receipt uom, convert
2686: /*
2687: IF (l_primary_uom_code <> l_uom_code) THEN
2688: l_rtv_qty := l_rls_qty - inv_rcv_cache.convert_qty
2689: (p_inventory_item_id => l_inventory_item_id
2690: ,p_from_qty => l_processed_lot_prim_qty
2691: ,p_from_uom_code => l_primary_uom_code
2692: ,p_to_uom_code => l_uom_code);

Line 2698: l_rtv_qty := l_cnv_rls_qty - inv_rcv_cache.convert_qty

2694: l_rtv_qty := l_rls_qty - l_processed_lot_prim_qty;
2695: END IF;
2696: */
2697: IF (l_primary_uom_code <> l_uom_code) THEN
2698: l_rtv_qty := l_cnv_rls_qty - inv_rcv_cache.convert_qty
2699: (p_inventory_item_id => l_inventory_item_id
2700: ,p_from_qty => l_processed_lot_prim_qty
2701: ,p_from_uom_code => l_primary_uom_code
2702: ,p_to_uom_code => l_uom_code);

Line 2737: l_rtv_qty := inv_rcv_cache.convert_qty

2733:
2734: -- If inspection uom is not same as receipt uom, convert
2735:
2736: IF (l_uom_code <> l_rtv_uom_code) THEN
2737: l_rtv_qty := inv_rcv_cache.convert_qty
2738: (p_inventory_item_id => l_inventory_item_id
2739: ,p_from_qty => l_rtv_qty
2740: ,p_from_uom_code => l_rtv_uom_code
2741: ,p_to_uom_code => l_uom_code);

Line 2766: l_primary_qty := inv_rcv_cache.convert_qty

2762: END IF;
2763:
2764: -- If required convert into primary unit of measure
2765: IF (l_uom_code <> l_primary_uom_code) THEN
2766: l_primary_qty := inv_rcv_cache.convert_qty
2767: (p_inventory_item_id => l_inventory_item_id
2768: ,p_from_qty => l_rtv_qty
2769: ,p_from_uom_code => l_uom_code
2770: ,p_to_uom_code => l_primary_uom_code);

Line 2867: , inv_rcv_cache.convert_qty

2863: , primary_quantity
2864: , DECODE(l_uom_code,ITEM_PRIMARY_UOM_CODE,primary_quantity,transaction_uom--added for Bug 13484877
2865: --commented for Bug 13484877, l_uom_code
2866: , transaction_quantity /*Bug6133345*/
2867: , inv_rcv_cache.convert_qty
2868: (l_inventory_item_id
2869: ,transaction_quantity
2870: ,transaction_uom
2871: ,l_uom_code