DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on INV_CONVERT

Line 364: INV_CONVERT.inv_um_conversion(

360: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';
361: BEGIN
362:
363: IF p_transaction_uom_code <> p_primary_uom_code THEN
364: INV_CONVERT.inv_um_conversion(
365: p_transaction_uom_code, p_primary_uom_code,
366: p_inventory_item_id, vTransToPrimaryUOMConv
367: );
368:

Line 370: INV_CONVERT.inv_um_conversion(

366: p_inventory_item_id, vTransToPrimaryUOMConv
367: );
368:
369: IF nvl(vTransToPrimaryUOMConv, 0) <= 0 THEN
370: INV_CONVERT.inv_um_conversion(
371: p_transaction_uom_code, p_primary_uom_code,
372: 0, vTransToPrimaryUOMConv
373: );
374: IF nvl(vTransToPrimaryUOMConv, 0) <= 0 THEN

Line 1263: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

1259: --2.1. Assessable Value of item category is picked up for the Customer Id, Null Site, UOM Code, Assessable value date
1260:
1261: --3. Assessable Value and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
1262: for the Primary UOM defined in Price List.
1263: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1264: as the product of the Assessable value.
1265: --3.1. Assessable Value of item category and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
1266: for the Primary UOM defined in Price List.
1267: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

Line 1267: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

1263: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1264: as the product of the Assessable value.
1265: --3.1. Assessable Value of item category and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
1266: for the Primary UOM defined in Price List.
1267: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1268: as the product of the Assessable value.
1269:
1270: --4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
1271: on a first come first serve basis.

Line 1276: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included

1272: --4.1. Assessable Value of item category is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
1273: on a first come first serve basis.
1274:
1275: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
1276: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
1277: as the product of the Assessable value.
1278: */
1279: ----------------------------------------------------------------------------------------------------------
1280:

Line 1423: inv_convert.inv_um_conversion

1419: close c_vat_ass_value_pri_uom_cust;
1420:
1421: IF v_primary_uom_code is not null THEN
1422:
1423: inv_convert.inv_um_conversion
1424: (
1425: p_uom_code,
1426: v_primary_uom_code,
1427: p_inventory_item_id,

Line 1433: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1429: );
1430:
1431:
1432: IF nvl(v_conversion_rate, 0) <= 0 THEN
1433: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1434: IF NVL(v_conversion_rate, 0) <= 0 THEN
1435: v_conversion_rate := 0;
1436: END IF;
1437: END IF;

Line 1462: inv_convert.inv_um_conversion( p_uom_code

1458: CLOSE cust_ass_value_pri_uom_cur;
1459:
1460: IF v_primary_uom_code IS NOT NULL
1461: THEN
1462: inv_convert.inv_um_conversion( p_uom_code
1463: , v_primary_uom_code
1464: , p_inventory_item_id
1465: , v_conversion_rate
1466: );

Line 1470: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1466: );
1467:
1468: IF NVL(v_conversion_rate, 0) <= 0
1469: THEN
1470: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1471: IF NVL(v_conversion_rate, 0) <= 0
1472: THEN
1473: v_conversion_rate := 0;
1474: END IF;

Line 1502: inv_convert.inv_um_conversion

1498: FETCH c_vat_ass_value_other_uom_cust into v_assessable_value,v_other_uom_code,lv_assess_val_curr_code; /* Added for bug#16288090 */
1499: CLOSE c_vat_ass_value_other_uom_cust;
1500:
1501: IF v_other_uom_code is not null THEN
1502: inv_convert.inv_um_conversion
1503: (
1504: p_uom_code,
1505: v_other_uom_code,
1506: p_inventory_item_id,

Line 1512: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1508: );
1509:
1510: IF nvl(v_conversion_rate, 0) <= 0 THEN
1511:
1512: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1513:
1514: IF NVL(v_conversion_rate, 0) <= 0 THEN
1515: v_conversion_rate := 0;
1516: END IF;

Line 1542: inv_convert.inv_um_conversion( p_uom_code

1538: CLOSE cust_ass_value_other_uom_cur;
1539:
1540: IF v_other_uom_code IS NOT NULL
1541: THEN
1542: inv_convert.inv_um_conversion( p_uom_code
1543: , v_other_uom_code
1544: , p_inventory_item_id
1545: , v_conversion_rate
1546: );

Line 1550: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1546: );
1547:
1548: IF NVL(v_conversion_rate, 0) <= 0
1549: THEN
1550: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1551: IF NVL(v_conversion_rate, 0) <= 0
1552: THEN
1553: v_conversion_rate := 0;
1554: END IF;

Line 1611: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

1607: --2.1. Assessable Value of item category is picked up for the Vendor Id, Null Site, UOM Code, Assessable value date
1608:
1609: --3. Assessable Value and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1610: for the Primary UOM defined in Price List.
1611: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1612: as the product of the Assessable value.
1613: --3.1. Assessable Value of item category and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1614: for the Primary UOM defined in Price List.
1615: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

Line 1615: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

1611: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1612: as the product of the Assessable value.
1613: --3.1. Assessable Value of item category and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1614: for the Primary UOM defined in Price List.
1615: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1616: as the product of the Assessable value.
1617:
1618: --4. Assessable Value is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1619: on a first come first serve basis.

Line 1624: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included

1620: --4.1. Assessable Value of item category is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1621: on a first come first serve basis.
1622:
1623: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
1624: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
1625: as the product of the Assessable value.
1626: */
1627: ----------------------------------------------------------------------------------------------------------
1628:

Line 1771: inv_convert.inv_um_conversion

1767: close c_vat_ass_value_pri_uom_vend;
1768:
1769: IF v_primary_uom_code is not null THEN
1770:
1771: inv_convert.inv_um_conversion
1772: (
1773: p_uom_code,
1774: v_primary_uom_code,
1775: p_inventory_item_id,

Line 1781: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1777: );
1778:
1779:
1780: IF nvl(v_conversion_rate, 0) <= 0 THEN
1781: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1782: IF NVL(v_conversion_rate, 0) <= 0 THEN
1783: v_conversion_rate := 0;
1784: END IF;
1785: END IF;

Line 1810: inv_convert.inv_um_conversion( p_uom_code

1806: CLOSE vend_ass_value_pri_uom_cur;
1807:
1808: IF v_primary_uom_code IS NOT NULL
1809: THEN
1810: inv_convert.inv_um_conversion( p_uom_code
1811: , v_primary_uom_code
1812: , p_inventory_item_id
1813: , v_conversion_rate
1814: );

Line 1818: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1814: );
1815:
1816: IF NVL(v_conversion_rate, 0) <= 0
1817: THEN
1818: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1819: IF NVL(v_conversion_rate, 0) <= 0
1820: THEN
1821: v_conversion_rate := 0;
1822: END IF;

Line 1851: inv_convert.inv_um_conversion

1847: FETCH c_vat_ass_value_other_uom_vend into v_assessable_value,v_other_uom_code,lv_assess_val_curr_code; /* Added for bug#16288090 */
1848: CLOSE c_vat_ass_value_other_uom_vend;
1849:
1850: IF v_other_uom_code is not null THEN
1851: inv_convert.inv_um_conversion
1852: (
1853: p_uom_code,
1854: v_other_uom_code,
1855: p_inventory_item_id,

Line 1861: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1857: );
1858:
1859: IF nvl(v_conversion_rate, 0) <= 0 THEN
1860:
1861: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1862:
1863: IF NVL(v_conversion_rate, 0) <= 0 THEN
1864: v_conversion_rate := 0;
1865: END IF;

Line 1891: inv_convert.inv_um_conversion( p_uom_code

1887: CLOSE vend_ass_value_other_uom_cur;
1888:
1889: IF v_other_uom_code IS NOT NULL
1890: THEN
1891: inv_convert.inv_um_conversion( p_uom_code
1892: , v_other_uom_code
1893: , p_inventory_item_id
1894: , v_conversion_rate
1895: );

Line 1899: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

1895: );
1896:
1897: IF NVL(v_conversion_rate, 0) <= 0
1898: THEN
1899: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1900: IF NVL(v_conversion_rate, 0) <= 0
1901: THEN
1902: v_conversion_rate := 0;
1903: END IF;